On Tuesday, April 21, 2015 at 9:39:14 PM UTC+2, Ron Chatterjee wrote: > > I tried this: > > db = > DAL('mysql://root@127.0.0.1:8000/my_database_name',migrate_enabled=False, > pool_size=20) > > It didn't work either. I guess someone needs to look at how to connect to > legacy database. > > where is the password ?!
BTW: I think there's a bit of misunderstandings going on in this thread. There are two separate concept at play: schema (structure) AND data. Every script/extract_***_models.py can "inspect" an existing database and figure out (with limitations) the model you should write to access that database --> schema (or structure) translated to nifty "db.define_table(....)" Exporting and importing a csv (compatible with what web2py generates) instead - again, with limitations - is the way to transfer data around. If you have a long list of SQL statements in a file, those are NOT going to work. There's virtually nothing that reverse-engineers table definitions such as "CREATE TABLE ....." to a model file, nor something that turns "INSERT INTO TABLE..." to a db.table.insert(), although it can be fun to create one (with lots of headaches). -- 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.