def to_dict(self): my_dict = Post.to_dict(self) my_dict.update({ 'question_id': self.question_id, 'user': self.user.to_dict() }) return my_dict
def to_dict(self): my_dict = Post.to_dict(self) my_dict.update({ 'title': self.title, 'nb_answers': len(self.answers), 'tags': [tag.label for tag in self.tags], 'user': self.user.to_dict() }) return my_dict
def get_post(self, post_id): query = Post.select( Post.id, Post.title, Post.url, Post.create_at, ).where(Post.id == post_id) for row in query: return { "id": row.id, "title": row.title, "url": row.url, "create_at": row.create_at, } return None
def get_posts(self): query = Post.select( Post.id, Post.title, Post.url, ).order_by(Post.create_at.desc()) post_list = [] for row in query: post_list.append({ 'id': row.id, 'title': row.title, 'url': row.url, 'create_at': row.create_at, }) return post_list
def delete_post(self, post_id): query = Post.delete().where(Post.id == post_id).execute()
def update_post(self, post_id, title, url): Post.update(title=title, url=url).where(post_id == post_id).execute()
def save_post(self, title, url): return Post.insert( title=title, url=url, create_at=datetime.now().strftime('%Y-%m-%d %H:%M:%S')).execute()