add comet support for real-time chatting

[chaz/chatty] / lib / Chatty / Schema / Result / Account.pm

diff --git a/lib/Chatty/Schema/Result/Account.pm b/lib/Chatty/Schema/Result/Account.pm
index 1589333de1493d2947b0c62d960bb54e4a6ba2a8..cedd0aece1c2ca680901176f61362b3e703076db 100644 (file)
--- a/lib/Chatty/Schema/Result/Account.pm
+++ b/lib/Chatty/Schema/Result/Account.pm
@@ -1,21 +1,36 @@
+use utf8;
 package Chatty::Schema::Result::Account;
 
 # Created by DBIx::Class::Schema::Loader
 # DO NOT MODIFY THE FIRST PART OF THIS FILE
 
+=head1 NAME
+
+Chatty::Schema::Result::Account
+
+=cut
+
 use strict;
 use warnings;
 
 use Moose;
 use MooseX::NonMoose;
-use namespace::autoclean;
+use MooseX::MarkAsMethods autoclean => 1;
 extends 'DBIx::Class::Core';
 
-__PACKAGE__->load_components("InflateColumn::DateTime");
+=head1 COMPONENTS LOADED
 
-=head1 NAME
+=over 4
 
-Chatty::Schema::Result::Account
+=item * L<DBIx::Class::InflateColumn::DateTime>
+
+=back
+
+=cut
+
+__PACKAGE__->load_components("InflateColumn::DateTime");
+
+=head1 TABLE: C<account>
 
 =cut
 
@@ -37,7 +52,7 @@ __PACKAGE__->table("account");
 =head2 password
 
   data_type: 'text'
-  is_nullable: 1
+  is_nullable: 0
 
 =head2 status
 
@@ -45,6 +60,12 @@ __PACKAGE__->table("account");
   default_value: 'active'
   is_nullable: 1
 
+=head2 current_room
+
+  data_type: 'integer'
+  is_foreign_key: 1
+  is_nullable: 1
+
 =cut
 
 __PACKAGE__->add_columns(
@@ -53,32 +74,64 @@ __PACKAGE__->add_columns(
   "username",
   { data_type => "text", is_nullable => 1 },
   "password",
-  { data_type => "text", is_nullable => 1 },
+  { data_type => "text", is_nullable => 0 },
   "status",
   { data_type => "text", default_value => "active", is_nullable => 1 },
+  "current_room",
+  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
 );
+
+=head1 PRIMARY KEY
+
+=over 4
+
+=item * L</id>
+
+=back
+
+=cut
+
 __PACKAGE__->set_primary_key("id");
 
+=head1 UNIQUE CONSTRAINTS
+
+=head2 C<username_unique>
+
+=over 4
+
+=item * L</username>
+
+=back
+
+=cut
+
+__PACKAGE__->add_unique_constraint("username_unique", ["username"]);
+
 =head1 RELATIONS
 
-=head2 messages
+=head2 current_room
 
-Type: has_many
+Type: belongs_to
 
-Related object: L<Chatty::Schema::Result::Message>
+Related object: L<Chatty::Schema::Result::Room>
 
 =cut
 
-__PACKAGE__->has_many(
-  "messages",
-  "Chatty::Schema::Result::Message",
-  { "foreign.author" => "self.id" },
-  { cascade_copy => 0, cascade_delete => 0 },
+__PACKAGE__->belongs_to(
+  "current_room",
+  "Chatty::Schema::Result::Room",
+  { id => "current_room" },
+  {
+    is_deferrable => 1,
+    join_type     => "LEFT",
+    on_delete     => "CASCADE",
+    on_update     => "CASCADE",
+  },
 );
 
 
-# Created by DBIx::Class::Schema::Loader v0.07010 @ 2011-10-12 22:20:29
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:D8HUHJmSfJwylSeDYjfeHA
+# Created by DBIx::Class::Schema::Loader v0.07015 @ 2012-01-03 16:58:35
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:vESFaWXuN0WYXW2Y18BfRg
 
 
 # You can replace this text with custom code or comments, and it will be preserved on regeneration