From 5ab353f8527a3f5b6704536e3d48fb313f05cc7d Mon Sep 17 00:00:00 2001 From: Pinapelz Date: Tue, 18 Jun 2024 00:54:34 -0700 Subject: return total view_count in subscriber endpoint --- app.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'app.py') diff --git a/app.py b/app.py index 6f8bdfa..1169257 100644 --- a/app.py +++ b/app.py @@ -38,7 +38,7 @@ def api_subscribers(): server = create_database_connection() query = 'SELECT sd.*, h.* FROM subscriber_data sd INNER JOIN "24h_historical" h ON sd.channel_id = h.channel_id ORDER BY sd.subscriber_count DESC' data = server.execute_query(query) - channel_data_list = [{"channel_name": row[3], "profile_pic": row[2], "subscribers": row[4], "sub_org": row[5], "video_count": row[6], "day_diff": int(row[4] - int(row[10]))} for row in data] + channel_data_list = [{"channel_name": row[3], "profile_pic": row[2], "subscribers": row[4], "sub_org": row[5], "video_count": row[6], "views": row[8], "day_diff": int(row[4] - int(row[11]))} for row in data] subscriber_data = {"timestamp": datetime.datetime.now(), "channel_data": channel_data_list} return jsonify(subscriber_data) -- cgit v1.2.3