ADODB_sqlite3 Class Reference

Inheritance diagram for ADODB_sqlite3:

Public Member Functions
	__construct ()
	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='adodbseq')
	_close ()
	MetaIndexes ($table, $primary=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 23 of file adodb-sqlite3.inc.php.

Constructor & Destructor Documentation

__construct()

ADODB_sqlite3::__construct

(

)

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

Member Function Documentation

_affectedrows()

ADODB_sqlite3::_affectedrows

(

)

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

_close()

ADODB_sqlite3::_close

(

)

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

_connect()

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

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

References _createFunctions().

Referenced by _pconnect().

_createFunctions()

ADODB_sqlite3::_createFunctions

(

)

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

Referenced by _connect().

_init()

ADODB_sqlite3::_init

(

$parentDriver

)

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

_insertid()

ADODB_sqlite3::_insertid

(

)

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

_pconnect()

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

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

References _connect().

_query()

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

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

References $sql.

BeginTrans()

ADODB_sqlite3::BeginTrans

(

)

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

CommitTrans()

ADODB_sqlite3::CommitTrans

(

$ok = true

)

Definition at line 58 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 = 'adodbseq'

)

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

ErrorMsg()

ADODB_sqlite3::ErrorMsg

(

)

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

References ErrorNo().

ErrorNo()

ADODB_sqlite3::ErrorNo

(

)

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

Referenced by ErrorMsg().

GenID()

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

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

MetaColumns()

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

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

References $rs.

MetaIndexes()

ADODB_sqlite3::MetaIndexes	(		$table,
			$primary = 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 290 of file adodb-sqlite3.inc.php.

References $rs.

RollbackTrans()

ADODB_sqlite3::RollbackTrans

(

)

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

References $rs, and $sql.

ServerInfo()

ADODB_sqlite3::ServerInfo

(

)

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

SQLDate()

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

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

Member Data Documentation

$_dropSeqSQL

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

Definition at line 275 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 229 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.