Inheritance diagram for ADODB_sqlite3:

Public Member Functions
	ADODB_sqlite3 ()

	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 = "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 22 of file adodb-sqlite3.inc.php.

Member Function Documentation

◆ _affectedrows()

ADODB_sqlite3::_affectedrows ( )

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

◆ _close()

ADODB_sqlite3::_close ( )

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

◆ _connect()

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

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

References _createFunctions().

◆ _createFunctions()

ADODB_sqlite3::_createFunctions ( )

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

Referenced by _connect(), and _pconnect().

◆ _init()

ADODB_sqlite3::_init ( $parentDriver )

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

◆ _insertid()

ADODB_sqlite3::_insertid ( )

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

◆ _pconnect()

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

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

References _createFunctions().

◆ _query()

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

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

References $sql.

◆ ADODB_sqlite3()

ADODB_sqlite3::ADODB_sqlite3 ( )

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

◆ BeginTrans()

ADODB_sqlite3::BeginTrans ( )

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

◆ CommitTrans()

ADODB_sqlite3::CommitTrans ( $ok = true )

Definition at line 66 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 )

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

◆ ErrorMsg()

ADODB_sqlite3::ErrorMsg ( )

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

References ErrorNo().

◆ ErrorNo()

ADODB_sqlite3::ErrorNo ( )

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

Referenced by ErrorMsg().

◆ GenID()

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

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

◆ MetaColumns()

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

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

References $rs.

◆ MetaIndexes()

ADODB_sqlite3::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 285 of file adodb-sqlite3.inc.php.

References $rs.

◆ RollbackTrans()

ADODB_sqlite3::RollbackTrans ( )

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

References $rs, and $sql.

◆ ServerInfo()

ADODB_sqlite3::ServerInfo ( )

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

◆ SQLDate()

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

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

Member Data Documentation

◆ $_dropSeqSQL

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

Definition at line 271 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 231 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.

Public Member Functions

Public Attributes