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 [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
