pta
/
WeatherNews.jl
forked from gg/WeatherNews.jl
1
0
Fork 0
Code Pull Requests Activity
295 Commits 1 Branch 0 Tags 706 KiB
Commit Graph

94 Commits

Author SHA1 Message Date
gg1234 af9be359d4 Replace double-quotes with single-quotes in SQL 
https://www.sqlite.org/quirks.html#double_quoted_string_literals_are_accepted
 2024-05-25 19:30:50 -07:00
gg1234 e78539bd38 Use @pta's query for caster_last_appearance 2024-05-25 10:49:38 -07:00
gg1234 4ecebcd02d Make sure TZ exists on both datetimes before passing to JULIANDAY 2024-05-24 16:32:48 -07:00
gg1234 2fc0a8abf5 Insert au PAY shows for 2024-05 2024-04-28 10:51:55 -07:00
gg1234 9c34758578 Count appearances grouped by caster, month, and segment 2024-04-28 10:51:14 -07:00
gg1234 f6945e507a Add view_count to big joined SELECT example 2024-04-28 10:49:37 -07:00
gg1234 2bf95ca33a Add some queries that explore schedule.view_count 2024-04-23 17:44:19 -07:00
pta 2d1c05baa4 Start recording view counts in schedule table 2024-04-19 18:21:28 -04:00
gg1234 82ff0f95f3 Ignore au PAY when figuring out caster's last appearance 2024-04-16 18:09:57 -07:00
gg1234 0e1cd80098 More au PAY updates 2024-04-16 16:59:27 -07:00
gg1234 b4ae9e0e50 Add link to post that started the conversation about gaps 2024-04-13 08:09:44 -07:00
gg1234 5ba57b2fad Add many queries for finding gaps between appearances 2024-04-13 08:05:04 -07:00
gg1234 0ba825e945 Add video_id for Senna's next au PAY show 2024-04-11 09:28:37 -07:00
gg1234 092db136d0 Add 2024-04 schedule for au PAY 2024-03-29 13:50:42 -07:00
gg1234 745daf3da0 Add a query for finding most recent appearance by caster 2024-03-13 08:25:52 -07:00
gg1234 96038bef34 Add more au PAY shows for 2024-03 2024-03-11 15:54:24 -07:00
gg1234 34ad772719 Add au PAY shows for 2024-03 2024-03-06 05:39:55 -08:00
gg1234 82923a49b4 Add video_id for Mi-chan's upcoming au PAY show 2024-02-24 21:10:55 -08:00
gg1234 e613e5486f Fix a bunch of video_ids 
JSON-STAFF-SAN!!!
 2024-02-20 21:57:18 -08:00
gg1234 7e22d20bb9 Add video_id for Rinon's upcoming au PAY show on 2/19 2024-02-14 15:54:28 -08:00
gg1234 a5e29317c9 Add video_ids for upcoming au PAY shows 2024-02-07 14:40:33 -08:00
gg1234 82d7345a06 Add au PAY shows for 2024-02 2024-01-30 23:59:16 -08:00
gg1234 8dafb9ce1b Add video_ids for Yui and Mizuki's upcoming au PAY streams 2024-01-20 14:39:23 -08:00
gg1234 d82ea8bf79 Add a query for finding days casters had to cover for eachother 2024-01-11 16:04:11 -08:00
gg1234 905d66aefb Add video_ids for upcoming au PAY streams 2024-01-10 03:44:42 -08:00
gg1234 397b9de8bf Add au PAY shows for 2024-01 2024-01-04 05:37:12 -08:00
gg1234 8eea6012ed Add year end au PAY shows 2023-12-21 17:42:19 -08:00
gg1234 52e2cbcf00 Add au PAY show for Senna 2023-12-20 04:52:27 -08:00
gg1234 0a299d9d0e Add upcoming au PAY for Ayaka 2023-12-06 01:31:39 -08:00
gg1234 28f05627b6 Fill in some missing schedule data 2023-11-30 23:00:07 -08:00
gg1234 da278c985d Fix stale data 2023-11-17 03:46:20 -08:00
gg1234 f7766b8a6e Add video_ids for upcoming au PAY shows 2023-11-17 03:25:50 -08:00
gg1234 73a7df1fb2 Add upcoming au PAY shows 2023-11-11 16:31:50 -08:00
gg1234 75992f3735 Perform various manual db updates 
- Insert schedule for Saya and Rinon's au PAY shows
- Update schedule for missing video_id due to daylight savings bug

I'm not sure how to fix the daylight savings bug,
but it only happens twice a year, so maybe I won't fix it.
 2023-11-06 13:48:11 -08:00
gg1234 e7e8e9e086 Add video_id for Mizuki's au PAY show 2023-10-27 18:57:27 -07:00
gg1234 61be33c9a5 Add video_ids for au PAY shows 2023-10-22 16:40:50 -07:00
gg1234 9d6d177a18 Add au PAY schedule updates 2023-10-13 11:25:46 -07:00
gg1234 e366c5f8c3 Add upcoming au PAY shows for 2023-10 2023-10-04 23:25:57 -07:00
gg1234 dfdbf16b05 Add exploration into joining mscale and schedule more accurately 2023-10-04 22:43:19 -07:00
gg1234 59eee409df Add video_id for Airi's au PAY show 2023-09-22 09:48:57 -07:00
gg1234 d5c858c432 Add video_ids for upcoming au PAY shows 2023-09-21 20:39:22 -07:00
gg 761f7bf1b0 Add missing data due to accidentally locked wn.db 2023-09-20 21:08:52 -07:00
gg c74f27f861 Stick w/ emacs' default indentation for the CASE expression 2023-09-13 07:54:24 -07:00
gg 7b705cf466 Uppercase COUNT for consistency 2023-09-12 03:57:12 -07:00
gg 60aaa6419f Let date range be parameterized in ranking page 2023-09-11 16:09:04 -07:00
gg f4a8833511 Add a fancier query for caster distribution by day of week 2023-09-11 15:11:05 -07:00
gg f63f986789 Add a query for caster distribution by day of week 2023-09-11 06:38:34 -07:00
gg 1022989acf Use COUNT(*) 
This allows a show to be counted
even when there is no caster.
 2023-09-11 00:26:52 -07:00
gg ca39b3e02c Figure out segment distribution including 0s 2023-09-09 10:17:58 -07:00
gg 8f2d0d5508 Insert Nana's au PAY show #5 
https://twitter.com/livetv_aupaymkt/status/1656177252613124097
 2023-09-06 08:20:59 -07:00