DBIx::SQLEngine::Schema::Table 0.93

DBIx::SQLEngine::Schema::Table is a table in a data source.

SYNOPSIS

 $sqldb = DBIx::SQLEngine->new( ... );
 
 $table = $sqldb->table( $table_name );
 
 $hash_ary = $table->fetch_select( where => { status => 2 } );

 $table->do_insert( values => { somefield => 'A Value', status => 3 } );
 $table->do_update( values => { status => 3 }, where => { status => 2 } );
 $table->do_delete( where => { somefield => 'A Value' } );

 $hash = $table->fetch_row( $primary_key );

 $table->insert_row( { somefield => 'Some Value' } );
 $table->update_row( { id => $primary_key, somefield => 'Some Value' } );
 $table->delete_row( { id => $primary_key } );

The DBIx::SQLEngine::Schema::Table class represents database tables accessible via a particular DBIx::SQLEngine.

By storing a reference to a SQLEngine and the name of a table to operate on, a Schema::Table object can facilitate generation of SQL queries that operate on the named table.

Each table can retrieve and cache a ColumnSet containing information about the name and type of the columns in the table. Column information is loaded from the storage as needed, but if you are creating a new table you must provide the definition.

The *_row() methods use this information about the table columns to facilitate common operations on table rows using their primary keys and simple hash-refs.


Product's homepage

Requirements:

· PassReminder