Re: [web2py] Re: Universal Database Interface - UDI

2010-10-02 Thread Alexandre Andrade
Well, I know I have a long way ahead. 2010/10/2 mdipierro > I do not see an easy solution. > > On Oct 2, 9:48 am, Alexandre Andrade wrote: > > The case is the databases and tables are not similar. > > > > Sample case: > > > > database1: city_population_data > > database2:city_financial_data >

[web2py] Re: Universal Database Interface - UDI

2010-10-02 Thread mdipierro
I do not see an easy solution. On Oct 2, 9:48 am, Alexandre Andrade wrote: > The case is the databases and tables are not similar. > > Sample case: > > database1: city_population_data > database2:city_financial_data > database3: city_sports_data > > while the 3 databases have SOME common informat

Re: [web2py] Re: Universal Database Interface - UDI

2010-10-02 Thread Alexandre Andrade
The case is the databases and tables are not similar. Sample case: database1: city_population_data database2:city_financial_data database3: city_sports_data while the 3 databases have SOME common information (cities), the other data are not common. so, in my application, I need to get cities da

[web2py] Re: Universal Database Interface - UDI

2010-10-02 Thread mdipierro
say you have two databases db1=DAL(...) db2=DAL(...) and they contains a similar table table1=db1.define_table('person',Field('name')) table2=db2.define_table('person',table1) # same fields a table1 and you want all records from both rows=db(table1.id>0).select()&db(table2.id>0).sele