def remove_comment_likes_by_comment_id(row_id):
if tf.validate_number(row_id):
return tf.remove_rows_by_column_name(
CommentLike,
row_id,
col_name='CommentId'
)
def get_pic_likes_by_picture_id(row_id):
if tf.validate_number(row_id):
rows = tf.get_rows_by_column(PictureLike, row_id, 'PictureId')
if rows is not None:
return rows
else:
return []
def get_comment_likes_by_comment_id(row_id):
if tf.validate_number(row_id):
return tf.get_row_by_column(CommentLike, row_id, col_name='CommentId')
def remove_location_by_id(row_id):
if tf.validate_number(row_id):
return tf.remove_row_by_id(Location, row_id)
def get_locations_by_user_id(row_id):
if tf.validate_number(row_id):
return tf.get_rows_by_column(Location, row_id, col_name='UserId')
def get_badge_by_id(row_id):
if tf.validate_number(row_id):
return tf.get_row_by_column(Badge, row_id, 'Id')
def remove_user_by_id(row_id):
if tf.validate_number(row_id):
return tf.remove_row_by_id(User, row_id)
def get_comment_by_user_id(row_id):
if tf.validate_number(row_id):
return tf.get_row_by_column(Comment, row_id, 'UserId')
def get_pictures_by_user_id(row_id):
if tf.validate_number(row_id):
return tf.get_rows_by_column(Picture, row_id, col_name='UserId')
def get_picture_by_id(row_id):
if tf.validate_number(row_id):
return tf.get_row_by_column(Picture, row_id)
def get_category_by_id(row_id):
if tf.validate_number(row_id):
return tf.get_row_by_column(Category, row_id)
def remove_category_by_id(row_id):
if tf.validate_number(row_id):
return tf.remove_row_by_id(Category, row_id)
def get_comment_like_by_id(row_id):
if tf.validate_number(row_id):
rows = tf.get_row_by_column(CommentLike, row_id)
return rows[0] if len(rows) > 0 else rows
def remove_comment_like_by_id(row_id):
if tf.validate_number(row_id):
return tf.remove_row_by_id(CommentLike, row_id)
def remove_comment_by_user_id(row_id):
if tf.validate_number(row_id):
return tf.remove_row_by_id(Comment, row_id, 'UserId')
def get_pictures_by_location_id(row_id):
if tf.validate_number(row_id):
return tf.get_rows_by_column(Picture, row_id, col_name='LocationId')
def remove_comment_by_review_id(row_id):
if tf.validate_number(row_id):
return tf.remove_row_by_id(Comment, row_id, 'ReviewId')
def remove_picture_by_id(row_id):
if tf.validate_number(row_id):
return tf.remove_row_by_id(Picture, row_id)
def get_user_by_id(row_id):
if tf.validate_number(row_id):
return tf.get_row_by_column(User, row_id)
def get_rating_by_user_id(row_id):
if tf.validate_number(row_id):
return tf.get_row_by_column(Rating, row_id, "UserId")
def remove_badge(row_id):
if tf.validate_number(row_id):
return tf.remove_row_by_id(Badge, row_id)
def remove_rating_by_location_id(row_id):
if tf.validate_number(row_id):
return tf.remove_row_by_id(Rating, row_id, "LocationId")
def get_pic_like_by_user_id(row_id):
if tf.validate_number(row_id):
return tf.get_row_by_column(PictureLike, row_id, 'UserId')
def remove_rating_by_user_id(row_id):
if tf.validate_number(row_id):
return tf.remove_row_by_id(Rating, row_id, "UserId")
def get_location_by_id(row_id):
if tf.validate_number(row_id):
return tf.get_row_by_column(Location, row_id)
def get_rating_by_location_id(row_id):
if tf.validate_number(row_id):
return tf.get_row_by_column(Rating, row_id, "LocationId")
def get_locations_by_category_id(row_id):
if tf.validate_number(row_id):
return tf.get_rows_by_column(Location, row_id, col_name='CategoryId')
def get_comment_by_review_id(row_id):
if tf.validate_number(row_id):
return tf.get_row_by_column(Comment, row_id, 'ReviewId')
def remove_locations_by_category_id(row_id):
if tf.validate_number(row_id):
return tf.remove_rows_by_column_name(Location,
row_id,
col_name='CategoryId')
def get_review_by_user_id(row_id):
if tf.validate_number(row_id):
return tf.get_row_by_column(Review, row_id, 'UserId')
