UNA
Loading...
Searching...
No Matches
BxDolObjectQuery Class Reference
Inheritance diagram for BxDolObjectQuery:
BxDolDb BxDolFactory iBxDolSingleton BxDolFavoriteQuery BxDolFeatureQuery BxDolReportQuery BxDolScoreQuery BxDolViewQuery BxDolVoteQuery BxDolVoteLikesQuery BxDolVoteReactionsQuery BxDolVoteStarsQuery

Public Member Functions

 __construct (&$oModule)
 
 getSqlParts ($sMainTable, $sMainField)
 
 getSqlPartsTrack ($sMainTable, $sMainField, $iAuthorId=0)
 
 getSqlPartsTrackAuthor ($sMainTable, $sMainField, $iObjectId=0)
 
 isPerformed ($iObjectId, $iAuthorId)
 
 getPerformedBy ($iObjectId, $iStart=0, $iPerPage=0)
 
 getData ($iObjectId)
 
 getTrack ($iObjectId, $iAuthorId)
 
 getTrackBy ($aParams=array())
 
 deleteObjectEntries ($iObjectId)
 
 deleteAuthorEntries ($iAuthorId)
 
 getObjectInfo ($iId)
 
 getObjectAuthorId ($iId)
 
 getObjectCount ($iId)
 
 updateMainTableValue ($iObjectId, $iValue)
 
 updateTriggerTable ($iObjectId)
 
 pruningByObject ($iObjectId)
 
 pruningByAuthor ($iAuthorId)
 
 pruningByDate ($iDate)
 
 updateTriggerTableValue ($iObjectId, $iValue)
 
- Public Member Functions inherited from BxDolDb
 __clone ()
 
 setReadOnlyMode ($b)
 
 connect ()
 
 disconnect ()
 
 ping ()
 
 pdoExec ($sQuery)
 
 pdoQuery ($sQuery)
 
 pdoExceptionHandler ($oException)
 
 getOption ($sName)
 
 getOne ($oStatement, $aBindings=array(), $iIndex=0)
 
 getRow ($oStatement, $aBindings=array(), $iFetchType=PDO::FETCH_ASSOC)
 
 getColumn ($oStatement, $aBindings=array(), $iFetchColumnNumber=0)
 
 getFirstRow ($oStatement, $aBindings=array(), $iFetchType=PDO::FETCH_ASSOC)
 
 getNextRow ($iFetchType=PDO::FETCH_ASSOC)
 
 getAll ($oStatement, $aBindings=array(), $iFetchType=PDO::FETCH_ASSOC)
 
 fillArray ($oStatement, $aBindings=array(), $iFetchType=PDO::FETCH_ASSOC)
 
 getAllWithKey ($oStatement, $sFieldKey, $aBindings=array(), $iFetchType=PDO::FETCH_ASSOC)
 
 getPairs ($oStatement, $sFieldKey, $sFieldValue, $aBindings=array(), $iFetchType=PDO::FETCH_ASSOC)
 
 getNumRows ($oStatement=null)
 
 getAffectedRows ($oStatement=null)
 
 lastId ()
 
 query ($oStatement, $aBindings=array(), $bVerbose=null)
 
 res ($oStatement, $aBindings=array(), $bVerbose=null)
 
 getServerInfo ()
 
 getVersion ()
 
 listTables ()
 
 getFields ($sTable)
 
 fetchField ($oStatement, $iField, $aBindings=array())
 
 isTableExists ($sTable)
 
 isFieldExists ($sTable, $sFieldName)
 
 isIndexExists ($sTable, $sIndexName)
 
 error ($aError)
 
 cacheParams ($bForceCacheInvalidate=false, $bForceCacheInvalidateMixed=false)
 
 cacheParamsClear ($sCacheName='')
 
 isParam ($sKey, $bFromCache=true)
 
 addParam ($sName, $sValue, $iKateg, $sDesc, $sType)
 
 getParam ($sKey, $bFromCache=true)
 
 setParam ($sKey, $mixedValue, $iMixId=0)
 
 getParamsMix ($iId)
 
 getParamsMixActive ($sType)
 
 getParamsMixes ($sType, $mixedPublished=false)
 
 setTimezone ($sTimezone)
 
 getEncoding ()
 
 setErrorChecking ($b)
 
 getDbCacheObject ()
 
 genDbCacheKey ($sName)
 
 getCache ($sName, $sFunc)
 
 setCache ($sName, $mData)
 
 fromCache ($sName, $sFunc)
 
 cleanCache ($sName)
 
fromMemory ($sName, $sFunc)
 
 cleanMemory ($sName)
 
 cleanMemoryAll ()
 
 escape ($s)
 
 implode_escape ($mixed)
 
 unescape ($mixed)
 
 prepare ($sQuery)
 
 prepareAsString ($sQuery)
 
 arrayToSQL ($a, $sDiv=',', $sOperator='=', $bWildcardSpaceChars=false)
 
 executeSQL ($sPath, $aReplace=array(), $isBreakOnError=true)
 

Protected Member Functions

 _updateTriggerTable ($iObjectId, $aEntry)
 
 _deleteAuthorEntriesTableMain ($aTrack)
 
 _deleteAuthorEntriesTableTrigger ($aTrack)
 
- Protected Member Functions inherited from BxDolDb
 __construct ($aDbConf=false)
 
 balancer ()
 
 isParamInCache ($sKey)
 
 log ($s)
 
 executeStatement ($oStatement, $aBindings=array(), $bVerbose=null, &$iErrorCode=null)
 
 executeStatementException ($oStatement, $aBindings=array(), $bVerbose=null)
 
 executeStatementSilent ($oStatement, $aBindings=array(), $bVerbose=null)
 
 errorOutput ($aError)
 

Protected Attributes

 $_oModule
 
 $_sTable
 
 $_sTableTrack
 
 $_sTableTrackFieldObject
 
 $_sTableTrackFieldAuthor
 
 $_sTableTrackFieldDate
 
 $_sTriggerTable
 
 $_sTriggerFieldId
 
 $_sTriggerFieldAuthor
 
 $_sTriggerFieldCount
 
 $_sMethodGetEntry
 
- Protected Attributes inherited from BxDolDb
 $_bPdoPersistent
 
 $_iPdoFetchType
 
 $_iPdoErrorMode
 
 $_bErrorChecking
 
 $_aError
 
 $_sHost
 
 $_sPort
 
 $_sSocket
 
 $_sDbname
 
 $_sUser
 
 $_sPassword
 
 $_sCharset
 
 $_sStorageEngine
 
 $_oStatement = null
 
 $_oDbCacheObject = null
 

Additional Inherited Members

- Static Public Member Functions inherited from BxDolDb
static getInstance ()
 
static getInstanceWithConf ($aDbConf, &$sError)
 
static getLink ()
 
- Static Protected Attributes inherited from BxDolDb
static $_rLink
 
static $_aDbCacheData
 
static $_aParams
 
static $_sParamsCacheName = 'sys_options'
 
static $_sParamsCacheNameMixed = 'sys_options_mixed_'
 
static $_sParamsCacheNameMix = 'sys_options_mix_'
 
static $_sErrorKey = 'bx_db_error'
 
static $_aErrors
 
static $_bReadOnlyMode = true
 
static $_bMultuServersMode = false
 

Detailed Description

See also
BxDolObject

Member Function Documentation

◆ _updateTriggerTable()

BxDolObjectQuery::_updateTriggerTable ( $iObjectId,
$aEntry )
protected

Reimplemented in BxDolVoteReactionsQuery.

◆ deleteAuthorEntries()

BxDolObjectQuery::deleteAuthorEntries ( $iAuthorId)

Note. It's essential that Trigger Table is updated at the end, because it may require updated data from main ($this->_sTable) table.

◆ getSqlParts()

BxDolObjectQuery::getSqlParts ( $sMainTable,
$sMainField )

Get SQL parts for main table.

Reimplemented in BxDolReportQuery, BxDolScoreQuery, BxDolVoteQuery, and BxDolVoteReactionsQuery.

◆ getSqlPartsTrack()

BxDolObjectQuery::getSqlPartsTrack ( $sMainTable,
$sMainField,
$iAuthorId = 0 )

Get SQL parts for track table.

◆ updateTriggerTableValue()

BxDolObjectQuery::updateTriggerTableValue ( $iObjectId,
$iValue )

Is used instead of 'updateTriggerTable' when trigger table contains only one field related to this object (View, Vote, Comment, etc). For example, it's used in Favourite (simple mode w\o lists) and Feature objects.

Reimplemented in BxDolFeatureQuery, and BxDolVoteQuery.


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