File: Table.php

Source Location: /DB_Table-1.5.0/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 elements based on the column definitions.

Author: Mark Wiesemann <wiesemann@php.net>
Author: Paul M. Jones <pmjones@php.net>
Version: $Id: Table.php,v 1.87 2007/06/14 15:07:27 morse Exp $
License: LGPL

Includes:

require_once('DB/Table/Date.php') [line 257]
The Date class for recasting date and time values
require_once('PEAR.php') [line 252]
The PEAR class for errors
require_once('DB/Table/Base.php') [line 247]
The DB_Table_Base parent class

DB_TABLE_ERR_ALTER_INDEX_IMPOS [line 236]

DB_TABLE_ERR_ALTER_INDEX_IMPOS = -36

Error code at alter() time when altering a(n) index/constraint is not possible (e.g. because MDB2 has no support for the change or because the DBMS does not support the change).

[ Top ]

DB_TABLE_ERR_ALTER_TABLE_IMPOS [line 229]

DB_TABLE_ERR_ALTER_TABLE_IMPOS = -35

Error code at alter() time when altering a table field is not possible (e.g. because MDB2 has no support for the change or because the DBMS does not support the change).

[ Top ]

DB_TABLE_ERR_AUTO_INC_COL [line 242]

DB_TABLE_ERR_AUTO_INC_COL = -37

Error code at insert() time due to invalid the auto-increment column definition. This column must be an integer type and required.

[ Top ]

DB_TABLE_ERR_CREATE_FLAG [line 84]

DB_TABLE_ERR_CREATE_FLAG = -11

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

[ Top ]

DB_TABLE_ERR_CREATE_PHPTYPE [line 210]

DB_TABLE_ERR_CREATE_PHPTYPE = -32

Error code at instantiation time when a creation mode is not available for a phptype.

[ Top ]

DB_TABLE_ERR_DECLARE_COLNAME [line 132]

DB_TABLE_ERR_DECLARE_COLNAME = -19

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 114]

DB_TABLE_ERR_DECLARE_DECIMAL = -16

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 138]

DB_TABLE_ERR_DECLARE_IDXNAME = -20

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_PRIMARY [line 216]

DB_TABLE_ERR_DECLARE_PRIMARY = -33

Error code at create() time when you define more than one primary key in $this->idx.

[ Top ]

DB_TABLE_ERR_DECLARE_PRIM_SQLITE [line 222]

DB_TABLE_ERR_DECLARE_PRIM_SQLITE = -34

Error code at create() time when a primary key is defined in $this->idx and SQLite is used (SQLite does not support primary keys).

[ Top ]

DB_TABLE_ERR_DECLARE_STRING [line 108]

DB_TABLE_ERR_DECLARE_STRING = -15

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 150]

DB_TABLE_ERR_DECLARE_STRLEN = -22

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 120]

DB_TABLE_ERR_DECLARE_TYPE = -17

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 144]

DB_TABLE_ERR_IDX_COL_CLOB = -21

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 96]

DB_TABLE_ERR_IDX_COL_UNDEF = -13

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 90]

DB_TABLE_ERR_IDX_NO_COLS = -12

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

[ Top ]

DB_TABLE_ERR_IDX_STRLEN [line 156]

DB_TABLE_ERR_IDX_STRLEN = -23

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 102]

DB_TABLE_ERR_IDX_TYPE = -14

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 50]

DB_TABLE_ERR_INS_COL_NOMAP = -5

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 56]

DB_TABLE_ERR_INS_COL_REQUIRED = -6

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 61]

DB_TABLE_ERR_INS_DATA_INVALID = -7

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

[ Top ]

DB_TABLE_ERR_NOT_DB_OBJECT [line 26]

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_NO_COLS [line 192]

DB_TABLE_ERR_NO_COLS = -29

Error code at instantiation time when the column definition array does not contain at least one column.

[ Top ]

DB_TABLE_ERR_PHPTYPE [line 32]

DB_TABLE_ERR_PHPTYPE = -2

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

[ Top ]

DB_TABLE_ERR_SEQ_STRLEN [line 168]

DB_TABLE_ERR_SEQ_STRLEN = -25

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

[ Top ]

DB_TABLE_ERR_SQL_NOT_STRING [line 44]

DB_TABLE_ERR_SQL_NOT_STRING = -4

Error code when you call select*() or buildSQL() and the first

parameter is neither an array nor a string

[ Top ]

DB_TABLE_ERR_SQL_UNDEF [line 38]

DB_TABLE_ERR_SQL_UNDEF = -3

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

[ Top ]

DB_TABLE_ERR_TABLE_STRLEN [line 162]

DB_TABLE_ERR_TABLE_STRLEN = -24

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 67]

DB_TABLE_ERR_UPD_COL_NOMAP = -8

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 73]

DB_TABLE_ERR_UPD_COL_REQUIRED = -9

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 78]

DB_TABLE_ERR_UPD_DATA_INVALID = -10

Error code when auto-validation fails on update data.

[ Top ]

DB_TABLE_ERR_VALIDATE_TYPE [line 126]

DB_TABLE_ERR_VALIDATE_TYPE = -18

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

[ Top ]

DB_TABLE_ERR_VER_COLUMN_MISSING [line 180]

DB_TABLE_ERR_VER_COLUMN_MISSING = -27

Error code at verify() time when the column does not exist in the database table.

[ Top ]

DB_TABLE_ERR_VER_COLUMN_TYPE [line 186]

DB_TABLE_ERR_VER_COLUMN_TYPE = -28

Error code at verify() time when the column type does not match the type specified in the column declaration.

[ Top ]

DB_TABLE_ERR_VER_IDX_COL_MISSING [line 204]

DB_TABLE_ERR_VER_IDX_COL_MISSING = -31

Error code at verify() time when an index does not contain all columns that it should contain.

[ Top ]

DB_TABLE_ERR_VER_IDX_MISSING [line 198]

DB_TABLE_ERR_VER_IDX_MISSING = -30

Error code at verify() time when an index cannot be found in the database table.

[ Top ]

DB_TABLE_ERR_VER_TABLE_MISSING [line 174]

DB_TABLE_ERR_VER_TABLE_MISSING = -26

Error code at verify() time when the table does not exist in the database.

[ Top ]