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

Public Member Functions

 _init ($parentDriver)
 
 ServerInfo ()
 
 SelectLimit ($sql, $nrows=-1, $offset=-1, $inputarr=false, $secs2cache=0)
 
 GenID ($seq='adodbseq', $start=1)
 
 CreateSequence ($seqname='adodbseq', $start=1)
 
 SetTransactionMode ($transaction_mode)
 
 BeginTrans ()
 
 CommitTrans ($ok=true)
 
 RollbackTrans ()
 
 MetaColumns ($tab, $normalize=true)
 
 MetaTables ($ttype=false, $showSchema=false, $mask=false)
 
- Public Member Functions inherited from ADODB_pdo
 ADODB_pdo ()
 
 _UpdatePDO ()
 
 Time ()
 
 _connect ($argDSN, $argUsername, $argPassword, $argDatabasename, $persist=false)
 
 Concat ()
 
 _pconnect ($argDSN, $argUsername, $argPassword, $argDatabasename)
 
 SelectLimit ($sql, $nrows=-1, $offset=-1, $inputarr=false, $secs2cache=0)
 
 ServerInfo ()
 
 MetaTables ($ttype=false, $showSchema=false, $mask=false)
 
 MetaColumns ($table, $normalize=true)
 
 InParameter (&$stmt, &$var, $name, $maxLen=4000, $type=false)
 
 OffsetDate ($dayFraction, $date=false)
 
 ErrorMsg ()
 
 ErrorNo ()
 
 SetTransactionMode ($transaction_mode)
 
 BeginTrans ()
 
 CommitTrans ($ok=true)
 
 RollbackTrans ()
 
 Prepare ($sql)
 
 PrepareStmt ($sql)
 
 CreateSequence ($seqname='adodbseq', $startID=1)
 
 DropSequence ($seqname='adodbseq')
 
 GenID ($seqname='adodbseq', $startID=1)
 
 _query ($sql, $inputarr=false)
 
 _close ()
 
 _affectedrows ()
 
 _insertid ()
 

Public Attributes

 $metaTablesSQL = "SELECT name FROM sqlite_master WHERE type='table'"
 
 $sysDate = 'current_date'
 
 $sysTimeStamp = 'current_timestamp'
 
 $nameQuote = '`'
 
 $replaceQuote = "''"
 
 $hasGenID = true
 
 $_genIDSQL = "UPDATE %s SET id=id+1 WHERE id=%s"
 
 $_genSeqSQL = "CREATE TABLE %s (id integer)"
 
 $_genSeqCountSQL = 'SELECT COUNT(*) FROM %s'
 
 $_genSeq2SQL = 'INSERT INTO %s VALUES(%s)'
 
 $_dropSeqSQL = 'DROP TABLE %s'
 
 $concat_operator = '||'
 
 $pdoDriver = false
 
 $random ='abs(random())'
 
- Public Attributes inherited from ADODB_pdo
 $databaseType = "pdo"
 
 $dataProvider = "pdo"
 
 $fmtDate = "'Y-m-d'"
 
 $fmtTimeStamp = "'Y-m-d, h:i:sA'"
 
 $replaceQuote = "''"
 
 $hasAffectedRows = true
 
 $_bindInputArray = true
 
 $_genSeqSQL = "create table %s (id integer)"
 
 $_autocommit = true
 
 $_haserrorfunctions = true
 
 $_lastAffectedRows = 0
 
 $_errormsg = false
 
 $_errorno = false
 
 $dsnType = ''
 
 $stmt = false
 

Detailed Description

Definition at line 16 of file adodb-pdo_sqlite.inc.php.

Member Function Documentation

◆ _init()

ADODB_pdo_sqlite::_init (   $parentDriver)

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

◆ BeginTrans()

ADODB_pdo_sqlite::BeginTrans ( )

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

References $pdoDriver.

◆ CommitTrans()

ADODB_pdo_sqlite::CommitTrans (   $ok = true)

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

References $pdoDriver.

◆ CreateSequence()

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

Definition at line 98 of file adodb-pdo_sqlite.inc.php.

References $pdoDriver.

◆ GenID()

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

Definition at line 66 of file adodb-pdo_sqlite.inc.php.

References $pdoDriver.

◆ MetaColumns()

ADODB_pdo_sqlite::MetaColumns (   $tab,
  $normalize = true 
)

Definition at line 147 of file adodb-pdo_sqlite.inc.php.

References $pdoDriver, and $rs.

◆ MetaTables()

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

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

References $metaTablesSQL, and $pdoDriver.

◆ RollbackTrans()

ADODB_pdo_sqlite::RollbackTrans ( )

Definition at line 134 of file adodb-pdo_sqlite.inc.php.

References $pdoDriver.

◆ SelectLimit()

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

Definition at line 53 of file adodb-pdo_sqlite.inc.php.

References $pdoDriver, $rs, and $sql.

◆ ServerInfo()

ADODB_pdo_sqlite::ServerInfo ( )

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

References $pdoDriver.

◆ SetTransactionMode()

ADODB_pdo_sqlite::SetTransactionMode (   $transaction_mode)

Definition at line 107 of file adodb-pdo_sqlite.inc.php.

References $pdoDriver.

Member Data Documentation

◆ $_dropSeqSQL

ADODB_pdo_sqlite::$_dropSeqSQL = 'DROP TABLE %s'

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

◆ $_genIDSQL

ADODB_pdo_sqlite::$_genIDSQL = "UPDATE %s SET id=id+1 WHERE id=%s"

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

◆ $_genSeq2SQL

ADODB_pdo_sqlite::$_genSeq2SQL = 'INSERT INTO %s VALUES(%s)'

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

◆ $_genSeqCountSQL

ADODB_pdo_sqlite::$_genSeqCountSQL = 'SELECT COUNT(*) FROM %s'

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

◆ $_genSeqSQL

ADODB_pdo_sqlite::$_genSeqSQL = "CREATE TABLE %s (id integer)"

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

◆ $concat_operator

ADODB_pdo_sqlite::$concat_operator = '||'

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

◆ $hasGenID

ADODB_pdo_sqlite::$hasGenID = true

Definition at line 22 of file adodb-pdo_sqlite.inc.php.

◆ $metaTablesSQL

ADODB_pdo_sqlite::$metaTablesSQL = "SELECT name FROM sqlite_master WHERE type='table'"

Definition at line 17 of file adodb-pdo_sqlite.inc.php.

Referenced by MetaTables().

◆ $nameQuote

ADODB_pdo_sqlite::$nameQuote = '`'

Definition at line 20 of file adodb-pdo_sqlite.inc.php.

◆ $pdoDriver

ADODB_pdo_sqlite::$pdoDriver = false

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

Referenced by BeginTrans(), CommitTrans(), CreateSequence(), GenID(), MetaColumns(), MetaTables(), RollbackTrans(), SelectLimit(), ServerInfo(), and SetTransactionMode().

◆ $random

ADODB_pdo_sqlite::$random ='abs(random())'

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

◆ $replaceQuote

ADODB_pdo_sqlite::$replaceQuote = "''"

Definition at line 21 of file adodb-pdo_sqlite.inc.php.

◆ $sysDate

ADODB_pdo_sqlite::$sysDate = 'current_date'

Definition at line 18 of file adodb-pdo_sqlite.inc.php.

◆ $sysTimeStamp

ADODB_pdo_sqlite::$sysTimeStamp = 'current_timestamp'

Definition at line 19 of file adodb-pdo_sqlite.inc.php.