def SelectStreamerInfo():
sql="select `kwai_id`,`eid`,`user_name`,`gender`,`horoscope`,`city`,`fans_num`,`product_num`,`oss_avatar_url`,`brief`,`has_kwai_shop`,`tag` " \
"from `ai_ks_live`.`ks_user`" \
" where `streamer_id`=188888880"
result = dbConnect.dbConnection(sql)
dict = {}
dict['kwai_id'] = result[0]
dict['eid'] = result[1]
dict['user_name'] = result[2]
dict['gender'] = result[3]
dict['horoscope'] = result[4]
dict['city'] = result[5]
dict['fans_num'] = result[6]
dict['product_num'] = result[7]
dict['oss_avatar_url'] = result[8]
dict['brief'] = result[9]
dict['has_kwai_shop'] = result[10]
dict['tag'] = result[11]
return dict
def getMonitorVideoID(self, userID):
sql = "select `photo_id` from `ks_live_spider_extra`.`ks_schedule_photo_monitor` where `monitor_user_id`=%s and `create_time`>'2019-12-24 10:00:00' and `status`=2;" % userID
videoID = dbConnect.dbConnection(sql)
return videoID
def getVideoViewCount(self, videoId):
sql = "select `view_count` from `ks_live_spider_extra`.`ks_user_video_monitor` where `photo_id`='%s';" % videoId
videoID = dbConnect.dbConnection(sql)
return videoID
def selectVideoID(self):
sql = "select `photo_id` from `ai_ks_live`.`ks_video_info` where `publish_time`>SUBDATE(now(),INTERVAL 24 hour) and `deleted_status`=0 limit 220;"
videoID = dbConnect.dbConnection(sql)
return videoID
def selectTeamCount(self, userId1, userId2):
sql = "select count(*) from `ai_ks_live`.`ks_user_collect` where `user_id` in (%s,%s)and `status`=1" % (
userId1, userId2)
count = dbConnect.dbConnection(sql)
return count
def selectCount(self, userId1):
sql = "select count(*) from `ai_ks_live`.`ks_user_collect` where `user_id`=%s and `status`=1" % userId1
print(sql)
count = dbConnect.dbConnection(sql)
return count