本文整理汇总了Python中models.Movie.from_id方法的典型用法代码示例。如果您正苦于以下问题：Python Movie.from_id方法的具体用法？Python Movie.from_id怎么用？Python Movie.from_id使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类models.Movie的用法示例。
在下文中一共展示了Movie.from_id方法的1个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的Python代码示例。
示例1: save
# 需要导入模块: from models import Movie [as 别名]
# 或者: from models.Movie import from_id [as 别名]
def save(guess, user_id, movie_id):
user = User.from_id(user_id)
rating = Movie.from_id(movie_id).rating
guess_id = None
connection = connect()
try:
with connection.cursor() as cursor:
sql = """INSERT INTO `guesses` (guess, user_id, movie_id, diff)
VALUES (%s, %s, %s, %s)"""
cursor.execute(
sql,
(
guess,
user_id,
movie_id,
Guess.calculate_score(rating, guess)
)
)
guess_id = cursor.lastrowid
sql = """SELECT SUM(`diff`) AS score
FROM `guesses` WHERE `user_id`=%s"""
cursor.execute(sql, (user_id))
result = cursor.fetchone()
user.score = result[u'score']
connection.commit()
finally:
connection.close()
user.update()
return Guess.from_id(guess_id)