def getRecommend(uid): result = findAllJson2() recomm = getRecommendations(result, uid) resultjson = '' list1 = [] dbutils = DBUtils(host, user, password, db, port) movie_list = [] if recomm[0][1]: print(recomm[0][1]) for i in range(5): redc = recomm[i][1] list1.append(redc) for item in list1: movie_item = getMovieByName(dbutils, item) movie_list.append(movie_item) else: sql = 'select * from movie where id<6' result = dbutils.query(sql) for item in result: movie_item = {} movie_item['id'] = item[0] movie_item['movieName'] = item[1].strip() movie_item['src'] = item[7] movie_item['averating'] = item[9].strip() movie_item['playPage'] = item[8] movie_item['fileName'] = item[10] movie_list.append(movie_item) dbutils.close() print(movie_list) return movie_list
def getMovieList(): dbutils = DBUtils(host, user, password, db, port) sql = 'select * from movie' result = dbutils.query(sql) movie_list = [] for item in result: movie_item = {} movie_item['id'] = item[0] movie_item['movieName'] = item[1].strip() movie_item['src'] = item[7] movie_item['averating'] = item[9].strip() movie_list.append(movie_item) dbutils.close() return movie_list
def getHistoryList(uid): dbutils = DBUtils(host, user, password, db, port) sql = 'select distinct m.id,m.movieName,m.movieType,m.director,m.star,m.release,m.language,m.coverUrl,m.playPage,m.averageScore,' \ 'm.fileName,m.year from movie as m join history ' \ 'as h where h.uid=%d and m.id = h.mid;' % int(uid) result = dbutils.query(sql) movie_list = [] for item in result: movie_item = {} movie_item['id'] = item[0] movie_item['movieName'] = item[1] movie_item['src'] = item[7] movie_item['averating'] = item[9] movie_list.append(movie_item) dbutils.close() return movie_list
def getMovieById(id): dbutils = DBUtils(host, user, password, db, port) sql = 'select * from movie where id=%d' % id result = dbutils.query(sql) movie = {} for item in result: movie['id'] = item[0] movie['name'] = item[1].strip() movie['src'] = item[7].strip() movie['averating'] = item[9].strip() movie['year'] = item[11] movie['director'] = item[3].strip() movie['star'] = item[4].strip() movie['type'] = item[2].strip() movie['language'] = item[6].strip() movie['release'] = item[5].strip() movie['playPage'] = item[8] movie['fileName'] = item[10] dbutils.close() return movie
def recordScore(uid, score, movieId): dbutils = DBUtils(host, user, password, db, port) sql = 'insert into history (uid,mid,score,dt) values (%d,%d,%d,now())' % (int(uid), int(movieId), int(score)) dbutils.insert(sql) dbutils.close()
''' @Time : 2017-2-28 21:20 @Author : Moses @File : GetLeagueListing.py ''' import requests from utils.DBUtils import DBUtils # https://wiki.teamfortress.com/wiki/WebAPI/GetLeagueListing url = "http://api.steampowered.com/IDOTA2Match_570/GetLeagueListing/v1" # url ="http://api.steampowered.com/IDOTA2Match_<ID>/GetLeagueListing/v1/" key = "?key=<key>" params = "&language=zh_cn" r = requests.get(url + key + params) rj = r.json() leagues = rj['result']['leagues'] dbutils = DBUtils() for l in leagues: league_name = l['name'] league_id = l['leagueid'] tournament_url = l['tournament_url'] itemdef = l['itemdef'] description = l['description'] dbutils.insertLeagues( [league_name, league_id, tournament_url, itemdef, description]) dbutils.close()