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