gg
0 Followers · 0 Following
  • Joined on 2023-05-24
Repositories
3
 Projects Packages Public Activity Starred Repositories
5
gg pushed to main at gg/WeatherNews.jl 2023-08-22 01:13:16 +00:00
f3ae9546ef Link to what will eventually be the site that presents wn.db
gg pushed to main at gg/WeatherNews.jl 2023-08-21 19:37:09 +00:00
e9fc30cc19 Link to git repo
gg pushed to main at gg/WeatherNews.jl 2023-08-21 19:15:52 +00:00
185d94fc02 Add a query for figuring out which casters have hosted a given segment
f03125a47c Think more about what data I want to present.
Compare 2 commits »
gg pushed to main at gg/WeatherNews.jl 2023-08-21 19:01:35 +00:00
86ebee0ab5 Write comments for conflict detection
gg commented on issue gg/WeatherNews.jl#2 2023-08-21 18:35:29 +00:00
more json data available from WNL page

Here's an unstyled dump of the schedule.
https://gg.vern.cc/wn/

gg closed issue gg/WeatherNews.jl#2 2023-08-21 16:46:41 +00:00
more json data available from WNL page
gg commented on issue gg/WeatherNews.jl#2 2023-08-20 21:35:12 +00:00
more json data available from WNL page

Feel free. Eventually a site that queries the db will be made, but until that exists, a link to the raw db may suffice.

gg pushed to main at gg/WeatherNews.jl 2023-08-20 00:08:21 +00:00
3532db8521 Add mscale value to query
gg pushed to main at gg/WeatherNews.jl 2023-08-20 00:02:27 +00:00
bfeb2d90f4 Add a query that may become the new schedule_joined view
gg commented on issue gg/WeatherNews.jl#2 2023-08-19 23:55:04 +00:00
more json data available from WNL page

@pta - The schedule table has a video_id column that will be updated the minute after the JSON reveals a new live video id via cron job. I currently only sync the db found on https://gg.vern.c…

gg pushed to main at gg/WeatherNews.jl 2023-08-19 23:38:34 +00:00
ee14004a32 Add more info to README
4dacfe6b5e Add script for updating video_ids
Compare 2 commits »
gg pushed to main at gg/WeatherNews.jl 2023-08-19 23:28:22 +00:00
c299540cf6 Add functions for discovering and updating video_id
92f173bdda Add the last manually updated video_id
Compare 2 commits »
gg pushed to main at gg/WeatherNews.jl 2023-08-19 13:15:05 +00:00
068c9dd5e5 Add another captured video_id manually
gg pushed to main at gg/WeatherNews.jl 2023-08-19 13:08:43 +00:00
362c880268 Manually add first schedule.video_id #2
gg pushed to main at gg/WeatherNews.jl 2023-08-19 12:59:18 +00:00
49299e9f41 Use /usr/bin/env to call bash because of vern.cc and nixos
gg pushed to main at gg/WeatherNews.jl 2023-08-19 12:57:24 +00:00
b8da2c7fa1 Use seconds for jst
gg pushed to main at gg/WeatherNews.jl 2023-08-19 12:51:00 +00:00
a0e8b5eab5 Update README with new migrations
gg pushed to main at gg/WeatherNews.jl 2023-08-19 12:46:17 +00:00
07bbd7b2f4 Experiment with LEFT JOINing against mscale
gg commented on issue gg/WeatherNews.jl#2 2023-08-19 12:26:56 +00:00
more json data available from WNL page

For recording purposes, I'm going to treat mscale as a value that's independent of the schedule. The unique jst column that exists in both the schedule and mscale tables can be used to join…

gg pushed to main at gg/WeatherNews.jl 2023-08-19 12:23:22 +00:00
c86316777c Add a bash script for recording mscale #2