Re: [sqlalchemy] Re: Help using SqlSoup with database views

2011-08-04 Thread Michael Bayer
On Aug 4, 2011, at 1:08 PM, Randy Syring wrote: > FWIW, I tried the map_to() method but still received the PK error. > The following method, however, worked fine: > > ss = SqlSoup(db.engine) > meta = ss._metadata > tbl_vrmf = sa.Table("vRMF", meta, autoload=True) > vrmf_pks = [tbl_vrmf.c.dateId,

[sqlalchemy] Re: Help using SqlSoup with database views

2011-08-04 Thread Randy Syring
FWIW, I tried the map_to() method but still received the PK error. The following method, however, worked fine: ss = SqlSoup(db.engine) meta = ss._metadata tbl_vrmf = sa.Table("vRMF", meta, autoload=True) vrmf_pks = [tbl_vrmf.c.dateId, tbl_vrmf.c.ident, tbl_vrmf.c.mnum] vrmf = ss.map(tbl_vrmf, prim