Would be great if we have a tool to automate reverse DBTables mapping to web2py models!
-- rochacbruno.com.br On Jun 28, 7:17 pm, mdipierro <[email protected]> wrote: > On 28 Giu, 15:18, Avik Basu <[email protected]> wrote: > > > My problem is that I have some different tables in each of the > > databases which is why I could not use the db export/import > > functions. Also, I am not defining tables in db2 as those tables > > already exist and have data in them. Am I still able to access the > > database function if i have not defined any tables for it in the > > model? > > No. You have to define table tables you want to use since it is > necessary map database types into web2py types. You do not need to > define all fields, only those you plan to access. Set migrate=False. > > > > > > > Avik > > > On Jun 28, 4:06 pm, mdipierro <[email protected]> wrote: > > > > import cStringIO > > > s=cStringIO.StringIO() > > > > after the same tables are defined for both dbs: > > > > db2.export_to_csv_file(s) > > > s.seek(0) > > > db1.import_form_csv_file(s) > > > > On 28 Giu, 13:25, Avik Basu <[email protected]> wrote: > > > > > Hi, > > > > > I'm trying to synchronize two databases that are similar but not > > > > exactly the same. I would like to create two connections (db1 and > > > > db2) and go through table by table to do the synchronization. > > > > > db1 = DAL('sqlite://storage.db') > > > > db2 = DAL('mysql://username:[email protected]/test_db', > > > > pool_size=10, check_reserved=['mysql'], migrate=False, > > > > fake_migrate=False) > > > > > db1 is defined in db.py while db2 is a mysql database (created via > > > > web2py) that already exists and has data in it. i'm trying to update > > > > the data in db2 with the data in db1. What is a good way to deal with > > > > this problem? > > > > > Avik
