UNA
Loading...
Searching...
No Matches
BxDolStorageQuery Class Reference
Inheritance diagram for BxDolStorageQuery:
BxDolDb BxDolFactory iBxDolSingleton

Public Member Functions

 __construct ($aObject)
 changeStorageEngine ($sEngine)
 getMimeTypeByExt ($sExt)
 getIconByExt ($sExt)
 getIconFontByExt ($sExt)
 clearAllMimeTypes ()
 addMimeType ($sMimeType, $sExt, $sIcon='', $sIconFont='')
 getStorageObjectQuota ()
 updateStorageObjectQuota ($iSize, $iNumber=1)
 getUserQuota ($iProfileId)
 updateUserQuota ($iProfileId, $iSize, $iNumber=1)
 addFile ($iProfileId, $sLocalId, $sPath, $aFileName, $sMimeType, $sExt, $iSize, $iTime, $isPrivate, $aAdditionalFields=array())
 modifyFilePrivate ($iFileId, $isPrivate)
 modifyCustomField ($iFileId, $sField, $sValue, $isUpdateModifiedField=true)
 deleteFile ($iFileId)
 getFileByFileName ($sValue)
 getFileById ($sValue)
 getFileByRemoteId ($sValue)
 isTokenValid ($iFileId, $sToken)
 genToken ($iFileId)
 insertGhosts ($mixedFileIds, $iProfileId, $iContentId=0)
 updateGhostOrder ($iProfileId, $iContentId, $iFileId, $iOrder)
 updateGhostsContentId ($mixedFileIds, $iProfileId, $iContentId, $aProfiles=array(), $isAdmin=false)
 deleteGhosts ($mixedFileIds, $iProfileId, $iContentId=false)
 getGhosts ($mixedProfileId, $iContentId=false, $isAdmin=false)
 getGhost ($iFileId)
 getFiles ($mixedProfileId, $isGhostsOnly=false, $iContentId=false, $isAdmin=false)
 getFilesAll ($iStart, $iPerPage)
 prune ()
 queueFilesForDeletion ($a)
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)

Static Public Member Functions

static getStorageObject ($sObject)
static getStorageObjects ()
static getAllGhosts ($aParams)
static getQueuedFilesForDeletion ($iLimit=1000)
static isQueuedFilesForDeletion ($sPrefix)
Static Public Member Functions inherited from BxDolDb
static getInstance ()
static getInstanceWithConf ($aDbConf, &$sError)
static getLink ()

Protected Member Functions

 _getFileBy ($sField, $sValue)
Protected Member Functions inherited from BxDolDb
 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

 $_aObject
 $_sTableFiles
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 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

Database queries for File storage class.

See also
BxDolStorage

Constructor & Destructor Documentation

◆ __construct()

BxDolStorageQuery::__construct ( $aDbConf)

set database parameters and connect to it

Reimplemented from BxDolDb.


The documentation for this class was generated from the following file:
  • inc/classes/BxDolStorageQuery.php