Sorry Clemens,
I hadn't checked your link correctly, it states it clearly with pseudo code
how the flags work.
Thanks, Jon.
if DAL.migrate_enabled and table.migrate:
if DAL.fake_migrate_all or table.fake_migrate:
perform fake migration
else:
perform migration
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
Libre
de virus. www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
On Tue, Dec 8, 2020 at 9:48 AM Jon Subscripted <jonsubscripti...@gmail.com>
wrote:
> Hi Clemens,
> Just some quick questions.
>
> 1) What happens with auth tables and python -S <appname> -M -P? it does
> not seem to create the .table files
> 2) Regarding migration and fake migration. I tried to summarize my
> understanding in the table below (use a fixed width font to see it
> properly). How does web2py behave on the cases marked with '?' in the table
> below?
> 3) I also assume from what I read in the book that define_table migration
> flags override those from db.py DAL constructor call. Is this correct?
>
> Thanks, Jon.
> FAKE_MIGRATE
> TRUE FALSE
> +-----------+-------------+
> | | changes |
> TRUE | ? | in DB & |
> | | .table files|
> MIGRATE +-------------------------+
> FALSE |NO changes | |
> |in DB, just| ? |
> |in .table | |
> +-----------+-------------+
>
> On Tue, Dec 8, 2020 at 9:22 AM Clemens <clemens.odend...@claret-clover.de>
> wrote:
>
>> Hello Jon,
>>
>> yes, this should do it. It's also fine to import an export of an existing
>> DB. But you can just start your application, this should create the .table
>> files at the first, I think.
>>
>> Regards
>> Clemens
>>
>> P.S.: Concerning migrate and fake_migrate options have a look there:
>> http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#table_migrations
>> I usually just use migrate=True, if I'm working on the models on my
>> development system. On production I use migrate=False and lazy_tables=True.
>>
>> On Tuesday, December 8, 2020 at 8:38:50 AM UTC+1 Jonsubs wrote:
>>
>>> Thanks Clemens and Jim S.
>>>
>>> So I guess that I should use the "python web2py.py -M -S <appname>"
>>> command option to create the new table files, right?
>>>
>>> On Mon, Dec 7, 2020 at 8:54 PM Clemens <clemens....@claret-clover.de>
>>> wrote:
>>>
>>>> Please try *not* to use the .table files. You can just rename database
>>>> folder to database.orig and create a new database folder in your
>>>> application directory. This is necessary since on the "new machine" there
>>>> are new databases created, I guess. Have a try. If it's solve the problem
>>>> you can easily recover the old database directory with the original .table
>>>> files.
>>>>
>>>> Regards
>>>> Clemens
>>>>
>>>> On Monday, December 7, 2020 at 2:04:15 PM UTC+1 Jonsubs wrote:
>>>>
>>>>> Hi all,
>>>>> I want to change the main repo copy from which I work but when I do it
>>>>> I'm not longer capable of modifying the database. BTW the old and new repo
>>>>> are not in the same machine.
>>>>>
>>>>> *My "sql.log" and every ".table" file are uploaded to the repo.
>>>>> *The old repo has migrations enabled (both in db.py and table
>>>>> definitions).
>>>>> *The new repo has migrations disabled and fake migrations enabled
>>>>> (both in db.py and table definitions).
>>>>>
>>>>> I want to be able to change the DB from the new repo (in the new
>>>>> machine). How can I change my database changing repo? Which are the steps
>>>>> to follow?
>>>>> Thanks, Jon.
>>>>>
>>>> --
>>>> Resources:
>>>> - http://web2py.com
>>>> - http://web2py.com/book (Documentation)
>>>> - http://github.com/web2py/web2py (Source code)
>>>> - https://code.google.com/p/web2py/issues/list (Report Issues)
>>>> ---
>>>> You received this message because you are subscribed to the Google
>>>> Groups "web2py-users" group.
>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>> an email to web2py+un...@googlegroups.com.
>>>> To view this discussion on the web visit
>>>> https://groups.google.com/d/msgid/web2py/43dc5ec9-2a60-4460-8911-ba00f8d699c5n%40googlegroups.com
>>>> <https://groups.google.com/d/msgid/web2py/43dc5ec9-2a60-4460-8911-ba00f8d699c5n%40googlegroups.com?utm_medium=email&utm_source=footer>
>>>> .
>>>>
>>> --
>> Resources:
>> - http://web2py.com
>> - http://web2py.com/book (Documentation)
>> - http://github.com/web2py/web2py (Source code)
>> - https://code.google.com/p/web2py/issues/list (Report Issues)
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "web2py-users" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to web2py+unsubscr...@googlegroups.com.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/web2py/cafa5ecb-a8a5-4492-afbc-9316d5d29addn%40googlegroups.com
>> <https://groups.google.com/d/msgid/web2py/cafa5ecb-a8a5-4492-afbc-9316d5d29addn%40googlegroups.com?utm_medium=email&utm_source=footer>
>> .
>>
>
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
Libre
de virus. www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/CAK8tz30myvWg7eopdYo5htb_Rr3jhyX%2Bf7Q%3D3Ci6%3DyzvwTu3_g%40mail.gmail.com.
