NAME

ObjectDB::Table - actions on tables

SYNOPSIS

    package MyDB;
    use base 'ObjectDB';

    sub init_db {
        ...
        return $dbh;
    }

    package MyAuthor;
    use base 'MyDB';

    __PACKAGE__->meta(
        table          => 'author',
        columns        => [qw/id name/],
        primary_key    => 'id',
        auto_increment => 'id',
        relationships  => {
            books => {
                type = 'one to many',
                class => 'MyBook',
                map   => {id => 'author_id'}
            }
        }
    );

    package MyBook;
    use base 'MyDB';

    __PACKAGE__->meta(
        table          => 'book',
        columns        => [qw/id author_id title/],
        primary_key    => 'id',
        auto_increment => 'id',
        relationships  => {
            author => {
                type = 'many to one',
                class => 'MyAuthor',
                map   => {author_id => 'id'}
            }
        }
    );

    my @books = MyBook->table->find(
        with     => 'author',
        order_by => [title => 'ASC'],
        page     => 1,
        per_page => 10
    );

DESCRIPTION

ObjectDB::Table allows to perform actions on table: find, update, delete many rows at a time.

Methods

find

Finds specific rows. Query builder is SQL::Composer.

    my @books = MyBook->table->find;
    my @books = MyBook->table->find(where => [...]);
    my @books = MyBook->table->find(where => [...], order_by => [...]);
    my @books =
      MyBook->table->find(where => [...], order_by => [...], group_by => [...]);

When using rows_as_hashes returns array of hashes instead of objects.

find_by_compose

Finds by using raw query.

    my @books = MyBook->find_by_compose(table => 'book', columns => ['id', 'title']);

When using rows_as_hashes returns array of hashes instead of objects.

find_by_sql

Finds by using raw SQL.

    my @books = MyBook->find_by_sql('SELECT * FROM books WHERE title = ?', ['About Everything']);
    my @books = MyBook->find_by_sql('SELECT * FROM books WHERE title = :title', { title => 'About Everything' });

When using rows_as_hashes returns array of hashes instead of objects.

count

A convenient method for counting.

    my $total_books = MyBook->table->count;

update

Updates many rows at a time.

    MyBook->table->update(set => {author_id => 1}, where => [author_id => 2]);

delete

Deletes many rows at a time.

    MyBook->table->delete;
    MyBook->table->delete(where => [...]);