- COPYRIGHT & LICENSE
Fey::SQL::Insert - Represents a INSERT query
my $sql = Fey::SQL->new_insert(); # INSERT INTO Part # (part_id, name, quantity) # VALUES # (?, ?, ?) $sql->insert()->into($Part); my $ph = Fey::Placeholder->new(); $sql->values( part_id => $ph, name => $ph, quantity => $ph, ); print $sql->sql($dbh);
This class represents a
This class provides the following methods:
To construct an object of this class, call
$query->insert() on a
This method is basically a no-op that exists to so that Fey::SQL has something to call after it constructs an object in this class.
If you pass a table object, then the
INTO will include all of that table's columns, in the order returned by the
Most RDBMS implementations only allow for a single table here, but some (like MySQL) do allow for multi-table inserts.
This method takes a hash where the keys are column names, and values are the value to be inserted for that column. Each value can be of the following:
a plain scalar, including undef
This will be passed to
You can call this method multiple times in order to do a multi-row insert.
Returns the full SQL statement which this object represents. A DBI handle must be passed so that identifiers can be properly quoted.
See the Fey::SQL section on Bind Parameters for more details.
INSERT INTO clause portion of the SQL statement as a string (just the tables).
Returns the portion of the SQL statement containing the columns for which values are being inserted as a string.
VALUES clause portion of the SQL statement as a string.
Dave Rolsky, <firstname.lastname@example.org>
See Fey for details on how to report bugs.
Copyright 2006-2009 Dave Rolsky, All Rights Reserved.
This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.