DB_Table
[ class tree: DB_Table ] [ index: DB_Table ] [ all elements ]
Packages:
DB_Table
Date


Classes:
DB_Table
   example
DB_Table
DB_Table_Manager_ibase
DB_Table_Manager_mysql
DB_Table_Manager_mysqli
DB_Table_Manager_oci8
DB_Table_Manager_pgsql
DB_Table_Manager_sqlite
DB_Table_QuickForm
DB_Table_Valid
Files:
bogotest.php
ibase.php
Manager.php
mysql.php
mysqli.php
oci8.php
pgsql.php
QuickForm.php
sqlite.php
Table.php
Valid.php

File: Table.php

Source Location: /DB_Table-1.3.0/DB/Table.php

Classes:

DB_Table
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.

Includes:

require_once('PEAR.php') [line 239]
The PEAR class for errors
require_once('DB/Table/Date.php') [line 244]
The Date class for recasting date and time values

DB_TABLE_ERR_ALTER_INDEX_IMPOS [line 234]

DB_TABLE_ERR_ALTER_INDEX_IMPOS = -35
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 227]

DB_TABLE_ERR_ALTER_TABLE_IMPOS = -34
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_CREATE_FLAG [line 82]

DB_TABLE_ERR_CREATE_FLAG = -10
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 208]

DB_TABLE_ERR_CREATE_PHPTYPE = -31
Error code at instantiation time when a creation mode is not available for a phptype.

[ Top ]


DB_TABLE_ERR_DECLARE_COLNAME [line 130]

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

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

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

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

[ Top ]


DB_TABLE_ERR_DECLARE_PRIM_SQLITE [line 220]

DB_TABLE_ERR_DECLARE_PRIM_SQLITE = -33
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 106]

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

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

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

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

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

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

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

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

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

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

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

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

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

[ Top ]


DB_TABLE_ERR_PHPTYPE [line 36]

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

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

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

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

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

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

DB_TABLE_ERR_UPD_DATA_INVALID = -9
Error code when auto-validation fails on update data.

[ Top ]


DB_TABLE_ERR_VALIDATE_TYPE [line 124]

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

[ Top ]


DB_TABLE_ERR_VER_COLUMN_MISSING [line 178]

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

[ Top ]


DB_TABLE_ERR_VER_COLUMN_TYPE [line 184]

DB_TABLE_ERR_VER_COLUMN_TYPE = -27
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 202]

DB_TABLE_ERR_VER_IDX_COL_MISSING = -30
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 196]

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

[ Top ]


DB_TABLE_ERR_VER_TABLE_MISSING [line 172]

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

[ Top ]


Documentation generated on Wed, 26 Apr 2006 12:03:21 -0400 by phpDocumentor 1.2.3. PEAR Logo Copyright © PHP Group 2004.