def get(self, id): query = ("SELECT id, name, url FROM topic" "WHERE id=%s") cursor = self.db.cursor() cursor.execute(query, (id)) sql_result = cursor.fetchone() cursor.close() topic = Topic(sql_result[1], sql_result[2]) topic.id = sql_result[0] return topic
def get_paginated(self, page=1, items=20): query = ("SELECT id, name, url FROM " "topic LIMIT %s OFFSET %s;") cursor = self.db.cursor() cursor.execute(query, (items, items * (page - 1))) topics = cursor.fetchall() cursor.close() if len(topics) == 0: return False topic_models = [] for t in topics: model = Topic(t[1], t[2]) model.id = t[0] topic_models.append(model) return topic_models