NAME

Async::ORM::Schema - Schema class

SYNOPSIS

package Article;

use Any::Moose;

extends 'Async::ORM';

__PACKAGE__->schema(
    table          => 'article',
    columns        => [qw/id category_id author_id title/],
    primary_keys   => ['id'],
    auto_increment => 'id',

    relationships => {
        author => {
            type  => 'many to one',
            class => 'Author',
            map   => {author_id => 'id'}
        },
        category => {
            type  => 'many to one',
            class => 'Category',
            map   => {category_id => 'id'}
        },
        tags => {
            type      => 'many to many',
            map_class => 'ArticleTagMap',
            map_from  => 'article',
            map_to    => 'tag'
        },
        comments => {
            type  => 'one to many',
            class => 'Comment',
            where => [type => 'article'],
            map   => {id => 'master_id'}
        }
    }
);

1;

DESCRIPTION

ATTRIBUTES

attr

METHODS

new

Not called externally, but sets the following attributes:

table

__PACKAGE__->schema(
    table => 'article
    ...

Table name.

columns

__PACKAGE__->schema(
    ...
    columns => [qw/id title/]
    ...

Sets columns.

primary_keys

__PACKAGE__->schema(
    ...
    primary_keys => [qw/id/]
    ...

Sets primary keys. Could be multiple of course.

unique_keys

__PACKAGE__->schema(
    ...
    unique_keys => [qw/title/]
    ...

Sets unique keys. Could be multiple of course.

auto_increment

__PACKAGE__->schema(
    ...
    auto_increment => 'id'
    ...

Sets auto increment key. Is altered on object database insertion.

relationships

__PACKAGE__->schema(
    ...
    relationships => {
        author => {
            type  => 'many to one',
            class => 'Author',
            map   => {author_id => 'id'}
        },
    ...

Sets relationships. For more information see Async::ORM::Relationship.

is_column

$article->schema->is_column('title'); # true

Returns true when argument is a column. False otherwise.

is_primary_key

$article->schema->is_primary_key('title'); # false

Returns true when argument is a primary key. False otherwise.

is_auto_increment

$article->schema->is_auto_increment('id'); # true

Returns true when argument is an auto increment column. False otherwise.

is_unique_key

$article->schema->is_unique_key('title'); # false

Returns true when argument is a unique key. False otherwise.

columns

my @columns = $article->schema->columns;

Returns schema columns.

primary_keys

my @primary_keys = $article->schema->primary_keys;

Returns primary keys.

unique_keys

my @unique_keys = $article->schema->unique_keys;

Returns unique keys.

add_column

__PACKAGE__->add_column(content => {default => 'foo'});

Adds column to the schema. Usually used when you extend existing class and want to add few new columns.

add_columns

__PACKAGE__->add_column(qw/content image/);

Adds columns to the schema. Uses add_column.

add_relationship

__PACKAGE__->add_relationship(
    comments => {
        type  => 'one to many',
        class => 'Comment',
        where => [type => 'article'],
        map   => {id => 'master_id'}
    }
);

Adds relationhips to the schema. Usually used when you extend existing class and want to add few new relationhips.

add_relationships

__PACKAGE__->add_relationships(
    comments => {
        type  => 'one to many',
        class => 'Comment',
        where => [type => 'article'],
        map   => {id => 'master_id'}
    },
    ...
);

Adds relationhips to the schema. Uses add_relationhip.

del_column

__PACKAGE__->del_column('content');

Deletes column from the schema. Usually used when you extend existing class and want to delete few old columns.

AUTHOR

Viacheslav Tikhanovskii, vti@cpan.org.

COPYRIGHT

Copyright (C) 2009, Viacheslav Tikhanovskii.

This program is free software, you can redistribute it and/or modify it under the same terms as Perl 5.10.

cpanm Async::ORM

perl -MCPAN -e shell
install Async::ORM