def select(conn, query, print_sql=False, **kwargs):
try:
with conn.cursor() as cur:
sql = sb.sqlrepr(
sb.Select(sb.Field("ser", "data"), where=query, **kwargs),
'postgres')
if print_sql:
print('SQL> ', sql)
cur.execute(sql)
for e in cur.fetchall():
pprint(e[0])
finally:
conn.rollback()
def select(conn, query, print_sql=False):
try:
with conn.cursor() as cur:
converter = mquery.Converter("mq", "data")
sql = sb.sqlrepr(
sb.Select(sb.Field("mq", "data"),
where=converter.convert(query)), 'postgres')
if print_sql:
print('SQL> ', sql)
cur.execute(sql)
for e in cur.fetchall():
pprint.pprint(e[0])
finally:
conn.rollback()
def select(conn, query, print_sql=False, **kwargs):
try:
with conn.cursor() as cur:
sql = sb.sqlrepr(
sb.Select(sb.Field("ser", "data"), where=query, **kwargs),
'postgres'
)
if print_sql:
print('SQL> ', sql)
cur.execute(sql)
for e in cur.fetchall():
pprint(e[0])
finally:
conn.rollback()
def select(conn, query, print_sql=False):
try:
with conn.cursor() as cur:
converter = mquery.Converter("mq", "data")
sql = sb.sqlrepr(
sb.Select(sb.Field("mq", "data"), where=converter.convert(query)),
'postgres'
)
if print_sql:
print 'SQL> ', sql
cur.execute(sql)
for e in cur.fetchall():
print e[0]
finally:
conn.rollback()