DBIx::SQLEngine::Schema::Table A table in a data source
Download

DBIx::SQLEngine::Schema::Table Ranking & Summary

DBIx::SQLEngine::Schema::Table Tags

database SQL Perl module perl database schema database table

DBIx::SQLEngine::Schema::Table Description

A table in a data source 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. Requirements: · PassReminder

DBIx::SQLEngine::Schema::Table Related Software