pta

History

gg1234 2fc0a8abf5 Insert au PAY shows for 2024-05		2024-04-28 10:51:55 -07:00
..
00.init.sql	Initialize the database with segments	2023-07-18 22:52:27 -07:00
01.views.sql	Add a migration that creates the schedule_joined view	2023-07-19 19:40:03 -07:00
02.cancellation.sql	Explain the purpose of the cancellation table	2023-08-07 00:46:28 -07:00
03.mscale.sql	Create a migration for the mscale table	2023-08-18 15:57:11 -07:00
04.video_id.sql	Add video_id to schedule table #2	2023-08-19 04:35:18 -07:00
05.view_count.sql	Start recording view counts in schedule table	2024-04-19 18:21:28 -04:00
README.md	List tables	2023-09-03 21:28:19 -07:00
queries.sql	Insert au PAY shows for 2024-05	2024-04-28 10:51:55 -07:00
schema.sql	Refine schema	2023-07-18 22:51:56 -07:00

README.md

wn-data

Initialize Database

sqlite3 wn.db < schema.sql
sqlite3 wn.db < 00.init.sql
sqlite3 wn.db < 01.views.sql
sqlite3 wn.db < 02.cancellation.sql
sqlite3 wn.db < 03.mscale.sql
sqlite3 wn.db < 04.video_id.sql

Schema

caster

segment

schedule

cancellation

mscale

schedule_joined (view)

This view was made early on to make the most common join pattern easily accessible. It joins the schedule table with segment and caster so you can get a readable representation of the WN schedule.

SELECT * FROM schedule_joined ORDER by jst;

Querying

The file queries.sql contains some sample queries to get you started.

Updates

Realtime updates of wn.db can be found at gg.vern.cc/wn-data/.