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	$sTable	core table name
string	$iLang	language 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

$sTable

table name

Returns

null

Definition at line 332 of file oxdbmetadatahandler.php.

oxDbMetaDataHandler::executeSql

(

$aSql

)

Executes arrary of sql strings

Parameters

array

$aSql

SQL query array

Returns

null

Definition at line 461 of file oxdbmetadatahandler.php.

oxDbMetaDataHandler::fieldExists	(		$sFieldName,
			$sTableName
	)

Check if field exists in table

Parameters

string	$sFieldName	field name
string	$sTableName	table 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	$sTable	core table name
string	$sField	field name
string	$sNewField	new field name
string	$sTableSet	table 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	$sTable	core table name
string	$sField	field name
string	$sNewField	new field name
string	$sPrevField	previous field in table
string	$sTableSet	table 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

$sTable

table 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

$sTableName

table name

Returns

array

Definition at line 41 of file oxdbmetadatahandler.php.

oxDbMetaDataHandler::getMultilangFields

(

$sTable

)

Get table multilanguge fields

Parameters

string

$sTable

table 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	$sTable	table name
int	$iLang	languane 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

$iLangId

Language 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	$iLangId	Language id
string	$sTableName	Table name

Returns

null

Definition at line 377 of file oxdbmetadatahandler.php.

oxDbMetaDataHandler::tableExists

(

$sTableName

)

Check if table exists

Parameters

string

$sTableName

table name

Returns

bool

Definition at line 60 of file oxdbmetadatahandler.php.

oxDbMetaDataHandler::updateViews

(

$aTables = null

)

Updates all views

Parameters

array

$aTables

array 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:

• core/oxdbmetadatahandler.php