Inheritance diagram for ADODB_DataDict:

Public Member Functions
	GetCommentSQL ($table, $col)

	SetCommentSQL ($table, $col, $cmt)

	MetaTables ()

	MetaColumns ($tab, $upper=true, $schema=false)

	MetaPrimaryKeys ($tab, $owner=false, $intkey=false)

	MetaIndexes ($table, $primary=false, $owner=false)

	MetaType ($t, $len=-1, $fieldobj=false)

	NameQuote ($name=NULL, $allowBrackets=false)

	TableName ($name)

	ExecuteSQLArray ($sql, $continueOnError=true)

	ActualType ($meta)

	CreateDatabase ($dbname, $options=false)

	CreateIndexSQL ($idxname, $tabname, $flds, $idxoptions=false)

	DropIndexSQL ($idxname, $tabname=NULL)

	SetSchema ($schema)

	AddColumnSQL ($tabname, $flds)

	AlterColumnSQL ($tabname, $flds, $tableflds='', $tableoptions='')

	RenameColumnSQL ($tabname, $oldcolumn, $newcolumn, $flds='')

	DropColumnSQL ($tabname, $flds, $tableflds='', $tableoptions='')

	DropTableSQL ($tabname)

	RenameTableSQL ($tabname, $newname)

	CreateTableSQL ($tabname, $flds, $tableoptions=array())

	_GenFields ($flds, $widespacing=false)

	_GetSize ($ftype, $ty, $fsize, $fprec)

	_CreateSuffix ($fname, &$ftype, $fnotnull, $fdefault, $fautoinc, $fconstraint, $funsigned)

	_IndexSQL ($idxname, $tabname, $flds, $idxoptions)

	_DropAutoIncrement ($tabname)

	_TableSQL ($tabname, $lines, $pkey, $tableoptions)

	_Triggers ($tabname, $taboptions)

	_Options ($opts)

	_getSizePrec ($size)

	ChangeTableSQL ($tablename, $flds, $tableoptions=false, $dropOldFlds=false)

Public Attributes
	$connection

	$debug = false

	$dropTable = 'DROP TABLE %s'

	$renameTable = 'RENAME TABLE %s TO %s'

	$dropIndex = 'DROP INDEX %s'

	$addCol = ' ADD'

	$alterCol = ' ALTER COLUMN'

	$dropCol = ' DROP COLUMN'

	$renameColumn = 'ALTER TABLE %s RENAME COLUMN %s TO %s'

	$nameRegex = '\w'

	$nameRegexBrackets = 'a-zA-Z0-9_'

	$schema = false

	$serverInfo = array()

	$autoIncrement = false

	$dataProvider

	$invalidResizeTypes4 = array('CLOB','BLOB','TEXT','DATE','TIME')

	$blobNotNull = false

	$blobDefaults = false

	$blobSize = 100

Detailed Description

Definition at line 166 of file adodb-datadict.inc.php.

Member Function Documentation

◆ _CreateSuffix()

ADODB_DataDict::_CreateSuffix	(		$fname,
		&	$ftype,
			$fnotnull,
			$fdefault,
			$fautoinc,
			$fconstraint,
			$funsigned
	)

Definition at line 823 of file adodb-datadict.inc.php.

Referenced by _GenFields().

◆ _DropAutoIncrement()

ADODB_DataDict::_DropAutoIncrement ( $tabname )

Definition at line 861 of file adodb-datadict.inc.php.

Referenced by _TableSQL().

◆ _GenFields()

ADODB_DataDict::_GenFields	(	$flds,
		$widespacing = `false`
	)

◆ _GetSize()

ADODB_DataDict::_GetSize	(	$ftype,
		$ty,
		$fsize,
		$fprec
	)

GENERATE THE SIZE PART OF THE DATATYPE $ftype is the actual type $ty is the type defined originally in the DDL

Definition at line 811 of file adodb-datadict.inc.php.

Referenced by _GenFields().

◆ _getSizePrec()

ADODB_DataDict::_getSizePrec ( $size )

Definition at line 923 of file adodb-datadict.inc.php.

Referenced by ChangeTableSQL().

◆ _IndexSQL()

ADODB_DataDict::_IndexSQL	(	$idxname,
		$tabname,
		$flds,
		$idxoptions
	)

Definition at line 832 of file adodb-datadict.inc.php.

References $sql.

Referenced by CreateIndexSQL().

◆ _Options()

ADODB_DataDict::_Options ( $opts )

Sanitize options, so that array elements with no keys are promoted to keys

Definition at line 911 of file adodb-datadict.inc.php.

Referenced by ADODB2_firebird\CreateDatabase(), ADODB2_oci8\CreateDatabase(), CreateDatabase(), CreateIndexSQL(), and CreateTableSQL().

◆ _TableSQL()

ADODB_DataDict::_TableSQL	(	$tabname,
		$lines,
		$pkey,
		$tableoptions
	)

Definition at line 866 of file adodb-datadict.inc.php.

References $sql, and _DropAutoIncrement().

Referenced by CreateTableSQL().

◆ _Triggers()

ADODB_DataDict::_Triggers	(	$tabname,
		$taboptions
	)

GENERATE TRIGGERS IF NEEDED used when table has auto-incrementing field that is emulated using triggers

Definition at line 903 of file adodb-datadict.inc.php.

Referenced by CreateTableSQL().

◆ ActualType()

ADODB_DataDict::ActualType ( $meta )

Returns the actual type given a character code.

C: varchar X: CLOB (character large object) or largest varchar size if CLOB is not supported C2: Multibyte varchar X2: Multibyte CLOB

B: BLOB (binary large object)

D: Date T: Date-time L: Integer field suitable for storing booleans (0 or 1) I: Integer F: Floating point number N: Numeric or decimal number

Definition at line 411 of file adodb-datadict.inc.php.

Referenced by _GenFields().

◆ AddColumnSQL()

ADODB_DataDict::AddColumnSQL	(	$tabname,
		$flds
	)

Definition at line 456 of file adodb-datadict.inc.php.

References $sql, _GenFields(), and TableName().

◆ AlterColumnSQL()

ADODB_DataDict::AlterColumnSQL	(	$tabname,
		$flds,
		$tableflds = `''`,
		$tableoptions = `''`
	)

Change the definition of one column

As some DBM's can't do that on there own, you need to supply the complete defintion of the new table, to allow, recreating the table and copying the content over to the new table

Parameters

string	$tabname	table-name
string	$flds	column-name and type for the changed column
string	$tableflds,=''	complete defintion of the new table, eg. for postgres, default ''
	array/string	$tableoptions='' options for the new table see CreateTableSQL, default ''

Returns: array with SQL strings

Definition at line 487 of file adodb-datadict.inc.php.

References $sql, _GenFields(), and TableName().

◆ ChangeTableSQL()

ADODB_DataDict::ChangeTableSQL	(	$tablename,
		$flds,
		$tableoptions = `false`,
		$dropOldFlds = `false`
	)

"Florian Buzin [ easywe ]" <florian.buzin::easywe.de>

This function changes/adds new fields to your table. You don't have to know if the col is new or not. It will check on its own.

Definition at line 943 of file adodb-datadict.inc.php.

References $sql, _GenFields(), _getSizePrec(), CreateTableSQL(), debug(), Lens_ParseArgs(), MetaColumns(), MetaType(), and TableName().

◆ CreateDatabase()

ADODB_DataDict::CreateDatabase	(	$dbname,
		$options = `false`
	)

Definition at line 416 of file adodb-datadict.inc.php.

References $sql, _Options(), and NameQuote().

◆ CreateIndexSQL()

ADODB_DataDict::CreateIndexSQL	(	$idxname,
		$tabname,
		$flds,
		$idxoptions = `false`
	)

Definition at line 432 of file adodb-datadict.inc.php.

References _IndexSQL(), _Options(), NameQuote(), and TableName().

Referenced by ADODB2_postgres\_recreate_copy_table().

◆ CreateTableSQL()

ADODB_DataDict::CreateTableSQL	(	$tabname,
		$flds,
		$tableoptions = `array()`
	)

Generate the SQL to create table. Returns an array of sql strings.

Definition at line 567 of file adodb-datadict.inc.php.

References $sql, _GenFields(), _Options(), _TableSQL(), _Triggers(), and TableName().

Referenced by ADODB2_postgres\_recreate_copy_table(), ADODB2_db2\ChangeTableSQL(), and ChangeTableSQL().

◆ DropColumnSQL()

ADODB_DataDict::DropColumnSQL	(	$tabname,
		$flds,
		$tableflds = `''`,
		$tableoptions = `''`
	)

Drop one column

Some DBM's can't do that on there own, you need to supply the complete defintion of the new table, to allow, recreating the table and copying the content over to the new table

Parameters

string	$tabname	table-name
string	$flds	column-name and type for the changed column
string	$tableflds,=''	complete defintion of the new table, eg. for postgres, default ''
	array/string	$tableoptions='' options for the new table see CreateTableSQL, default ''

Returns: array with SQL strings

Definition at line 542 of file adodb-datadict.inc.php.

References $sql, NameQuote(), and TableName().

Referenced by ADODB2_postgres\DropColumnSQL().

◆ DropIndexSQL()

ADODB_DataDict::DropIndexSQL	(	$idxname,
		$tabname = `NULL`
	)

Definition at line 446 of file adodb-datadict.inc.php.

References NameQuote(), and TableName().

◆ DropTableSQL()

ADODB_DataDict::DropTableSQL ( $tabname )

Definition at line 554 of file adodb-datadict.inc.php.

References TableName().

Referenced by ADODB2_postgres\DropTableSQL().

◆ ExecuteSQLArray()

ADODB_DataDict::ExecuteSQLArray	(	$sql,
		$continueOnError = `true`
	)

Definition at line 374 of file adodb-datadict.inc.php.

References $conn, $connection, $sql, and debug().

◆ GetCommentSQL()

ADODB_DataDict::GetCommentSQL	(	$table,
		$col
	)

any varchar/char field this size or greater is treated as a blob in other words, we use a text area for editting.

Definition at line 188 of file adodb-datadict.inc.php.

◆ MetaColumns()

ADODB_DataDict::MetaColumns	(	$tab,
		$upper = `true`,
		$schema = `false`
	)

Definition at line 204 of file adodb-datadict.inc.php.

References TableName().

Referenced by ADODB2_postgres\_recreate_copy_table(), ADODB2_postgres\AlterColumnSQL(), ADODB2_db2\ChangeTableSQL(), and ChangeTableSQL().

◆ MetaIndexes()

ADODB_DataDict::MetaIndexes	(	$table,
		$primary = `false`,
		$owner = `false`
	)

Definition at line 216 of file adodb-datadict.inc.php.

References TableName().

Referenced by ADODB2_postgres\_recreate_copy_table().

◆ MetaPrimaryKeys()

ADODB_DataDict::MetaPrimaryKeys	(	$tab,
		$owner = `false`,
		$intkey = `false`
	)

Definition at line 210 of file adodb-datadict.inc.php.

References TableName().

◆ MetaTables()

ADODB_DataDict::MetaTables ( )

Definition at line 198 of file adodb-datadict.inc.php.

◆ MetaType()

ADODB_DataDict::MetaType	(	$t,
		$len = `-1`,
		$fieldobj = `false`
	)

Definition at line 222 of file adodb-datadict.inc.php.

Referenced by ChangeTableSQL().

◆ NameQuote()

ADODB_DataDict::NameQuote	(	$name = `NULL`,
		$allowBrackets = `false`
	)

Definition at line 336 of file adodb-datadict.inc.php.

Referenced by _GenFields(), CreateDatabase(), CreateIndexSQL(), ADODB2_sapdb\DropColumnSQL(), ADODB2_oci8\DropColumnSQL(), ADODB2_mssqlnative\DropColumnSQL(), DropColumnSQL(), DropIndexSQL(), RenameColumnSQL(), and TableName().

◆ RenameColumnSQL()

ADODB_DataDict::RenameColumnSQL	(	$tabname,
		$oldcolumn,
		$newcolumn,
		$flds = `''`
	)

Rename one column

Some DBM's can only do this together with changeing the type of the column (even if that stays the same, eg. mysql)

Parameters

string	$tabname	table-name
string	$oldcolumn	column-name to be renamed
string	$newcolumn	new column-name
string	$flds,=''	complete column-defintion-string like for AddColumnSQL, only used by mysql atm., default=''

Returns: array with SQL strings

Definition at line 518 of file adodb-datadict.inc.php.

References _GenFields(), NameQuote(), and TableName().

◆ RenameTableSQL()

ADODB_DataDict::RenameTableSQL	(	$tabname,
		$newname
	)

Definition at line 559 of file adodb-datadict.inc.php.

References TableName().

◆ SetCommentSQL()

ADODB_DataDict::SetCommentSQL	(	$table,
		$col,
		$cmt
	)

Definition at line 193 of file adodb-datadict.inc.php.

◆ SetSchema()

ADODB_DataDict::SetSchema ( $schema )

Definition at line 451 of file adodb-datadict.inc.php.

References $schema.

◆ TableName()

ADODB_DataDict::TableName ( $name )

Definition at line 365 of file adodb-datadict.inc.php.

References NameQuote().

Member Data Documentation

◆ $addCol

ADODB_DataDict::$addCol = ' ADD'

Definition at line 172 of file adodb-datadict.inc.php.

◆ $alterCol

ADODB_DataDict::$alterCol = ' ALTER COLUMN'

Definition at line 173 of file adodb-datadict.inc.php.

◆ $autoIncrement

ADODB_DataDict::$autoIncrement = false

Definition at line 180 of file adodb-datadict.inc.php.

◆ $blobDefaults

ADODB_DataDict::$blobDefaults = false

Definition at line 184 of file adodb-datadict.inc.php.

◆ $blobNotNull

ADODB_DataDict::$blobNotNull = false

Definition at line 183 of file adodb-datadict.inc.php.

◆ $blobSize

ADODB_DataDict::$blobSize = 100

Definition at line 185 of file adodb-datadict.inc.php.

◆ $connection

ADODB_DataDict::$connection

Definition at line 167 of file adodb-datadict.inc.php.

Referenced by ExecuteSQLArray().

◆ $dataProvider

ADODB_DataDict::$dataProvider

Definition at line 181 of file adodb-datadict.inc.php.

◆ $debug

ADODB_DataDict::$debug = false

Definition at line 168 of file adodb-datadict.inc.php.

◆ $dropCol

ADODB_DataDict::$dropCol = ' DROP COLUMN'

Definition at line 174 of file adodb-datadict.inc.php.

◆ $dropIndex

ADODB_DataDict::$dropIndex = 'DROP INDEX %s'

Definition at line 171 of file adodb-datadict.inc.php.

◆ $dropTable

ADODB_DataDict::$dropTable = 'DROP TABLE %s'

Definition at line 169 of file adodb-datadict.inc.php.

◆ $invalidResizeTypes4

ADODB_DataDict::$invalidResizeTypes4 = array('CLOB','BLOB','TEXT','DATE','TIME')

Definition at line 182 of file adodb-datadict.inc.php.

◆ $nameRegex

ADODB_DataDict::$nameRegex = '\w'

Definition at line 176 of file adodb-datadict.inc.php.

◆ $nameRegexBrackets

ADODB_DataDict::$nameRegexBrackets = 'a-zA-Z0-9_'

Definition at line 177 of file adodb-datadict.inc.php.

◆ $renameColumn

ADODB_DataDict::$renameColumn = 'ALTER TABLE %s RENAME COLUMN %s TO %s'

Definition at line 175 of file adodb-datadict.inc.php.

◆ $renameTable

ADODB_DataDict::$renameTable = 'RENAME TABLE %s TO %s'

Definition at line 170 of file adodb-datadict.inc.php.

◆ $schema

ADODB_DataDict::$schema = false

Definition at line 178 of file adodb-datadict.inc.php.

Referenced by ADODB2_postgres\RenameTableSQL(), and SetSchema().

◆ $serverInfo

ADODB_DataDict::$serverInfo = array()

Definition at line 179 of file adodb-datadict.inc.php.

Public Member Functions

Public Attributes

Detailed Description

Member Function Documentation

◆ _CreateSuffix()

◆ _DropAutoIncrement()

◆ _GenFields()

◆ _GetSize()

◆ _getSizePrec()

◆ _IndexSQL()

◆ _Options()

◆ _TableSQL()

◆ _Triggers()

◆ ActualType()

◆ AddColumnSQL()

◆ AlterColumnSQL()

◆ ChangeTableSQL()

◆ CreateDatabase()

◆ CreateIndexSQL()

◆ CreateTableSQL()

◆ DropColumnSQL()

◆ DropIndexSQL()

◆ DropTableSQL()

◆ ExecuteSQLArray()

◆ GetCommentSQL()

◆ MetaColumns()

◆ MetaIndexes()

◆ MetaPrimaryKeys()

◆ MetaTables()

◆ MetaType()

◆ NameQuote()

◆ RenameColumnSQL()

◆ RenameTableSQL()

◆ SetCommentSQL()

◆ SetSchema()

◆ TableName()

Member Data Documentation

◆ $addCol

◆ $alterCol

◆ $autoIncrement

◆ $blobDefaults

◆ $blobNotNull

◆ $blobSize

◆ $connection

◆ $dataProvider

◆ $debug

◆ $dropCol

◆ $dropIndex

◆ $dropTable

◆ $invalidResizeTypes4

◆ $nameRegex

◆ $nameRegexBrackets

◆ $renameColumn

◆ $renameTable

◆ $schema

◆ $serverInfo