def test_get_field_value():
tcdb = TcDatabase()
tcdb.connect(host, port, user, password, database)
result = tcdb.get_field_value("auto_test_testsuitexecuterecord", 'creator',
"creator='admin'")
print("result in test_get_field_value: %s\n" % result)
assert result == 'admin'
def test_select_all():
tcdb = TcDatabase()
tcdb.connect(host, port, user, password, database)
result = tcdb.select_all("auto_test_testsuitexecuterecord",
"creator='admin'")
print("result in test_select_all: %s\n" % result)
assert len(result) >= 1
def test_select_one():
tcdb = TcDatabase()
tcdb.connect(host, port, user, password, database)
result = tcdb.select_one("auto_test_testsuitexecuterecord",
"creator='admin'")
print("result in test_select_one: %s\n" % result)
assert type(result) == dict, 'failed in test_select_one'
assert result['creator'] == 'admin', 'failed in test_select_one'
def test_execute_sql():
tcdb = TcDatabase()
tcdb.connect(host, port, user, password, database)
sql = "select * from auto_test_testsuitexecuterecord;"
result = tcdb.execute_sql(sql)
print("result in test_execute_sql: %s\n" % result)
assert type(result) == list
assert len(result) >= 1, 'failed in test_execute_sql'
def test_update():
tcdb = TcDatabase()
tcdb.connect(host, port, user, password, database)
val_obj = """{"id": 1, "name": "\\u641c\\u8d85\\u4eba\\u7535\\u5f71", "author": "\\u5434\\u8001\\u5e08",
"create_time": "2020-07-02 02:42:57.602000", "update_time": "2020-07-04 02:42:57.602000",
"belong_module_id": 1, "belong_project_id": 1, "user_id": 2}"""
result = tcdb.update("auto_test_testcase", val_obj, "id=1")
print("result in test_update: %s\n" % result)
assert result >= 0
def test_msyql_result_assert():
tcdb = TcDatabase()
tcdb.connect(host, port, user, password, database)
result = tcdb.mysql_result_assert("select * from auto_test_testcase;")
print("result in test_msyql_result_assert: %s\n" % result)
assert result == 'yes'
def test_sum():
tcdb = TcDatabase()
tcdb.connect(host, port, user, password, database)
result = tcdb.sum("test_sum", "id", "belong_project_id=1")
print("result in test_update: %s\n" % result)
assert result >= 0
def test_connect():
tcdb = TcDatabase()
tcdb.connect(host, port, user, password, database)
assert tcdb.connected == True, 'failed'
def test_count():
tcdb = TcDatabase()
tcdb.connect(host, port, user, password, database)
result = tcdb.count("auto_test_testcase", "id=16")
print("result in test_count: %s\n" % result)
assert result >= 1