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)

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'

Detailed Description

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

Member Function Documentation

◆ _affectedrows()

ADODB_sqlite::_affectedrows ( )

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

◆ _close()

ADODB_sqlite::_close ( )

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

◆ _connect()

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

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

References _createFunctions().

◆ _createFunctions()

ADODB_sqlite::_createFunctions ( )

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

Referenced by _connect(), and _pconnect().

◆ _init()

ADODB_sqlite::_init ( $parentDriver )

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

◆ _insertid()

ADODB_sqlite::_insertid ( )

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

◆ _pconnect()

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

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

References _createFunctions().

◆ _query()

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

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

References $sql.

◆ ADODB_sqlite()

ADODB_sqlite::ADODB_sqlite ( )

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

Referenced by ADODB_sqlitepo\ADODB_sqlitepo().

◆ BeginTrans()

ADODB_sqlite::BeginTrans ( )

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

◆ CommitTrans()

ADODB_sqlite::CommitTrans ( $ok = true )

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

References RollbackTrans().

◆ CreateSequence()

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

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

◆ DropSequence()

ADODB_sqlite::DropSequence ( $seqname )

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

◆ ErrorMsg()

ADODB_sqlite::ErrorMsg ( )

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

◆ ErrorNo()

ADODB_sqlite::ErrorNo ( )

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

References $_errorNo.

◆ GenID()

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

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

◆ MetaColumns()

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

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

References $rs.

◆ MetaIndexes()

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.

◆ RollbackTrans()

ADODB_sqlite::RollbackTrans ( )

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

Referenced by CommitTrans().

◆ SelectLimit()

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

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

References $rs, and $sql.

◆ ServerInfo()

ADODB_sqlite::ServerInfo ( )

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

◆ SQLDate()

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

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

Member Data Documentation

◆ $_dropSeqSQL

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

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

◆ $_errorNo

ADODB_sqlite::$_errorNo = 0

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

Referenced by ErrorNo().

◆ $_genSeqSQL

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

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

◆ $concat_operator

ADODB_sqlite::$concat_operator ='||'

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

◆ $databaseType

ADODB_sqlite::$databaseType = "sqlite"

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

◆ $fmtTimeStamp

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

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

◆ $hasAffectedRows

ADODB_sqlite::$hasAffectedRows = true

supports autoincrement ID?

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

◆ $hasInsertID

ADODB_sqlite::$hasInsertID = true

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

◆ $hasLimit

ADODB_sqlite::$hasLimit = true

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

◆ $metaTablesSQL

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.

◆ $replaceQuote

ADODB_sqlite::$replaceQuote = "''"

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

◆ $sysDate

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

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

◆ $sysTimeStamp

ADODB_sqlite::$sysTimeStamp = "adodb_date('Y-m-d H:i:s')"

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

Public Member Functions

Public Attributes