I have my default db.py model file and the db1.py which outlines my sql database. I didn't redfine anything else. All I did was update db.py to reflect the mysql layout.
On Wednesday, February 5, 2014 4:09:36 PM UTC-5, Anthony wrote: > > How many model files do you have and what is in them? Did you > inadvertently redefine the "db" object in a subsequent model file (that > will remove any previously defined models)? > > Anthony > > On Wednesday, February 5, 2014 3:35:29 PM UTC-5, Austin Taylor wrote: >> >> Hi Anthony, >> >> I created the db1.py (using scripts/extract_mysql_models.py) and placed >> that in the app/models folder. Should I have done something else? >> >> >> On Wednesday, February 5, 2014 2:53:40 PM UTC-5, Anthony wrote: >>> >>> When you do "for x in db", that will iterate of the Table objects >>> attached to db. The Table objects are just models defined in your model >>> files -- they do not necessarily have to correspond to actual tables in >>> your database. The tables you listed are Auth tables that would be defined >>> via auth.define_tables(). If you have migrations turned off (or the >>> database is not writable), then defining those tables in the model will not >>> result in them actually being created in the database. >>> >>> Regarding the existing tables in the database, do you have models in >>> your app defining them? >>> >>> Anthony >>> >>> On Wednesday, February 5, 2014 2:29:16 PM UTC-5, Austin Taylor wrote: >>>> >>>> Hello, >>>> >>>> I followed the instructions for importing legacy databases and created >>>> a db1.py which gave me a nice model, but I'd like to be able to interact >>>> with my current database. >>>> >>>> When I type db the shell returns <DAL uri="mysql://*****:********@ >>>> 127.0.0.1/tablename"> >>>> >>>> I run for x in db: >>>> print x >>>> >>>> and it only shows user, user_group, user_membership, auth_event, and >>>> auth_cas when I access my database from phpmyadmin I don't even have those >>>> tables in the database. >>>> >>>> Am I doing something wrong? >>>> >>> -- 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/groups/opt_out.