mssqlDaoBuilder
extends jDaoGenerator
in package
driver for jDaoCompiler
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
- genUpdateAutoIncrementPK() : mixed
- getAutoIncrementPKField() : mixed
- get autoincrement PK field
- parseSQLFunction() : mixed
Properties
$_DaoClassName
the DAO classname
protected
string
$_DaoClassName
=
ull
$_daoId
protected
mixed
$_daoId
$_daoPath
protected
mixed
$_daoPath
$_DaoRecordClassName
The DaoRecord ClassName
protected
string
$_DaoRecordClassName
=
ull
$_dataParser
the dao definition.
protected
jDaoParser
$_dataParser
=
ull
$_dbType
protected
mixed
$_dbType
$aliasWord
protected
mixed
$aliasWord
= ' AS '
$propertiesListForInsert
protected
mixed
$propertiesListForInsert
= 'PrimaryFieldsExcludeAutoIncrement'
$sqlFromClause
protected
mixed
$sqlFromClause
= ''
$sqlSelectClause
protected
mixed
$sqlSelectClause
= ''
$sqlWhereClause
protected
mixed
$sqlWhereClause
= ''
$tableRealName
the real name of the main table
protected
mixed
$tableRealName
= ''
$tableRealNameEsc
the real name of the main table, escaped in SQL so it is ready to include into a SQL query.
protected
mixed
$tableRealNameEsc
= ''
$tools
protected
jDbTools
$tools
Methods
__construct()
constructor
public
__construct(jSelectorDao $selector, jDbTools $tools, jDaoParser $daoParser) : mixed
Parameters
- $selector : jSelectorDao
- $tools : jDbTools
- $daoParser : jDaoParser
Return values
mixed —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
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 —buildEndOfClass()
protected
buildEndOfClass() : 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
genUpdateAutoIncrementPK()
protected
genUpdateAutoIncrementPK(mixed $pkai, mixed $pTableRealName) : mixed
Parameters
- $pkai : mixed
- $pTableRealName : mixed
Return values
mixed —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