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
-~----------~----~----~----~------~----~------~--~---
