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>
> .
>
--
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/CAK8tz33bsiDjC5-RVi%2BPEc6d9Nfb94zTaU_RsiYec%3DBSOJaf7w%40mail.gmail.com.
