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='******')
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='******')
