Hi all, i have the following situation: i have a table (imported_data) with data generated from some wifi terminals and i have other table (using_data) where user can modify / delete the data. Every time i run the program, i need to copy new data of imported_data into using_data. i using this query for get the new data:
def newdata(self,src_table,dst_table): lista = config.Sess.query(src_table).outerjoin((dst_table, src_table.ID==dst_table.ID)).filter(dst_table.ID==None).all() return lista So I try to insert all data in the table but always inserts only the last line: for rec in dati: config.Sess.add(rec) config.Sess.commit() Thanks a lot for every suggestions. Ghido -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@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.