and you can save more coding with one statement that duplicates all
tables:
[db2.define_table(name,db1[name]) for name in db1.tables]
On Nov 25, 2:42 am, vihang <[EMAIL PROTECTED]> wrote:
> My only hesitation was defining the table twice and THATs SOLVED !!!
> Thanks a ton !
>
> On Nov 25, 11:57 am, mdipierro <[EMAIL PROTECTED]> wrote:
>
> > If I understand...
>
> > #create two connections
> > db1=SQLDB(...)
> > db2=SQLDB(...)
>
> > #define the tables twice (perhaps using the following trick)
> > db1.define_table('mytable',....)
> > db2.define_table('mytable',db1.mytable)
>
> > then use db1 for select and db2 for update, insert, etc.
>
> > Massimo
>
> > On Nov 25, 1:52 am, vihang <[EMAIL PROTECTED]> wrote:
>
> > > Hi,
>
> > > I am working on a small project that requires me to direct certain
> > > queries to certain database connections. That is, simply put, all
> > > select queries to one database connection and update, insert queries
> > > to another. Can this be done in web2py without making mods to the DAL
> > > code?
>
> > > Cheers
> > > Vihang
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
