If you are going to do script once and outside main application, maybe
this is going to be little faster:
users = session.query(Users).select()
ref_pairs = []
for u in users:
ref_pairs.extend([(u.id, int(pr_id)) for pr_id in u.fk_project.split(',')])
#this should do multi-value insert:
users_projects.insert().execute(*ref_pairs)
-------------------------------------------------------------------------
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
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
