From: Matt S Trout <mst@shadowcat.co.uk>
Date: Mon, 18 Jan 2010 01:03:57 +0000 (+0000)
Subject: Add example data
X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?p=catagits%2FApp-IdiotBox.git;a=commitdiff_plain;h=0ab4fd2ebf0f9745b2a8eb1f8f53357eb7ce4690

Add example data

Tragically, I'm on an airplane so the examples are all my talks since I can
remember what those are called (and mdk's, since he's sat next to me ...).
---

diff --git a/share/sql/example-data-1.0.sql b/share/sql/example-data-1.0.sql
new file mode 100644
index 0000000..909d18d
--- /dev/null
+++ b/share/sql/example-data-1.0.sql
@@ -0,0 +1,39 @@
+INSERT INTO buckets (slug, name) VALUES (
+  'lpw2009', 'London Perl Workshop 2009'
+);
+INSERT INTO buckets (slug, name) VALUES (
+  'opw2010', 'Perl Oasis 2010'
+);
+
+INSERT INTO announcements (id, made_at, bucket_slug) VALUES (
+  1, '2009-12-25 09:00:00', 'lpw2009'
+);
+INSERT INTO announcements (id, made_at, bucket_slug) VALUES (
+  2, '2010-01-01 14:00:00', 'lpw2009',
+);
+INSERT INTO announcements (id, made_at, bucket_slug) VALUES (
+  3, '2010-01-21 01:00:00', 'opw2010'
+);
+
+INSERT INTO videos (
+  slug, bucket_slug, name, author,announcement_id
+) VALUES (
+  'BEGIN', 'lpw2009', 'BEGINning Perl', 'Matt S Trout (mst)', 1
+);
+INSERT INTO videos (
+  slug, bucket_slug, name, author,announcement_id
+) VALUES (
+  'dream', 'lpw2009', 'Dreamcasting', 'Matt S Trout (mst)', 2
+);
+INSERT INTO videos (
+  slug, bucket_slug, name, author,announcement_id
+) VALUES (
+  'troll-god-mountain', 'opw2010', 'The Troll, the God and the Mountain',
+   'Matt S Trout (mst)', 3
+);
+INSERT INTO videos (
+  slug, bucket_slug, name, author,announcement_id
+) VALUES (
+  'keynote', 'opw2010', 'The Most Disgusting Word You''ll Hear'
+  'Mark Keating (mdk)', 4
+);