def setup_module(): initdata.set_test_data(env, test_parameter) header['X-Auth-Token'] = test_parameter['backend_token'] header['X-Auth-Nonce'] = test_parameter['backend_nonce'] idList.append( api.search_user(test_parameter['prefix'], test_parameter['user_acc'], header)) idList.append( api.search_user(test_parameter['prefix'], test_parameter['user1_acc'], header)) idList.append( api.search_user(test_parameter['prefix'], 'track0900', header)) idList.append( api.search_user(test_parameter['prefix'], 'track0901', header)) idList.append( api.search_user(test_parameter['prefix'], test_parameter['broadcaster_acc'], header)) idList.append( api.search_user(test_parameter['prefix'], test_parameter['broadcaster1_acc'], header)) initdata.resetData(test_parameter['db'], idList[0]) for i in range(10): liveAccount = 'broadcaster0' + str(30 + i) liveList.append( api.search_user(test_parameter['prefix'], liveAccount, header))
def initTestingData(): #print('init data') header['X-Auth-Token'] = test_parameter['backend_token'] header['X-Auth-Nonce'] = test_parameter['backend_nonce'] idlist.append(api.search_user(test_parameter['prefix'], test_parameter['broadcaster_acc'], header)) idlist.append(api.search_user(test_parameter['prefix'], test_parameter['broadcaster1_acc'], header)) idlist.append(api.search_user(test_parameter['prefix'], test_parameter['user_acc'], header)) idlist.append(api.search_user(test_parameter['prefix'], test_parameter['user1_acc'], header)) idlist.append(api.search_user(test_parameter['prefix'], test_parameter['broadcaster2_acc'], header)) initdata.resetData(test_parameter['db'], idlist[0])
def init(): initdata.set_test_data(env, test_parameter) header['X-Auth-Token'] = test_parameter['backend_token'] header['X-Auth-Nonce'] = test_parameter['backend_nonce'] idlist.append(api.search_user(test_parameter['prefix'], test_parameter['broadcaster_acc'], header)) idlist.append(api.search_user(test_parameter['prefix'], test_parameter['broadcaster1_acc'], header)) idlist.append(api.search_user(test_parameter['prefix'], test_parameter['user_acc'], header)) idlist.append(api.search_user(test_parameter['prefix'], test_parameter['user1_acc'], header)) initdata.resetData(test_parameter['db'], idlist[0]) sqlList = ["insert into zego_master values('" + idlist[0] + "')"] dbConnect.dbSetting(test_parameter['db'], sqlList)
def init(): initdata.set_test_data(env, test_parameter) header['X-Auth-Token'] = test_parameter['backend_token'] header['X-Auth-Nonce'] = test_parameter['backend_nonce'] idlist.append( api.search_user(test_parameter['prefix'], test_parameter['broadcaster_acc'], header)) idlist.append( api.search_user(test_parameter['prefix'], test_parameter['broadcaster1_acc'], header)) idlist.append( api.search_user(test_parameter['prefix'], test_parameter['user_acc'], header)) idlist.append( api.search_user(test_parameter['prefix'], test_parameter['user1_acc'], header)) initdata.resetData(test_parameter['db'], idlist[0])
def setup_module(): initdata.set_test_data(env, test_parameter) header['X-Auth-Token'] = test_parameter['backend_token'] header['X-Auth-Nonce'] = test_parameter['backend_nonce'] idList.append( api.search_user(test_parameter['prefix'], test_parameter['broadcaster_acc'], header)) idList.append( api.search_user(test_parameter['prefix'], test_parameter['broadcaster1_acc'], header)) idList.append( api.search_user(test_parameter['prefix'], test_parameter['backend_acc'], header)) idList.append( api.search_user(test_parameter['prefix'], test_parameter['user_acc'], header)) initdata.resetData(test_parameter['db'], idList[0]) for i in range(2000, 2030): account = 'track' + str(i) userList.append( api.search_user(test_parameter['prefix'], account, header))
def initData(): initdata.set_test_data(env, test_parameter) getLivemasterList() getFansList() initdata.resetData(test_parameter['db'], lmList[0]) setFollow()
def setup_module(): sqlList = [] initdata.set_test_data(env, test_parameter) header['X-Auth-Token'] = test_parameter['backend_token'] header['X-Auth-Nonce'] = test_parameter['backend_nonce'] for i in range(85, 101): if i // 10 < 10: account = 'broadcaster0' + str(i) else: account = 'broadcaster' + str(i) BClist.append(api.search_user(test_parameter['prefix'], account, header)) for i in range(3): if i > 0: account = 'track0' + str(i * 100 + 77) else: account = 'track0077' URlist.append(api.search_user(test_parameter['prefix'], account, header)) initdata.resetData(test_parameter['db'], BClist[0]) tableList = ['liveshow_gift_history', 'live_room_gift', 'live_room'] for i in tableList: if i == 'live_room': sqlStr = "delete from " + i + " where chat_server_id = 350" sqlList.append(sqlStr) elif i == 'live_room_gift': for k in URlist: sqlStr = "delete from " + i + " where create_user_id = '" + k + "'" sqlList.append(sqlStr) else: for k in URlist: sqlStr = "delete from " + i + " where giver_user_id = '" + k + "'" sqlList.append(sqlStr) dbConnect.dbSetting(test_parameter['db'], sqlList) sqlList.clear() for i in range(13): k = i % 3 if giftList[i * 2] in ('253b4361-1b0d-499d-9943-4452ab81a88c', '57cfc4a6-92f3-4c9f-86e5-045e3a5ba2fa', 'fd514de8-fdfb-4c56-9170-a9d92ffa125a'): if URlist[k] in category74: category74[URlist[k]] += giftList[i * 2 + 1] else: category74[URlist[k]] = giftList[i * 2 + 1] if BClist[i] in category74Formaster: category74Formaster[BClist[i]] += giftList[i * 2 + 1] else: category74Formaster[BClist[i]] = giftList[i * 2 + 1] if i < 5: if URlist[k] in top5Master: top5Master[URlist[k]] += giftList[i * 2 + 1] else: top5Master[URlist[k]] = giftList[i * 2 + 1] if i not in (1, 2): if BClist[i] in newMaster: newMaster[BClist[i]] += giftList[i * 2 + 1] else: newMaster[BClist[i]] = giftList[i * 2 + 1] if BClist[i] in totalMaster: totalMaster[BClist[i]] += giftList[i * 2 + 1] else: totalMaster[BClist[i]] = giftList[i * 2 + 1] if URlist[k] in totalPoint: totalPoint[URlist[k]] += giftList[i * 2 + 1] else: totalPoint[URlist[k]] = giftList[i * 2 + 1] sqlStr = "insert into live_room_gift(consumption_point, create_at, create_user_id, room_id, status, gift_id, target_user_id) values (" + str(giftList[i * 2 + 1]) sqlStr += ", FROM_UNIXTIME(" + str(create_At + i * 120) + ", '%Y-%m-%d %H:%i:%s'), '" + URlist[k] + "', 5487, 0, '" + giftList[i * 2] + "', '" + BClist[i] + "')" sqlList.append(sqlStr) begDatetime = datetime.fromtimestamp(create_At - 2) + timedelta(hours=-8) endDatetime = datetime.fromtimestamp(create_At + (600 + i * 120)) + timedelta(hours=-8) liveTimeSum[BClist[i]] = (endDatetime - begDatetime).seconds sqlStr = "insert into live_room(create_at, end_at, live_master_id, rtmp_url, status, chat_server_id, title) values ('" + begDatetime.strftime('%Y-%m-%d %H:%M:%S') + "', '" sqlStr += endDatetime.strftime('%Y-%m-%d %H:%M:%S') + "', '" + BClist[i] + "', 'rtmp://ottworigin2.media.hinet.net/live_angel06/3955fd05-309f-4a07-a8a2-a2bb6146e605', 0, 350, 0)" sqlList.append(sqlStr) Barrage = [35, 350] for i in range(13, 15): k = i % 3 totalPoint[URlist[k]] += Barrage[i % 13] if BClist[i] in totalMaster: totalMaster[BClist[i]] += Barrage[i % 13] else: totalMaster[BClist[i]] = Barrage[i % 13] if BClist[i] in newMaster: newMaster[BClist[i]] += Barrage[i % 13] else: newMaster[BClist[i]] = Barrage[i % 13] sqlStr = "insert into live_room_gift(consumption_point, create_at, create_user_id, room_id, status, barrage_id, target_user_id) values (" + str(Barrage[i % 13]) sqlStr += ", FROM_UNIXTIME(" + str(create_At + i * 120) + ", '%Y-%m-%d %H:%i:%s'), '" + URlist[k] + "', 5487, 0, '" + str(i % 13 + 1) + "', '" + BClist[i] + "')" sqlList.append(sqlStr) begDatetime = datetime.fromtimestamp(create_At - 2) + timedelta(hours=-8) endDatetime = datetime.fromtimestamp(create_At + (600 + i * 120)) + timedelta(hours=-8) liveTimeSum[BClist[i]] = (endDatetime - begDatetime).seconds sqlStr = "insert into live_room(create_at, end_at, live_master_id, rtmp_url, status, chat_server_id, title) values ('" + begDatetime.strftime('%Y-%m-%d %H:%M:%S') + "', '" sqlStr += endDatetime.strftime('%Y-%m-%d %H:%M:%S') + "', '" + BClist[i] + "', 'rtmp://ottworigin2.media.hinet.net/live_angel06/3955fd05-309f-4a07-a8a2-a2bb6146e605', 0, 350, 0)" sqlList.append(sqlStr) begDatetime = datetime.now() - timedelta(days=1) begDatetime = begDatetime.replace(hour=15, minute=30, second=0) endDatetime = datetime.now() - timedelta(days=1) endDatetime = endDatetime.replace(hour=17, minute=30, second=0) endDatetime1 = datetime.now() - timedelta(days=1) for i in range(10, 12): endDatetime1 = endDatetime1.replace(hour=17, minute=i, second=0) totalPoint[URlist[2]] += giftList[i * 2 + 1] if BClist[15] in totalMaster: totalMaster[BClist[15]] += giftList[i * 2 + 1] else: totalMaster[BClist[15]] = giftList[i * 2 + 1] if BClist[15] in newMaster: newMaster[BClist[15]] += giftList[i * 2 + 1] else: newMaster[BClist[15]] = giftList[i * 2 + 1] sqlStr = "insert into liveshow_gift_history(liveshow, team, giver_user_id, live_master_id, room_id, gift_id, points, ratio, create_at) values (1, 148, '" sqlStr += URlist[2] + "', '" + BClist[15] + "', 4567, '" + giftList[i * 2] + "'," + str(giftList[i * 2 + 1]) + ", 2.00, '" + endDatetime.strftime('%Y-%m-%d %H:%M:%S') + "')" sqlList.append(sqlStr) liveTimeSum[BClist[15]] = (endDatetime - begDatetime).seconds sqlStr = "insert into live_room(create_at, end_at, live_master_id, rtmp_url, status, chat_server_id, title) values ('" + begDatetime.strftime('%Y-%m-%d %H:%M:%S') + "', '" sqlStr += endDatetime.strftime('%Y-%m-%d %H:%M:%S') + "', '" + BClist[15] + "', 'rtmp://ottworigin2.media.hinet.net/live_angel06/3955fd05-309f-4a07-a8a2-a2bb6146e605', 0, 350, 0)" sqlList.append(sqlStr) OneToOneMessage # 加入1對1私訊資料 sendGiftToPost(BClist[15], URlist[0]) #加入動態送禮 for i in range(3): sqlStr = "update user_experience set experience = " + str(48000000 + i * 10000) + " where identity_id = '" + BClist[i] + "'" if i > 0: sqlStr2 = "delete from new_live_master where live_master_id = '" + BClist[i] + "'" sqlList.append(sqlStr2) sqlList.append(sqlStr) dbConnect.dbSetting(test_parameter['db'], sqlList)