Jelix 1.6.40

sqlite3DaoBuilder extends jDaoGenerator
in package

driver for jDaoCompiler

Tags
subpackage

db_driver

Table of Contents

$_DaoClassName  : string
the DAO classname
$_daoId  : mixed
$_daoPath  : mixed
$_DaoRecordClassName  : string
The DaoRecord ClassName
$_dataParser  : jDaoParser
the dao definition.
$_dbType  : mixed
$aliasWord  : mixed
$propertiesListForInsert  : mixed
$sqlFromClause  : mixed
$sqlSelectClause  : mixed
$sqlWhereClause  : mixed
$tableRealName  : mixed
the real name of the main table
$tableRealNameEsc  : mixed
the real name of the main table, escaped in SQL so it is ready to include into a SQL query.
$tools  : jDbTools
__construct()  : mixed
constructor
buildClasses()  : mixed
build all classes
_captureAll()  : mixed
_captureBinaryField()  : mixed
_captureFieldToUpdate()  : mixed
_captureFieldToUpdateOnUpdate()  : mixed
_capturePrimaryFieldsExcludeAutoIncrement()  : mixed
_capturePrimaryFieldsExcludePk()  : mixed
_capturePrimaryTable()  : mixed
_encloseName()  : mixed
_getPrimaryFieldsList()  : mixed
_preparePHPCallbackExpr()  : mixed
_preparePHPExpr()  : mixed
_prepareValues()  : mixed
_writeFieldNamesWith()  : mixed
format field names with start, end and between strings.
_writeFieldsInfoWith()  : string
format field names with a start, an end and a between strings.
buildCountUserQuery()  : mixed
buildDeleteUserQuery()  : mixed
buildEndOfClass()  : mixed
buildFromWhereClause()  : mixed
create FROM clause and WHERE clause for all SELECT query
buildInsertMethod()  : string
build the insert() method in the final class
buildOuterJoins()  : array<string|int, mixed>
generates the part of the FROM clause for outer joins
buildSelectClause()  : string
build a SELECT clause for all SELECT queries
buildSelectPattern()  : mixed
build an item for the select clause
buildSelectUserQuery()  : mixed
buildUpdateAutoIncrementPK()  : mixed
buildUpdateMethod()  : string
build the update() method for the final class
buildUpdateUserQuery()  : mixed
buildUserMethods()  : string
build all methods defined by the developer in the dao file
getAutoIncrementPKField()  : mixed
get autoincrement PK field
parseSQLFunction()  : mixed

Properties

$_DaoRecordClassName

The DaoRecord ClassName

protected string $_DaoRecordClassName = ull

$propertiesListForInsert

protected mixed $propertiesListForInsert = 'PrimaryFieldsExcludeAutoIncrement'

$tableRealNameEsc

the real name of the main table, escaped in SQL so it is ready to include into a SQL query.

protected mixed $tableRealNameEsc = ''

Methods

buildClasses()

build all classes

public buildClasses() : mixed
Return values
mixed

_captureAll()

protected _captureAll(mixed &$field) : mixed
Parameters
$field : mixed
Return values
mixed

_captureBinaryField()

protected _captureBinaryField(mixed &$field) : mixed
Parameters
$field : mixed
Return values
mixed

_captureFieldToUpdate()

protected _captureFieldToUpdate(mixed &$field) : mixed
Parameters
$field : mixed
Return values
mixed

_captureFieldToUpdateOnUpdate()

protected _captureFieldToUpdateOnUpdate(mixed &$field) : mixed
Parameters
$field : mixed
Return values
mixed

_capturePrimaryFieldsExcludeAutoIncrement()

protected _capturePrimaryFieldsExcludeAutoIncrement(mixed &$field) : mixed
Parameters
$field : mixed
Return values
mixed

_capturePrimaryFieldsExcludePk()

protected _capturePrimaryFieldsExcludePk(mixed &$field) : mixed
Parameters
$field : mixed
Return values
mixed

_capturePrimaryTable()

protected _capturePrimaryTable(mixed &$field) : mixed
Parameters
$field : mixed
Return values
mixed

_encloseName()

protected _encloseName(mixed $name) : mixed
Parameters
$name : mixed
Return values
mixed

_getPrimaryFieldsList()

protected _getPrimaryFieldsList() : mixed
Return values
mixed

_preparePHPCallbackExpr()

protected _preparePHPCallbackExpr(mixed $field) : mixed
Parameters
$field : mixed
Return values
mixed

_preparePHPExpr()

protected _preparePHPExpr(mixed $expr, mixed $field[, mixed $checknull = true ][, mixed $forCondition = '' ]) : mixed
Parameters
$expr : mixed
$field : mixed
$checknull : mixed = true
$forCondition : mixed = ''
Return values
mixed

_prepareValues()

protected _prepareValues(mixed $fieldList[, mixed $pattern = '' ][, mixed $prefixfield = '' ]) : mixed
Parameters
$fieldList : mixed
$pattern : mixed = ''
$prefixfield : mixed = ''
Return values
mixed

_writeFieldNamesWith()

format field names with start, end and between strings.

protected _writeFieldNamesWith([mixed $start = '' ][, mixed $end = '' ][, mixed $beetween = '' ][, mixed $using = null ]) : mixed
Parameters
$start : mixed = ''
$end : mixed = ''
$beetween : mixed = ''
$using : mixed = null
Return values
mixed

_writeFieldsInfoWith()

format field names with a start, an end and a between strings.

protected _writeFieldsInfoWith(string $info[, string $start = '' ][, string $end = '' ][, string $beetween = '' ][, array<string|int, jDaoProperty$using = null ]) : string

ex: give 'name' as $info, it will output the result of $field->name

Parameters
$info : string

property to get from objects in $using

$start : string = ''

string to add before the info

$end : string = ''

string to add after the info

$beetween : string = ''

string to add between each info

$using : array<string|int, jDaoProperty> = null

list of jDaoProperty object. if null, get default fields list

Tags
see
jDaoProperty
Return values
string

list of field names separated by the $between character

buildCountUserQuery()

protected buildCountUserQuery(mixed $method, mixed &$src, mixed &$allField) : mixed
Parameters
$method : mixed
$src : mixed
$allField : mixed
Return values
mixed

buildDeleteUserQuery()

protected buildDeleteUserQuery(mixed $method, mixed &$src, mixed &$primaryFields) : mixed
Parameters
$method : mixed
$src : mixed
$primaryFields : mixed
Return values
mixed

buildFromWhereClause()

create FROM clause and WHERE clause for all SELECT query

protected buildFromWhereClause() : mixed
Return values
mixed

buildInsertMethod()

build the insert() method in the final class

protected buildInsertMethod(mixed $pkFields) : string
Parameters
$pkFields : mixed
Return values
string

the source of the method

buildOuterJoins()

generates the part of the FROM clause for outer joins

protected buildOuterJoins(mixed &$tables, mixed $primaryTableName) : array<string|int, mixed>
Parameters
$tables : mixed
$primaryTableName : mixed
Return values
array<string|int, mixed>

[0]=> the part of the FROM clause, [1]=> the part to add to the WHERE clause when needed

buildSelectClause()

build a SELECT clause for all SELECT queries

protected buildSelectClause([mixed $distinct = false ]) : string
Parameters
$distinct : mixed = false
Return values
string

the select clause.

buildSelectPattern()

build an item for the select clause

protected buildSelectPattern(mixed $pattern, mixed $table, mixed $fieldname, mixed $propname) : mixed
Parameters
$pattern : mixed
$table : mixed
$fieldname : mixed
$propname : mixed
Return values
mixed

buildSelectUserQuery()

protected buildSelectUserQuery(mixed $method, mixed &$src, mixed &$allField) : mixed
Parameters
$method : mixed
$src : mixed
$allField : mixed
Return values
mixed

buildUpdateAutoIncrementPK()

protected buildUpdateAutoIncrementPK(mixed $pkai) : mixed
Parameters
$pkai : mixed
Return values
mixed

buildUpdateMethod()

build the update() method for the final class

protected buildUpdateMethod(mixed $pkFields) : string
Parameters
$pkFields : mixed
Return values
string

the source of the method

buildUpdateUserQuery()

protected buildUpdateUserQuery(mixed $method, mixed &$src, mixed &$primaryFields) : mixed
Parameters
$method : mixed
$src : mixed
$primaryFields : mixed
Return values
mixed

buildUserMethods()

build all methods defined by the developer in the dao file

protected buildUserMethods() : string
Return values
string

the source of the methods

getAutoIncrementPKField()

get autoincrement PK field

protected getAutoIncrementPKField([mixed $using = null ]) : mixed
Parameters
$using : mixed = null
Return values
mixed

parseSQLFunction()

protected parseSQLFunction(mixed $expression) : mixed
Parameters
$expression : mixed
Return values
mixed

Search results