On Jun 10, 2011, at 2:25 PM, Cody Django wrote:
Hi all -- I'm new on pylons, coming from a django background. I'm
working on a mapfish project.
I'd like to autoload a model based on a db table, but in doing so I
get the error could not assemble any primary key columns for mapped
table.
The table itself is a postgres view with no declared primary key
column, so it makes sense that no primary key columns are detected.
I figure it is possible to define which columns to use as the primary
key in the __table_args__ dict, but I have yet to figure out exactly
how.
Tips, please!
I do the same thing:
newtable = Table(name,
meta,
*props,
autoload=True
)
where props = ColumnCollection(Column('id',Integer,primary_key=True))
SQLAlchemy overwrites the autoloaded info with the passed-in column info.
Cheers,
M
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.