NAME

Mango::Schema::Product - DBIC schema class for products

SYNOPSIS

    use Mango::Schema;
    my $schema = Mango::Schema->connect;
    my $products = $schema->resultset('Products')->search;

DESCRIPTION

Mango::Schema::Product is loaded by Mango::Schema to read/write product data.

COLUMNS

id

Contains the primary key for each product record.

    id => {
        data_type         => 'INT',
        is_auto_increment => 1,
        is_nullable       => 0,
        extras            => {unsigned => 1}
    },

sku

The sku, or part number of the product.

    sku => {
        data_type      => 'VARCHAR',
        size           => 25,
        is_nullable    => 0,
    },

name

Contains the product name.

    name => {
        data_type   => 'VARCHAR',
        size        => 25,
        is_nullable => 0
    },

description

The products description.

    description => {
        data_type   => 'VARCHAR',
        size        => 100,
        is_nullable => 1
    },

price

The price of the current product.

    price => {
        data_type      => 'DECIMAL',
        size           => [9,2],
        is_nullable    => 0,
        default_value  => '0.00'
    },

created

When the product record was created.

    created => {
        data_type   => 'DATETIME',
        is_nullable => 0
    },

updated

When the product record was updated.

    updated => {
        data_type   => 'DATETIME',
        is_nullable => 0
    }

AUTHOR

    Christopher H. Laco
    CPAN ID: CLACO
    claco@chrislaco.com
    http://today.icantfocus.com/blog/