Public Member Functions | Static Public Member Functions | Public Attributes | Static Public Attributes | Protected Member Functions | Static Protected Member Functions | Static Protected Attributes | Static Private Attributes

oxDb Class Reference

Collaboration diagram for oxDb:

List of all members.

Public Member Functions

 quoteArray ($aStrArray)
 resetTblDescCache ()
 getTableDescription ($sTableName)
 convertDBDateTime ($oObject, $blToTimeStamp=false, $blOnlyDate=false)
 convertDBTimestamp ($oObject, $blToTimeStamp=false)
 convertDBDate ($oObject, $blToTimeStamp=false)
 isValidFieldName ($sField)
 escapeString ($sString)
 updateViews ($aTables=null)

Static Public Member Functions

static setConfig ($oConfig)
static getInstance ()
static getDb ($iFetchMode=oxDb::FETCH_MODE_NUM)

Public Attributes

const FETCH_MODE_NUM = ADODB_FETCH_NUM
const FETCH_MODE_ASSOC = ADODB_FETCH_ASSOC

Static Public Attributes

static $configSet = false

Protected Member Functions

 isAdmin ()
 _getModules ()
 _setUp ($oDb)
 _sendMail ($sEmail, $sSubject, $sBody)
 _notifyConnectionErrors ($oDb)
 _onConnectionError ($oDb)
 _getDbInstance ($iInstType=false)
 _setDefaultFormatedValue ($oObject, $sDate, $sLocalDateFormat, $sLocalTimeFormat, $blOnlyDate)
 _defineAndCheckDefaultTimeValues ($blToTimeStamp)
 _defineAndCheckDefaultDateValues ($blToTimeStamp)
 _defaultDatePattern ()
 _defaultTimePattern ()
 _regexp2ValidateDateInput ()
 _regexp2ValidateTimeInput ()
 _defineDateFormattingRules ()
 _defineTimeFormattingRules ()
 _setDefaultDateTimeValue ($oObject, $sLocalDateFormat, $sLocalTimeFormat, $blOnlyDate)
 _setDate ($oObject, $sDateFormat, $aDFields, $aDateMatches)
 _formatCorrectTimeValue ($oObject, $sDateFormat, $sTimeFormat, $aDateMatches, $aTimeMatches, $aTFields, $aDFields)
 _getConnectionId ()

Static Protected Member Functions

static _getConfigParam ($sConfigName)

Static Protected Attributes

static $_instance = null
static $_oDB = null
static $_aTblDescCache = array()

Static Private Attributes

static $_dbType = ''
static $_dbUser = ''
static $_dbPwd = ''
static $_dbName = ''
static $_dbHost = ''
static $_iDebug = 0
static $_blLogChangesInAdmin = false
static $_iUtfMode = 0
static $_sDefaultDatabaseConnection = null
static $_aSlaveHosts
static $_sAdminEmail
static $_iMasterSlaveBalance
static $_sLocalTimeFormat
static $_sLocalDateFormat

Detailed Description

Database connection class

Definition at line 10 of file oxdb.php.


Member Function Documentation

oxDb._defaultDatePattern (  )  [protected]

sets default date pattern

Deprecated:
from 2012-11-21, not used here anymore. All date formatting moved to oxutilsdate
Returns:
null

Definition at line 611 of file oxdb.php.

oxDb._defaultTimePattern (  )  [protected]

sets default time pattern

Deprecated:
from 2012-11-21, not used here anymore. All date formatting moved to oxutilsdate
Returns:
null

Definition at line 622 of file oxdb.php.

oxDb._defineAndCheckDefaultDateValues ( blToTimeStamp  )  [protected]

defines and checks default date values

Parameters:
bool $blToTimeStamp marker how to format
Deprecated:
from 2012-11-21, not used here anymore. All date formatting moved to oxutilsdate
Returns:
null

Definition at line 600 of file oxdb.php.

oxDb._defineAndCheckDefaultTimeValues ( blToTimeStamp  )  [protected]

defines and checks default time values

Parameters:
bool $blToTimeStamp -
Deprecated:
from 2012-11-21, not used here anymore. All date formatting moved to oxutilsdate
Returns:
null

Definition at line 587 of file oxdb.php.

oxDb._defineDateFormattingRules (  )  [protected]

define date formatting rules

Deprecated:
from 2012-11-21, not used here anymore. All date formatting moved to oxutilsdate
Returns:
array

Definition at line 655 of file oxdb.php.

oxDb._defineTimeFormattingRules (  )  [protected]

defines time formatting rules

Deprecated:
from 2012-11-21, not used here anymore. All date formatting moved to oxutilsdate
Returns:
array

Definition at line 672 of file oxdb.php.

oxDb._formatCorrectTimeValue ( oObject,
sDateFormat,
sTimeFormat,
aDateMatches,
aTimeMatches,
aTFields,
aDFields 
) [protected]

Formatting correct time value

Parameters:
object $oObject data field object
string $sDateFormat date format
string $sTimeFormat time format
array $aDateMatches new new date
array $aTimeMatches new time
array $aTFields defines the time fields
array $aDFields defines the date fields
Deprecated:
from 2012-11-21, not used here anymore. All date formatting moved to oxutilsdate
Returns:
null

Definition at line 756 of file oxdb.php.

static oxDb._getConfigParam ( sConfigName  )  [static, protected]

Return local config value by given name.

Parameters:
string $sConfigName returning config name.
Returns:
mixed

Definition at line 167 of file oxdb.php.

oxDb._getConnectionId (  )  [protected]

Get connection ID

Returns:
link identifier

Definition at line 781 of file oxdb.php.

oxDb._getDbInstance ( iInstType = false  )  [protected]

Returns database instance object for given type

Parameters:
int $iInstType instance type
Returns:
ADONewConnection

Definition at line 374 of file oxdb.php.

oxDb._getModules (  )  [protected]

Returns adodb modules string

Returns:
string

Definition at line 215 of file oxdb.php.

oxDb._notifyConnectionErrors ( oDb  )  [protected]

Notifying shop owner about connection problems

Parameters:
ADOConnection $oDb database connection instance
Returns:
null

Definition at line 300 of file oxdb.php.

oxDb._onConnectionError ( oDb  )  [protected]

In case of connection error - redirects to setup or send notification message for shop owner

Parameters:
ADOConnection $oDb database connection instance
Returns:
null

Definition at line 341 of file oxdb.php.

oxDb._regexp2ValidateDateInput (  )  [protected]

regular expressions to validate date input

Deprecated:
from 2012-11-21, not used here anymore. All date formatting moved to oxutilsdate
Returns:
null

Definition at line 633 of file oxdb.php.

oxDb._regexp2ValidateTimeInput (  )  [protected]

regular expressions to validate time input

Deprecated:
from 2012-11-21, not used here anymore. All date formatting moved to oxutilsdate
Returns:
null

Definition at line 644 of file oxdb.php.

oxDb._sendMail ( sEmail,
sSubject,
sBody 
) [protected]

Returns $oMailer instance

Parameters:
string $sEmail email address
string $sSubject subject
string $sBody email body
Returns:
phpmailer

Definition at line 280 of file oxdb.php.

oxDb._setDate ( oObject,
sDateFormat,
aDFields,
aDateMatches 
) [protected]

sets date

Parameters:
object $oObject date field object
string $sDateFormat date format
array $aDFields days
array $aDateMatches new date as array (month, year)
Deprecated:
from 2012-11-21, not used here anymore. All date formatting moved to oxutilsdate
Returns:
null

Definition at line 725 of file oxdb.php.

oxDb._setDefaultDateTimeValue ( oObject,
sLocalDateFormat,
sLocalTimeFormat,
blOnlyDate 
) [protected]

Sets default date time value

Parameters:
object $oObject date field object
string $sLocalDateFormat input format
string $sLocalTimeFormat local format
bool $blOnlyDate marker to format only date field (no time)
Deprecated:
from 2012-11-21, not used here anymore. All date formatting moved to oxUtilsDate
Returns:
null

Definition at line 694 of file oxdb.php.

oxDb._setDefaultFormatedValue ( oObject,
sDate,
sLocalDateFormat,
sLocalTimeFormat,
blOnlyDate 
) [protected]

sets default formatted value

Parameters:
object $oObject date field object
string $sDate prefered date
string $sLocalDateFormat input format
string $sLocalTimeFormat local format
bool $blOnlyDate marker to format only date field (no time)
Deprecated:
from 2012-11-21, not used here anymore. All date formatting moved to oxutilsdate
Returns:
null

Definition at line 574 of file oxdb.php.

oxDb._setUp ( oDb  )  [protected]

Setting up connection parameters - sql mode, encoding, logging etc

Parameters:
ADOConnection $oDb database connection instance
Returns:
null

Definition at line 242 of file oxdb.php.

oxDb.convertDBDate ( oObject,
blToTimeStamp = false 
)

Bidirectional converter for date field

Parameters:
object $oObject oxField type object that keeps db field info
bool $blToTimeStamp if true - converts value to database compatible timestamp value
Deprecated:
from 2012-11-21, use oxRegistry.get('oxUtilsDate')->convertDBDate()
Returns:
string

Definition at line 543 of file oxdb.php.

oxDb.convertDBDateTime ( oObject,
blToTimeStamp = false,
blOnlyDate = false 
)

Bidirectional converter for date/datetime field

Parameters:
object $oObject data field object
bool $blToTimeStamp set TRUE to format MySQL compatible value
bool $blOnlyDate set TRUE to format "date" type field
Deprecated:
from 2012-11-21, use oxRegistry.get('oxUtilsDate')->convertDBDateTime()
Returns:
string

Definition at line 513 of file oxdb.php.

oxDb.convertDBTimestamp ( oObject,
blToTimeStamp = false 
)

Bidirectional converter for timestamp field

Parameters:
object $oObject oxField type object that keeps db field info
bool $blToTimeStamp if true - converts value to database compatible timestamp value
Deprecated:
from 2012-11-21, use oxRegistry.get('oxUtilsDate')->convertDBTimestamp()
Returns:
string

Definition at line 528 of file oxdb.php.

oxDb.escapeString ( sString  ) 

Escape string for using in mysql statements

Parameters:
string $sString string which will be escaped
Returns:
string

Definition at line 793 of file oxdb.php.

static oxDb.getDb ( iFetchMode = oxDb::FETCH_MODE_NUM  )  [static]

Returns database object

Parameters:
int $iFetchMode - fetch mode default numeric - 0
Exceptions:
oxConnectionException error while initiating connection to DB
Returns:
oxLegacyDb

Definition at line 403 of file oxdb.php.

static oxDb.getInstance (  )  [static]

Returns Singleton instance

Returns:
oxdb

Definition at line 181 of file oxdb.php.

oxDb.getTableDescription ( sTableName  ) 

Extracts and returns table metadata from DB.

Parameters:
string $sTableName Name of table to invest.
Returns:
array

Definition at line 488 of file oxdb.php.

oxDb.isAdmin (  )  [protected]

Cal function is admin from oxFunction. Need to mock in tests.

Returns:
bool

Definition at line 205 of file oxdb.php.

oxDb.isValidFieldName ( sField  ) 

Checks if given string is valid database field name. It must contain from alphanumeric plus dot and underscore symbols

Parameters:
string $sField field name
Returns:
bool

Definition at line 556 of file oxdb.php.

oxDb.quoteArray ( aStrArray  ) 

Quotes an array.

Parameters:
array $aStrArray array of strings to quote
Returns:
array

Definition at line 461 of file oxdb.php.

oxDb.resetTblDescCache (  ) 

Call to reset table description cache

Returns:
null

Definition at line 476 of file oxdb.php.

static oxDb.setConfig ( oConfig  )  [static]

Sets configs object with method getVar() and properties needed for successful connection.

Parameters:
object $oConfig configs.
Returns:
void

Definition at line 142 of file oxdb.php.

oxDb.updateViews ( aTables = null  ) 

Updates shop views

Parameters:
array $aTables If you need to update specific tables, just pass its names as array [optional]
Deprecated:
since v5.0.1 (2012-11-05); Use public oxDbMetaDataHandler.updateViews().
Returns:
bool

Definition at line 813 of file oxdb.php.


Member Data Documentation

oxDb.$_aSlaveHosts [static, private]

Definition at line 109 of file oxdb.php.

oxDb.$_aTblDescCache = array() [static, protected]

Definition at line 49 of file oxdb.php.

oxDb.$_blLogChangesInAdmin = false [static, private]

Definition at line 91 of file oxdb.php.

oxDb.$_dbHost = '' [static, private]

Definition at line 79 of file oxdb.php.

oxDb.$_dbName = '' [static, private]

Definition at line 73 of file oxdb.php.

oxDb.$_dbPwd = '' [static, private]

Definition at line 67 of file oxdb.php.

oxDb.$_dbType = '' [static, private]

Definition at line 55 of file oxdb.php.

oxDb.$_dbUser = '' [static, private]

Definition at line 61 of file oxdb.php.

oxDb.$_iDebug = 0 [static, private]

Definition at line 85 of file oxdb.php.

oxDb.$_iMasterSlaveBalance [static, private]

Definition at line 121 of file oxdb.php.

oxDb.$_instance = null [static, protected]

Definition at line 35 of file oxdb.php.

oxDb.$_iUtfMode = 0 [static, private]

Definition at line 97 of file oxdb.php.

oxDb.$_oDB = null [static, protected]

Definition at line 42 of file oxdb.php.

oxDb.$_sAdminEmail [static, private]

Definition at line 115 of file oxdb.php.

oxDb.$_sDefaultDatabaseConnection = null [static, private]

Definition at line 103 of file oxdb.php.

oxDb.$_sLocalDateFormat [static, private]

Definition at line 133 of file oxdb.php.

oxDb.$_sLocalTimeFormat [static, private]

Definition at line 127 of file oxdb.php.

oxDb.$configSet = false [static]

Definition at line 28 of file oxdb.php.

const oxDb.FETCH_MODE_ASSOC = ADODB_FETCH_ASSOC

Definition at line 22 of file oxdb.php.

const oxDb.FETCH_MODE_NUM = ADODB_FETCH_NUM

Definition at line 16 of file oxdb.php.


The documentation for this class was generated from the following file: