def update_contribution_request_count(tale_id, value): DAO.update( ''' UPDATE anaddventure.tale SET tale_contribution_request_count = tale_contribution_request_count + (%s) WHERE tale_id = (%s) ''', (value, tale_id))
def update_follow_count(tale_id, value): DAO.update( ''' UPDATE anaddventure.tale SET tale_follow_count = tale_follow_count + (%s) WHERE tale_id = (%s) ''', (value, tale_id))
def update_contribution_request_count(tale_id, value): DAO.update( ''' UPDATE anaddventure.tale SET tale_contribution_request_count = tale_contribution_request_count + (%s) WHERE tale_id = (%s) ''', (value, tale_id) )
def update_follow_count(tale_id, value): DAO.update( ''' UPDATE anaddventure.tale SET tale_follow_count = tale_follow_count + (%s) WHERE tale_id = (%s) ''', (value, tale_id) )
def update_all(tale_id, title, description, category, license_id): DAO.update( ''' UPDATE anaddventure.tale SET tale_title = (%s), tale_description = (%s), tale_category = (%s), tale_license = (%s) WHERE tale_id = (%s) ''', (title, description, category, license_id, tale_id))
def update_profile(user_id, name, email, biography, is_email_visible): DAO.update( """ UPDATE anaddventure.system_user SET system_user_name = (%s), system_user_email = (%s), system_user_biography = (%s), system_user_is_email_visible = (%s) WHERE system_user_id = (%s) """, (name, email, biography, is_email_visible, user_id))
def update_all(tale_id, title, description, category, license_id): DAO.update( ''' UPDATE anaddventure.tale SET tale_title = (%s), tale_description = (%s), tale_category = (%s), tale_license = (%s) WHERE tale_id = (%s) ''', (title, description, category, license_id, tale_id) )
def update_title_and_content(contribution_request_id, title, content): return DAO.update( ''' UPDATE anaddventure.contribution_request SET contribution_request_title = (%s), contribution_request_content = (%s) WHERE contribution_request_id = (%s) ''', (title, content, contribution_request_id))
def update_was_accepted(contribution_request_id, was_accepted): return DAO.update( ''' UPDATE anaddventure.contribution_request SET contribution_request_was_accepted = (%s), contribution_request_was_closed = True WHERE contribution_request_id = (%s) ''', (was_accepted, contribution_request_id))
def update_title_and_content(contribution_request_id, title, content): return DAO.update( ''' UPDATE anaddventure.contribution_request SET contribution_request_title = (%s), contribution_request_content = (%s) WHERE contribution_request_id = (%s) ''', (title, content, contribution_request_id) )
def update_was_accepted(contribution_request_id, was_accepted): return DAO.update( ''' UPDATE anaddventure.contribution_request SET contribution_request_was_accepted = (%s), contribution_request_was_closed = True WHERE contribution_request_id = (%s) ''', (was_accepted, contribution_request_id) )
def update_title_and_content(chapter_id, title, content): return DAO.update( "UPDATE anaddventure.chapter SET chapter_title = (%s), chapter_content = (%s) WHERE chapter_id = (%s)", (title, content, chapter_id))
def update_download_count(chapter_id): return DAO.update( "UPDATE anaddventure.chapter SET chapter_download_count = chapter_download_count + 1 WHERE chapter_id = (%s)", (chapter_id, ) )
def update_title_and_content(chapter_id, title, content): return DAO.update( "UPDATE anaddventure.chapter SET chapter_title = (%s), chapter_content = (%s) WHERE chapter_id = (%s)", (title, content, chapter_id) )
def update_password(user_id, password): DAO.update( "UPDATE anaddventure.system_user SET system_user_password = (%s) WHERE system_user_id = (%s)", (hashlib.sha256(password.encode('utf-8')).hexdigest(), user_id))
def activate_account(user_id): DAO.update( "UPDATE anaddventure.system_user SET system_user_is_valid_account = True WHERE system_user_id = (%s)", (user_id, ))
def update_download_count(chapter_id): return DAO.update( "UPDATE anaddventure.chapter SET chapter_download_count = chapter_download_count + 1 WHERE chapter_id = (%s)", (chapter_id, ))