def list_comments(session: Session) -> List[CommentSchema]:
comments = session.query(Comment).all()
return [
CommentSchema(id=ob.id,
content=ob.content,
user_id=ob.user_id,
date_created=ob.date_created) for ob in comments
]
def get_comment(comment_id: int, session: Session) -> CommentSchema:
ob = session.query(Comment).get(comment_id)
if ob is None:
raise HTTPError(HTTP_404, {"error": f"comment {comment_id} not found"})
return CommentSchema(id=ob.id,
content=ob.content,
user_id=ob.user_id,
date_created=ob.date_created)
def list_users(session: Session) -> List[UserSchema]:
user_obs = session.query(User).all()
return [
UserSchema(
id=ob.id,
email_address=ob.email_address,
display_name=ob.display_name,
title=ob.title,
# comments=ob.comments
) for ob in user_obs
]
def get_user(user_id: int, session: Session) -> UserSchema:
ob = session.query(User).get(user_id)
if ob is None:
raise HTTPError(HTTP_404, {"error": f"user {user_id} not found"})
return UserSchema(
id=ob.id,
email_address=ob.email_address,
display_name=ob.display_name,
title=ob.title,
# comments=ob.comments
)
def get_kitten(kitten_id: int, session: Session) -> Kitten:
kitten_ob = session.query(KittenModel).get(kitten_id)
if kitten_ob is None:
raise HTTPError(HTTP_404, {"error": f"kitten {kitten_id} not found"})
return Kitten(id=kitten_ob.id, name=kitten_ob.name)
def list_kittens(session: Session) -> List[Kitten]:
kitten_obs = session.query(KittenModel).all()
return [Kitten(id=ob.id, name=ob.name) for ob in kitten_obs]
def delete_user(user_id: str, session: Session) -> Tuple[str, None]:
session.query(User).filter(User.id == user_id).delete()
return HTTP_204, None
def delete_comment(comment_id: int, session: Session) -> Tuple[str, None]:
session.query(Comment).filter(Comment.id == comment_id).delete()
return HTTP_204, None