diff options
| author | Pinapelz <yukais@pinapelz.com> | 2024-06-18 00:54:34 -0700 |
|---|---|---|
| committer | Pinapelz <yukais@pinapelz.com> | 2024-06-18 01:12:13 -0700 |
| commit | deac9543f5f67fb94eecf23e5f964c170189f214 (patch) | |
| tree | 83b4d2ea0213ce9c37bc671d0680ad44687476f3 /app.py | |
| parent | 64aecd7fb00c0f9edd0739af6681e09eeaa5c7d5 (diff) | |
return total view_count in subscriber endpoint
Diffstat (limited to 'app.py')
| -rw-r--r-- | app.py | 2 |
1 files changed, 1 insertions, 1 deletions
@@ -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) |
