OXID eShop CE  4.8.10
 All Classes Files Functions Variables Pages
oxDbMetaDataHandler Class Reference
+ Inheritance diagram for oxDbMetaDataHandler:
+ Collaboration diagram for oxDbMetaDataHandler:

Public Member Functions

 getFields ($sTableName)
 tableExists ($sTableName)
 fieldExists ($sFieldName, $sTableName)
 getAllTables ()
 getAllMultiTables ($sTable)
 getAddFieldSql ($sTable, $sField, $sNewField, $sPrevField, $sTableSet=null)
 getAddFieldIndexSql ($sTable, $sField, $sNewField, $sTableSet=null)
 getCurrentMaxLangId ()
 getNextLangId ()
 getMultilangFields ($sTable)
 getSinglelangFields ($sTable, $iLang)
 addNewMultilangField ($sTable)
 resetMultilangFields ($iLangId, $sTableName)
 addNewLangToDb ()
 resetLanguage ($iLangId)
 executeSql ($aSql)
 updateViews ($aTables=null)
- Public Member Functions inherited from oxSuperCfg
 __call ($sMethod, $aArgs)
 __construct ()
 getConfig ()
 setConfig ($oConfig)
 getSession ()
 setSession ($oSession)
 getUser ()
 setUser ($oUser)
 isAdmin ()
 setAdminMode ($blAdmin)

Protected Member Functions

 _getCreateTableSetSql ($sTable, $iLang)

Protected Attributes

 $_aDbTablesFields = null
 $_aTables = null
 $_iCurrentMaxLangId
 $_aSkipTablesOnReset = array( "oxcountry" )

Additional Inherited Members

- Static Protected Attributes inherited from oxSuperCfg
static $_oConfig = null
static $_oSession = null
static $_oRights = null
static $_oActUser = null
static $_blIsAdmin = null

Detailed Description

Class for handling database related operations

Definition at line 7 of file oxdbmetadatahandler.php.

Member Function Documentation

oxDbMetaDataHandler::_getCreateTableSetSql (   $sTable,
  $iLang 
)
protected

Get sql for new multilanguage table set creation

Parameters
string$sTablecore table name
string$iLanglanguage id
Returns
string

Definition at line 140 of file oxdbmetadatahandler.php.

oxDbMetaDataHandler::addNewLangToDb ( )

Add new language to database. Scans all tables and adds new multilanguage fields

Returns
null

Definition at line 410 of file oxdbmetadatahandler.php.

oxDbMetaDataHandler::addNewMultilangField (   $sTable)

Add new multilanguages fields to table. Dublicates all multilanguage fields and fields indexes with next available language ID

Parameters
string$sTabletable name
Returns
null

Definition at line 332 of file oxdbmetadatahandler.php.

oxDbMetaDataHandler::executeSql (   $aSql)

Executes arrary of sql strings

Parameters
array$aSqlSQL query array
Returns
null

Definition at line 461 of file oxdbmetadatahandler.php.

oxDbMetaDataHandler::fieldExists (   $sFieldName,
  $sTableName 
)

Check if field exists in table

Parameters
string$sFieldNamefield name
string$sTableNametable name
Returns
bool

Definition at line 75 of file oxdbmetadatahandler.php.

oxDbMetaDataHandler::getAddFieldIndexSql (   $sTable,
  $sField,
  $sNewField,
  $sTableSet = null 
)

Get sql for new multilang field index creation

Parameters
string$sTablecore table name
string$sFieldfield name
string$sNewFieldnew field name
string$sTableSettable to change (if not setted take core table)
Returns
string

Definition at line 199 of file oxdbmetadatahandler.php.

oxDbMetaDataHandler::getAddFieldSql (   $sTable,
  $sField,
  $sNewField,
  $sPrevField,
  $sTableSet = null 
)

Get sql for new multilang field creation

Parameters
string$sTablecore table name
string$sFieldfield name
string$sNewFieldnew field name
string$sPrevFieldprevious field in table
string$sTableSettable to change (if not setted take core table)
Returns
string

Definition at line 163 of file oxdbmetadatahandler.php.

oxDbMetaDataHandler::getAllMultiTables (   $sTable)

return all DB tables for the language sets

Parameters
string$sTabletable name to check
Returns
array

Definition at line 119 of file oxdbmetadatahandler.php.

oxDbMetaDataHandler::getAllTables ( )

Get all tables names from db. Views tables are not incuded in this list.

Returns
array

Definition at line 97 of file oxdbmetadatahandler.php.

oxDbMetaDataHandler::getCurrentMaxLangId ( )

Get max language ID used in shop. For checking is used table "oxarticle" field "oxtitle"

Returns
int

Definition at line 248 of file oxdbmetadatahandler.php.

oxDbMetaDataHandler::getFields (   $sTableName)

Get table fields

Parameters
string$sTableNametable name
Returns
array

Definition at line 41 of file oxdbmetadatahandler.php.

oxDbMetaDataHandler::getMultilangFields (   $sTable)

Get table multilanguge fields

Parameters
string$sTabletable name
Returns
array

Definition at line 284 of file oxdbmetadatahandler.php.

oxDbMetaDataHandler::getNextLangId ( )

Get next available language ID

Returns
int

Definition at line 272 of file oxdbmetadatahandler.php.

oxDbMetaDataHandler::getSinglelangFields (   $sTable,
  $iLang 
)

Get single language fields

Parameters
string$sTabletable name
int$iLanglanguane id
Returns
array

Definition at line 306 of file oxdbmetadatahandler.php.

oxDbMetaDataHandler::resetLanguage (   $iLangId)

Reseting all multilanguage fields with specific language id to default value in all tables. Only if language ID > 0.

Parameters
int$iLangIdLanguage id
Returns
null

Definition at line 433 of file oxdbmetadatahandler.php.

oxDbMetaDataHandler::resetMultilangFields (   $iLangId,
  $sTableName 
)

Reseting all multilanguage fields with specific language id to default value in selected table

Parameters
int$iLangIdLanguage id
string$sTableNameTable name
Returns
null

Definition at line 377 of file oxdbmetadatahandler.php.

oxDbMetaDataHandler::tableExists (   $sTableName)

Check if table exists

Parameters
string$sTableNametable name
Returns
bool

Definition at line 60 of file oxdbmetadatahandler.php.

oxDbMetaDataHandler::updateViews (   $aTables = null)

Updates all views

Parameters
array$aTablesarray of DB table name that can store different data per shop like oxArticle
Returns
bool

Definition at line 482 of file oxdbmetadatahandler.php.

Member Data Documentation

oxDbMetaDataHandler::$_aDbTablesFields = null
protected

Definition at line 13 of file oxdbmetadatahandler.php.

oxDbMetaDataHandler::$_aSkipTablesOnReset = array( "oxcountry" )
protected

Definition at line 32 of file oxdbmetadatahandler.php.

oxDbMetaDataHandler::$_aTables = null
protected

Definition at line 20 of file oxdbmetadatahandler.php.

oxDbMetaDataHandler::$_iCurrentMaxLangId
protected

Definition at line 26 of file oxdbmetadatahandler.php.


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