Docs For Class InsertQueryInterface

Description

An InsertQuery interface provides the tools to build an SQL INSERT query.

version: $Id: InsertQuery.interface.php,v 1.5 2007/09/05 21:38:59 adamfranco Exp $
license: GNU General Public License (GPL)
copyright: Copyright © 2005, Middlebury College

Located in /harmoni/core/DBHandler/InsertQuery.interface.php (line 24)

Query
   |
   --InsertQueryInterface

Method Summary

void addRowOfValues (array $values)

void setAutoIncrementColumn (string $column, string $sequence)

void setColumns (mixed $columns, array $table)

void setTable (string $table)

void setValues (array $values)

Methods

addRowOfValues (line 51)

Adds one row of values to insert into the table.

By calling this method multiple times, you can insert many rows of information using just one query.

access: public

void addRowOfValues (array $values)

array $values: One row of values to insert into the table. Must match the order of columns specified with the setColumns() method.

setAutoIncrementColumn (line 74)

Sets the autoincrement column.

Sets the autoincrement column. This could be useful with Oracle, for example. Do not include this column with the setColumns() method - it will be added automatically.

access: public

void setAutoIncrementColumn (string $column, string $sequence)

string $column: The autoincrement column.
string $sequence: The sequence to use for generating new ids.

setColumns (line 40)

Sets the columns to insert into the table.

access: public

void setColumns (mixed $columns, array $table)

array $table: The columns to insert into the table.

setTable (line 33)

Sets the table to insert into.

access: public

void setTable (string $table)

string $table: The table to insert into.

setValues (line 63)

This is an alias for addRowOfValues for compatability with the UpdateQuery class.

Adds one row of values to insert into the table. By calling this method multiple times, you can insert many rows of information using just one query.

access: public
see: InsertQueryInterface::addRowOfValues

void setValues (array $values)

array $values: One row of values to insert into the table. Must match the order of columns specified with the setColumns() method.

Inherited Methods

Inherited From Query

Query::getType()
Query::reset()

Interface InsertQueryInterface

Inherited Methods