2008-04-10 15:30:39,844 INFO sqlalchemy.engine.base.Engine.0x..cc select distinct OWNER from systables where tabname=?
2008-04-10 15:30:39,846 INFO sqlalchemy.engine.base.Engine.0x..cc ['fac_rec']
2008-04-10 15:30:39,857 INFO sqlalchemy.engine.base.Engine.0x..cc select colname , coltype , collength , t3.default , t1.colno from syscolumns as t1 , systables as t2 , OUTER sysdefaults as t3
where t1.tabid = t2.tabid and t2.tabname=? and t2.owner=?
and t3.tabid = t2.tabid and t3.colno = t1.colno
order by t1.colno
2008-04-10 15:30:39,858 INFO sqlalchemy.engine.base.Engine.0x..cc ('fac_rec', 'informix')
2008-04-10 15:30:39,908 INFO sqlalchemy.engine.base.Engine.0x..cc select t1.constrname as cons_name , t1.constrtype as cons_type ,
t4.colname as local_column , t7.tabname as remote_table ,
t6.colname as remote_column
from sysconstraints as t1 , systables as t2 ,
sysindexes as t3 , syscolumns as t4 ,
sysreferences as t5 , syscolumns as t6 , systables as t7 ,
sysconstraints as t8 , sysindexes as t9
where t1.tabid = t2.tabid and t2.tabname=? and t2.owner=? and t1.constrtype = 'R'
and t3.tabid = t2.tabid and t3.idxname = t1.idxname
and t4.tabid = t2.tabid and t4.colno = t3.part1
and t5.constrid = t1.constrid and t8.constrid = t5.primary
and t6.tabid = t5.ptabid and t6.colno = t9.part1 and t9.idxname = t8.idxname
and t7.tabid = t5.ptabid
2008-04-10 15:30:39,911 INFO sqlalchemy.engine.base.Engine.0x..cc ('fac_rec', 'informix')
2008-04-10 15:30:40,060 INFO sqlalchemy.engine.base.Engine.0x..cc select t1.constrname as cons_name , t1.constrtype as cons_type ,
t4.colname as local_column
from sysconstraints as t1 , systables as t2 ,
sysindexes as t3 , syscolumns as t4
where t1.tabid = t2.tabid and t2.tabname=? and t2.owner=? and t1.constrtype = 'P'
and t3.tabid = t2.tabid and t3.idxname = t1.idxname
and t4.tabid = t2.tabid and t4.colno = t3.part1
2008-04-10 15:30:40,061 INFO sqlalchemy.engine.base.Engine.0x..cc ('fac_rec', 'informix')
2008-04-10 15:30:40,098 INFO sqlalchemy.engine.base.Engine.0x..cc SELECT fac_rec.id, fac_rec.title, fac_rec.rank, fac_rec.campus, fac_rec.bldg, fac_rec.room, fac_rec.pt, fac_rec.ctrct, fac_rec.tenure_date, fac_rec.ctrct_mos, fac_rec.ctrct_beg_date, fac_rec.memo1, fac_rec.memo2, fac_rec.abbr_name, fac_rec.stat, fac_rec.stat_date, fac_rec.accrl_meth, fac_rec.accrl_date, fac_rec.dept, fac_rec.prim_assoc, fac_rec.edu, fac_rec.interest, fac_rec.url, fac_rec.phone, fac_rec.email, fac_rec.titletxt
FROM fac_rec
WHERE fac_rec.id = 1
2008-04-10 15:30:40,100 INFO sqlalchemy.engine.base.Engine.0x..cc [196111]