def update_post(db: Session, post: Post):
db_post = db.query(models.Post).get(post.id)
post_dict = get_dict_from_model(post)
for key, value in post_dict.items():
setattr(db_post, key, value)
db.commit()
db.refresh(db_post)
return db_post
def delete_post(db: Session, post_id: int):
db_post = db.query(models.Post).get(post_id)
db.delete(db_post)
db.commit()
def get_post_list(db: Session):
return db.query(models.Post).all()
def get_post(db: Session, post_id: int):
db_post = db.query(models.Post).filter(models.Post.id == post_id)
return None if db_post.count() > 1 else db_post.first()