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 )
