From 13625d722a421441c1edc6eb1256b7e20f20544d Mon Sep 17 00:00:00 2001 From: Pinapelz Date: Sun, 26 Nov 2023 02:36:07 -0800 Subject: use SSR for rendering graph + transition demo to PhaseConnect - I like Phase Connect --- backend/data/exclude_channel.txt | 119 +++------------------------------------ backend/data/last_refresh.txt | 2 +- backend/graph.py | 2 +- backend/index.html | 14 +++++ backend/sql_table_config.json | 2 +- 5 files changed, 25 insertions(+), 114 deletions(-) create mode 100644 backend/index.html (limited to 'backend') diff --git a/backend/data/exclude_channel.txt b/backend/data/exclude_channel.txt index 314b524..760a480 100644 --- a/backend/data/exclude_channel.txt +++ b/backend/data/exclude_channel.txt @@ -1,111 +1,8 @@ -UCX7YkU9nEeaoZbkVLVajcMg -UCwi4P78SVunSYAGrvC9aKcw -UCNRh9kkByBTYLo0IJupnAug -C4Jyg9gFStHO8r5n4ya7XCQ -UCStzBFfjwFYb0qSYHnzFZvw -UCrhf6HYKnV6bxyaB6ooJzbw -UCfki3lMEF6SGBFiFfo9kvUA -UCtHFXfrn52juTqGBN4WbMVw -UCbLgcjfsUaCUgJh9SVit8kw -UC_D2DNy-KUNQJ_NGMppgmyg -UCxWcO9CLti4uouUIS5IIF-Q -UC4Jyg9gFStHO8r5n4ya7XCQ -UCz6vnIbgiqFT9xUcD6Bp65Q -UC-JSeFfovhNsEhftt1WHMvg -UC0PwyIlUefx1LGWjFI0QjMg -UCRzHROJUp7Wg900p_fXtJtQ -UC2NtHPaDUA5htYsjVrO8Gng -UCLSzgV37Dt24T8p3-TNiSLg -UC8vZcu6W-EJ6UYEy_C31c-A -UCh00mQw8BCrTbchYWGz4JTQ -UCWwwXXd_RPzj3LAyEfBslsg -UCINqoksO3CQPCt8a-mRe-Ew -UCF1JdALrXgub24weQpqDy9Q -UCvQIBipkXlXXVdGga9sn8dw -UCKQi12nOGZsJ5nOuCTHErmA -UCSUZugdxy9Wcrkp781cFt1w -UCTi_rzf5QIkXjhJjkbcAdTg -UCpfjQCCavrO-rnKaAaIF9dg -UCX7YkU9nEeaoZbkVLVajcMg -UCwi4P78SVunSYAGrvC9aKcw -UCNRh9kkByBTYLo0IJupnAug -C4Jyg9gFStHO8r5n4ya7XCQ -UCStzBFfjwFYb0qSYHnzFZvw -UCrhf6HYKnV6bxyaB6ooJzbw -UCfki3lMEF6SGBFiFfo9kvUA -UCtHFXfrn52juTqGBN4WbMVw -UCbLgcjfsUaCUgJh9SVit8kw -UC_D2DNy-KUNQJ_NGMppgmyg -UCxWcO9CLti4uouUIS5IIF-Q -UC4Jyg9gFStHO8r5n4ya7XCQ -UCz6vnIbgiqFT9xUcD6Bp65Q -UC-JSeFfovhNsEhftt1WHMvg -UC0PwyIlUefx1LGWjFI0QjMg -UCRzHROJUp7Wg900p_fXtJtQ -UC2NtHPaDUA5htYsjVrO8Gng -UCLSzgV37Dt24T8p3-TNiSLg -UC8vZcu6W-EJ6UYEy_C31c-A -UCh00mQw8BCrTbchYWGz4JTQ -UCWwwXXd_RPzj3LAyEfBslsg -UCINqoksO3CQPCt8a-mRe-Ew -UCF1JdALrXgub24weQpqDy9Q -UCvQIBipkXlXXVdGga9sn8dw -UCKQi12nOGZsJ5nOuCTHErmA -UCSUZugdxy9Wcrkp781cFt1w -UCTi_rzf5QIkXjhJjkbcAdTg -UCpfjQCCavrO-rnKaAaIF9dg -UC0lik9pHju6ONgkBh7N5wHw -UC1ZV7KBscK0EMoJKFu1DnDg -UC69URn8iP4u8D_zUp-IJ1sg -UC6oW4FXETgEGOFTxWmI2h5Q -UC6WU2SrnG019ucm_bdY6qxQ -UC8oPnditPSp5lZu45fnXWCA -UC9oudjCTHL2BfwxfDwI18eg -UC_a1ZYZ8ZTXpjg9xUY9sj8w -UC_aB_-PHLFHiP61djM0oOiQ -UCb5JxV6vKlYVknoJB8TnyYg -UCbLgcjfsUaCUgJh9SVit8kw -UCCJcCWrbQzz6eDhX4M1CUwg -UCCVwhI5trmaSxfcze_Ovzfw -UCF1JdALrXgub24weQpqDy9Q -UCFaDvgez8USXHiKidt0NtZg -UCfki3lMEF6SGBFiFfo9kvUA -UCfM_A7lE6LkGrzx6_mOtI4g -UCi6nV5Z2dzFuXBzLG3P9zqQ -UCIairB9UMDvqSKfMdv1jmjg -UCIJ9zP6gIkT8BB4Lz4UYPhA -UCJ6LH4jMNy0JN9RSThz1mMQ -UCjGE11ZnF0JSR8egVAwh-3A -UCks41vQN-hN-1KHmpZyPY3A -UCLpYMk5h1bq8_GAFVBgXhPQ -UCLSzgV37Dt24T8p3-TNiSLg -UCmWqYB6y8gSfPONWGspuOWQ -UCNUgrFCo2Hr_VXc9bEwjcHQ -UCOmjciHZ8Au3iKMElKXCF_g -UCP2o-o6u4uX3uq1hXspl0rg -UCqEp6RdtsMbUNrCdCswr6pA -UCqQV8xEBWd5SVZBLlYrS_5Q -UCRzHROJUp7Wg900p_fXtJtQ -UCSc_KzY_9WYAx9LghggjVRA -UCSlv7Z-4q7_7NRkzJB10A5Q -UCStzBFfjwFYb0qSYHnzFZvw -UCufQu4q65z63IgE4cfKs1BQ -UCuz0vzQgC8LRdS6lVV0UkUg -UCveZ9Ic1VtcXbsyaBgxPMvg -UCwcyyxn6h9ex4sMXGtpQE_g -UCwQ9Uv-m8xkE5PzRc7Bqx3Q -UCyqzU2nq7eGNi4kN0uHx7TA -UCZgRRTDMYwHpQ7sCl0aCp2Q -UCzMAP-oh5-pC8j6RlCPf26w -UC5qSx7KzdRwbsO1QmJc4d-w -UC5yckZliCkuaEFbqzLBD7hQ -UCA3WE2WRSpoIvtnoVGq4VAw -UCe_p3YEuYJb8Np0Ip9dk-FQ -UCeShTCVgZyq2lsBW9QwIJcw -UCIBj1-d71vKjRftiauF50pg -UCIM92Ok_spNKLVB5TsgwseQ -UCk5r533QVMgJUdWwqegH2TA -UCkieJGn3pgJikVW8gmMXE2w -UCoWH3sDpeXG1aXmOxveX4KA -UCrR7JxkbeLY82e8gsj_I0pQ -UCZ5dNZsqBjBzbBl0l_IdmXg +UCRW3qJuYP8aODl7_5TXn_nw +UCx7aPMHI_kK1CP6zSvilHSA +UCL0_lYZwyhbcNX-feoyCcJw +UCkDfBt3R64R2rRIrAQwldeQ +UCa_EIfw5I5uDlwsK6sc-83Q +UC3-Rfh_Ek-s6EUWS4fT5VPw +UCUC1EIq0MtF-kctHPtQzIjQ +UCvmSVAwFc5MJwQowsDvCTuw diff --git a/backend/data/last_refresh.txt b/backend/data/last_refresh.txt index 07602c3..0f7ae5c 100644 --- a/backend/data/last_refresh.txt +++ b/backend/data/last_refresh.txt @@ -1 +1 @@ -2023-11-18 \ No newline at end of file +2023-11-26 \ No newline at end of file diff --git a/backend/graph.py b/backend/graph.py index 16c6f6e..815c1ea 100644 --- a/backend/graph.py +++ b/backend/graph.py @@ -5,7 +5,7 @@ import math from datetime import datetime, timedelta import numpy as np -def plot_subscriber_count_over_time(server, table_name, gtitle = "Subscriber Count Over Time for Nijisanji Members", +def plot_subscriber_count_over_time(server, table_name, gtitle = "Subscriber Count Over Time for Phase Connect Members", overrideQuery = None, markers = "lines", exclude_channels = []): warnings.filterwarnings('ignore') # Ignore pandas warning regarding pyodbc query = f"SELECT name, subscriber_count, timestamp, channel_id FROM {table_name} ORDER by timestamp DESC" if overrideQuery is None else overrideQuery diff --git a/backend/index.html b/backend/index.html new file mode 100644 index 0000000..3d7fe4c --- /dev/null +++ b/backend/index.html @@ -0,0 +1,14 @@ + + + +
+
+ + \ No newline at end of file diff --git a/backend/sql_table_config.json b/backend/sql_table_config.json index e77ff10..0a2ebc3 100644 --- a/backend/sql_table_config.json +++ b/backend/sql_table_config.json @@ -5,5 +5,5 @@ "DAILY_HEADER": "channel_id, sub_diff", "HISTORICAL_COLUMNS": "id INT PRIMARY KEY AUTO_INCREMENT, channel_id VARCHAR(255), profile_pic VARCHAR(255), name VARCHAR(255), subscriber_count INT, timestamp DATETIME", "HISTORICAL_HEADER": "channel_id, profile_pic, name, subscriber_count, timestamp", - "HOLODEX_ORGS": "Nijisanji" + "HOLODEX_ORGS": "Phase%20Connect" } -- cgit v1.2.3