TYPO3 CMS  TYPO3_6-2
•All Classes Namespaces Files Functions Variables Pages
Public Member Functions | Static Public Member Functions | Public Attributes | List of all members
ADODB_mssqlnative Class Reference
Inheritance diagram for ADODB_mssqlnative:

Public Member Functions

 ADODB_mssqlnative ()
 
 ServerVersion ()
 
 ServerInfo ()
 
 IfNull ( $field, $ifNull)
 
 _insertid ()
 
 _affectedrows ()
 
 GenID ($seq='adodbseq', $start=1)
 
 CreateSequence ($seq='adodbseq', $start=1)
 
 CreateSequence2008 ($seq='adodbseq', $start=1)
 
 CreateSequence2012 ($seq='adodb', $start=1)
 
 GenID2008 ($seq='adodbseq', $start=1)
 
 GenID2012 ($seq='adodbseq', $start=1)
 
 SQLDate ($fmt, $col=false)
 
 BeginTrans ()
 
 CommitTrans ($ok=true)
 
 RollbackTrans ()
 
 SetTransactionMode ( $transaction_mode)
 
 RowLock ($tables, $where, $col='1 as adodbignore')
 
 SelectDB ($dbName)
 
 ErrorMsg ()
 
 ErrorNo ()
 
 _connect ($argHostname, $argUsername, $argPassword, $argDatabasename)
 
 _pconnect ($argHostname, $argUsername, $argPassword, $argDatabasename)
 
 Prepare ($sql)
 
 Concat ()
 
 UpdateBlob ($table, $column, $val, $where, $blobtype='BLOB')
 
 _query ($sql, $inputarr=false)
 
 _close ()
 
 MetaIndexes ($table, $primary=false, $owner=false)
 
 MetaForeignKeys ($table, $owner=false, $upper=false)
 
 MetaDatabases ()
 
 MetaPrimaryKeys ($table, $owner=false)
 
 MetaTables ($ttype=false, $showSchema=false, $mask=false)
 
 MetaColumns ($table, $upper=true, $schema=false)
 

Static Public Member Functions

static UnixDate ($v)
 
static UnixTimeStamp ($v)
 

Public Attributes

 $databaseType = "mssqlnative"
 
 $dataProvider = "mssqlnative"
 
 $replaceQuote = "''"
 
 $fmtDate = "'Y-m-d'"
 
 $fmtTimeStamp = "'Y-m-d\TH:i:s'"
 
 $hasInsertID = true
 
 $substr = "substring"
 
 $length = 'len'
 
 $hasAffectedRows = true
 
 $poorAffectedRows = false
 
 $metaDatabasesSQL = "select name from sys.sysdatabases where name <> 'master'"
 
 $metaTablesSQL ="select name,case when type='U' then 'T' else 'V' end from sysobjects where (type='U' or type='V') and (name not in ('sysallocations','syscolumns','syscomments','sysdepends','sysfilegroups','sysfiles','sysfiles1','sysforeignkeys','sysfulltextcatalogs','sysindexes','sysindexkeys','sysmembers','sysobjects','syspermissions','sysprotects','sysreferences','systypes','sysusers','sysalternates','sysconstraints','syssegments','REFERENTIAL_CONSTRAINTS','CHECK_CONSTRAINTS','CONSTRAINT_TABLE_USAGE','CONSTRAINT_COLUMN_USAGE','VIEWS','VIEW_TABLE_USAGE','VIEW_COLUMN_USAGE','SCHEMATA','TABLES','TABLE_CONSTRAINTS','TABLE_PRIVILEGES','COLUMNS','COLUMN_DOMAIN_USAGE','COLUMN_PRIVILEGES','DOMAINS','DOMAIN_CONSTRAINTS','KEY_COLUMN_USAGE','dtproperties'))"
 
 $metaColumnsSQL
 
 $hasTop = 'top'
 
 $hasGenID = true
 
 $sysDate = 'convert(datetime,convert(char,GetDate(),102),102)'
 
 $sysTimeStamp = 'GetDate()'
 
 $maxParameterLen = 4000
 
 $arrayClass = 'ADORecordSet_array_mssqlnative'
 
 $uniqueSort = true
 
 $leftOuter = '*='
 
 $rightOuter = '=*'
 
 $ansiOuter = true
 
 $identitySQL = 'select SCOPE_IDENTITY()'
 
 $uniqueOrderBy = true
 
 $_bindInputArray = true
 
 $_dropSeqSQL = "drop table %s"
 
 $connectionInfo = array()
 
 $sequences = false
 
 $mssql_version = ''
 

Detailed Description

Definition at line 81 of file adodb-mssqlnative.inc.php.

Member Function Documentation

◆ _affectedrows()

ADODB_mssqlnative::_affectedrows ( )

Definition at line 200 of file adodb-mssqlnative.inc.php.

◆ _close()

ADODB_mssqlnative::_close ( )

Definition at line 606 of file adodb-mssqlnative.inc.php.

References RollbackTrans().

◆ _connect()

ADODB_mssqlnative::_connect (   $argHostname,
  $argUsername,
  $argPassword,
  $argDatabasename 
)

Definition at line 476 of file adodb-mssqlnative.inc.php.

References $connectionInfo, and debug().

Referenced by _pconnect().

◆ _insertid()

ADODB_mssqlnative::_insertid ( )

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

◆ _pconnect()

ADODB_mssqlnative::_pconnect (   $argHostname,
  $argUsername,
  $argPassword,
  $argDatabasename 
)

Definition at line 511 of file adodb-mssqlnative.inc.php.

References _connect().

◆ _query()

ADODB_mssqlnative::_query (   $sql,
  $inputarr = false 
)

Definition at line 574 of file adodb-mssqlnative.inc.php.

References $sql, and debug().

◆ ADODB_mssqlnative()

ADODB_mssqlnative::ADODB_mssqlnative ( )

Definition at line 129 of file adodb-mssqlnative.inc.php.

References debug().

◆ BeginTrans()

ADODB_mssqlnative::BeginTrans ( )

Definition at line 382 of file adodb-mssqlnative.inc.php.

References debug().

Referenced by RowLock().

◆ CommitTrans()

ADODB_mssqlnative::CommitTrans (   $ok = true)

Definition at line 391 of file adodb-mssqlnative.inc.php.

References debug(), and RollbackTrans().

◆ Concat()

ADODB_mssqlnative::Concat ( )

Definition at line 530 of file adodb-mssqlnative.inc.php.

◆ CreateSequence()

ADODB_mssqlnative::CreateSequence (   $seq = 'adodbseq',
  $start = 1 
)

Definition at line 220 of file adodb-mssqlnative.inc.php.

References CreateSequence2008(), CreateSequence2012(), and ServerVersion().

◆ CreateSequence2008()

ADODB_mssqlnative::CreateSequence2008 (   $seq = 'adodbseq',
  $start = 1 
)

For Server 2005,2008, duplicate a sequence with an identity table

Definition at line 240 of file adodb-mssqlnative.inc.php.

References debug().

Referenced by CreateSequence().

◆ CreateSequence2012()

ADODB_mssqlnative::CreateSequence2012 (   $seq = 'adodb',
  $start = 1 
)

Proper Sequences Only available to Server 2012 and up

Definition at line 259 of file adodb-mssqlnative.inc.php.

References $sql, and die.

Referenced by CreateSequence(), and GenID2012().

◆ ErrorMsg()

ADODB_mssqlnative::ErrorMsg ( )

Definition at line 452 of file adodb-mssqlnative.inc.php.

◆ ErrorNo()

ADODB_mssqlnative::ErrorNo ( )

Definition at line 467 of file adodb-mssqlnative.inc.php.

◆ GenID()

ADODB_mssqlnative::GenID (   $seq = 'adodbseq',
  $start = 1 
)

Definition at line 206 of file adodb-mssqlnative.inc.php.

References GenID2008(), GenID2012(), and ServerVersion().

◆ GenID2008()

ADODB_mssqlnative::GenID2008 (   $seq = 'adodbseq',
  $start = 1 
)

For Server 2005,2008, duplicate a sequence with an identity table

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

References debug().

Referenced by GenID().

◆ GenID2012()

ADODB_mssqlnative::GenID2012 (   $seq = 'adodbseq',
  $start = 1 
)

Only available to Server 2012 and up Cannot do this the normal adodb way by trapping an error if the sequence does not exist because sql server will auto create a sequence with the starting number of -9223372036854775808

Definition at line 298 of file adodb-mssqlnative.inc.php.

References $sql, and CreateSequence2012().

Referenced by GenID().

◆ IfNull()

ADODB_mssqlnative::IfNull (   $field,
  $ifNull 
)

Definition at line 185 of file adodb-mssqlnative.inc.php.

◆ MetaColumns()

ADODB_mssqlnative::MetaColumns (   $table,
  $upper = true,
  $schema = false 
)

Definition at line 762 of file adodb-mssqlnative.inc.php.

References $database, $rs, SelectDB(), and ServerVersion().

◆ MetaDatabases()

ADODB_mssqlnative::MetaDatabases ( )

Definition at line 705 of file adodb-mssqlnative.inc.php.

References $rs, and SelectDB().

◆ MetaForeignKeys()

ADODB_mssqlnative::MetaForeignKeys (   $table,
  $owner = false,
  $upper = false 
)

Definition at line 665 of file adodb-mssqlnative.inc.php.

References $sql.

◆ MetaIndexes()

ADODB_mssqlnative::MetaIndexes (   $table,
  $primary = false,
  $owner = false 
)

Definition at line 625 of file adodb-mssqlnative.inc.php.

References $rs, and $sql.

◆ MetaPrimaryKeys()

ADODB_mssqlnative::MetaPrimaryKeys (   $table,
  $owner = false 
)

Definition at line 723 of file adodb-mssqlnative.inc.php.

References $database, and $sql.

◆ MetaTables()

ADODB_mssqlnative::MetaTables (   $ttype = false,
  $showSchema = false,
  $mask = false 
)

Definition at line 748 of file adodb-mssqlnative.inc.php.

References $metaTablesSQL.

◆ Prepare()

ADODB_mssqlnative::Prepare (   $sql)

Definition at line 517 of file adodb-mssqlnative.inc.php.

References $sql.

◆ RollbackTrans()

ADODB_mssqlnative::RollbackTrans ( )

Definition at line 400 of file adodb-mssqlnative.inc.php.

References debug().

Referenced by _close(), and CommitTrans().

◆ RowLock()

ADODB_mssqlnative::RowLock (   $tables,
  $where,
  $col = '1 as adodbignore' 
)

Definition at line 432 of file adodb-mssqlnative.inc.php.

References BeginTrans().

◆ SelectDB()

ADODB_mssqlnative::SelectDB (   $dbName)

Definition at line 439 of file adodb-mssqlnative.inc.php.

References $rs.

Referenced by MetaColumns(), and MetaDatabases().

◆ ServerInfo()

ADODB_mssqlnative::ServerInfo ( )

Definition at line 165 of file adodb-mssqlnative.inc.php.

Referenced by ServerVersion().

◆ ServerVersion()

ADODB_mssqlnative::ServerVersion ( )

Definition at line 144 of file adodb-mssqlnative.inc.php.

References die, and ServerInfo().

Referenced by CreateSequence(), GenID(), and MetaColumns().

◆ SetTransactionMode()

ADODB_mssqlnative::SetTransactionMode (   $transaction_mode)

Definition at line 409 of file adodb-mssqlnative.inc.php.

◆ SQLDate()

ADODB_mssqlnative::SQLDate (   $fmt,
  $col = false 
)

Definition at line 322 of file adodb-mssqlnative.inc.php.

References $sysTimeStamp.

◆ UnixDate()

static ADODB_mssqlnative::UnixDate (   $v)
static

Definition at line 615 of file adodb-mssqlnative.inc.php.

References ADORecordSet_array_mssqlnative\UnixDate().

◆ UnixTimeStamp()

static ADODB_mssqlnative::UnixTimeStamp (   $v)
static

Definition at line 620 of file adodb-mssqlnative.inc.php.

References ADORecordSet_array_mssqlnative\UnixTimeStamp().

◆ UpdateBlob()

ADODB_mssqlnative::UpdateBlob (   $table,
  $column,
  $val,
  $where,
  $blobtype = 'BLOB' 
)

Definition at line 562 of file adodb-mssqlnative.inc.php.

References $sql.

Member Data Documentation

◆ $_bindInputArray

ADODB_mssqlnative::$_bindInputArray = true

Definition at line 123 of file adodb-mssqlnative.inc.php.

◆ $_dropSeqSQL

ADODB_mssqlnative::$_dropSeqSQL = "drop table %s"

Definition at line 124 of file adodb-mssqlnative.inc.php.

◆ $ansiOuter

ADODB_mssqlnative::$ansiOuter = true

Definition at line 120 of file adodb-mssqlnative.inc.php.

◆ $arrayClass

ADODB_mssqlnative::$arrayClass = 'ADORecordSet_array_mssqlnative'

Definition at line 116 of file adodb-mssqlnative.inc.php.

◆ $connectionInfo

ADODB_mssqlnative::$connectionInfo = array()

Definition at line 125 of file adodb-mssqlnative.inc.php.

Referenced by _connect().

◆ $databaseType

ADODB_mssqlnative::$databaseType = "mssqlnative"

Definition at line 82 of file adodb-mssqlnative.inc.php.

◆ $dataProvider

ADODB_mssqlnative::$dataProvider = "mssqlnative"

Definition at line 83 of file adodb-mssqlnative.inc.php.

◆ $fmtDate

ADODB_mssqlnative::$fmtDate = "'Y-m-d'"

Definition at line 85 of file adodb-mssqlnative.inc.php.

◆ $fmtTimeStamp

ADODB_mssqlnative::$fmtTimeStamp = "'Y-m-d\TH:i:s'"

Definition at line 86 of file adodb-mssqlnative.inc.php.

◆ $hasAffectedRows

ADODB_mssqlnative::$hasAffectedRows = true

Definition at line 90 of file adodb-mssqlnative.inc.php.

◆ $hasGenID

ADODB_mssqlnative::$hasGenID = true

Definition at line 112 of file adodb-mssqlnative.inc.php.

◆ $hasInsertID

ADODB_mssqlnative::$hasInsertID = true

Definition at line 87 of file adodb-mssqlnative.inc.php.

◆ $hasTop

ADODB_mssqlnative::$hasTop = 'top'

Definition at line 111 of file adodb-mssqlnative.inc.php.

◆ $identitySQL

ADODB_mssqlnative::$identitySQL = 'select SCOPE_IDENTITY()'

Definition at line 121 of file adodb-mssqlnative.inc.php.

◆ $leftOuter

ADODB_mssqlnative::$leftOuter = '*='

Definition at line 118 of file adodb-mssqlnative.inc.php.

◆ $length

ADODB_mssqlnative::$length = 'len'

Definition at line 89 of file adodb-mssqlnative.inc.php.

◆ $maxParameterLen

ADODB_mssqlnative::$maxParameterLen = 4000

Definition at line 115 of file adodb-mssqlnative.inc.php.

◆ $metaColumnsSQL

ADODB_mssqlnative::$metaColumnsSQL
Initial value:
=
"select c.name,
t.name as type,
c.length,
c.xprec as precision,
c.xscale as scale,
c.isnullable as nullable,
c.cdefault as default_value,
c.xtype,
t.length as type_length,
sc.is_identity
from syscolumns c
join systypes t on t.xusertype=c.xusertype
join sysobjects o on o.id=c.id
join sys.tables st on st.name=o.name
join sys.columns sc on sc.object_id = st.object_id and sc.name=c.name
where o.name='%s'"

Definition at line 94 of file adodb-mssqlnative.inc.php.

◆ $metaDatabasesSQL

ADODB_mssqlnative::$metaDatabasesSQL = "select name from sys.sysdatabases where name <> 'master'"

Definition at line 92 of file adodb-mssqlnative.inc.php.

◆ $metaTablesSQL

ADODB_mssqlnative::$metaTablesSQL ="select name,case when type='U' then 'T' else 'V' end from sysobjects where (type='U' or type='V') and (name not in ('sysallocations','syscolumns','syscomments','sysdepends','sysfilegroups','sysfiles','sysfiles1','sysforeignkeys','sysfulltextcatalogs','sysindexes','sysindexkeys','sysmembers','sysobjects','syspermissions','sysprotects','sysreferences','systypes','sysusers','sysalternates','sysconstraints','syssegments','REFERENTIAL_CONSTRAINTS','CHECK_CONSTRAINTS','CONSTRAINT_TABLE_USAGE','CONSTRAINT_COLUMN_USAGE','VIEWS','VIEW_TABLE_USAGE','VIEW_COLUMN_USAGE','SCHEMATA','TABLES','TABLE_CONSTRAINTS','TABLE_PRIVILEGES','COLUMNS','COLUMN_DOMAIN_USAGE','COLUMN_PRIVILEGES','DOMAINS','DOMAIN_CONSTRAINTS','KEY_COLUMN_USAGE','dtproperties'))"

Definition at line 93 of file adodb-mssqlnative.inc.php.

Referenced by MetaTables().

◆ $mssql_version

ADODB_mssqlnative::$mssql_version = ''

Definition at line 127 of file adodb-mssqlnative.inc.php.

◆ $poorAffectedRows

ADODB_mssqlnative::$poorAffectedRows = false

Definition at line 91 of file adodb-mssqlnative.inc.php.

◆ $replaceQuote

ADODB_mssqlnative::$replaceQuote = "''"

Definition at line 84 of file adodb-mssqlnative.inc.php.

◆ $rightOuter

ADODB_mssqlnative::$rightOuter = '=*'

Definition at line 119 of file adodb-mssqlnative.inc.php.

◆ $sequences

ADODB_mssqlnative::$sequences = false

Definition at line 126 of file adodb-mssqlnative.inc.php.

◆ $substr

ADODB_mssqlnative::$substr = "substring"

Definition at line 88 of file adodb-mssqlnative.inc.php.

◆ $sysDate

ADODB_mssqlnative::$sysDate = 'convert(datetime,convert(char,GetDate(),102),102)'

Definition at line 113 of file adodb-mssqlnative.inc.php.

◆ $sysTimeStamp

ADODB_mssqlnative::$sysTimeStamp = 'GetDate()'

Definition at line 114 of file adodb-mssqlnative.inc.php.

Referenced by SQLDate().

◆ $uniqueOrderBy

ADODB_mssqlnative::$uniqueOrderBy = true

Definition at line 122 of file adodb-mssqlnative.inc.php.

◆ $uniqueSort

ADODB_mssqlnative::$uniqueSort = true

Definition at line 117 of file adodb-mssqlnative.inc.php.