TYPO3 CMS  TYPO3_7-6
ADODB2_mssqlnative Class Reference
Inheritance diagram for ADODB2_mssqlnative:
ADODB_DataDict

Public Member Functions

 MetaType ($t, $len=-1, $fieldobj=false)
 
 ActualType ($meta)
 
 AddColumnSQL ($tabname, $flds)
 
 DropColumnSQL ($tabname, $flds, $tableflds='', $tableoptions='')
 
 _CreateSuffix ($fname, &$ftype, $fnotnull, $fdefault, $fautoinc, $fconstraint, $funsigned)
 
 _IndexSQL ($idxname, $tabname, $flds, $idxoptions)
 
 _GetSize ($ftype, $ty, $fsize, $fprec)
 
- Public Member Functions inherited from ADODB_DataDict
 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

 $databaseType = 'mssqlnative'
 
 $dropIndex = 'DROP INDEX %1$s ON %2$s'
 
 $renameTable = "EXEC sp_rename '%s','%s'"
 
 $renameColumn = "EXEC sp_rename '%s.%s','%s'"
 
 $typeX = 'TEXT'
 
 $typeXL = 'TEXT'
 
- Public Attributes inherited from ADODB_DataDict
 $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 46 of file datadict-mssqlnative.inc.php.

Member Function Documentation

◆ _CreateSuffix()

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

Definition at line 190 of file datadict-mssqlnative.inc.php.

◆ _GetSize()

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

Definition at line 304 of file datadict-mssqlnative.inc.php.

◆ _IndexSQL()

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

Definition at line 273 of file datadict-mssqlnative.inc.php.

References $sql.

◆ ActualType()

ADODB2_mssqlnative::ActualType (   $meta)

Definition at line 101 of file datadict-mssqlnative.inc.php.

◆ AddColumnSQL()

ADODB2_mssqlnative::AddColumnSQL (   $tabname,
  $flds 
)

◆ DropColumnSQL()

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

Drop a column, syntax is ALTER TABLE table DROP COLUMN column,column

Parameters
string$tabnameTable Name
string[]$flds One, or an array of Fields To Drop
string$tablefldsThrowaway value to make the function match the parent
string$tableoptionsThroway value to make the function match the parent
Returns
string The SQL necessary to drop the column

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

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

◆ MetaType()

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

Definition at line 56 of file datadict-mssqlnative.inc.php.

Member Data Documentation

◆ $databaseType

ADODB2_mssqlnative::$databaseType = 'mssqlnative'

Definition at line 47 of file datadict-mssqlnative.inc.php.

◆ $dropIndex

ADODB2_mssqlnative::$dropIndex = 'DROP INDEX %1$s ON %2$s'

Definition at line 48 of file datadict-mssqlnative.inc.php.

◆ $renameColumn

ADODB2_mssqlnative::$renameColumn = "EXEC sp_rename '%s.%s','%s'"

Definition at line 50 of file datadict-mssqlnative.inc.php.

◆ $renameTable

ADODB2_mssqlnative::$renameTable = "EXEC sp_rename '%s','%s'"

Definition at line 49 of file datadict-mssqlnative.inc.php.

◆ $typeX

ADODB2_mssqlnative::$typeX = 'TEXT'

Definition at line 51 of file datadict-mssqlnative.inc.php.

◆ $typeXL

ADODB2_mssqlnative::$typeXL = 'TEXT'

Definition at line 52 of file datadict-mssqlnative.inc.php.