def update_book_page(form_dict): def callback(cursor): query_list = [] if 'body' in form_dict: query = ''' UPDATE authority.book_pages SET body = '%s' WHERE id = %s ''' % ( form_dict['body'], form_dict["book_page_id"], ) query_list.append(query) if 'image_id' in form_dict and 'image_link' in form_dict: query = ''' UPDATE authority.book_pages SET image_id = '%s', image_link = '%s' WHERE id = %s ''' % ( form_dict['image_id'], form_dict['image_link'], form_dict["book_page_id"], ) query_list.append(query) if 'tags' in form_dict: query = ''' UPDATE authority.book_pages SET tags = '%s' WHERE id = %s ''' % ( form_dict['tags'], form_dict["book_page_id"], ) query_list.append(query) if 'is_explicit' in form_dict: query = ''' UPDATE authority.book_pages SET is_explicit = %s WHERE id = %s ''' % ( form_dict['is_explicit'], form_dict["book_page_id"], ) query_list.append(query) if 'is_private' in form_dict: query = ''' UPDATE authority.book_pages SET is_private = %s WHERE id = %s ''' % ( form_dict['is_private'], form_dict["book_page_id"], ) query_list.append(query) for q in query_list: cursor.execute(q) return True return run_db_action(callback)
def delete_book_page(row_id): def callback(cursor): delete_tuple = (row_id, ) query = ''' DELETE FROM authority.books WHERE id = %s ''' print('delete query - ', query) cursor.execute(query, delete_tuple) return True return run_db_action(callback)
def delete_story_view_request(row_id): def callback(cursor): delete_tuple = (row_id, ) query = ''' DELETE FROM authority.story_view_requests WHERE id = %s ''' print('delete query - ', query) cursor.execute(query, delete_tuple) return True return run_db_action(callback)
def proxy_delete(table_name, row_id): def callback(cursor): delete_tuple = ( table_name, row_id, ) query = ''' DELETE FROM authority.'%s' WHERE id = %s ''' print('delete query - ', query) cursor.execute(query, delete_tuple) return True return run_db_action(callback)
def proxy_update_comment(form_dict): def callback(cursor): query_list = [] if 'body' in form_dict: query = ''' UPDATE authority.'%s' SET body = %s WHERE id = %s ''' cursor.execute(query, ( form_dict['table_name'], form_dict['body'], form_dict["content_id"], )) return True return run_db_action(callback)
def update_account(form_dict, you_dict): print(form_dict, you_dict) def callback(cursor): query_list = [] if 'displayname' in form_dict: query = ''' UPDATE authority.users SET displayname = '%s' WHERE id = %s ''' % ( form_dict['displayname'], you_dict["id"], ) query_list.append(query) if 'username' in form_dict: query = ''' UPDATE authority.users SET username = '******' WHERE id = %s ''' % ( form_dict['username'], you_dict["id"], ) query_list.append(query) if 'email' in form_dict: query = ''' UPDATE authority.users SET email = '%s' WHERE id = %s ''' % ( form_dict['email'], you_dict["id"], ) query_list.append(query) if 'weblink' in form_dict: query = ''' UPDATE authority.users SET weblink = '%s' WHERE id = %s ''' % ( form_dict['weblink'], you_dict["id"], ) query_list.append(query) if 'tags' in form_dict: query = ''' UPDATE authority.users SET tags = '%s' WHERE id = %s ''' % ( form_dict['tags'], you_dict["id"], ) query_list.append(query) if 'bio' in form_dict: query = ''' UPDATE authority.users SET bio = '%s' WHERE id = %s ''' % ( form_dict['bio'], you_dict["id"], ) query_list.append(query) if 'visibility' in form_dict: query = ''' UPDATE authority.users SET is_private = %s WHERE id = %s ''' % ( form_dict['visibility'], you_dict["id"], ) query_list.append(query) if 'icon_link' in form_dict and 'icon_id' in form_dict: query = ''' UPDATE authority.users SET icon_link = '%s', icon_id = '%s' WHERE id = %s ''' % ( form_dict['icon_link'], form_dict['icon_id'], you_dict["id"], ) query_list.append(query) if 'wallpaper_link' in form_dict and 'wallpaper_id' in form_dict: query = ''' UPDATE authority.users SET wallpaper_link = '%s', wallpaper_id = '%s' WHERE id = %s ''' % ( form_dict['wallpaper_link'], form_dict['wallpaper_id'], you_dict["id"], ) query_list.append(query) if 'password' in form_dict: password = make_password(form_dict['password']) query = ''' UPDATE authority.users SET pswrd = '%s' WHERE id = %s ''' % ( password, you_dict["id"], ) query_list.append(query) for q in query_list: cursor.execute(q) return True return run_db_action(callback)