File: Database.php

Source Location: /DB_Table-1.5.6/DB/Table/Database.php

Classes:

Relational database abstraction class

Page Details:

DB_Table_Database relational database abstraction class

PHP versions 4 and 5

LICENSE:

Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met:

* Redistributions of source code must retain the above copyright notice, this list of conditions and the following disclaimer. * Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the following disclaimer in the documentation and/or other materials provided with the distribution. * The names of the authors may not be used to endorse or promote products derived from this software without specific prior written permission.

THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

Author: David C. Morse <morse@php.net>
Version: CVS: $Id: Database.php,v 1.15 2007/12/13 16:52:14 wiesemann Exp $
Link: http://pear.php.net/package/DB_Table
License: New BSD License

Includes:

require_once('DB/Table.php') [line 263]
DB_Table table abstraction class
require_once('DB/Table/Base.php') [line 258]
DB_Table_Base base class
require_once('PEAR.php') [line 268]
The PEAR class for errors

DB_TABLE_DATABASE_ERR_AMBIG_JOIN [line 235]

DB_TABLE_DATABASE_ERR_AMBIG_JOIN = -237

Error in autoJoin for non-unique set of join conditions

[ Top ]

DB_TABLE_DATABASE_ERR_COL_NOT_STRING [line 84]

DB_TABLE_DATABASE_ERR_COL_NOT_STRING = -207

Error for column name that is not a string

[ Top ]

DB_TABLE_DATABASE_ERR_COL_NOT_UNIQUE [line 230]

DB_TABLE_DATABASE_ERR_COL_NOT_UNIQUE = -236

Error in autoJoin for ambiguous column name

[ Top ]

DB_TABLE_DATABASE_ERR_DATA_KEY [line 190]

DB_TABLE_DATABASE_ERR_DATA_KEY = -228

Error in buildFilter due to invalid key for full match

[ Top ]

DB_TABLE_DATABASE_ERR_DBTABLE_OBJECT [line 59]

DB_TABLE_DATABASE_ERR_DBTABLE_OBJECT = -202

Error in addTable, parameter $table_obj is not a DB_Table object

[ Top ]

DB_TABLE_DATABASE_ERR_DB_OBJECT [line 54]

DB_TABLE_DATABASE_ERR_DB_OBJECT = -201

Parameter is not a DB/MDB2 object

[ Top ]

DB_TABLE_DATABASE_ERR_FAIL_JOIN [line 240]

DB_TABLE_DATABASE_ERR_FAIL_JOIN = -238

Error in autoJoin for failed construction of join

[ Top ]

DB_TABLE_DATABASE_ERR_FILT_KEY [line 195]

DB_TABLE_DATABASE_ERR_FILT_KEY = -229

Error in buildFilter due to invalid key for full match

[ Top ]

DB_TABLE_DATABASE_ERR_FKEY [line 109]

DB_TABLE_DATABASE_ERR_FKEY = -212

Error in addRef for an invalid foreign key, neither string nor array

[ Top ]

DB_TABLE_DATABASE_ERR_FKEY_CONSTRAINT [line 205]

DB_TABLE_DATABASE_ERR_FKEY_CONSTRAINT = -231

Error in insert for a failed foreign key constraint

[ Top ]

DB_TABLE_DATABASE_ERR_FULL_KEY [line 200]

DB_TABLE_DATABASE_ERR_FULL_KEY = -230

Error in buildFilter due to invalid key for full match

[ Top ]

DB_TABLE_DATABASE_ERR_MATCH_TYPE [line 185]

DB_TABLE_DATABASE_ERR_MATCH_TYPE = -227

Error in buildFilter due to invalid match type

[ Top ]

DB_TABLE_DATABASE_ERR_MULT_PKEY [line 89]

DB_TABLE_DATABASE_ERR_MULT_PKEY = -208

Error in addTable for multiple primary keys

[ Top ]

DB_TABLE_DATABASE_ERR_MULT_REF [line 144]

DB_TABLE_DATABASE_ERR_MULT_REF = -219

Error in addRef for multiple references from one table to another

[ Top ]

DB_TABLE_DATABASE_ERR_NO_COL [line 74]

DB_TABLE_DATABASE_ERR_NO_COL = -205

Error in getCol for a non-existent column name

[ Top ]

DB_TABLE_DATABASE_ERR_NO_COL_DB [line 164]

DB_TABLE_DATABASE_ERR_NO_COL_DB = -223

Error in validCol for a column name that does not exist in the datase

[ Top ]

DB_TABLE_DATABASE_ERR_NO_COL_NO_TBL [line 225]

DB_TABLE_DATABASE_ERR_NO_COL_NO_TBL = -235

Error in autoJoin, column and tables parameter both null

[ Top ]

DB_TABLE_DATABASE_ERR_NO_COL_TBL [line 169]

DB_TABLE_DATABASE_ERR_NO_COL_TBL = -224

Error in validCol for column name that does not exist in the specified table

[ Top ]

DB_TABLE_DATABASE_ERR_NO_FCOL [line 129]

DB_TABLE_DATABASE_ERR_NO_FCOL = -216

Error in addRef for non-existence foreign key (referencing) column

[ Top ]

DB_TABLE_DATABASE_ERR_NO_FOREIGN_COL [line 79]

DB_TABLE_DATABASE_ERR_NO_FOREIGN_COL = -206

Error in getForeignCol for a non-existent foreign key column

[ Top ]

DB_TABLE_DATABASE_ERR_NO_FTABLE [line 94]

DB_TABLE_DATABASE_ERR_NO_FTABLE = -209

Error in addRef for a non-existent foreign key table

[ Top ]

DB_TABLE_DATABASE_ERR_NO_PKEY [line 104]

DB_TABLE_DATABASE_ERR_NO_PKEY = -211

Error in addRef for null referenced key in a table with no primary key

[ Top ]

DB_TABLE_DATABASE_ERR_NO_RCOL [line 134]

DB_TABLE_DATABASE_ERR_NO_RCOL = -217

Error in addRef for non-existence referenced column

[ Top ]

DB_TABLE_DATABASE_ERR_NO_REF_LINK [line 159]

DB_TABLE_DATABASE_ERR_NO_REF_LINK = -222

Error in addLink due to missing required reference

[ Top ]

DB_TABLE_DATABASE_ERR_NO_RTABLE [line 99]

DB_TABLE_DATABASE_ERR_NO_RTABLE = -210

Error in addRef for non-existence referenced table

[ Top ]

DB_TABLE_DATABASE_ERR_NO_TBL [line 64]

DB_TABLE_DATABASE_ERR_NO_TBL = -203

Error for table name that does not exist in the database

[ Top ]

DB_TABLE_DATABASE_ERR_ON_DELETE_ACTION [line 149]

DB_TABLE_DATABASE_ERR_ON_DELETE_ACTION = -220

Error due to invalid ON DELETE action name

[ Top ]

DB_TABLE_DATABASE_ERR_ON_UPDATE_ACTION [line 154]

DB_TABLE_DATABASE_ERR_ON_UPDATE_ACTION = -221

Error due to invalid ON UPDATE action name

[ Top ]

DB_TABLE_DATABASE_ERR_PHP_VERSION [line 245]

DB_TABLE_DATABASE_ERR_PHP_VERSION = -239

Error in fromXML for PHP 4 (this function requires PHP 5)

[ Top ]

DB_TABLE_DATABASE_ERR_REF_TYPE [line 139]

DB_TABLE_DATABASE_ERR_REF_TYPE = -218

Error in addRef for referencing and referenced columns of different types

[ Top ]

DB_TABLE_DATABASE_ERR_RESTRICT_DELETE [line 210]

DB_TABLE_DATABASE_ERR_RESTRICT_DELETE = -232

Error in delete due to a referentially triggered 'restrict' action

[ Top ]

DB_TABLE_DATABASE_ERR_RESTRICT_UPDATE [line 215]

DB_TABLE_DATABASE_ERR_RESTRICT_UPDATE = -233

Error in update due to a referentially triggered 'restrict' action

[ Top ]

DB_TABLE_DATABASE_ERR_RKEY_COL_NUMBER [line 124]

DB_TABLE_DATABASE_ERR_RKEY_COL_NUMBER = -215

Error in addRef for wrong number of columns in referenced key

[ Top ]

DB_TABLE_DATABASE_ERR_RKEY_NOT_ARRAY [line 119]

DB_TABLE_DATABASE_ERR_RKEY_NOT_ARRAY = -214

Error in addRef for referenced key that is not an array, array foreign key

[ Top ]

DB_TABLE_DATABASE_ERR_RKEY_NOT_STRING [line 114]

DB_TABLE_DATABASE_ERR_RKEY_NOT_STRING = -213

Error in addRef for referenced key that is not a string, string foreign key

[ Top ]

DB_TABLE_DATABASE_ERR_SQL_NOT_STRING [line 180]

DB_TABLE_DATABASE_ERR_SQL_NOT_STRING = -226

Error in a buildSQL or select* method for a key of $this->sql that is

not a string

[ Top ]

DB_TABLE_DATABASE_ERR_SQL_UNDEF [line 174]

DB_TABLE_DATABASE_ERR_SQL_UNDEF = -225

Error in a buildSQL or select* method for an undefined key of $this->sql

[ Top ]

DB_TABLE_DATABASE_ERR_TBL_NOT_STRING [line 69]

DB_TABLE_DATABASE_ERR_TBL_NOT_STRING = -204

Error for table name parameter that is not a string

[ Top ]

DB_TABLE_DATABASE_ERR_XML_MULT_AUTO_INC [line 220]

DB_TABLE_DATABASE_ERR_XML_MULT_AUTO_INC = -234

Error in fromXML for table with multiple auto_increment columns

[ Top ]

DB_TABLE_DATABASE_ERR_XML_PARSE [line 250]

DB_TABLE_DATABASE_ERR_XML_PARSE = -240

Error parsing XML string in fromXML

[ Top ]