ADODB_pdo_sqlite Class Reference

Inheritance diagram for ADODB_pdo_sqlite:

Public Member Functions
	_init ($parentDriver)
	ServerInfo ()
	SelectLimit ($sql, $nrows=-1, $offset=-1, $inputarr=false, $secs2cache=0)
	GenID ($seq='adodbseq', $start=1)
	CreateSequence ($seqname='adodbseq', $start=1)
	SetTransactionMode ($transaction_mode)
	BeginTrans ()
	CommitTrans ($ok=true)
	RollbackTrans ()
	MetaColumns ($tab, $normalize=true)
	MetaTables ($ttype=false, $showSchema=false, $mask=false)
Public Member Functions inherited from ADODB_pdo
	__construct ()
	_UpdatePDO ()
	Time ()
	_connect ($argDSN, $argUsername, $argPassword, $argDatabasename, $persist=false)
	Concat ()
	_pconnect ($argDSN, $argUsername, $argPassword, $argDatabasename)
	SelectLimit ($sql, $nrows=-1, $offset=-1, $inputarr=false, $secs2cache=0)
	ServerInfo ()
	MetaTables ($ttype=false, $showSchema=false, $mask=false)
	MetaColumns ($table, $normalize=true)
	InParameter (&$stmt, &$var, $name, $maxLen=4000, $type=false)
	OffsetDate ($dayFraction, $date=false)
	ErrorMsg ()
	ErrorNo ()
	SetTransactionMode ($transaction_mode)
	BeginTrans ()
	CommitTrans ($ok=true)
	RollbackTrans ()
	Prepare ($sql)
	PrepareStmt ($sql)
	CreateSequence ($seqname='adodbseq', $startID=1)
	DropSequence ($seqname='adodbseq')
	GenID ($seqname='adodbseq', $startID=1)
	_query ($sql, $inputarr=false)
	_close ()
	_affectedrows ()
	_insertid ()

Public Attributes
	$metaTablesSQL = "SELECT name FROM sqlite_master WHERE type='table'"
	$sysDate = 'current_date'
	$sysTimeStamp = 'current_timestamp'
	$nameQuote = '`'
	$replaceQuote = "''"
	$hasGenID = true
	$_genIDSQL = "UPDATE %s SET id=id+1 WHERE id=%s"
	$_genSeqSQL = "CREATE TABLE %s (id integer)"
	$_genSeqCountSQL = 'SELECT COUNT(*) FROM %s'
	$_genSeq2SQL = 'INSERT INTO %s VALUES(%s)'
	$_dropSeqSQL = 'DROP TABLE %s'
	$concat_operator = '||'
	$pdoDriver = false
	$random ='abs(random())'
Public Attributes inherited from ADODB_pdo
	$databaseType = "pdo"
	$dataProvider = "pdo"
	$fmtDate = "'Y-m-d'"
	$fmtTimeStamp = "'Y-m-d, h:i:sA'"
	$replaceQuote = "''"
	$hasAffectedRows = true
	$_bindInputArray = true
	$_genIDSQL
	$_genSeqSQL = "create table %s (id integer)"
	$_dropSeqSQL
	$_autocommit = true
	$_haserrorfunctions = true
	$_lastAffectedRows = 0
	$_errormsg = false
	$_errorno = false
	$dsnType = ''
	$stmt = false
	$_driver

Detailed Description

Definition at line 18 of file adodb-pdo_sqlite.inc.php.

Member Function Documentation

_init()

ADODB_pdo_sqlite::_init

(

$parentDriver

)

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

BeginTrans()

ADODB_pdo_sqlite::BeginTrans

(

)

Definition at line 115 of file adodb-pdo_sqlite.inc.php.

References $pdoDriver.

CommitTrans()

ADODB_pdo_sqlite::CommitTrans

(

$ok = true

)

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

References $pdoDriver.

CreateSequence()

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

Definition at line 100 of file adodb-pdo_sqlite.inc.php.

References $pdoDriver.

GenID()

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

Definition at line 68 of file adodb-pdo_sqlite.inc.php.

References $pdoDriver.

MetaColumns()

ADODB_pdo_sqlite::MetaColumns	(		$tab,
			$normalize = true
	)

Definition at line 149 of file adodb-pdo_sqlite.inc.php.

References $pdoDriver, and $rs.

MetaTables()

ADODB_pdo_sqlite::MetaTables	(		$ttype = false,
			$showSchema = false,
			$mask = false
	)

Definition at line 187 of file adodb-pdo_sqlite.inc.php.

References $metaTablesSQL, and $pdoDriver.

RollbackTrans()

ADODB_pdo_sqlite::RollbackTrans

(

)

Definition at line 136 of file adodb-pdo_sqlite.inc.php.

References $pdoDriver.

SelectLimit()

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

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

References $pdoDriver, $rs, and $sql.

ServerInfo()

ADODB_pdo_sqlite::ServerInfo

(

)

Definition at line 42 of file adodb-pdo_sqlite.inc.php.

References $pdoDriver.

SetTransactionMode()

ADODB_pdo_sqlite::SetTransactionMode

(

$transaction_mode

)

Definition at line 109 of file adodb-pdo_sqlite.inc.php.

References $pdoDriver.

Member Data Documentation

$_dropSeqSQL

ADODB_pdo_sqlite::$_dropSeqSQL = 'DROP TABLE %s'

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

$_genIDSQL

ADODB_pdo_sqlite::$_genIDSQL = "UPDATE %s SET id=id+1 WHERE id=%s"

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

$_genSeq2SQL

ADODB_pdo_sqlite::$_genSeq2SQL = 'INSERT INTO %s VALUES(%s)'

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

$_genSeqCountSQL

ADODB_pdo_sqlite::$_genSeqCountSQL = 'SELECT COUNT(*) FROM %s'

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

$_genSeqSQL

ADODB_pdo_sqlite::$_genSeqSQL = "CREATE TABLE %s (id integer)"

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

$concat_operator

ADODB_pdo_sqlite::$concat_operator = '||'

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

$hasGenID

ADODB_pdo_sqlite::$hasGenID = true

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

$metaTablesSQL

ADODB_pdo_sqlite::$metaTablesSQL = "SELECT name FROM sqlite_master WHERE type='table'"

Definition at line 19 of file adodb-pdo_sqlite.inc.php.

Referenced by MetaTables().

$nameQuote

ADODB_pdo_sqlite::$nameQuote = '`'

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

$pdoDriver

ADODB_pdo_sqlite::$pdoDriver = false

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

Referenced by BeginTrans(), CommitTrans(), CreateSequence(), GenID(), MetaColumns(), MetaTables(), RollbackTrans(), SelectLimit(), ServerInfo(), and SetTransactionMode().

$random

ADODB_pdo_sqlite::$random ='abs(random())'

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

$replaceQuote

ADODB_pdo_sqlite::$replaceQuote = "''"

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

$sysDate

ADODB_pdo_sqlite::$sysDate = 'current_date'

Definition at line 20 of file adodb-pdo_sqlite.inc.php.

$sysTimeStamp

ADODB_pdo_sqlite::$sysTimeStamp = 'current_timestamp'

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