def cancel_user( database, mail_address ): 'cencel the registration of the user' mail_address = mail_address.strip() query = SQL_CANCEL % dict( datetime = ( '%s' % datetime.now() )[ : 19 ], mail_address = mail_address ) database_execute( database, query )
def transition_of_num_of_registered(): 'the transition of number of registered users' database = database_open() database_execute( database, "SET max_error_count = 0" ) fetched = database_fetch( database, SQL_TRANSITION_USERS ) database_execute( database, "SET max_error_count = 64" ) database_close( database ) return fetched
def update_user( database, mail_address, direction, column, row, day, hour ): 'register or update user information' mail_address = mail_address.strip() if get_user_by_mail( database, mail_address ): query = SQL_UPDATE % dict( direction = direction, column = column, row = row, day = day, hour = hour, mail_address = mail_address ) else: query = SQL_REGISTER % dict( mail_address = mail_address, direction = direction, column = column, row = row, day = day, hour = hour, datetime = ( '%s' % datetime.now() )[ : 19 ] ) database_execute( database, query )
def increment_send_index( database, mail_address ): 'increment the uta index to send next of specified user' mail_address = mail_address.strip() query = SQL_INCREMENT % dict( mail_address = mail_address ) database_execute( database, query )