Docs For Class ADODB

void ActualType(

$meta)

Overridden in child classes as:

ADODB2_sapdb::ActualType()

ADODB2_firebird::ActualType()

ADODB2_mssql::ActualType()

ADODB2_db2::ActualType()

ADODB2_ibase::ActualType()

ADODB2_generic::ActualType()

ADODB2_informix::ActualType()

ADODB2_sybase::ActualType()

ADODB2_mssqlnative::ActualType()

ADODB2_postgres::ActualType()

ADODB2_oci8::ActualType()

ADODB2_mysql::ActualType()

ADODB2_access::ActualType()

Parameters:

$meta

[ Top ]

void AddColumnSQL(

$tabname, 
$flds)

Overridden in child classes as:

ADODB2_sapdb::AddColumnSQL()

ADODB2_mssql::AddColumnSQL()

ADODB2_sybase::AddColumnSQL()

ADODB2_mssqlnative::AddColumnSQL()

ADODB2_postgres::AddColumnSQL(): Adding a new Column

ADODB2_oci8::AddColumnSQL()

Parameters:

	$tabname
	$flds

[ Top ]

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

Tags:

return:

with SQL strings

Overridden in child classes as:

ADODB2_sapdb::AlterColumnSQL()

ADODB2_db2::AlterColumnSQL()

ADODB2_ibase::AlterColumnSQL()

ADODB2_generic::AlterColumnSQL()

ADODB2_informix::AlterColumnSQL()

ADODB2_sybase::AlterColumnSQL()

ADODB2_postgres::AlterColumnSQL(): Change the definition of one column

ADODB2_oci8::AlterColumnSQL()

ADODB2_access::AlterColumnSQL()

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 ]

void ChangeTableSQL(

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

Overridden in child classes as:

ADODB2_db2::ChangeTableSQL()

Parameters:

	$tablename
	$flds
	$tableoptions

[ Top ]

void CreateDatabase(

$dbname, [
$options = false])

Overridden in child classes as:

ADODB2_firebird::CreateDatabase()

ADODB2_oci8::CreateDatabase()

ADODB2_access::CreateDatabase()

Parameters:

	$dbname
	$options

[ Top ]

void CreateIndexSQL(

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

Parameters:

	$idxname
	$tabname
	$flds
	$idxoptions

[ Top ]

void CreateTableSQL(

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

Parameters:

	$tabname
	$flds
	$tableoptions

[ Top ]

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

Tags:

return:

with SQL strings

Overridden in child classes as:

ADODB2_sapdb::DropColumnSQL()

ADODB2_mssql::DropColumnSQL()

ADODB2_db2::DropColumnSQL()

ADODB2_ibase::DropColumnSQL()

ADODB2_generic::DropColumnSQL()

ADODB2_informix::DropColumnSQL()

ADODB2_sybase::DropColumnSQL()

ADODB2_mssqlnative::DropColumnSQL()

ADODB2_postgres::DropColumnSQL(): Drop one column

ADODB2_oci8::DropColumnSQL()

ADODB2_access::DropColumnSQL()

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 ]

void DropIndexSQL(

$idxname, [
$tabname = NULL])

Overridden in child classes as:

ADODB2_postgres::DropIndexSQL()

Parameters:

	$idxname
	$tabname

[ Top ]

void DropTableSQL(

$tabname)

Overridden in child classes as:

ADODB2_postgres::DropTableSQL()

Parameters:

$tabname

[ Top ]

void ExecuteSQLArray(

$sql, [
$continueOnError = true])

Parameters:

	$sql
	$continueOnError

[ Top ]

void GetCommentSQL(

$table, 
$col)

Overridden in child classes as:

ADODB2_oci8::GetCommentSQL()

Parameters:

	$table
	$col

[ Top ]

void MetaColumns(

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

Parameters:

	$tab
	$upper
	$schema

[ Top ]

void MetaIndexes(

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

Parameters:

	$table
	$primary
	$owner

[ Top ]

void MetaPrimaryKeys(

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

Parameters:

	$tab
	$owner
	$intkey

[ Top ]

void MetaTables(
)

[ Top ]

void MetaType(

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

Overridden in child classes as:

ADODB2_sapdb::MetaType()

ADODB2_mssql::MetaType()

ADODB2_sybase::MetaType()

ADODB2_mssqlnative::MetaType()

ADODB2_postgres::MetaType()

ADODB2_oci8::MetaType()

ADODB2_mysql::MetaType()

Parameters:

	$t
	$len
	$fieldobj

[ Top ]

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

Overridden in child classes as:

ADODB2_firebird::NameQuote()

Parameters:

	$name
	$allowBrackets

[ Top ]

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 ]

void RenameTableSQL(

$tabname, 
$newname)

Overridden in child classes as:

ADODB2_postgres::RenameTableSQL()

Parameters:

	$tabname
	$newname

[ Top ]

void SetCommentSQL(

$table, 
$col, 
$cmt)

Overridden in child classes as:

ADODB2_oci8::SetCommentSQL()

Parameters:

	$table
	$col
	$cmt

[ Top ]

void SetSchema(

$schema)

Overridden in child classes as:

ADODB2_access::SetSchema()

Parameters:

$schema

[ Top ]

void TableName(

$name)

Parameters:

$name

[ Top ]

void _CreateSuffix(

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

Overridden in child classes as:

ADODB2_sapdb::_CreateSuffix()

ADODB2_firebird::_CreateSuffix()

ADODB2_mssql::_CreateSuffix()

ADODB2_db2::_CreateSuffix()

ADODB2_informix::_CreateSuffix()

ADODB2_sybase::_CreateSuffix()

ADODB2_mssqlnative::_CreateSuffix()

ADODB2_postgres::_CreateSuffix()

ADODB2_oci8::_CreateSuffix()

ADODB2_mysql::_CreateSuffix()

ADODB2_access::_CreateSuffix()

Parameters:

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

[ Top ]

void _DropAutoIncrement(

$tabname)

Overridden in child classes as:

ADODB2_firebird::_DropAutoIncrement()

ADODB2_postgres::_DropAutoIncrement()

ADODB2_oci8::_DropAutoIncrement()

Parameters:

$tabname

[ Top ]

void _GenFields(

$flds, [
$widespacing = false])

Parameters:

	$flds
	$widespacing

[ Top ]

void _GetSize(

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

Overridden in child classes as:

ADODB2_mssql::_GetSize()

ADODB2_mssqlnative::_GetSize()

ADODB2_postgres::_GetSize()

Parameters:

	$ftype
	$ty
	$fsize
	$fprec

[ Top ]

void _IndexSQL(

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

Overridden in child classes as:

ADODB2_mssql::_IndexSQL()

ADODB2_sybase::_IndexSQL()

ADODB2_mssqlnative::_IndexSQL()

ADODB2_postgres::_IndexSQL()

ADODB2_oci8::_IndexSQL()

ADODB2_mysql::_IndexSQL()

Parameters:

	$idxname
	$tabname
	$flds
	$idxoptions

[ Top ]

void _Options(

$opts)

Parameters:

$opts

[ Top ]

void _TableSQL(

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

Parameters:

	$tabname
	$lines
	$pkey
	$tableoptions

[ Top ]

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 407]

Parameters:

method AddColumnSQL [line 452]

Parameters:

method AlterColumnSQL [line 483]

Tags:

Parameters:

method ChangeTableSQL [line 922]

Parameters:

method CreateDatabase [line 412]

Parameters:

method CreateIndexSQL [line 428]

Parameters:

method CreateTableSQL [line 563]

Parameters:

method DropColumnSQL [line 538]

Tags:

Parameters:

method DropIndexSQL [line 442]

Parameters:

method DropTableSQL [line 550]

Parameters:

method ExecuteSQLArray [line 370]

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 218]

Parameters:

method NameQuote [line 332]

Parameters:

method RenameColumnSQL [line 514]

Tags:

Parameters:

method RenameTableSQL [line 555]

Parameters:

method SetCommentSQL [line 189]

Parameters:

method SetSchema [line 447]

Parameters:

method TableName [line 361]

Parameters:

method _CreateSuffix [line 817]

Parameters:

method _DropAutoIncrement [line 855]

Parameters:

method _GenFields [line 593]

Parameters:

method _GetSize [line 805]