Solutions Open Source

Référence de la classe ADODB_DataDict

Graphe d'héritage de ADODB_DataDict:

Liste de tous les membres

Fonctions membres publiques

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)

Attributs publics

$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

Documentation des fonctions membres

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

Réimplémentée dans ADODB2_oci8.

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

Réimplémentée dans ADODB2_oci8.

ADODB_DataDict::MetaTables ( )

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

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

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

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

Réimplémentée dans ADODB2_mssql, ADODB2_mysql, ADODB2_postgres, ADODB2_sapdb, et ADODB2_sybase.

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

ADODB_DataDict::TableName ( $ name )

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

ADODB_DataDict::ActualType ( $ meta )

Réimplémentée dans ADODB2_access, ADODB2_db2, ADODB2_firebird, ADODB2_generic, ADODB2_ibase, ADODB2_informix, ADODB2_mssql, ADODB2_mysql, ADODB2_oci8, ADODB2_postgres, ADODB2_sapdb, et ADODB2_sybase.

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

Réimplémentée dans ADODB2_access, ADODB2_firebird, et ADODB2_oci8.

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

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

ADODB_DataDict::SetSchema ( $ schema )

Réimplémentée dans ADODB2_access.

ADODB_DataDict::AddColumnSQL	(	$	tabname,
		$	flds
	)

Réimplémentée dans ADODB2_mssql, ADODB2_oci8, ADODB2_postgres, ADODB2_sapdb, et ADODB2_sybase.

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

Paramètres:

	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 ''

Renvoie:: array with SQL strings

Réimplémentée dans ADODB2_postgres.

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)

Paramètres:

	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=''

Renvoie:: array with SQL strings

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

Paramètres:

	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 ''

Renvoie:: array with SQL strings

Réimplémentée dans ADODB2_postgres.

ADODB_DataDict::DropTableSQL ( $ tabname )

Réimplémentée dans ADODB2_postgres.

ADODB_DataDict::RenameTableSQL	(	$	tabname,
		$	newname
	)

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

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

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

Réimplémentée dans ADODB2_mssql, et ADODB2_postgres.

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

Réimplémentée dans ADODB2_db2, ADODB2_mssql, et ADODB2_sybase.

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

Réimplémentée dans ADODB2_mssql, ADODB2_mysql, ADODB2_oci8, ADODB2_postgres, et ADODB2_sybase.

ADODB_DataDict::_DropAutoIncrement ( $ tabname )

Réimplémentée dans ADODB2_firebird, ADODB2_oci8, et ADODB2_postgres.

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

ADODB_DataDict::_Triggers	(	$	tabname,
		$	taboptions
	)

Réimplémentée dans ADODB2_firebird, et ADODB2_oci8.

ADODB_DataDict::_Options ( $ opts )

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

Réimplémentée dans ADODB2_db2.

Documentation des données membres

ADODB_DataDict::$connection

ADODB_DataDict::$debug = false

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

Réimplémentée dans ADODB2_mysql, ADODB2_oci8, et ADODB2_postgres.

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

Réimplémentée dans ADODB2_mssql, et ADODB2_postgres.

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

Réimplémentée dans ADODB2_mssql, ADODB2_mysql, et ADODB2_sybase.

ADODB_DataDict::$addCol = ' ADD'

Réimplémentée dans ADODB2_postgres.

ADODB_DataDict::$alterCol = ' ALTER COLUMN'

Réimplémentée dans ADODB2_mysql, et ADODB2_oci8.

ADODB_DataDict::$dropCol = ' DROP COLUMN'

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

Réimplémentée dans ADODB2_mssql, ADODB2_mysql, et ADODB2_sapdb.

ADODB_DataDict::$nameRegex = '\w'

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

ADODB_DataDict::$schema = false

ADODB_DataDict::$serverInfo = array()

ADODB_DataDict::$autoIncrement = false

ADODB_DataDict::$dataProvider

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

ADODB_DataDict::$blobSize = 100

Réimplémentée dans ADODB2_firebird.

La documentation de cette classe a été générée à partir du fichier suivant :

Z:/doxygen/typo3_src-4.1.2/typo3/sysext/adodb/adodb/adodb-datadict.inc.php

Généré le Fri Aug 31 11:39:41 2007 pour OBLADY - Typo3 API v4.1.2 par

1.5.3


Fonctions membres publiques
	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)
Attributs publics
	$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