NAME
DBIx::Class::Table - Basic table methods
SYNOPSIS
DESCRIPTION
This class is responsible for defining and doing basic operations on DBIx::Class objects.
METHODS
- add_columns
-
__PACKAGE__->add_columns(qw/col1 col2 col3/);Adds columns to the current package, and creates accessors for them
- search_literal
-
my @obj = $class->search_literal($literal_where_cond, @bind); my $cursor = $class->search_literal($literal_where_cond, @bind); - count_literal
-
my $count = $class->count_literal($literal_where_cond); - count
-
my $count = $class->count({ foo => 3 }); - search
-
my @obj = $class->search({ foo => 3 }); # "... WHERE foo = 3" my $cursor = $class->search({ foo => 3 });To retrieve all rows, simply call
search()with no condition parameter,my @all = $class->search(); # equivalent to search({})If you need to pass in additional attributes (see "Attributes" in DBIx::Class::ResultSet for details) an empty hash indicates no condition,
my @all = $class->search({}, { cols => [qw/foo bar/] }); # "SELECT foo, bar FROM $class_table" - search_like
-
Identical to search except defaults to 'LIKE' instead of '=' in condition
- table
-
__PACKAGE__->table('tbl_name'); - find_or_create
-
$class->find_or_create({ key => $val, ... });Searches for a record matching the search condition; if it doesn't find one, creates one and returns that instead
- has_column
-
if ($obj->has_column($col)) { ... }Returns 1 if the object has a column of this name, 0 otherwise
- column_info
-
my $info = $obj->column_info($col);Returns the column metadata hashref for the column
- columns
-
my @column_names = $obj->columns;
AUTHORS
Matt S. Trout <mst@shadowcatsystems.co.uk>
LICENSE
You may distribute this code under the same terms as Perl itself.