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