File: Table.php

Source Location: /DB_Table-1.0.0RC1/DB/Table.php

Classes:

DB_Table is a database API and data type SQL abstraction class.

Page Details:

DB_Table is a database API and data type SQL abstraction class.

DB_Table provides database API abstraction, data type abstraction, automated SELECT, INSERT, and UPDATE queries, automated table creation, automated validation of inserted/updated column values, and automated creation of QuickForm elemnts based on the column definitions.

Author: Paul M. Jones <pmjones@php.net>
Version: $Id: Table.php,v 1.25 2005/02/23 17:10:10 pmjones Exp $

Includes:

require_once('Date.php') [line 174]
The Date class for recasting date and time values
require_once('PEAR.php') [line 169]
The PEAR class for errors

DB_TABLE_ERR_CREATE_FLAG [line 79]

DB_TABLE_ERR_CREATE_FLAG = -10

Error code when you use a create() flag that is not recognized (must be 'safe', 'drop', or boolean false.

[ Top ]

DB_TABLE_ERR_DECLARE_COLNAME [line 127]

DB_TABLE_ERR_DECLARE_COLNAME = -18

Error code at create() time when you define a column in $this->col with an invalid column name (usually because it's a reserved keyword).

[ Top ]

DB_TABLE_ERR_DECLARE_DECIMAL [line 109]

DB_TABLE_ERR_DECLARE_DECIMAL = -15

Error code at create() time when you have an error in a 'decimal' definition (usually becuase the 'size' or 'scope' are wrong).

[ Top ]

DB_TABLE_ERR_DECLARE_IDXNAME [line 133]

DB_TABLE_ERR_DECLARE_IDXNAME = -19

Error code at create() time when you define an index in $this->idx with an invalid index name (usually because it's a reserved keyword).

[ Top ]

DB_TABLE_ERR_DECLARE_STRING [line 103]

DB_TABLE_ERR_DECLARE_STRING = -14

Error code at create() time when you have an error in a 'char' or 'varchar' definition in $this->col (usually because 'size' is wrong).

[ Top ]

DB_TABLE_ERR_DECLARE_STRLEN [line 145]

DB_TABLE_ERR_DECLARE_STRLEN = -21

Error code at create() time when you define a column name that is more than 30 chars long (an Oracle restriction).

[ Top ]

DB_TABLE_ERR_DECLARE_TYPE [line 115]

DB_TABLE_ERR_DECLARE_TYPE = -16

Error code at create() time when you define a column in $this->col with an unrecognized 'type'.

[ Top ]

DB_TABLE_ERR_IDX_COL_CLOB [line 139]

DB_TABLE_ERR_IDX_COL_CLOB = -20

Error code at create() time when you define an index in $this->idx that refers to a CLOB column.

[ Top ]

DB_TABLE_ERR_IDX_COL_UNDEF [line 91]

DB_TABLE_ERR_IDX_COL_UNDEF = -12

Error code at create() time when you define an index in $this->idx that refers to a column that does not exist in the $this->col array.

[ Top ]

DB_TABLE_ERR_IDX_NO_COLS [line 85]

DB_TABLE_ERR_IDX_NO_COLS = -11

Error code at create() time when you define an index in $this->idx that has no columns.

[ Top ]

DB_TABLE_ERR_IDX_STRLEN [line 151]

DB_TABLE_ERR_IDX_STRLEN = -22

Error code at create() time when the index name ends up being more than 30 chars long (an Oracle restriction).

[ Top ]

DB_TABLE_ERR_IDX_TYPE [line 97]

DB_TABLE_ERR_IDX_TYPE = -13

Error code at create() time when you define a $this->idx index type that is not recognized (must be 'normal' or 'unique').

[ Top ]

DB_TABLE_ERR_INS_COL_NOMAP [line 45]

DB_TABLE_ERR_INS_COL_NOMAP = -4

Error code when you try to insert data to a column that is not in the $this->col array.

[ Top ]

DB_TABLE_ERR_INS_COL_REQUIRED [line 51]

DB_TABLE_ERR_INS_COL_REQUIRED = -5

Error code when you try to insert data, and that data does not have a column marked as 'require' in the $this->col array.

[ Top ]

DB_TABLE_ERR_INS_DATA_INVALID [line 56]

DB_TABLE_ERR_INS_DATA_INVALID = -6

Error code when auto-validation fails on data to be inserted.

[ Top ]

DB_TABLE_ERR_NOT_DB_OBJECT [line 27]

DB_TABLE_ERR_NOT_DB_OBJECT = -1

Error code at instantiation time when the first parameter to the constructor is not a PEAR DB object.

[ Top ]

DB_TABLE_ERR_PHPTYPE [line 33]

DB_TABLE_ERR_PHPTYPE = -2

Error code at instantiation time when the PEAR DB $phptype is not supported by DB_Table.

[ Top ]

DB_TABLE_ERR_SEQ_STRLEN [line 163]

DB_TABLE_ERR_SEQ_STRLEN = -24

Error code at nextID() time when the sequence name is more than 30 chars long (an Oracle restriction).

[ Top ]

DB_TABLE_ERR_SQL_UNDEF [line 39]

DB_TABLE_ERR_SQL_UNDEF = -3

Error code when you call select() or selectResult() and the first parameter does not match any of the $this->sql keys.

[ Top ]

DB_TABLE_ERR_TABLE_STRLEN [line 157]

DB_TABLE_ERR_TABLE_STRLEN = -23

Error code at create() time when the table name is more than 30 chars long (an Oracle restriction).

[ Top ]

DB_TABLE_ERR_UPD_COL_NOMAP [line 62]

DB_TABLE_ERR_UPD_COL_NOMAP = -7

Error code when you try to update data to a column that is not in the $this->col array.

[ Top ]

DB_TABLE_ERR_UPD_COL_REQUIRED [line 68]

DB_TABLE_ERR_UPD_COL_REQUIRED = -8

Error code when you try to update data, and that data does not have a column marked as 'require' in the $this->col array.

[ Top ]

DB_TABLE_ERR_UPD_DATA_INVALID [line 73]

DB_TABLE_ERR_UPD_DATA_INVALID = -9

Error code when auto-validation fails on update data.

[ Top ]

DB_TABLE_ERR_VALIDATE_TYPE [line 121]

DB_TABLE_ERR_VALIDATE_TYPE = -17

Error code at validation time when a column in $this->col has an unrecognized 'type'.

[ Top ]