On Wednesday, November 21, 2018 at 5:32:29 AM UTC-8, Ben Duncan wrote: > > Ok, I turned migration on for tables, and it gave errors because of > foreign keyes. > Everything looks exactly like the docs spell out. > > I'm not sure I see the reasoning for the stuff in directory 'database'. >
It's the DAL's representation of the schema, with hints on how to translate it for the flavor of DB backend in use (through a driver, like pgsql). If the table changes (in models/mytables.py), the migrate steps update the database/*.table files and generate the appropriate SQL instructions to get the backend to match. Fake migrate skips the generate, and is used when the changes already are in place on the backend. > > I'm going ahead putting back migration=False on all the tables, since It > works that way and these > are external tables. > > Anyone see any problems with that ? > > Productiion should normally have migration=False. When it is needed, it only needs to be True for one access (barring errors). > Thanks ... > > *Ben Duncan* > DBA / Chief Software Architect > Mississippi State Supreme Court > Electronic Filing Division > > /dps > > On Wed, Nov 21, 2018 at 6:57 AM Ben Duncan <linu...@gmail.com > <javascript:>> wrote: > >> I tried enable fake migrations (Backend has tables), nothing was created >> in databases, but everything works as it should .. >> *Ben Duncan* >> DBA / Chief Software Architect >> Mississippi State Supreme Court >> Electronic Filing Division >> >> >> On Tue, Nov 20, 2018 at 4:20 PM Dave S <snide...@gmail.com <javascript:>> >> wrote: >> >>> >>> >>> On Tuesday, November 20, 2018 at 8:30:29 AM UTC-8, Ben Duncan wrote: >>>> >>>> Is it necessary to enable or even do migrations in the DAL (creating >>>> database/ entries) if the database and the tables are already preexisting >>>> ? >>>> >>>> Thanks ... >>>> >>>> *Ben Duncan* >>>> DBA / Chief Software Architect >>>> Mississippi State Supreme Court >>>> Electronic Filing Division >>>> >>> >>> >>> Let's see if I get it right: >>> >>> new table design: enable migrations >>> new field in existing design: enable migrations >>> new definition, backend has table: enable fake_migrations >>> >>> /dps >>> >>> -- >>> 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 <javascript:>. >>> For more options, visit https://groups.google.com/d/optout. >>> >> -- 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. For more options, visit https://groups.google.com/d/optout.
