def random_play_back(starts, ends, sid, test_type): for k in range(random_size): # starts.append(datetime.datetime.now() - datetime.timedelta(seconds=random.randint(0, 345600))) starts.append(datetime.datetime(2016, 5, 5) + datetime.timedelta(seconds=random.randint(0, 43200))) ends.append(starts[k] + datetime.timedelta(seconds=15)) for k in range(random_size): run_in_background(url_stat, urls[3] % (starts[k].year, starts[k].month, starts[k].day, starts[k].hour, starts[k].minute, starts[k].second, ends[k].year, ends[k].month, ends[k].day, ends[k].hour, ends[k].minute, ends[k].second, random.randint(2, 4), 125, 216, 231, 164, 37777, sid), test_type) time.sleep(0.05)
conn = sqlite3.connect(db_name) cursor = conn.cursor() cursor.execute(sql_fmt, *args) values = cursor.fetchall() cursor.close() conn.close() mutex.release() return values def test_new_table(): new_table('test.db', 'user', 'id varchar(20), name varchar(20)') def test_insert(): execute('test.db', 'insert into user (id, name) values (\'' + str(random.randint(0, 100)) + '\', \'test' + str( random.randint(0, 100)) + '\')') def test_query(): print(query('test.db', 'select * from user')) if __name__ == '__main__': test_new_table() for i in range(9): if i % 2 == 0: run_in_background(test_query) else: run_in_background(test_insert)
# back_cache_stat() # # # 直播缓存测试 # real_cache_stat() # # # 回播缓存测试 # long_cache_stat() # # print_data_set(query_stat_all()) # # # 模拟正常流程测试 # sample_stat("3") # # # 模拟单客户端多次测试 # for i in range(30): # sample_stat("3") # print_data_set(query_stat_all()) # print('range : ' + str(i)) # # 模拟多客户端测试 for i in range(4): run_in_background(sample_stat, "4") sample_stat("4") input('请按回车退出') print_data_set(query_stat_all()) # 测试删 # sqlite.execute('url_stat.db', 'delete from single WHERE id > 2099') # 测试改 # sqlite.execute('url_stat.db', 'update single set type = 3 WHERE type = 1')
cursor.execute(sql_fmt, *args) values = cursor.fetchall() cursor.close() conn.close() mutex.release() return values def test_new_table(): new_table('test.db', 'user', 'id varchar(20), name varchar(20)') def test_insert(): execute( 'test.db', 'insert into user (id, name) values (\'' + str(random.randint(0, 100)) + '\', \'test' + str(random.randint(0, 100)) + '\')') def test_query(): print(query('test.db', 'select * from user')) if __name__ == '__main__': test_new_table() for i in range(9): if i % 2 == 0: run_in_background(test_query) else: run_in_background(test_insert)