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())