def test_ddl_execute(self):
engine = create_engine('sqlite:///')
cx = engine.connect()
table = self.users
ddl = DDL('SELECT 1')
for py in ('engine.execute(ddl)',
'engine.execute(ddl, table)',
'cx.execute(ddl)',
'cx.execute(ddl, table)',
'ddl.execute(engine)',
'ddl.execute(engine, table)',
'ddl.execute(cx)',
'ddl.execute(cx, table)'):
r = eval(py)
assert list(r) == [(1,)], py
for py in ('ddl.execute()',
'ddl.execute(schema_item=table)'):
try:
r = eval(py)
assert False
except tsa.exc.UnboundExecutionError:
pass
for bind in engine, cx:
ddl.bind = bind
for py in ('ddl.execute()',
'ddl.execute(schema_item=table)'):
r = eval(py)
assert list(r) == [(1,)], py
def test_ddl_execute(self):
engine = create_engine('sqlite:///')
cx = engine.connect()
table = self.users
ddl = DDL('SELECT 1')
for py in ('engine.execute(ddl)', 'engine.execute(ddl, table)',
'cx.execute(ddl)', 'cx.execute(ddl, table)',
'ddl.execute(engine)', 'ddl.execute(engine, table)',
'ddl.execute(cx)', 'ddl.execute(cx, table)'):
r = eval(py)
assert list(r) == [(1, )], py
for py in ('ddl.execute()', 'ddl.execute(schema_item=table)'):
try:
r = eval(py)
assert False
except tsa.exc.UnboundExecutionError:
pass
for bind in engine, cx:
ddl.bind = bind
for py in ('ddl.execute()', 'ddl.execute(schema_item=table)'):
r = eval(py)
assert list(r) == [(1, )], py
def test_ddl_execute(self):
engine = create_engine("sqlite:///")
cx = engine.connect()
table = self.users
ddl = DDL("SELECT 1")
for py in (
"engine.execute(ddl)",
"engine.execute(ddl, table)",
"cx.execute(ddl)",
"cx.execute(ddl, table)",
"ddl.execute(engine)",
"ddl.execute(engine, table)",
"ddl.execute(cx)",
"ddl.execute(cx, table)",
):
r = eval(py)
assert list(r) == [(1,)], py
for py in ("ddl.execute()", "ddl.execute(target=table)"):
try:
r = eval(py)
assert False
except tsa.exc.UnboundExecutionError:
pass
for bind in engine, cx:
ddl.bind = bind
for py in ("ddl.execute()", "ddl.execute(target=table)"):
r = eval(py)
assert list(r) == [(1,)], py
def test_ddl_execute(self):
engine = create_engine("sqlite:///")
cx = engine.connect()
table = self.users
ddl = DDL("SELECT 1")
for spec in (
(engine.execute, ddl),
(engine.execute, ddl, table),
(cx.execute, ddl),
(cx.execute, ddl, table),
(ddl.execute, engine),
(ddl.execute, engine, table),
(ddl.execute, cx),
(ddl.execute, cx, table),
):
fn = spec[0]
arg = spec[1:]
r = fn(*arg)
eq_(list(r), [(1, )])
for fn, kw in ((ddl.execute, {}), (ddl.execute, dict(target=table))):
assert_raises(tsa.exc.UnboundExecutionError, fn, **kw)
for bind in engine, cx:
ddl.bind = bind
for fn, kw in (
(ddl.execute, {}),
(ddl.execute, dict(target=table)),
):
r = fn(**kw)
eq_(list(r), [(1, )])
def test_ddl_execute(self):
engine = create_engine("sqlite:///")
cx = engine.connect()
table = self.users
ddl = DDL("SELECT 1")
for py in (
"engine.execute(ddl)",
"engine.execute(ddl, table)",
"cx.execute(ddl)",
"cx.execute(ddl, table)",
"ddl.execute(engine)",
"ddl.execute(engine, table)",
"ddl.execute(cx)",
"ddl.execute(cx, table)",
):
r = eval(py)
assert list(r) == [(1, )], py
for py in ("ddl.execute()", "ddl.execute(target=table)"):
try:
r = eval(py)
assert False
except tsa.exc.UnboundExecutionError:
pass
for bind in engine, cx:
ddl.bind = bind
for py in ("ddl.execute()", "ddl.execute(target=table)"):
r = eval(py)
assert list(r) == [(1, )], py
