# $Id: /local/CPAN/Mango/lib/Mango/Schema/Profile.pm 1644 2008-06-02T01:46:53.055259Z claco $ package Mango::Schema::Profile; use strict; use warnings; BEGIN { use base qw/DBIx::Class/; use DateTime (); } __PACKAGE__->load_components( qw/ +Handel::Components::DefaultValues +Handel::Components::Constraints +Handel::Components::Validation InflateColumn::DateTime Core / ); __PACKAGE__->table('profile'); __PACKAGE__->source_name('Profiles'); __PACKAGE__->add_columns( id => { data_type => 'INT', is_auto_increment => 1, is_nullable => 0, extras => { unsigned => 1 } }, user_id => { data_type => 'INT', is_nullable => 0, is_foreign_key => 1, extras => { unsigned => 1 } }, first_name => { data_type => 'VARCHAR', size => 25, is_nullable => 1 }, last_name => { data_type => 'VARCHAR', size => 25, is_nullable => 1 }, email => { data_type => 'VARCHAR', size => 150, is_nullable => 1 }, created => { data_type => 'DATETIME', is_nullable => 0, extra => { timezone => 'UTC' } }, updated => { data_type => 'DATETIME', is_nullable => 0, extra => { timezone => 'UTC' } } ); __PACKAGE__->set_primary_key('id'); __PACKAGE__->add_unique_constraint( user_id => [qw/user_id/] ); __PACKAGE__->add_unique_constraint( email => [qw/email/] ); __PACKAGE__->belongs_to( user => 'Mango::Schema::User', { 'foreign.id' => 'self.user_id' } ); __PACKAGE__->default_values( { created => sub { DateTime->now }, updated => sub { DateTime->now } } ); 1; __END__ =head1 NAME Mango::Schema::Profile - DBIC schema class for Profiles =head1 SYNOPSIS use Mango::Schema; my $schema = Mango::Schema->connect; my $profiles = $schema->resultset('Profiles')->search; =head1 DESCRIPTION Mango::Schema::Profile is loaded by Mango::Schema to read/write user profile data. =head1 COLUMNS =head2 id Contains the primary key for each profile record. id => { data_type => 'INT', is_auto_increment => 1, is_nullable => 0, extras => {unsigned => 1} }, =head2 user_id Contains the user id foreign key. user_id => { data_type => 'INT', is_nullable => 0, is_foreign_key => 1, extras => {unsigned => 1} }, =head2 first_name Contains the users first name. first_name => { data_type => 'VARCHAR', size => 25, is_nullable => 1 }, =head2 last_name Contains the users last name. last_name => { data_type => 'VARCHAR', size => 25, is_nullable => 1 }, =head2 created When the profile record was created. created => { data_type => 'DATETIME', is_nullable => 0 }, =head2 updated When the profile record was updated. updated => { data_type => 'DATETIME', is_nullable => 0 } =head1 AUTHOR Christopher H. Laco CPAN ID: CLACO claco@chrislaco.com http://today.icantfocus.com/blog/