def get_badge_by_id(row_id):
if tf.validate_number(row_id):
return tf.get_row_by_column(Badge, row_id, 'Id')
def get_user_by_username(username):
return tf.get_row_by_column(User, username, col_name='Username')
def get_user_by_token(token):
return tf.get_row_by_column(User, token, col_name='Token')
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_user_by_id(row_id):
if tf.validate_number(row_id):
return tf.get_row_by_column(User, row_id)
def get_user_that_liked_pictures(pic_id):
tf.get_row_by_column(PictureLike, 'User_id', pic_id)
def get_user_has_badge_by_user_id(row_id):
if tf.validate_number(row_id):
return tf.get_row_by_column(UserBadge, row_id, "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_rating_by_user_id(row_id):
if tf.validate_number(row_id):
return tf.get_row_by_column(Rating, row_id, "UserId")
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 get_category_by_id(row_id):
if tf.validate_number(row_id):
return tf.get_row_by_column(Category, row_id)
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 get_review_by_user_id(row_id):
if tf.validate_number(row_id):
return tf.get_row_by_column(Review, row_id, 'UserId')
def get_review_by_location_id(row_id):
if tf.validate_number(row_id):
return tf.get_row_by_column(Review, 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 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_liked_pictures(pic_id):
tf.get_row_by_column(PictureLike, 'Picture_id', pic_id)
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 get_location_by_id(row_id):
if tf.validate_number(row_id):
return tf.get_row_by_column(Location, row_id)
def get_visited_location_by_location_id(row_id):
if tf.validate_number(row_id):
return tf.get_row_by_column(VisitedLocation, row_id, "LocationId")
