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 <rochacbr...@gmail.com> 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 <mdipie...@cs.depaul.edu> wrote:
>
>
>
> > On 28 Giu, 15:18, Avik Basu <avikb...@gmail.com> 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 <mdipie...@cs.depaul.edu> 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 <avikb...@gmail.com> 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:passw...@mysql.test.com/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
