From d5d36bac73f37a92d4ee2d18a807b2acbccf16f3 Mon Sep 17 00:00:00 2001 From: dakkar Date: Mon, 21 Jun 2010 23:20:31 +0100 Subject: initial version --- lib/TFLMonitor/Schema.pm | 16 +++++++++++ lib/TFLMonitor/Schema/Line.pm | 35 +++++++++++++++++++++++ lib/TFLMonitor/Schema/LineStatus.pm | 55 +++++++++++++++++++++++++++++++++++++ lib/TFLMonitor/Schema/Status.pm | 53 +++++++++++++++++++++++++++++++++++ 4 files changed, 159 insertions(+) create mode 100644 lib/TFLMonitor/Schema.pm create mode 100644 lib/TFLMonitor/Schema/Line.pm create mode 100644 lib/TFLMonitor/Schema/LineStatus.pm create mode 100644 lib/TFLMonitor/Schema/Status.pm (limited to 'lib') 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; -- cgit v1.2.3