ADODB_sqlite Class Reference

Inheritance diagram for ADODB_sqlite:

List of all members.

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?
	$metaTablesSQL = "SELECT name FROM sqlite_master WHERE type='table' ORDER BY name"
	supports affected rows for update/delete?
	$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 21 of file adodb-sqlite.inc.php.

---

Member Function Documentation

ADODB_sqlite::_affectedrows

(

)

Definition at line 128 of file adodb-sqlite.inc.php.

ADODB_sqlite::_close

(

)

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

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

Definition at line 159 of file adodb-sqlite.inc.php.

References _createFunctions().

Here is the call graph for this function:

ADODB_sqlite::_createFunctions

(

)

Definition at line 151 of file adodb-sqlite.inc.php.

Referenced by _connect(), and _pconnect().

Here is the caller graph for this function:

ADODB_sqlite::_init

(

$

parentDriver

)

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

ADODB_sqlite::_insertid

(

)

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

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

Definition at line 171 of file adodb-sqlite.inc.php.

References _createFunctions().

Here is the call graph for this function:

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

Definition at line 183 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().

Here is the caller graph for this function:

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().

Here is the call graph for this function:

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

Definition at line 242 of file adodb-sqlite.inc.php.

ADODB_sqlite::DropSequence

(

$

seqname

)

Definition at line 252 of file adodb-sqlite.inc.php.

ADODB_sqlite::ErrorMsg

(

)

Definition at line 133 of file adodb-sqlite.inc.php.

ADODB_sqlite::ErrorNo

(

)

Definition at line 139 of file adodb-sqlite.inc.php.

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

Definition at line 213 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 264 of file adodb-sqlite.inc.php.

References $row, and $rs.

ADODB_sqlite::RollbackTrans

(

)

Definition at line 72 of file adodb-sqlite.inc.php.

Referenced by CommitTrans().

Here is the caller graph for this function:

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

Definition at line 193 of file adodb-sqlite.inc.php.

References $rs, and $sql.

ADODB_sqlite::ServerInfo

(

)

Definition at line 47 of file adodb-sqlite.inc.php.

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

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

---

Member Data Documentation

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

Definition at line 251 of file adodb-sqlite.inc.php.

ADODB_sqlite::$_errorNo = 0

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

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

Definition at line 211 of file adodb-sqlite.inc.php.

ADODB_sqlite::$concat_operator = '||'

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

ADODB_sqlite::$databaseType = "sqlite"

Reimplemented in ADODB_sqlitepo.

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.

---

The documentation for this class was generated from the following file:

• typo3/sysext/adodb/adodb/drivers/adodb-sqlite.inc.php