def save_media_data(self, data):
sql = "insert into mediadb.media_simple (id, title, rate, url, classify) VALUES "
for i in range(len(data)):
sql = sql + "( '" + data[i]['id'].replace("'", "''") + "', '" + data[i]['title'].replace("'", "''") + "', '" \
+ data[i]['rate'].replace("'", "''") + "', '" + data[i]['url'].replace("'", "''") + "', '" + data[i]['classify'].replace("'", "''") + "')"
if i != len(data) - 1:
sql = sql + ","
else:
sql = sql + ";"
mysql().insertOperation(sql)
def save_media_detail(self, data):
sql = "INSERT INTO `mediadb`.`media_detail` (`id`,`title`,`title_long`,`m_year`,`classify`," \
"`m_type`,`country`,`m_language`,`release_date`,`runtime`,`season`,`episodes`,`along_run_time`,`alias`," \
"`imdb_id`,`score`,`stars5`,`stars4`,`stars3`,`stars2`,`stars1`,`people_num`,`tags`,`report`)VALUES"
sql = sql + "('" + data['id'].replace("'", "''") + "', '" + data['title'].replace("'", "''") + "', '" + data['titleLong'].replace("'", "''") + "', '" + data['year'].replace("'", "''") \
+ "', '" + data['classify'].replace("'", "''") + "', '" + data['type'].replace("'", "''") + "', '" + data['country'].replace("'", "''") + "', '" + data['language'].replace("'", "''") \
+ "', '" + data['releaseDate'].replace("'", "''") + "', '" + data['runtime'].replace("'", "''") + "', '" + data['season'].replace("'", "''") + "', '" + data['episodes'].replace("'", "''") \
+ "', '" + data['alongRuntime'].replace("'", "''") + "', '" + data['alias'].replace("'", "''") + "', '" + data['imdbId'].replace("'", "''") + "', '" + data['score'].replace("'", "''") \
+ "', '" + data['rating']['stars5'].replace("'", "''") + "', '" + data['rating']['stars4'].replace("'", "''") + "', '" + data['rating']['stars3'].replace("'", "''") + "', '" + data['rating']['stars2'].replace("'", "''") \
+ "', '" + data['rating']['stars1'].replace("'", "''") + "', '" + data['rating']['peopleNum'].replace("'", "''") + "', '" + data['tags'].replace("'", "''") + "', '" + data['report'].replace("'", "''") + "');"
mysql().insertOperation(sql)
def save_media_attr(self, dataList, id, title, type):
sql = "insert into mediadb.media_attender (id, title, attender_id, attender_name, attender_type) values "
for i in range(len(dataList)):
sql = sql + "('" + id.replace("'", "''") + "', '" + title.replace(
"'", "''") + "', '" + dataList[i]['id'].replace(
"'", "''") + "', '" + dataList[i]['name'].replace(
"'", "''") + "', '" + type.replace("'", "''") + "')"
if i != len(dataList) - 1:
sql = sql + ","
else:
sql = sql + ";"
mysql().insertOperation(sql)
def save_media_recommend(self, recommendList, id, title):
sql = "insert into mediadb.media_recommend (id, title, recommend_id, recommend_title) values "
for i in range(len(recommendList)):
sql = sql + "('" + id.replace("'", "''") + "', '" + title.replace(
"'", "''") + "', '" + recommendList[i]['id'].replace(
"'", "''") + "', '" + recommendList[i]['name'].replace(
"'", "''") + "')"
if i != len(recommendList) - 1:
sql = sql + ","
else:
sql = sql + ";"
mysql().insertOperation(sql)
def save_media_pic_id(self, dataList):
sql = "insert into mediadb.media_pic (id, title, pic_id) values "
for i in range(len(dataList)):
sql = sql + "('" + dataList[i]['id'].replace(
"'", "''") + "', '" + dataList[i]['title'].replace(
"'", "''") + "', '" + dataList[i]['picId'].replace(
"'", "''") + "')"
if i != len(dataList) - 1:
sql = sql + ","
else:
sql = sql + ";"
mysql().insertOperation(sql)
def save_media_award(self, dataList):
sql = "insert into mediadb.media_award (id, title, award_name, award_year, award_type, award_user_id, award_user_name) values "
for i in range(len(dataList)):
sql = sql + "('" + dataList[i]['id'].replace(
"'", "''") + "', '" + dataList[i]['title'].replace(
"'", "''") + "', '" + dataList[i]['awardName'].replace(
"'", "''") + "', '" + dataList[i]['awardYear'].replace(
"'",
"''") + "', '" + dataList[i]['awardType'].replace(
"'", "''"
) + "', '" + dataList[i]['awardUserId'].replace(
"'", "''"
) + "', '" + dataList[i]['awardUserName'].replace(
"'", "''") + "')"
if i != len(dataList) - 1:
sql = sql + ","
else:
sql = sql + ";"
mysql().insertOperation(sql)
def update_media_history(self, type):
sql = "update mediadb.query_history_data set num = num + 1 where type = '" + type + "' ;"
mysql().updateOperation(sql)
def query_media_history(self, type):
sql = "select * from mediadb.query_history_data where type = '" + str(
type) + "';"
return mysql().queryOperation(sql)
def query_media_data(self, start, size):
sql = "select * from mediadb.media_simple order by media_id limit " + str(
start) + ", " + str(size) + ";"
return mysql().queryOperation(sql)
def query_history_data(self):
sql = "select target_num, num from mediadb.history_data where id = 1;"
return mysql().queryOperation(sql)
def save_history_data(self, targetNum, num):
sql = "update mediadb.history_data set target_num = " + str(
targetNum) + ", num = " + str(num) + " where id = 1;"
mysql().updateOperation(sql)
def query_media_pic_id(self, movieId):
sql = "select * from mediadb.media_pic where id = " + movieId + ";"
return mysql().queryOperation(sql)