diff options
| author | Pinapelz <donaldshan1@outlook.com> | 2023-07-02 13:37:28 -0700 |
|---|---|---|
| committer | Pinapelz <donaldshan1@outlook.com> | 2023-07-02 13:37:28 -0700 |
| commit | 5c48dcb23ac331a514d5af995edfcddd91e93a6f (patch) | |
| tree | 33e2d194731083169ecf92b3b08f070874279ee4 | |
| parent | 4224d1170097bc704b83edd2bf48679d3e6b598c (diff) | |
remove 7 day limit on full tables
| -rw-r--r-- | html_builders/tables.py | 2 |
1 files changed, 1 insertions, 1 deletions
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) |