—

              
# $Id: /local/Mango/trunk/lib/Mango/Schema/Cart/Item.pm 155 2007-04-16T02:58:37.637652Z claco  $
package Mango::Schema::Cart::Item;
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('cart_item');
__PACKAGE__->source_name('CartItems');
__PACKAGE__->add_columns(
    id => {
        data_type         => 'INT',
        is_auto_increment => 1,
        is_nullable       => 0,
        extras            => {unsigned => 1}
    },
    cart_id => {
        data_type         => 'INT',
        is_nullable       => 0,
        is_foreign_key    => 1,
        extras            => {unsigned => 1}
    },
    sku => {
        data_type      => 'VARCHAR',
        size           => 25,
        is_nullable    => 0,
    },
    quantity => {
        data_type      => 'TINYINT',
        size           => 3,
        is_nullable    => 0,
        default_value  => 1,
        extras         => {unsigned => 1}
    },
    price => {
        data_type      => 'DECIMAL',
        size           => [9,2],
        is_nullable    => 0,
        default_value  => '0.00'
    },
    description => {
        data_type     => 'VARCHAR',
        size          => 255,
        is_nullable   => 1,
        default_value => undef
    },
    created => {
        data_type     => 'DATETIME',
        is_nullable   => 0
    },
    updated => {
        data_type     => 'DATETIME',
        is_nullable   => 0
    }
);
__PACKAGE__->set_primary_key('id');
__PACKAGE__->belongs_to(cart => 'Mango::Schema::Cart',
    {'foreign.id' => 'self.cart_id'}
);
__PACKAGE__->default_values({
    created => sub {DateTime->now},
    updated => sub {DateTime->now}
});
1;
__END__
HideShow 107 lines of Pod
=head1 NAME
Mango::Schema::Cart::Item - DBIC schema class for cart items
=head1 SYNOPSIS
    use Mango::Schema;
    my $schema = Mango::Schema->connect;
    my $items = $schema->resultset('CartItems')->search;
=head1 DESCRIPTION
Mango::Schema::Cart::Item is loaded by Mango::Schema to read/write cart item data.
=head1 COLUMNS
=head2 id
Contains the primary key for each cart item record.
    id => {
        data_type         => 'INT',
        is_auto_increment => 1,
        is_nullable       => 0,
        extras            => {unsigned => 1}
    },
=head2 cart_id
Contains the foreign key to the cart table.
    cart_id => {
        data_type         => 'INT',
        is_nullable       => 0,
        is_foreign_key    => 1,
        extras            => {unsigned => 1}
    },
=head2 sku
Contains the sku (Stock Keeping Unit), or part number for the current cart item.
    sku => {
        data_type      => 'VARCHAR',
        size           => 25,
        is_nullable    => 0,
    },
=head2 quantity
Contains the number of this cart item being ordered.
    quantity => {
        data_type      => 'TINYINT',
        size           => 3,
        is_nullable    => 0,
        default_value  => 1,
        extras         => {unsigned => 1}
    },
=head2 price
Contains the price if the current cart item.
    price => {
        data_type      => 'DECIMAL',
        size           => [9,2],
        is_nullable    => 0,
        default_value  => '0.00'
    },
=head2 description
Contains the description of the current cart item.
    description => {
        data_type     => 'VARCHAR',
        size          => 255,
        is_nullable   => 1,
        default_value => undef
    },
=head2 created
When the cart item record was created.
    created => {
        data_type   => 'DATETIME',
        is_nullable => 0
    },
=head2 updated
When the cart item 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/