Docs For Class ADODB

$addCol = ' ADD'

[line 170]

Type:

mixed

[ Top ]

$alterCol = ' ALTER COLUMN'

[line 171]

Type:

mixed

[ Top ]

$autoIncrement = false

[line 178]

Type:

mixed

[ Top ]

$blobSize = 100

[line 181]

Type:

mixed

[ Top ]

$connection =

[line 165]

Type:

mixed

[ Top ]

$dataProvider =

[line 179]

Type:

mixed

[ Top ]

$debug = false

[line 166]

Type:

mixed

[ Top ]

$dropCol = ' DROP COLUMN'

[line 172]

Type:

mixed

[ Top ]

$dropIndex = 'DROP INDEX %s'

[line 169]

Type:

mixed

[ Top ]

$dropTable = 'DROP TABLE %s'

[line 167]

Type:

mixed

[ Top ]

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

[line 180]

Type:

mixed

[ Top ]

$nameRegex = '\w'

[line 174]

Type:

mixed

[ Top ]

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

[line 175]

Type:

mixed

[ Top ]

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

[line 173]

Type:

mixed

[ Top ]

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

[line 168]

Type:

mixed

[ Top ]

$schema = false

[line 176]

Type:

mixed

[ Top ]

$serverInfo = array()

[line 177]

Type:

mixed

[ Top ]

method ActualType [line 406]

void ActualType(

$meta)

Overridden in child classes as:

ADODB2_access::ActualType()

ADODB2_db2::ActualType()

ADODB2_firebird::ActualType()

ADODB2_generic::ActualType()

ADODB2_ibase::ActualType()

ADODB2_informix::ActualType()

ADODB2_mssql::ActualType()

ADODB2_mysql::ActualType()

ADODB2_oci8::ActualType()

ADODB2_postgres::ActualType()

ADODB2_sapdb::ActualType()

ADODB2_sybase::ActualType()

Parameters:

$meta

[ Top ]

method AddColumnSQL [line 451]

void AddColumnSQL(

$tabname, 
$flds)

Overridden in child classes as:

ADODB2_mssql::AddColumnSQL()

ADODB2_oci8::AddColumnSQL()

ADODB2_postgres::AddColumnSQL(): Adding a new Column

ADODB2_sapdb::AddColumnSQL()

ADODB2_sybase::AddColumnSQL()

Parameters:

	$tabname
	$flds

[ Top ]

method AlterColumnSQL [line 482]

array AlterColumnSQL(
string
$tabname, string
$flds, [
$tableflds = ''], [
$tableoptions = ''], string
$tableflds='', array/string
$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 ''
	$tableflds
	$tableoptions

[ Top ]

method ChangeTableSQL [line 921]

void ChangeTableSQL(

$tablename, 
$flds, [
$tableoptions = false])

Overridden in child classes as:

ADODB2_db2::ChangeTableSQL()

Parameters:

	$tablename
	$flds
	$tableoptions

[ Top ]

method CreateDatabase [line 411]

void CreateDatabase(

$dbname, [
$options = false])

Overridden in child classes as:

ADODB2_access::CreateDatabase()

ADODB2_firebird::CreateDatabase()

ADODB2_oci8::CreateDatabase()

Parameters:

	$dbname
	$options

[ Top ]

method CreateIndexSQL [line 427]

void CreateIndexSQL(

$idxname, 
$tabname, 
$flds, [
$idxoptions = false])

Parameters:

	$idxname
	$tabname
	$flds
	$idxoptions

[ Top ]

method CreateTableSQL [line 562]

void CreateTableSQL(

$tabname, 
$flds, [
$tableoptions = array()])

Parameters:

	$tabname
	$flds
	$tableoptions

[ Top ]

method DropColumnSQL [line 537]

array DropColumnSQL(
string
$tabname, string
$flds, [
$tableflds = ''], [
$tableoptions = ''], string
$tableflds='', array/string
$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 ''
	$tableflds
	$tableoptions

[ Top ]

method DropIndexSQL [line 441]

void DropIndexSQL(

$idxname, [
$tabname = NULL])

Overridden in child classes as:

ADODB2_postgres::DropIndexSQL()

Parameters:

	$idxname
	$tabname

[ Top ]

method DropTableSQL [line 549]

void DropTableSQL(

$tabname)

Overridden in child classes as:

ADODB2_postgres::DropTableSQL()

Parameters:

$tabname

[ Top ]

method ExecuteSQLArray [line 369]

void ExecuteSQLArray(

$sql, [
$continueOnError = true])

Parameters:

	$sql
	$continueOnError

[ Top ]

method GetCommentSQL [line 184]

void GetCommentSQL(

$table, 
$col)

Overridden in child classes as:

ADODB2_oci8::GetCommentSQL()

Parameters:

	$table
	$col

[ Top ]

method MetaColumns [line 200]

void MetaColumns(

$tab, [
$upper = true], [
$schema = false])

Parameters:

	$tab
	$upper
	$schema

[ Top ]

method MetaIndexes [line 212]

void MetaIndexes(

$table, [
$primary = false], [
$owner = false])

Parameters:

	$table
	$primary
	$owner

[ Top ]

method MetaPrimaryKeys [line 206]

void MetaPrimaryKeys(

$tab, [
$owner = false], [
$intkey = false])

Parameters:

	$tab
	$owner
	$intkey

[ Top ]

method MetaTables [line 194]

void MetaTables(
)

[ Top ]

method MetaType [line 219]

void MetaType(

$t, [
$len = -1], [
$fieldobj = false])

Overridden in child classes as:

ADODB2_mssql::MetaType()

ADODB2_mysql::MetaType()

ADODB2_oci8::MetaType()

ADODB2_postgres::MetaType()

ADODB2_sapdb::MetaType()

ADODB2_sybase::MetaType()

Parameters:

	$t
	$len
	$fieldobj

[ Top ]

method NameQuote [line 331]

void NameQuote(
[
$name = NULL], [
$allowBrackets = false])

Overridden in child classes as:

ADODB2_firebird::NameQuote()

Parameters:

	$name
	$allowBrackets

[ Top ]

method RenameColumnSQL [line 513]

array RenameColumnSQL(
string
$tabname, string
$oldcolumn, string
$newcolumn, [
$flds = ''], string
$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)

Tags:

return:

with SQL strings

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

[ Top ]

method RenameTableSQL [line 554]

void RenameTableSQL(

$tabname, 
$newname)

Overridden in child classes as:

ADODB2_postgres::RenameTableSQL()

Parameters:

	$tabname
	$newname

[ Top ]

method SetCommentSQL [line 189]

void SetCommentSQL(

$table, 
$col, 
$cmt)

Overridden in child classes as:

ADODB2_oci8::SetCommentSQL()

Parameters:

	$table
	$col
	$cmt

[ Top ]

method SetSchema [line 446]

void SetSchema(

$schema)

Overridden in child classes as:

ADODB2_access::SetSchema()

Parameters:

$schema

[ Top ]

method TableName [line 360]

void TableName(

$name)

Parameters:

$name

[ Top ]

method _CreateSuffix [line 816]

void _CreateSuffix(

$fname, 
$ftype, 
$fnotnull, 
$fdefault, 
$fautoinc, 
$fconstraint)

Overridden in child classes as:

ADODB2_access::_CreateSuffix()

ADODB2_db2::_CreateSuffix()

ADODB2_firebird::_CreateSuffix()

ADODB2_informix::_CreateSuffix()

ADODB2_mssql::_CreateSuffix()

ADODB2_mysql::_CreateSuffix()

ADODB2_oci8::_CreateSuffix()

ADODB2_postgres::_CreateSuffix()

ADODB2_sapdb::_CreateSuffix()

ADODB2_sybase::_CreateSuffix()

Parameters:

	$fname
	$ftype
	$fnotnull
	$fdefault
	$fautoinc
	$fconstraint

[ Top ]

method _DropAutoIncrement [line 854]

void _DropAutoIncrement(

$tabname)

Overridden in child classes as:

ADODB2_firebird::_DropAutoIncrement()

ADODB2_oci8::_DropAutoIncrement()

ADODB2_postgres::_DropAutoIncrement()

Parameters:

$tabname

[ Top ]

method _GenFields [line 592]

void _GenFields(

$flds, [
$widespacing = false])

Parameters:

	$flds
	$widespacing

[ Top ]

method _GetSize [line 804]

void _GetSize(

$ftype, 
$ty, 
$fsize, 
$fprec)

Overridden in child classes as:

ADODB2_mssql::_GetSize()

ADODB2_postgres::_GetSize()

Parameters:

	$ftype
	$ty
	$fsize
	$fprec

[ Top ]

method _IndexSQL [line 825]

void _IndexSQL(

$idxname, 
$tabname, 
$flds, 
$idxoptions)

Overridden in child classes as:

ADODB2_mssql::_IndexSQL()

ADODB2_mysql::_IndexSQL()

ADODB2_oci8::_IndexSQL()

ADODB2_postgres::_IndexSQL()

ADODB2_sybase::_IndexSQL()

Parameters:

	$idxname
	$tabname
	$flds
	$idxoptions

[ Top ]

method _Options [line 904]

void _Options(

$opts)

Parameters:

$opts

[ Top ]

method _TableSQL [line 859]

void _TableSQL(

$tabname, 
$lines, 
$pkey, 
$tableoptions)

Parameters:

	$tabname
	$lines
	$pkey
	$tableoptions

[ Top ]

method _Triggers [line 896]

void _Triggers(

$tabname, 
$taboptions)

Overridden in child classes as:

ADODB2_firebird::_Triggers()

ADODB2_oci8::_Triggers()

Parameters:

	$tabname
	$taboptions

[ Top ]

Class: ADODB_DataDict

Class Overview

Variables

Methods

Child classes:

Class Details

Class Variables

$addCol = ' ADD'

$alterCol = ' ALTER COLUMN'

$autoIncrement = false

$blobSize = 100

$connection =

$dataProvider =

$debug = false

$dropCol = ' DROP COLUMN'

$dropIndex = 'DROP INDEX %s'

$dropTable = 'DROP TABLE %s'

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

$nameRegex = '\w'

$nameRegexBrackets = 'a-zA-Z0-9_\(\)'

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

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

$schema = false

$serverInfo = array()

Class Methods

method ActualType [line 406]

Parameters:

method AddColumnSQL [line 451]

Parameters:

method AlterColumnSQL [line 482]

Tags:

Parameters:

method ChangeTableSQL [line 921]

Parameters:

method CreateDatabase [line 411]

Parameters:

method CreateIndexSQL [line 427]

Parameters:

method CreateTableSQL [line 562]

Parameters:

method DropColumnSQL [line 537]

Tags:

Parameters:

method DropIndexSQL [line 441]

Parameters:

method DropTableSQL [line 549]

Parameters:

method ExecuteSQLArray [line 369]

Parameters:

method GetCommentSQL [line 184]

Parameters:

method MetaColumns [line 200]

Parameters:

method MetaIndexes [line 212]

Parameters:

method MetaPrimaryKeys [line 206]

Parameters:

method MetaTables [line 194]

method MetaType [line 219]

Parameters:

method NameQuote [line 331]

Parameters:

method RenameColumnSQL [line 513]

Tags:

Parameters:

method RenameTableSQL [line 554]

Parameters:

method SetCommentSQL [line 189]

Parameters:

method SetSchema [line 446]

Parameters:

method TableName [line 360]

Parameters:

method _CreateSuffix [line 816]

Parameters:

method _DropAutoIncrement [line 854]

Parameters:

method _GenFields [line 592]

Parameters:

method _GetSize [line 804]