Documentation TYPO3 par Ameos

Disponible dans d'autres versions de TYPO3 -> 3.7.0  3.8.1  4.0.0  4.0.1  4.1.0   <- Available in other TYPO3 versions

ADODB_DataDict Class Reference

Inheritance diagram for ADODB_DataDict:[legend]List of all members.

Public Member Functions
	GetCommentSQL ($table, $col)
	in other words, we use a text area for editting.
	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=false)
	_GenFields ($flds, $widespacing=false)
	_GetSize ($ftype, $ty, $fsize, $fprec)
	_CreateSuffix ($fname, $ftype, $fnotnull, $fdefault, $fautoinc, $fconstraint)
	_IndexSQL ($idxname, $tabname, $flds, $idxoptions)
	_DropAutoIncrement ($tabname)
	_TableSQL ($tabname, $lines, $pkey, $tableoptions)
	_Triggers ($tabname, $taboptions)
	_Options ($opts)
	ChangeTableSQL ($tablename, $flds, $tableoptions=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')
	$blobSize = 100

---

Detailed Description

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

---

Member Function Documentation

ADODB_DataDict::GetCommentSQL	(	$	table,
		$	col
	)

in other words, we use a text area for editting.

any varchar/char field this size or greater is treated as a blob

Reimplemented in ADODB2_oci8.

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

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

Reimplemented in ADODB2_postgres.

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

References _GenFields(), and TableName().

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 388 of file adodb-datadict.inc.php.

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

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

Reimplemented in ADODB2_postgres.

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

References NameQuote(), and TableName().

Referenced by ADODB2_postgres::DropColumnSQL().

---

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

• typo3_src-4.1/typo3/sysext/adodb/adodb/adodb-datadict.inc.php

---