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')
Example #6
0
def get_badge_by_id(row_id):
    if tf.validate_number(row_id):
        return tf.get_row_by_column(Badge, row_id, 'Id')
Example #7
0
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')
Example #9
0
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')
Example #10
0
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)
Example #15
0
def remove_comment_by_user_id(row_id):
    if tf.validate_number(row_id):
        return tf.remove_row_by_id(Comment, row_id, 'UserId')
Example #16
0
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')
Example #17
0
def remove_comment_by_review_id(row_id):
    if tf.validate_number(row_id):
        return tf.remove_row_by_id(Comment, row_id, 'ReviewId')
Example #18
0
def remove_picture_by_id(row_id):
    if tf.validate_number(row_id):
        return tf.remove_row_by_id(Picture, row_id)
Example #19
0
def get_user_by_id(row_id):
    if tf.validate_number(row_id):
        return tf.get_row_by_column(User, row_id)
Example #20
0
def get_rating_by_user_id(row_id):
    if tf.validate_number(row_id):
        return tf.get_row_by_column(Rating, row_id, "UserId")
Example #21
0
def remove_badge(row_id):
    if tf.validate_number(row_id):
        return tf.remove_row_by_id(Badge, row_id)
Example #22
0
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')
Example #24
0
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)
Example #26
0
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')
Example #28
0
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')
Example #30
0
def get_review_by_user_id(row_id):
    if tf.validate_number(row_id):
        return tf.get_row_by_column(Review, row_id, 'UserId')