TYPO3 CMS  TYPO3_7-6
ADODB_sqlite3 Class Reference
Inheritance diagram for ADODB_sqlite3:

Public Member Functions

 __construct ()
 
 ServerInfo ()
 
 BeginTrans ()
 
 CommitTrans ($ok=true)
 
 RollbackTrans ()
 
 MetaColumns ($table, $normalize=true)
 
 _init ($parentDriver)
 
 _insertid ()
 
 _affectedrows ()
 
 ErrorMsg ()
 
 ErrorNo ()
 
 SQLDate ($fmt, $col=false)
 
 _createFunctions ()
 
 _connect ($argHostname, $argUsername, $argPassword, $argDatabasename)
 
 _pconnect ($argHostname, $argUsername, $argPassword, $argDatabasename)
 
 _query ($sql, $inputarr=false)
 
 SelectLimit ($sql, $nrows=-1, $offset=-1, $inputarr=false, $secs2cache=0)
 
 GenID ($seq='adodbseq', $start=1)
 
 CreateSequence ($seqname='adodbseq', $start=1)
 
 DropSequence ($seqname='adodbseq')
 
 _close ()
 
 MetaIndexes ($table, $primary=FALSE, $owner=false)
 

Public Attributes

 $databaseType = "sqlite3"
 
 $replaceQuote = "''"
 
 $concat_operator ='||'
 
 $_errorNo = 0
 
 $hasLimit = true
 
 $hasInsertID = true
 
 $hasAffectedRows = true
 supports autoincrement ID? More...
 
 $metaTablesSQL = "SELECT name FROM sqlite_master WHERE type='table' ORDER BY name"
 supports affected rows for update/delete? More...
 
 $sysDate = "adodb_date('Y-m-d')"
 
 $sysTimeStamp = "adodb_date('Y-m-d H:i:s')"
 
 $fmtTimeStamp = "'Y-m-d H:i:s'"
 
 $_genSeqSQL = "create table %s (id integer)"
 
 $_dropSeqSQL = 'drop table %s'
 

Detailed Description

Definition at line 23 of file adodb-sqlite3.inc.php.

Constructor & Destructor Documentation

◆ __construct()

ADODB_sqlite3::__construct ( )

Definition at line 36 of file adodb-sqlite3.inc.php.

Member Function Documentation

◆ _affectedrows()

ADODB_sqlite3::_affectedrows ( )

Definition at line 143 of file adodb-sqlite3.inc.php.

◆ _close()

ADODB_sqlite3::_close ( )

Definition at line 285 of file adodb-sqlite3.inc.php.

◆ _connect()

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

Definition at line 176 of file adodb-sqlite3.inc.php.

References _createFunctions().

Referenced by _pconnect().

◆ _createFunctions()

ADODB_sqlite3::_createFunctions ( )

Definition at line 168 of file adodb-sqlite3.inc.php.

Referenced by _connect().

◆ _init()

ADODB_sqlite3::_init (   $parentDriver)

Definition at line 132 of file adodb-sqlite3.inc.php.

◆ _insertid()

ADODB_sqlite3::_insertid ( )

Definition at line 138 of file adodb-sqlite3.inc.php.

◆ _pconnect()

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

Definition at line 188 of file adodb-sqlite3.inc.php.

References _connect().

◆ _query()

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

Definition at line 195 of file adodb-sqlite3.inc.php.

References $sql.

◆ BeginTrans()

ADODB_sqlite3::BeginTrans ( )

Definition at line 48 of file adodb-sqlite3.inc.php.

◆ CommitTrans()

ADODB_sqlite3::CommitTrans (   $ok = true)

Definition at line 58 of file adodb-sqlite3.inc.php.

References RollbackTrans().

◆ CreateSequence()

ADODB_sqlite3::CreateSequence (   $seqname = 'adodbseq',
  $start = 1 
)

Definition at line 262 of file adodb-sqlite3.inc.php.

◆ DropSequence()

ADODB_sqlite3::DropSequence (   $seqname = 'adodbseq')

Definition at line 276 of file adodb-sqlite3.inc.php.

◆ ErrorMsg()

ADODB_sqlite3::ErrorMsg ( )

Definition at line 148 of file adodb-sqlite3.inc.php.

References ErrorNo().

◆ ErrorNo()

ADODB_sqlite3::ErrorNo ( )

Definition at line 156 of file adodb-sqlite3.inc.php.

Referenced by ErrorMsg().

◆ GenID()

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

Definition at line 231 of file adodb-sqlite3.inc.php.

◆ MetaColumns()

ADODB_sqlite3::MetaColumns (   $table,
  $normalize = true 
)

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

References $rs.

◆ MetaIndexes()

ADODB_sqlite3::MetaIndexes (   $table,
  $primary = FALSE,
  $owner = false 
)

There must be a more elegant way of doing this, the index elements appear in the SQL statement in cols[1] between parentheses e.g CREATE UNIQUE INDEX ware_0 ON warehouse (org,warehouse)

Definition at line 290 of file adodb-sqlite3.inc.php.

References $rs.

◆ RollbackTrans()

ADODB_sqlite3::RollbackTrans ( )

Definition at line 73 of file adodb-sqlite3.inc.php.

Referenced by CommitTrans().

◆ SelectLimit()

ADODB_sqlite3::SelectLimit (   $sql,
  $nrows = -1,
  $offset = -1,
  $inputarr = false,
  $secs2cache = 0 
)

Definition at line 210 of file adodb-sqlite3.inc.php.

References $rs, and $sql.

◆ ServerInfo()

ADODB_sqlite3::ServerInfo ( )

Definition at line 40 of file adodb-sqlite3.inc.php.

◆ SQLDate()

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

Definition at line 161 of file adodb-sqlite3.inc.php.

Member Data Documentation

◆ $_dropSeqSQL

ADODB_sqlite3::$_dropSeqSQL = 'drop table %s'

Definition at line 275 of file adodb-sqlite3.inc.php.

◆ $_errorNo

ADODB_sqlite3::$_errorNo = 0

Definition at line 27 of file adodb-sqlite3.inc.php.

◆ $_genSeqSQL

ADODB_sqlite3::$_genSeqSQL = "create table %s (id integer)"

Definition at line 229 of file adodb-sqlite3.inc.php.

◆ $concat_operator

ADODB_sqlite3::$concat_operator ='||'

Definition at line 26 of file adodb-sqlite3.inc.php.

◆ $databaseType

ADODB_sqlite3::$databaseType = "sqlite3"

Definition at line 24 of file adodb-sqlite3.inc.php.

◆ $fmtTimeStamp

ADODB_sqlite3::$fmtTimeStamp = "'Y-m-d H:i:s'"

Definition at line 34 of file adodb-sqlite3.inc.php.

◆ $hasAffectedRows

ADODB_sqlite3::$hasAffectedRows = true

supports autoincrement ID?

Definition at line 30 of file adodb-sqlite3.inc.php.

◆ $hasInsertID

ADODB_sqlite3::$hasInsertID = true

Definition at line 29 of file adodb-sqlite3.inc.php.

◆ $hasLimit

ADODB_sqlite3::$hasLimit = true

Definition at line 28 of file adodb-sqlite3.inc.php.

◆ $metaTablesSQL

ADODB_sqlite3::$metaTablesSQL = "SELECT name FROM sqlite_master WHERE type='table' ORDER BY name"

supports affected rows for update/delete?

Definition at line 31 of file adodb-sqlite3.inc.php.

◆ $replaceQuote

ADODB_sqlite3::$replaceQuote = "''"

Definition at line 25 of file adodb-sqlite3.inc.php.

◆ $sysDate

ADODB_sqlite3::$sysDate = "adodb_date('Y-m-d')"

Definition at line 32 of file adodb-sqlite3.inc.php.

◆ $sysTimeStamp

ADODB_sqlite3::$sysTimeStamp = "adodb_date('Y-m-d H:i:s')"

Definition at line 33 of file adodb-sqlite3.inc.php.