I'm inserting rows into a reflected table as: m = db.MetaData() t = db.Table(tablename,m,autoload = True, autoload_with = db.engine)
# create a list of dictionaries called output_batch. then do ... db.engine.execute(t.insert(),output_batch) I'm using flask-sqlalchemy hence the db object. The insertion works but it is in a different order. Further down, I try to query for the first 10 rows of the data that was inserted hoping to get the rows that correspond to the first 10 list values. But that's not the case. Is this expected behavior? Is there something I can do to keep the order of the dictionaries in the list the same as the order the rows appear in the table? Thanks. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.