Hi,

I've got an application that shares a DB with another application running a 
different framework. The setup is that my application declares a set of 
tables that the other application can read from but won't write to, so I 
haven't been exploring the mechanisms for connecting to legacy databases.

However, the other application requires a UUID primary key called Oid, to 
use as a foreign reference in its own tables. I can easily add that as a 
field:

db.define_table('project_details',
    Field('oid', length=64, default=uuid.uuid4, rname='"Oid"'),
    Field('project_id', 'reference project_id'),
    Field('version', 'integer'))

What I can't figure out how to do is add that field to the primary key. For 
legacy tables, it seems like using this would be the approach:

primarykey=['id','oid'],

However, from what I can tell, once you provide primarykey, the usual 
mechanisms for creating the default integer id primary key get disrupted. 

Any suggestions?

Thanks,
David

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to