def query(self, table, ids=None, limit=None, offset=None):
conn = self.generate_conn()
cur = conn.cursor()
sql = "SELECT * FROM %s " % (table)
if ids:
sql = sql + "WHERE id IN (" + ", ".join(["?"] * len(ids)) + ")"
cur.execute(sql, ids)
else:
cur.execute(sql)
return copyListDicts(cur.fetchall())
def query_sync(self, table, limit=None, offset=None):
conn = self.generate_conn()
cur = conn.cursor()
print "Limit : ", limit
sql = """SELECT id, write_date FROM %s """ % (table)
if limit:
sql = "%s LIMIT %s" % (sql, limit)
if offset:
sql = "%s OFFSET %s" % (sql, offset)
cur.execute(sql)
return copyListDicts(cur.fetchall())
