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.

Reply via email to