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