TYPO3 CMS  TYPO3_7-6
Public Member Functions | Static Public Member Functions | Public Attributes | Static Public Attributes | List of all members
ADODB_Active_Record Class Reference

Public Member Functions

 __set ($name, $value)
 
 __construct ($table=false, $pkeyarr=false, $db=false)
 
 __wakeup ()
 
 _pluralize ($table)
 
 _singularize ($tables)
 
 hasMany ($foreignRef, $foreignKey=false, $foreignClass='ADODB_Active_Record')
 
 belongsTo ($foreignRef, $foreignKey=false, $parentKey='', $parentClass='ADODB_Active_Record')
 
 __get ($name)
 
 LoadRelations ($name, $whereOrderBy='', $offset=-1, $limit=-1)
 
 UpdateActiveTable ($pkeys=false, $forceUpdate=false)
 
 GetPrimaryKeys (&$db, $table)
 
 Error ($err, $fn)
 
 ErrorMsg ()
 
 ErrorNo ()
 
 DB ()
 
& TableInfo ()
 
 Reload ()
 
 Set (&$row)
 
 LastInsertID (&$db, $fieldname)
 
 doquote (&$db, $val, $t)
 
 GenWhere (&$db, &$table)
 
 _QName ($n, $db=false)
 
 Load ($where=null, $bindarr=false, $lock=false)
 
 LoadLocked ($where=null, $bindarr=false)
 
 Reset ()
 
 Save ()
 
 Insert ()
 
 Delete ()
 
 Find ($whereOrderBy, $bindarr=false, $pkeysArr=false, $extra=array())
 
 Replace ()
 
 Update ()
 
 GetAttributeNames ()
 
 __set ($name, $value)
 
 __construct ($table=false, $pkeyarr=false, $db=false, $options=array())
 
 __wakeup ()
 
 _pluralize ($table)
 
 _singularize ($table)
 
 hasMany ($foreignRef, $foreignKey=false)
 
 belongsTo ($foreignRef, $foreignKey=false)
 
 __get ($name)
 
 LoadRelations ($name, $whereOrderBy, $offset=-1, $limit=-1)
 
 UpdateActiveTable ($pkeys=false, $forceUpdate=false)
 
 GetPrimaryKeys (&$db, $table)
 
 Error ($err, $fn)
 
 ErrorMsg ()
 
 ErrorNo ()
 
 DB ()
 
& TableInfo ()
 
 Reload ()
 
 Set (&$row)
 
 LastInsertID (&$db, $fieldname)
 
 doquote (&$db, $val, $t)
 
 GenWhere (&$db, &$table)
 
 Load ($where=null, $bindarr=false)
 
 Save ()
 
 Dirty ()
 
 Insert ()
 
 Delete ()
 
 Find ($whereOrderBy, $bindarr=false, $pkeysArr=false, $extra=array())
 
 packageFind ($whereOrderBy, $bindarr=false, $pkeysArr=false, $extra=array())
 
 Replace ()
 
 Update ()
 
 GetAttributeNames ()
 

Static Public Member Functions

static UseDefaultValues ($bool=null)
 
static SetDatabaseAdapter (&$db, $index=false)
 
static TableHasMany ($table, $foreignRef, $foreignKey=false, $foreignClass='ADODB_Active_Record')
 
static TableKeyHasMany ($table, $tablePKey, $foreignRef, $foreignKey=false, $foreignClass='ADODB_Active_Record')
 
static ClassHasMany ($parentclass, $foreignRef, $foreignKey=false, $foreignClass='ADODB_Active_Record')
 
static ClassBelongsTo ($class, $foreignRef, $foreignKey=false, $parentKey='', $parentClass='ADODB_Active_Record')
 
static TableBelongsTo ($table, $foreignRef, $foreignKey=false, $parentKey='', $parentClass='ADODB_Active_Record')
 
static TableKeyBelongsTo ($table, $tablePKey, $foreignRef, $foreignKey=false, $parentKey='', $parentClass='ADODB_Active_Record')
 
static UseDefaultValues ($bool=null)
 
static SetDatabaseAdapter (&$db)
 

Public Attributes

 $_dbat
 
 $_table
 
 $_tableat
 
 $_where
 
 $_saved = false
 
 $_lasterr = false
 
 $_original = false
 
 $foreignName
 
 $lockMode = ' for update '
 
 $_sTable
 
 $_pTable
 

Static Public Attributes

static $_changeNames = true
 
static $_quoteNames = false
 
static $_foreignSuffix = '_id'
 
static $IrregularP
 
static $IrregularS
 
static $WeIsI
 

Detailed Description

Definition at line 81 of file adodb-active-record.inc.php.

Constructor & Destructor Documentation

◆ __construct() [1/2]

ADODB_Active_Record::__construct (   $table = false,
  $pkeyarr = false,
  $db = false 
)

Definition at line 121 of file adodb-active-record.inc.php.

References $_ADODB_ACTIVE_DBS, ADODB_Active_DB\$db, and SetDatabaseAdapter().

◆ __construct() [2/2]

ADODB_Active_Record::__construct (   $table = false,
  $pkeyarr = false,
  $db = false,
  $options = array() 
)

Definition at line 138 of file adodb-active-recordx.inc.php.

References $_ADODB_ACTIVE_DBS, ADODB_Active_DB\$db, and SetDatabaseAdapter().

Member Function Documentation

◆ __get() [1/2]

ADODB_Active_Record::__get (   $name)

__get Access properties - used for lazy loading

Parameters
mixed$nameprotected
Returns
mixed

Definition at line 302 of file adodb-active-record.inc.php.

◆ __get() [2/2]

ADODB_Active_Record::__get (   $name)

__get Access properties - used for lazy loading

Parameters
mixed$nameprotected
Returns
void

Definition at line 348 of file adodb-active-recordx.inc.php.

◆ __set() [1/2]

ADODB_Active_Record::__set (   $name,
  $value 
)

Definition at line 114 of file adodb-active-record.inc.php.

◆ __set() [2/2]

ADODB_Active_Record::__set (   $name,
  $value 
)

Definition at line 122 of file adodb-active-recordx.inc.php.

◆ __wakeup() [1/2]

ADODB_Active_Record::__wakeup ( )

Definition at line 156 of file adodb-active-record.inc.php.

◆ __wakeup() [2/2]

ADODB_Active_Record::__wakeup ( )

Definition at line 191 of file adodb-active-recordx.inc.php.

◆ _pluralize() [1/2]

ADODB_Active_Record::_pluralize (   $table)

Definition at line 162 of file adodb-active-record.inc.php.

References $_changeNames.

◆ _pluralize() [2/2]

ADODB_Active_Record::_pluralize (   $table)

Definition at line 225 of file adodb-active-recordx.inc.php.

References $_changeNames.

◆ _QName()

ADODB_Active_Record::_QName (   $n,
  $db = false 
)

Definition at line 759 of file adodb-active-record.inc.php.

References $_quoteNames, and ADODB_Active_DB\$db.

◆ _singularize() [1/2]

ADODB_Active_Record::_singularize (   $tables)

Definition at line 190 of file adodb-active-record.inc.php.

References $_changeNames, and ADODB_Active_DB\$tables.

◆ _singularize() [2/2]

ADODB_Active_Record::_singularize (   $table)

Definition at line 258 of file adodb-active-recordx.inc.php.

References $_changeNames.

◆ belongsTo() [1/2]

ADODB_Active_Record::belongsTo (   $foreignRef,
  $foreignKey = false,
  $parentKey = '',
  $parentClass = 'ADODB_Active_Record' 
)

Definition at line 258 of file adodb-active-record.inc.php.

◆ belongsTo() [2/2]

ADODB_Active_Record::belongsTo (   $foreignRef,
  $foreignKey = false 
)

ar->foreignName will contain the name of the tables associated with this table because this table's rows may also be referenced by those tables using thistable_id or the provided foreign keys (this index name is stored in ar->foreignKey)

this-table.other-table_id = other-table.id

Definition at line 324 of file adodb-active-recordx.inc.php.

◆ ClassBelongsTo()

static ADODB_Active_Record::ClassBelongsTo (   $class,
  $foreignRef,
  $foreignKey = false,
  $parentKey = '',
  $parentClass = 'ADODB_Active_Record' 
)
static

Definition at line 273 of file adodb-active-record.inc.php.

◆ ClassHasMany()

static ADODB_Active_Record::ClassHasMany (   $parentclass,
  $foreignRef,
  $foreignKey = false,
  $foreignClass = 'ADODB_Active_Record' 
)
static

Definition at line 251 of file adodb-active-record.inc.php.

◆ DB() [1/2]

ADODB_Active_Record::DB ( )

Definition at line 607 of file adodb-active-record.inc.php.

References $_ADODB_ACTIVE_DBS, and ADODB_Active_DB\$db.

◆ DB() [2/2]

ADODB_Active_Record::DB ( )

Definition at line 636 of file adodb-active-recordx.inc.php.

References $_ADODB_ACTIVE_DBS, and ADODB_Active_DB\$db.

◆ Delete() [1/2]

ADODB_Active_Record::Delete ( )

Definition at line 901 of file adodb-active-record.inc.php.

References ADODB_Active_DB\$db, and $sql.

◆ Delete() [2/2]

ADODB_Active_Record::Delete ( )

Definition at line 1016 of file adodb-active-recordx.inc.php.

References ADODB_Active_DB\$db, and $sql.

◆ Dirty()

ADODB_Active_Record::Dirty ( )

Definition at line 957 of file adodb-active-recordx.inc.php.

◆ doquote() [1/2]

ADODB_Active_Record::doquote ( &  $db,
  $val,
  $t 
)

Definition at line 711 of file adodb-active-record.inc.php.

References ADODB_Active_DB\$db.

◆ doquote() [2/2]

ADODB_Active_Record::doquote ( &  $db,
  $val,
  $t 
)

Definition at line 770 of file adodb-active-recordx.inc.php.

References ADODB_Active_DB\$db.

◆ Error() [1/2]

ADODB_Active_Record::Error (   $err,
  $fn 
)

Definition at line 546 of file adodb-active-record.inc.php.

References $_ADODB_ACTIVE_DBS, ADODB_Active_DB\$db, and adodb_throw().

◆ Error() [2/2]

ADODB_Active_Record::Error (   $err,
  $fn 
)

Definition at line 575 of file adodb-active-recordx.inc.php.

References $_ADODB_ACTIVE_DBS, ADODB_Active_DB\$db, and adodb_throw().

◆ ErrorMsg() [1/2]

ADODB_Active_Record::ErrorMsg ( )

Definition at line 577 of file adodb-active-record.inc.php.

References ADODB_Active_DB\$db.

◆ ErrorMsg() [2/2]

ADODB_Active_Record::ErrorMsg ( )

Definition at line 606 of file adodb-active-recordx.inc.php.

References ADODB_Active_DB\$db.

◆ ErrorNo() [1/2]

ADODB_Active_Record::ErrorNo ( )

Definition at line 595 of file adodb-active-record.inc.php.

References ADODB_Active_DB\$db.

◆ ErrorNo() [2/2]

ADODB_Active_Record::ErrorNo ( )

Definition at line 624 of file adodb-active-recordx.inc.php.

References ADODB_Active_DB\$db.

◆ Find() [1/2]

ADODB_Active_Record::Find (   $whereOrderBy,
  $bindarr = false,
  $pkeysArr = false,
  $extra = array() 
)

Definition at line 917 of file adodb-active-record.inc.php.

References ADODB_Active_DB\$db.

◆ Find() [2/2]

ADODB_Active_Record::Find (   $whereOrderBy,
  $bindarr = false,
  $pkeysArr = false,
  $extra = array() 
)

Definition at line 1032 of file adodb-active-recordx.inc.php.

References ADODB_Active_DB\$db.

◆ GenWhere() [1/2]

ADODB_Active_Record::GenWhere ( &  $db,
&  $table 
)

Definition at line 744 of file adodb-active-record.inc.php.

References ADODB_Active_DB\$db.

◆ GenWhere() [2/2]

ADODB_Active_Record::GenWhere ( &  $db,
&  $table 
)

Definition at line 796 of file adodb-active-recordx.inc.php.

References ADODB_Active_DB\$db.

◆ GetAttributeNames() [1/2]

ADODB_Active_Record::GetAttributeNames ( )

Definition at line 1071 of file adodb-active-record.inc.php.

◆ GetAttributeNames() [2/2]

ADODB_Active_Record::GetAttributeNames ( )

Definition at line 1197 of file adodb-active-recordx.inc.php.

◆ GetPrimaryKeys() [1/2]

ADODB_Active_Record::GetPrimaryKeys ( &  $db,
  $table 
)

Definition at line 540 of file adodb-active-record.inc.php.

References ADODB_Active_DB\$db.

◆ GetPrimaryKeys() [2/2]

ADODB_Active_Record::GetPrimaryKeys ( &  $db,
  $table 
)

Definition at line 569 of file adodb-active-recordx.inc.php.

References ADODB_Active_DB\$db.

◆ hasMany() [1/2]

ADODB_Active_Record::hasMany (   $foreignRef,
  $foreignKey = false,
  $foreignClass = 'ADODB_Active_Record' 
)

Definition at line 220 of file adodb-active-record.inc.php.

◆ hasMany() [2/2]

ADODB_Active_Record::hasMany (   $foreignRef,
  $foreignKey = false 
)

Definition at line 301 of file adodb-active-recordx.inc.php.

◆ Insert() [1/2]

ADODB_Active_Record::Insert ( )

Definition at line 848 of file adodb-active-record.inc.php.

References ADODB_Active_DB\$db, and $sql.

◆ Insert() [2/2]

ADODB_Active_Record::Insert ( )

Definition at line 963 of file adodb-active-recordx.inc.php.

References ADODB_Active_DB\$db, and $sql.

◆ LastInsertID() [1/2]

ADODB_Active_Record::LastInsertID ( &  $db,
  $fieldname 
)

Definition at line 694 of file adodb-active-record.inc.php.

References ADODB_Active_DB\$db.

◆ LastInsertID() [2/2]

ADODB_Active_Record::LastInsertID ( &  $db,
  $fieldname 
)

Definition at line 753 of file adodb-active-recordx.inc.php.

References ADODB_Active_DB\$db.

◆ Load() [1/2]

ADODB_Active_Record::Load (   $where = null,
  $bindarr = false,
  $lock = false 
)

Definition at line 775 of file adodb-active-record.inc.php.

References ADODB_Active_DB\$db.

◆ Load() [2/2]

ADODB_Active_Record::Load (   $where = null,
  $bindarr = false 
)
Todo:
Improve by storing once and for all in table metadata
Todo:
Also re-use info for hasManyId

Definition at line 813 of file adodb-active-recordx.inc.php.

References ADODB_Active_DB\$db.

◆ LoadLocked()

ADODB_Active_Record::LoadLocked (   $where = null,
  $bindarr = false 
)

Definition at line 810 of file adodb-active-record.inc.php.

◆ LoadRelations() [1/2]

ADODB_Active_Record::LoadRelations (   $name,
  $whereOrderBy = '',
  $offset = -1,
  $limit = -1 
)
Parameters
string$name
string$whereOrderBy: eg. ' AND field1 = value ORDER BY field2'
offset
limit
Returns
mixed

Definition at line 314 of file adodb-active-record.inc.php.

References ADODB_Active_DB\$db.

◆ LoadRelations() [2/2]

ADODB_Active_Record::LoadRelations (   $name,
  $whereOrderBy,
  $offset = -1,
  $limit = -1 
)

Definition at line 353 of file adodb-active-recordx.inc.php.

◆ packageFind()

ADODB_Active_Record::packageFind (   $whereOrderBy,
  $bindarr = false,
  $pkeysArr = false,
  $extra = array() 
)

Definition at line 1048 of file adodb-active-recordx.inc.php.

References ADODB_Active_DB\$db.

◆ Reload() [1/2]

ADODB_Active_Record::Reload ( )

Definition at line 633 of file adodb-active-record.inc.php.

References ADODB_Active_DB\$db.

◆ Reload() [2/2]

ADODB_Active_Record::Reload ( )

Definition at line 663 of file adodb-active-recordx.inc.php.

References ADODB_Active_DB\$db.

◆ Replace() [1/2]

ADODB_Active_Record::Replace ( )

Definition at line 928 of file adodb-active-record.inc.php.

References ADODB_Active_DB\$db.

◆ Replace() [2/2]

ADODB_Active_Record::Replace ( )

Definition at line 1061 of file adodb-active-recordx.inc.php.

References ADODB_Active_DB\$db.

◆ Reset()

ADODB_Active_Record::Reset ( )

Definition at line 817 of file adodb-active-record.inc.php.

◆ Save() [1/2]

ADODB_Active_Record::Save ( )

Definition at line 834 of file adodb-active-record.inc.php.

◆ Save() [2/2]

ADODB_Active_Record::Save ( )

Definition at line 943 of file adodb-active-recordx.inc.php.

◆ Set() [1/2]

ADODB_Active_Record::Set ( &  $row)

Definition at line 646 of file adodb-active-record.inc.php.

References $ACTIVE_RECORD_SAFETY, and ADODB_Active_DB\$db.

◆ Set() [2/2]

ADODB_Active_Record::Set ( &  $row)

Definition at line 676 of file adodb-active-recordx.inc.php.

References $ACTIVE_RECORD_SAFETY, and ADODB_Active_DB\$db.

◆ SetDatabaseAdapter() [1/2]

static ADODB_Active_Record::SetDatabaseAdapter ( &  $db,
  $index = false 
)
static

Definition at line 108 of file adodb-active-record.inc.php.

References ADODB_Active_DB\$db, and ADODB_SetDatabaseAdapter().

Referenced by __construct().

◆ SetDatabaseAdapter() [2/2]

static ADODB_Active_Record::SetDatabaseAdapter ( &  $db)
static

Definition at line 116 of file adodb-active-recordx.inc.php.

References ADODB_Active_DB\$db, and ADODB_SetDatabaseAdapter().

◆ TableBelongsTo()

static ADODB_Active_Record::TableBelongsTo (   $table,
  $foreignRef,
  $foreignKey = false,
  $parentKey = '',
  $parentClass = 'ADODB_Active_Record' 
)
static

Definition at line 279 of file adodb-active-record.inc.php.

◆ TableHasMany()

static ADODB_Active_Record::TableHasMany (   $table,
  $foreignRef,
  $foreignKey = false,
  $foreignClass = 'ADODB_Active_Record' 
)
static

Definition at line 232 of file adodb-active-record.inc.php.

◆ TableInfo() [1/2]

& ADODB_Active_Record::TableInfo ( )

Definition at line 622 of file adodb-active-record.inc.php.

References $_ADODB_ACTIVE_DBS.

◆ TableInfo() [2/2]

& ADODB_Active_Record::TableInfo ( )

Definition at line 651 of file adodb-active-recordx.inc.php.

References $_ADODB_ACTIVE_DBS.

◆ TableKeyBelongsTo()

static ADODB_Active_Record::TableKeyBelongsTo (   $table,
  $tablePKey,
  $foreignRef,
  $foreignKey = false,
  $parentKey = '',
  $parentClass = 'ADODB_Active_Record' 
)
static

Definition at line 285 of file adodb-active-record.inc.php.

◆ TableKeyHasMany()

static ADODB_Active_Record::TableKeyHasMany (   $table,
  $tablePKey,
  $foreignRef,
  $foreignKey = false,
  $foreignClass = 'ADODB_Active_Record' 
)
static

Definition at line 239 of file adodb-active-record.inc.php.

◆ Update() [1/2]

ADODB_Active_Record::Update ( )

Definition at line 1004 of file adodb-active-record.inc.php.

References ADODB_Active_DB\$db, and $sql.

◆ Update() [2/2]

ADODB_Active_Record::Update ( )

Definition at line 1136 of file adodb-active-recordx.inc.php.

References ADODB_Active_DB\$db, and $sql.

◆ UpdateActiveTable() [1/2]

ADODB_Active_Record::UpdateActiveTable (   $pkeys = false,
  $forceUpdate = false 
)

Definition at line 375 of file adodb-active-record.inc.php.

References $_ADODB_ACTIVE_DBS, $ADODB_ACTIVE_CACHESECS, $ADODB_ACTIVE_DEFVALS, ADODB_Active_DB\$db, ADODB_Active_DB\$tables, and adodb_write_file().

◆ UpdateActiveTable() [2/2]

ADODB_Active_Record::UpdateActiveTable (   $pkeys = false,
  $forceUpdate = false 
)

Definition at line 411 of file adodb-active-recordx.inc.php.

References $_ADODB_ACTIVE_DBS, $ADODB_ACTIVE_CACHESECS, $ADODB_ACTIVE_DEFVALS, ADODB_Active_DB\$db, ADODB_Active_DB\$tables, and adodb_write_file().

◆ UseDefaultValues() [1/2]

static ADODB_Active_Record::UseDefaultValues (   $bool = null)
static

Definition at line 98 of file adodb-active-record.inc.php.

References $ADODB_ACTIVE_DEFVALS.

◆ UseDefaultValues() [2/2]

static ADODB_Active_Record::UseDefaultValues (   $bool = null)
static

Definition at line 106 of file adodb-active-recordx.inc.php.

References $ADODB_ACTIVE_DEFVALS.

Member Data Documentation

◆ $_changeNames

static ADODB_Active_Record::$_changeNames = true
static

Definition at line 82 of file adodb-active-record.inc.php.

Referenced by _pluralize(), and _singularize().

◆ $_dbat

ADODB_Active_Record::$_dbat

Definition at line 86 of file adodb-active-record.inc.php.

◆ $_foreignSuffix

static ADODB_Active_Record::$_foreignSuffix = '_id'
static

Definition at line 85 of file adodb-active-record.inc.php.

◆ $_lasterr

ADODB_Active_Record::$_lasterr = false

Definition at line 91 of file adodb-active-record.inc.php.

◆ $_original

ADODB_Active_Record::$_original = false

Definition at line 92 of file adodb-active-record.inc.php.

◆ $_pTable

ADODB_Active_Record::$_pTable

Definition at line 97 of file adodb-active-recordx.inc.php.

◆ $_quoteNames

ADODB_Active_Record::$_quoteNames = false
static

Definition at line 83 of file adodb-active-record.inc.php.

Referenced by _QName().

◆ $_saved

ADODB_Active_Record::$_saved = false

Definition at line 90 of file adodb-active-record.inc.php.

◆ $_sTable

ADODB_Active_Record::$_sTable

Definition at line 96 of file adodb-active-recordx.inc.php.

◆ $_table

ADODB_Active_Record::$_table

Definition at line 87 of file adodb-active-record.inc.php.

◆ $_tableat

ADODB_Active_Record::$_tableat

Definition at line 88 of file adodb-active-record.inc.php.

◆ $_where

ADODB_Active_Record::$_where

Definition at line 89 of file adodb-active-record.inc.php.

◆ $foreignName

ADODB_Active_Record::$foreignName

Definition at line 94 of file adodb-active-record.inc.php.

◆ $IrregularP

ADODB_Active_Record::$IrregularP
static
Initial value:
= array(
'PERSON' => 'people',
'MAN' => 'men',
'WOMAN' => 'women',
'CHILD' => 'children',
'COW' => 'kine',
)

Definition at line 198 of file adodb-active-recordx.inc.php.

◆ $IrregularS

ADODB_Active_Record::$IrregularS
static
Initial value:
= array(
'PEOPLE' => 'PERSON',
'MEN' => 'man',
'WOMEN' => 'woman',
'CHILDREN' => 'child',
'KINE' => 'cow',
)

Definition at line 206 of file adodb-active-recordx.inc.php.

◆ $lockMode

ADODB_Active_Record::$lockMode = ' for update '

Definition at line 96 of file adodb-active-record.inc.php.

◆ $WeIsI

ADODB_Active_Record::$WeIsI
static
Initial value:
= array(
'EQUIPMENT' => true,
'INFORMATION' => true,
'RICE' => true,
'MONEY' => true,
'SPECIES' => true,
'SERIES' => true,
'FISH' => true,
'SHEEP' => true,
)

Definition at line 214 of file adodb-active-recordx.inc.php.