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
