def load(self, source, **params): eng = self.table.bind with eng.begin() as conn: ins = database._compile_insert(self.table, **params) vals = [rw for rw in source] results = conn.execute(ins, vals) return (dict(rs) for rs in results)
def test_compile_insert(db): meta = sqlalchemy.MetaData(bind=db, reflect=True) tbl = meta.tables[TBL] ins = database._compile_insert(tbl, **{'returning': ['Col0']}) assert ins._returning == [tbl.c['Col0']]