Example #1
0
def addLog(**kwargs):
    if ('message' not in kwargs):
        logging.warning('invalid params: message not exist')
        return -1
    message =  kwargs['message']
    db_util = DBUtil()
    db_util.add_use_log(UseLog(message=message, log_time=datetime.now()))
    return 0
Example #2
0
def verify(**kwargs):
    if ('serial_key' not in kwargs):
        logging.warning('invalid params: serial_key not exist')
        return -2

    serial_key = kwargs['serial_key']
    db_util = DBUtil()
    return db_util.check_serial(serial_key)
Example #3
0
def test_get_account_data_mysql():
    db_util = DBUtil()

    test_system = SystemInfo(sys_name='test_system', db_type=DatabaseType.mysql, db_ip='127.0.0.1',
                         db_port='3306', db_name='wpd', db_table_name='user_table', db_column_username='******',
                         db_column_password='******', db_password_encrypt_algorithm=EncryptAlgorithmType.md5)

    db_util.add_system(test_system)
    print '____________________%d' % test_system.id
    test_system.get_account_data(username='******', password='******')
Example #4
0
def test_get_account_data_oracle():
    db_util = DBUtil()

    test_system = SystemInfo(sys_name='test_system2', db_type=DatabaseType.oracle, db_ip='192.168.238.130',
                         db_port='1521', db_name='ora11g', db_table_name='PM_BID_PROJECT_INFO', db_column_username='******',
                         db_column_password='******', db_password_encrypt_algorithm=EncryptAlgorithmType.md5)

    db_util.add_system(test_system)
    print '____________________%d' % test_system.id
    test_system.get_account_data(username='******', password='******')
Example #5
0
def test_sysinfo_manage():
    db_util = DBUtil()

    #create
    demo_system = SystemInfo(sys_name='oa333', db_type=DatabaseType.oracle, db_ip='127.0.0.1',
                         db_port='1521', db_name='db', db_table_name='accounts', db_column_username='******',
                         db_column_password='******', db_password_encrypt_algorithm=EncryptAlgorithmType.md5)
    db_util.add_system(demo_system)
    for i in db_util.get_all_system():
        print i

    #update
    demo_system.db_type = DatabaseType.mysql
    demo_system.db_port = '3306'

    #request
    idd = demo_system.id
    print '____________________%d' % idd
    s =  db_util.get_system_by_id(idd)
    print s
    print '__ __ __ __ __ __ __ ___ ___%d' % idd

    #delete
    db_util.del_system(s)
    s =  db_util.get_system_by_id(idd)
    print s