http://groups.google.com/group/web2py/browse_thread/thread/c347e86a6644432a/c1c7126c1b14600d?lnk=gst&q=Script+to+generate+schema#c1c7126c1b14600d
On 29 Giu, 07:42, rochacbruno <[email protected]> wrote: > I found a person who wants the same > > http://www.freelancer.com/projects/pingfreelance_566941.html > > This person is willing to pay for development of a tool to generate > the reverse schema, from Database for Web2py. May be a good chance for > any experienced web2py programmer develop and then release to the > community. > > On Jun 28, 11:25 pm, rochacbruno <[email protected]> wrote: > > > 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
