Im new to sqlachemy and sql in general but I have created several tables using sqlalchemy with simple joins using primary and foreignkeys. I am populating the main table allowing autogeneration of primarykeys for each row and my problem is that i want to recall this primarykey to use in the secondary tables as foreignkeys
i found the last_inserted_ids(self) command and i have pasted my commands below
from sqlalchemy.engine import ExecutionContext.....
i = main_seq_table.insert() i.execute({'seq_length': seq_length,'seq_name' : seq_name,'seq_descr': seq_descr,'seq_path' : seq_path,'pattern_name': pattern_name}) temp = ExecutionContext() s = temp.last_inserted_ids()This doesnt work and gives a "NotImplementedError".
I cant find a coding example for this and I have no idea what else to do, please help!
Thanks
------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642_______________________________________________ Sqlalchemy-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
