NAME

Fey::SQL::Insert - Represents a INSERT query

SYNOPSIS

  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);

DESCRIPTION

This class represents a INSERT query.

METHODS

This class provides the following methods:

Constructor

To construct an object of this class, call $query->insert() on a Fey::SQL object.

$insert->insert()

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.

$insert->into()

This method specifies the INTO clause of the query. It expects a list of Fey::Column and/or Fey::Table objects, but not aliases.

If you pass a table object, then the INTO will include all of that table's columns, in the order returned by the $table->columns() method.

Most RDBMS implementations only allow for a single table here, but some (like MySQL) do allow for multi-table inserts.

$insert->values(...)

This method takes a hash reference where the keys are column names, and values are the value to be inserted for that column. Each value can be of the following: