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)
