ADODB_sqlite Class Reference

Inheritance diagram for ADODB_sqlite:

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)
Data Fields
	$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

_affectedrows

(

)

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

_close

(

)

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

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

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

Here is the call graph for this function:

_createFunctions

(

)

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

Here is the caller graph for this function:

_init

(

$

parentDriver

)

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

_insertid

(

)

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

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

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

Here is the call graph for this function:

_query	(	$	sql,
		$	inputarr = false
	)

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

ADODB_sqlite

(

)

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

Here is the caller graph for this function:

BeginTrans

(

)

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

CommitTrans

(

$

ok = true

)

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

Here is the call graph for this function:

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

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

DropSequence

(

$

seqname

)

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

ErrorMsg

(

)

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

ErrorNo

(

)

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

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

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

MetaColumns	(	$	table,
		$	normalize = true
	)

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

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.

RollbackTrans

(

)

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

Here is the caller graph for this function:

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

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

ServerInfo

(

)

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

SQLDate	(	$	fmt,
		$	col = false
	)

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

---

Field Documentation

$_dropSeqSQL = 'drop table %s'

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

$_errorNo = 0

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

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

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

$concat_operator = '||'

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

$databaseType = "sqlite"

Reimplemented in ADODB_sqlitepo.

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

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

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

$hasAffectedRows = true

supports autoincrement ID?

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

$hasInsertID = true

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

$hasLimit = true

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

$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.

$replaceQuote = "''"

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

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

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

$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:

• C:/xampp/htdocs/moodle/lib/adodb/drivers/adodb-sqlite.inc.php