initial version

4 files changed, 159 insertions, 0 deletions

diff --git a/lib/TFLMonitor/Schema.pm b/lib/TFLMonitor/Schema.pm
new file mode 100644
index 0000000..a8f09c6
--- /dev/null
+++ b/lib/TFLMonitor/Schema.pm
@@ -0,0 +1,16 @@
+package TFLMonitor::Schema;
+
+use strict;
+use warnings;
+
+use base 'DBIx::Class::Schema';
+
+__PACKAGE__->load_classes;
+
+
+# Created by DBIx::Class::Schema::Loader v0.04006 @ 2010-06-21 23:15:30
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Du/rUVC8IdRUPtkgGVjM/A
+
+
+# You can replace this text with custom content, and it will be preserved on regeneration
+1;
diff --git a/lib/TFLMonitor/Schema/Line.pm b/lib/TFLMonitor/Schema/Line.pm
new file mode 100644
index 0000000..acbf60d
--- /dev/null
+++ b/lib/TFLMonitor/Schema/Line.pm
@@ -0,0 +1,35 @@
+package TFLMonitor::Schema::Line;
+
+use strict;
+use warnings;
+
+use base 'DBIx::Class';
+
+__PACKAGE__->load_components("Core");
+__PACKAGE__->table("line");
+__PACKAGE__->add_columns(
+  "id",
+  { data_type => "INT", default_value => undef, is_nullable => 1, size => undef },
+  "name",
+  {
+    data_type => "VARCHAR",
+    default_value => undef,
+    is_nullable => 0,
+    size => 255,
+  },
+);
+__PACKAGE__->set_primary_key("id");
+__PACKAGE__->add_unique_constraint("name_unique", ["name"]);
+__PACKAGE__->has_many(
+  "line_statuses",
+  "TFLMonitor::Schema::LineStatus",
+  { "foreign.line_id" => "self.id" },
+);
+
+
+# Created by DBIx::Class::Schema::Loader v0.04006 @ 2010-06-21 23:15:30
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ZwKNYS6AzGFRfM7vnAMqTQ
+
+
+# You can replace this text with custom content, and it will be preserved on regeneration
+1;
diff --git a/lib/TFLMonitor/Schema/LineStatus.pm b/lib/TFLMonitor/Schema/LineStatus.pm
new file mode 100644
index 0000000..ced0012
--- /dev/null
+++ b/lib/TFLMonitor/Schema/LineStatus.pm
@@ -0,0 +1,55 @@
+package TFLMonitor::Schema::LineStatus;
+
+use strict;
+use warnings;
+
+use base 'DBIx::Class';
+
+__PACKAGE__->load_components("Core");
+__PACKAGE__->table("line_status");
+__PACKAGE__->add_columns(
+  "time",
+  {
+    data_type => "DATETIME",
+    default_value => undef,
+    is_nullable => 0,
+    size => undef,
+  },
+  "line_id",
+  { data_type => "INT", default_value => undef, is_nullable => 0, size => undef },
+  "status_code",
+  {
+    data_type => "VARCHAR",
+    default_value => undef,
+    is_nullable => 0,
+    size => 255,
+  },
+  "is_active",
+  {
+    data_type => "BOOLEAN",
+    default_value => undef,
+    is_nullable => 0,
+    size => undef,
+  },
+  "details",
+  {
+    data_type => "TEXT",
+    default_value => undef,
+    is_nullable => 1,
+    size => undef,
+  },
+);
+__PACKAGE__->belongs_to("line_id", "TFLMonitor::Schema::Line", { id => "line_id" });
+__PACKAGE__->belongs_to(
+  "status_code",
+  "TFLMonitor::Schema::Status",
+  { code => "status_code" },
+);
+
+
+# Created by DBIx::Class::Schema::Loader v0.04006 @ 2010-06-21 23:15:30
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:1b6y2NC79YSXgyECT4uEzQ
+
+
+# You can replace this text with custom content, and it will be preserved on regeneration
+1;
diff --git a/lib/TFLMonitor/Schema/Status.pm b/lib/TFLMonitor/Schema/Status.pm
new file mode 100644
index 0000000..c2e43fd
--- /dev/null
+++ b/lib/TFLMonitor/Schema/Status.pm
@@ -0,0 +1,53 @@
+package TFLMonitor::Schema::Status;
+
+use strict;
+use warnings;
+
+use base 'DBIx::Class';
+
+__PACKAGE__->load_components("Core");
+__PACKAGE__->table("status");
+__PACKAGE__->add_columns(
+  "code",
+  {
+    data_type => "VARCHAR",
+    default_value => undef,
+    is_nullable => 1,
+    size => 255,
+  },
+  "class",
+  {
+    data_type => "VARCHAR",
+    default_value => undef,
+    is_nullable => 0,
+    size => 255,
+  },
+  "description",
+  {
+    data_type => "VARCHAR",
+    default_value => undef,
+    is_nullable => 0,
+    size => 255,
+  },
+  "is_active",
+  {
+    data_type => "BOOLEAN",
+    default_value => undef,
+    is_nullable => 0,
+    size => undef,
+  },
+);
+__PACKAGE__->set_primary_key("code");
+__PACKAGE__->has_many(
+  "line_statuses",
+  "TFLMonitor::Schema::LineStatus",
+  { "foreign.status_code" => "self.code" },
+);
+
+
+# Created by DBIx::Class::Schema::Loader v0.04006 @ 2010-06-21 23:15:30
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:HllgP4wdCoe4KqxmyI0m8Q
+
+
+# You can replace this text with custom content, and it will be preserved on regeneration
+1;