Ok, I've got it now to where there are files in the databases directory, but still getting empty list for print db.tables
-Jim On Tue, Oct 23, 2012 at 4:21 PM, Niphlod <[email protected]> wrote: > auto_import scans the table files for tables. That's the whole point of > not redefining models (because they are stored in table files that can be > read). > Normal behaviour is: > DAL(..., migrate=True) > let it define tables, then > DAL(, migrate=False) #or migrate_enabled=False > so table files are never touched again, and can be imported. > PS: big_id isn't saved into table definitions, so you must specify that > parameter also outside (and it's safe I guess turning migrations off also > for external access). > > To solve your problem, try one round of > DAL(..,migrate_enabled=False, fake_migrate_all=True) > fake_migrate_all will fake all table creations and generates the relative > .table files (of course you must be sure that your table definitions are > synced with your db structure) > From then on, you should be able to import them > DAL(...,migrate_enabled=False, big_id=True, auto_import=True, folder='...') > > > > On Tuesday, October 23, 2012 11:08:04 PM UTC+2, Jim S wrote: > >> It is empty. >> >> >> On Tue, Oct 23, 2012 at 4:01 PM, Niphlod <[email protected]> wrote: >> >>> is your databases folder filled with the .table files relative to the >>> tables ? >>> >>> >>> On Tuesday, October 23, 2012 10:57:04 PM UTC+2, Jim S wrote: >>>> >>>> Hi - I use MySQL for my database. In my production environment I'm >>>> specifying the following: >>>> >>>> db = DAL(infoCenterUtil.getDalString(), migrate=False, >>>> migrate_enabled=False, bigint_id=True) >>>> >>>> On my production machine I'm also trying to use the DAL outside of >>>> web2py with the following: >>>> >>>> import sys >>>> sys.path.append('c:/prod/web2py') >>>> from gluon import DAL, Field >>>> db = DAL('mysql://username:password@server/database',folder= >>>> 'c:/prod/web2py/applications/InfoCenter/databases', auto_import=True) >>>> >>>> print db.tables >>>> >>>> But, I get an empty list when I print db.tables. On my test machine >>>> where all of my auto-migrations happen, it works fine. >>>> >>>> Am I barking up the wrong tree in thinking that migration has something >>>> to do with my problem (print db.tables give empty list). If not, what am I >>>> doing wrong? I don't want auto-migrations on my production box. What is >>>> the proper way to have no migration on a machine, but allow for DAL outside >>>> of web2py? >>>> >>>> -Jim >>>> >>> -- >>> >>> >>> >>> >> >> -- > > > > --
