From 5c48dcb23ac331a514d5af995edfcddd91e93a6f Mon Sep 17 00:00:00 2001 From: Pinapelz Date: Sun, 2 Jul 2023 13:37:28 -0700 Subject: remove 7 day limit on full tables --- html_builders/tables.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'html_builders/tables.py') diff --git a/html_builders/tables.py b/html_builders/tables.py index 6c35382..2ffe443 100644 --- a/html_builders/tables.py +++ b/html_builders/tables.py @@ -46,7 +46,7 @@ def generate_html_table(server, table, diff_table, headers=["Rank", "Liver", "Su cursor.close() return table_html -def generate_individual_table(server, table_name, channel_name, param="LIMIT 7"): +def generate_individual_table(server, table_name, channel_name, param=""): cursor = server.get_connection().cursor() query = f"SELECT subscriber_count, timestamp FROM {table_name} WHERE name=\"{channel_name}\" GROUP BY DATE(timestamp) ORDER by timestamp DESC " + param cursor.execute(query) -- cgit v1.2.3