TYPO3 CMS
TYPO3_6-2
|
Public Member Functions | |
ADODB_sqlite () | |
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) | |
_close () | |
MetaIndexes ($table, $primary=FALSE, $owner=false, $owner=false) | |
Public Attributes | |
$databaseType = "sqlite" | |
$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' | |
Definition at line 21 of file adodb-sqlite.inc.php.
ADODB_sqlite::_affectedrows | ( | ) |
Definition at line 129 of file adodb-sqlite.inc.php.
ADODB_sqlite::_close | ( | ) |
Definition at line 260 of file adodb-sqlite.inc.php.
ADODB_sqlite::_connect | ( | $argHostname, | |
$argUsername, | |||
$argPassword, | |||
$argDatabasename | |||
) |
Definition at line 160 of file adodb-sqlite.inc.php.
References _createFunctions().
ADODB_sqlite::_createFunctions | ( | ) |
Definition at line 152 of file adodb-sqlite.inc.php.
Referenced by _connect(), and _pconnect().
ADODB_sqlite::_init | ( | $parentDriver | ) |
Definition at line 117 of file adodb-sqlite.inc.php.
ADODB_sqlite::_insertid | ( | ) |
Definition at line 124 of file adodb-sqlite.inc.php.
ADODB_sqlite::_pconnect | ( | $argHostname, | |
$argUsername, | |||
$argPassword, | |||
$argDatabasename | |||
) |
Definition at line 172 of file adodb-sqlite.inc.php.
References _createFunctions().
ADODB_sqlite::_query | ( | $sql, | |
$inputarr = false |
|||
) |
Definition at line 184 of file adodb-sqlite.inc.php.
References $sql.
ADODB_sqlite::ADODB_sqlite | ( | ) |
Definition at line 34 of file adodb-sqlite.inc.php.
Referenced by ADODB_sqlitepo\ADODB_sqlitepo().
ADODB_sqlite::BeginTrans | ( | ) |
Definition at line 55 of file adodb-sqlite.inc.php.
ADODB_sqlite::CommitTrans | ( | $ok = true | ) |
Definition at line 63 of file adodb-sqlite.inc.php.
References RollbackTrans().
ADODB_sqlite::CreateSequence | ( | $seqname = 'adodbseq' , |
|
$start = 1 |
|||
) |
Definition at line 243 of file adodb-sqlite.inc.php.
ADODB_sqlite::DropSequence | ( | $seqname | ) |
Definition at line 253 of file adodb-sqlite.inc.php.
ADODB_sqlite::ErrorMsg | ( | ) |
Definition at line 134 of file adodb-sqlite.inc.php.
ADODB_sqlite::ErrorNo | ( | ) |
Definition at line 140 of file adodb-sqlite.inc.php.
References $_errorNo.
ADODB_sqlite::GenID | ( | $seq = 'adodbseq' , |
|
$start = 1 |
|||
) |
Definition at line 214 of file adodb-sqlite.inc.php.
ADODB_sqlite::MetaColumns | ( | $table, | |
$normalize = true |
|||
) |
Definition at line 81 of file adodb-sqlite.inc.php.
References $rs.
ADODB_sqlite::MetaIndexes | ( | $table, | |
$primary = FALSE , |
|||
$owner = 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 265 of file adodb-sqlite.inc.php.
References $rs.
ADODB_sqlite::RollbackTrans | ( | ) |
Definition at line 72 of file adodb-sqlite.inc.php.
Referenced by CommitTrans().
ADODB_sqlite::SelectLimit | ( | $sql, | |
$nrows = -1 , |
|||
$offset = -1 , |
|||
$inputarr = false , |
|||
$secs2cache = 0 |
|||
) |
Definition at line 194 of file adodb-sqlite.inc.php.
ADODB_sqlite::ServerInfo | ( | ) |
Definition at line 47 of file adodb-sqlite.inc.php.
ADODB_sqlite::SQLDate | ( | $fmt, | |
$col = false |
|||
) |
Definition at line 145 of file adodb-sqlite.inc.php.
ADODB_sqlite::$_dropSeqSQL = 'drop table %s' |
Definition at line 252 of file adodb-sqlite.inc.php.
ADODB_sqlite::$_errorNo = 0 |
Definition at line 25 of file adodb-sqlite.inc.php.
Referenced by ErrorNo().
ADODB_sqlite::$_genSeqSQL = "create table %s (id integer)" |
Definition at line 212 of file adodb-sqlite.inc.php.
ADODB_sqlite::$concat_operator ='||' |
Definition at line 24 of file adodb-sqlite.inc.php.
ADODB_sqlite::$databaseType = "sqlite" |
Definition at line 22 of file adodb-sqlite.inc.php.
ADODB_sqlite::$fmtTimeStamp = "'Y-m-d H:i:s'" |
Definition at line 32 of file adodb-sqlite.inc.php.
ADODB_sqlite::$hasAffectedRows = true |
supports autoincrement ID?
Definition at line 28 of file adodb-sqlite.inc.php.
ADODB_sqlite::$hasInsertID = true |
Definition at line 27 of file adodb-sqlite.inc.php.
ADODB_sqlite::$hasLimit = true |
Definition at line 26 of file adodb-sqlite.inc.php.
ADODB_sqlite::$metaTablesSQL = "SELECT name FROM sqlite_master WHERE type='table' ORDER BY name" |
supports affected rows for update/delete?
Definition at line 29 of file adodb-sqlite.inc.php.
ADODB_sqlite::$replaceQuote = "''" |
Definition at line 23 of file adodb-sqlite.inc.php.
ADODB_sqlite::$sysDate = "adodb_date('Y-m-d')" |
Definition at line 30 of file adodb-sqlite.inc.php.
ADODB_sqlite::$sysTimeStamp = "adodb_date('Y-m-d H:i:s')" |
Definition at line 31 of file adodb-sqlite.inc.php.