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