def retrieve_transactions(): sql = """ SELECT * FROM Collector_log WHERE event = 'buy' ORDER BY session_id, content_id """ cursor = DataHelper.get_query_cursor(sql) data = DataHelper.dictfetchall(cursor) return data
def chart(request, take=10): sql = """SELECT content_id, mov.title, count(*) as sold FROM collector_log log JOIN moviegeeks_movie mov ON log.content_id = mov.movie_id WHERE event like 'buy' GROUP BY content_id, mov.title ORDER BY sold desc LIMIT {} """.format(take) c = DataHelper.get_query_cursor(sql) data = DataHelper.dictfetchall(c) return JsonResponse(data, safe=False)
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