debian man page for alzabo::runtime::inserthandle

Query: alzabo::runtime::inserthandle

OS: debian

Section: 3pm

Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar

Alzabo::Runtime::InsertHandle(3pm)			User Contributed Perl Documentation			Alzabo::Runtime::InsertHandle(3pm)

NAME
Alzabo::Runtime::InsertHandle - A handle representing an insert
SYNOPSIS
my $handle = $table->insert_handle ( columns => [ $table->columns( 'name', 'job' ) ] ); my $faye_row = $handle->insert( values => { name => 'Faye', job => 'HK Pop Chanteuse' } ); my $guesch_row = $handle->insert( values => { name => 'Guesch', job => 'French Chanteuse and Dancer' } );
DESCRIPTION
This object is analogous to a DBI statement handle, and can be used to insert multiple rows into a table more efficiently than repeatedly calling "Alzabo::Runtime::Table->insert()".
METHODS
Objects of this class provide one public method: insert This method is used to insert a new row into a table. It accepts the following parameters: * values This should be a hash reference containing the values to be inserted into the table. If no value is given for a primary key column and the column is "sequenced" then the primary key will be auto-generated. If values are not provided for other columns which were given when "Alzabo::Runtime::Table->insert_handle" was called, this method first checks to see if a value was provided for the column when "Alzabo::Runtime::Table->insert_handle" was called. If none was pro- vided, then the column's default value is used. If column values were passed to "Alzabo::Runtime::Table->insert_handle", then these can be overridden by values passed to this method. It is not possible to override column values that were given as SQL functions when "Alzabo::Runtime::Table->insert_handle" was called. This method returns a new "Alzabo::Runtime::Row" object. Throws: "Alzabo::Exception::Logic", "Alzabo::Exception::Params" perl v5.8.8 2007-12-23 Alzabo::Runtime::InsertHandle(3pm)
Related Man Pages
alzabo::create::index(3pm) - debian
alzabo::quickref(3pm) - debian
alzabo::runtime::inserthandle(3pm) - debian
alzabo::runtime::row(3pm) - debian
alzabo::runtime::rowcursor(3pm) - debian
Similar Topics in the Unix Linux Community
adding a column
check if the insert statement is using column names
Insert script result into Oracle Table
Insert Command Creating Table Locking Problem
Shell script for insert multiple records into a Database