Ejemplo n.º 1
0
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
Ejemplo n.º 2
0
def num_of_registered():
    'the number of registerd users'
    database = database_open()
    fetched  = database_fetch( database, SQL_NUM_OF_REGISTERED )
    database_close( database )
    try:
        return fetched[ 0 ][ 'COUNT( * )' ]
    except:
        return 0
Ejemplo n.º 3
0
def do_it():
    'do it'
    try:
        database   = database_open()
        day, hour  = get_day(), int( sys.argv[ 1 ] )
        users      = get_user_by_date( database, day, hour )
        if not users:
            database_close( database )
            return
        utas       = get_uta_by_indices(
            database, [ user[ 'send_index' ] for user in users ] )
        smtpserver = get_smtpserver()
        for user in users:
            process_user( user, utas, database, smtpserver )
        database_close( database )
        smtpserver.close()
    except:
        error_handler()