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)
 isValidFieldName ($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:
  • inc/classes/BxDolObjectQuery.php