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)