summaryrefslogtreecommitdiffstats
path: root/app.py
diff options
context:
space:
mode:
authorPinapelz <yukais@pinapelz.com>2024-06-18 00:54:34 -0700
committerPinapelz <yukais@pinapelz.com>2024-06-18 00:54:34 -0700
commit5ab353f8527a3f5b6704536e3d48fb313f05cc7d (patch)
treebcae74aa75e900416ab709504a483f0eacb34774 /app.py
parenta84d8973ad402caef19a0f86842bed69832702af (diff)
return total view_count in subscriber endpoint
Diffstat (limited to 'app.py')
-rw-r--r--app.py2
1 files changed, 1 insertions, 1 deletions
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)
send patches to the email below
yukais@pinapelz.com
include the subject [PATCH repo_name]
pinapelz.com
homepage