def _get(self, table_name, column_list, value_list, shard_by = None, order_by = None, count = None, offset = None):
sql = (
"SELECT * FROM " + table_name + " WHERE "
+ " AND ".join(
column_name+"=%s" for column_name in column_list
))
if order_by:
if offset:
sql += " AND " + order_by + " > " + str(offset)
sql += " ORDER BY " + order_by
if count:
sql += " LIMIT " + str(count)
else:
sql += " " + SQLUtils.get_limit_string(count, offset)
if shard_by is None:
shard_by = value_list[0]
logging.getLogger().debug(sql)
try:
ret = MySQL.get(shard_by).query(sql, value_list)
except BadIdError:
raise RowNotFoundException()
logging.getLogger().debug("RESULTS: " + str(len(ret)))
return ret
def _get(self,
table_name,
column_list,
value_list,
shard_by=None,
order_by=None,
count=None,
offset=None):
sql = ("SELECT * FROM " + table_name + " WHERE " +
" AND ".join(column_name + "=%s"
for column_name in column_list))
if order_by:
if offset:
sql += " AND " + order_by + " > " + str(offset)
sql += " ORDER BY " + order_by
if count:
sql += " LIMIT " + str(count)
else:
sql += " " + SQLUtils.get_limit_string(count, offset)
if shard_by is None:
shard_by = value_list[0]
logging.getLogger().debug(sql)
try:
ret = MySQL.get(shard_by).query(sql, value_list)
except BadIdError:
raise RowNotFoundException()
logging.getLogger().debug("RESULTS: " + str(len(ret)))
return ret
def limit(self, count=None, offset=None):
self._parts["limit"] = SQLUtils.get_limit_string(count, offset)
return self
def limit(self, count=None, offset=None):
self._parts["limit"] = SQLUtils.get_limit_string(count, offset)
return self
