Python _compile_insert Examples

Example #1

File: target.py Project: daterrell2/datatools

 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)

Example #2

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']]

Example #3

File: test_database.py Project: daterrell2/datatools

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']]

Example #4

 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)