jDaoFactoryBase

in package

• jelix
• dao

base class for all factory classes generated by the dao compiler.

Tags

subpackage

dao

Table of Contents

$_conn  : jDbConnection

the database connector.

$_DaoRecordClassName  : string

the class name of a dao record for this dao factory.

$_daoSelector  : string

the selector of the dao, to be sent with events.

$_deleteAfterEvent  : mixed

$_deleteBeforeEvent  : mixed

$_deleteByAfterEvent  : mixed

$_deleteByBeforeEvent  : mixed

$_fromClause  : string

the from clause you can reuse for a specific SELECT query.

$_primaryTable  : string

the id of the primary table.

$_selectClause  : string

the select clause you can reuse for a specific SELECT query.

$_tables  : array<string|int, mixed>

informations on tables.

$_whereClause  : string

the where clause you can reuse for a specific SELECT query.

$falseValue  : mixed

$trueValue  : mixed

__construct()  : mixed

countAll()  : int

return the number of all records.

countBy()  : int

return the number of records corresponding to the conditions stored into the jDaoConditions object.

createRecord()  : jDaoRecordBase

creates a record object for the dao.

deleteBy()  : number

delete all record corresponding to the conditions stored into the jDaoConditions object.

findAll()  : jDbResultSet

return all records.

findBy()  : jDbResultSet

return all record corresponding to the conditions stored into the jDaoConditions object.

getPrimaryKeyNames()  : array<string|int, mixed>

list of id of primary properties.

getPrimaryTable()  : string

getProperties()  : array<string|int, mixed>

informations on all properties.

getTables()  : array<string|int, mixed>

insert()  : int

save a new record into the database if the dao record has an autoincrement key, its corresponding property is updated.

update()  : int

save a modified record into the database.

_callbackBool()  : mixed

a callback function for some array_map call in generated methods.

_callbackQuote()  : mixed

a callback function for some array_map call in generated methods.

_callbackQuoteBin()  : mixed

a callback function for some array_map call in generated methods.

_getPkWhereClauseForNonSelect()  : string

create a WHERE clause with conditions on primary keys with given value. This method should be used for DELETE and UPDATE queries.

_getPkWhereClauseForSelect()  : string

create a WHERE clause with conditions on primary keys with given value. This method should be used for SELECT queries. You haven't to escape values.

_prepareValue()  : mixed

prepare the value ready to be used in a dynamic evaluation.

finishInitResultSet()  : mixed

finish to initialise a record set. Could be redefined in child class to do additionnal processes.

 array (
  'name' => ' the table alias',
  'realname' => 'the real name of the table',
  'pk' => array ( list of primary keys name ),
  'fields' => array ( list of property name attached to this table )
)

 array (
 'name' => 'name of property',
 'fieldName' => 'name of fieldname',
 'regExp' => NULL, // or the regular expression to test the value
 'required' => true/false,
 'isPK' => true/false, //says if it is a primary key
 'isFK' => true/false, //says if it is a foreign key
 'datatype' => '', // type of data : string
 'unifiedType'=> '' // the corresponding unified type
 'table' => 'grp', // alias of the table the property is attached to
 'updatePattern' => '%s',
 'insertPattern' => '%s',
 'selectPattern' => '%s',
 'sequenceName' => '', // name of the sequence when field is autoincrement
 'maxlength' => NULL, // or a number
 'minlength' => NULL, // or a number
 'ofPrimaryTable' => true/false
 'autoIncrement'=> true/false
)