def save_rules(rules):
conn = DataHelper.connect_to_db()
for rule in rules:
sql = """INSERT INTO seeded_recs (created, source, target, support, confidence, type)
VALUES ('{}', '{}', '{}', {}, {}, 'associate')"""
print(sql.format(rule[0], rule[1], rule[2], rule[3], rule[4]))
conn.cursor().execute(sql.format(rule[0], rule[1], rule[2], rule[3], rule[4]))
conn.commit()
conn.close()
def save_ratings(ratings, userid, type, conn=DataHelper.connect_to_db()):
print("saving ratings")
i = 0
for content_id, rating in ratings.items():
sql = """
UPDATE analytics_rating
SET rating = {},rating_timestamp = '{}', type='{}'
WHERE user_id = {} and movie_id = {}
""".format(rating, datetime.datetime.now(), type, userid, content_id)
# print (sql)
conn.cursor().execute(sql)
i += 1
if i == 100:
print('.', end="")
i = 0
