ADODB_sqlite Class Reference

Inheritance diagram for ADODB_sqlite:

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

Constructor & Destructor Documentation

__construct()

ADODB_sqlite::__construct

(

)

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

Member Function Documentation

_affectedrows()

ADODB_sqlite::_affectedrows

(

)

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

_close()

ADODB_sqlite::_close

(

)

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

_connect()

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

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

References _createFunctions().

_createFunctions()

ADODB_sqlite::_createFunctions

(

)

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

Referenced by _connect(), and _pconnect().

_init()

ADODB_sqlite::_init

(

$parentDriver

)

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

_insertid()

ADODB_sqlite::_insertid

(

)

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

_pconnect()

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

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

References _createFunctions().

_query()

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

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

References $sql.

BeginTrans()

ADODB_sqlite::BeginTrans

(

)

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

CommitTrans()

ADODB_sqlite::CommitTrans

(

$ok = true

)

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

References RollbackTrans().

CreateSequence()

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

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

DropSequence()

ADODB_sqlite::DropSequence

(

$seqname = 'adodbseq'

)

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

ErrorMsg()

ADODB_sqlite::ErrorMsg

(

)

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

ErrorNo()

ADODB_sqlite::ErrorNo

(

)

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

References $_errorNo.

GenID()

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

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

MetaColumns()

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

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

References $rs.

MetaIndexes()

ADODB_sqlite::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 307 of file adodb-sqlite.inc.php.

References $rs.

RollbackTrans()

ADODB_sqlite::RollbackTrans

(

)

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

References $rs, and $sql.

ServerInfo()

ADODB_sqlite::ServerInfo

(

)

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

SQLDate()

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

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

Member Data Documentation

$_dropSeqSQL

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

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

$_errorNo

ADODB_sqlite::$_errorNo = 0

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

Referenced by ErrorNo().

$_genSeqSQL

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

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

$concat_operator

ADODB_sqlite::$concat_operator ='||'

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

$databaseType

ADODB_sqlite::$databaseType = "sqlite"

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

$fmtTimeStamp

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

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

$hasAffectedRows

ADODB_sqlite::$hasAffectedRows = true

supports autoincrement ID?

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

$hasInsertID

ADODB_sqlite::$hasInsertID = true

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

$hasLimit

ADODB_sqlite::$hasLimit = true

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

$replaceQuote

ADODB_sqlite::$replaceQuote = "''"

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

$sysDate

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

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

$sysTimeStamp

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

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