GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages


Manual Reference Pages  -  ALZABO::RUNTIME::INSERTHANDLE (3)

.ds Aq ’

NAME

Alzabo::Runtime::InsertHandle - A handle representing an insert

CONTENTS

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:
o 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 provided, 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

Search for    or go to Top of page |  Section 3 |  Main Index


perl v5.20.3 ALZABO::RUNTIME::INSERTHANDLE (3) 2016-04-03

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with manServer 1.07.