Inherits PntDao.
|
| getDbmsName () |
|
| _runQuery ($error="Query error") |
|
| getFieldNames () |
|
| initFieldNames () |
|
| dataSeek ($index) |
|
| getSingleValue ($query='', $error="Query error") |
|
| convertToSql ($value) |
|
| convertConditionArgumentToSql ($value) |
|
| quote ($string) |
|
| getAssocRow () |
|
| addFieldPropsTo_table ($obj, $tableName, $includeList=null) |
|
| release () |
|
| connect () |
|
| beginTransaction () |
|
| commit ($seconds=15) |
|
| rollBack () |
|
| __construct ($connection=null) |
|
| getDbmsName () |
|
| supportsSelectRowCount () |
|
| runQuery ($query='', $error="Query error") |
|
| _runQuery ($error="Query error") |
|
| getFieldNames () |
|
| getRowCount () |
|
| getColumnCount () |
|
| getError () |
|
| getErrNo () |
|
| dataSeek ($index) |
|
| getSingleValue ($query='', $error="Query error") |
|
| getInsertId () |
|
| prefixColumnNames ($colNames, $prefix) |
|
| select_from ($columnNames, $tableName, $distinct=false) |
|
| where_equals ($columnName, $value, $placeholder='?') |
|
| limit ($rowCount, $offset=0) |
|
| joinAllById ($tableMap, $baseTable) |
|
| in ($columnName, $values) |
|
| convertToSql ($value) |
|
| convertConditionArgumentToSql ($value) |
|
| quote ($string) |
|
| setQueryToInsertObject_table_fieldMap ($anObject, $tableName, $fieldMap) |
|
| setQueryToSaveObject_table_fieldMap ($anObject, $tableName, $fieldMap, $insert) |
|
| setQueryToDeleteFrom_where_equals ($tableName, $columnName, $value) |
|
| addSqlFromSpec ($spec, $groupBy=false) |
|
| getAssocRows ($max=null) |
|
| getAssocRow () |
|
| release () |
|
| getConnection () |
|
| setConnection ($value) |
|
| setDefaultConnection () |
|
| connect () |
|
| beginTransaction () |
|
| commit () |
|
| rollBack () |
|
| param ($value, $placeholder='?') |
|
| clearParams () |
|
| replacePlaceholders () |
|
| addFieldPropsTo_table ($obj, $tableName, $includeList=null) |
|
| addFieldPropTo_row ($obj, $row) |
|
| getPropertyType ($mySqlType) |
|
_runQuery |
( |
|
$error = "Query error" | ) |
|
addFieldPropsTo_table |
( |
|
$obj, |
|
|
|
$tableName, |
|
|
|
$includeList = null |
|
) |
| |
Adds fieldProperties to the object for the columns from the database. This method assumes column names to be equal to the names of their corresponding field properties.
- Parameters
-
PntDbObject | $obj | the object to add fieldProperties to |
String | $tableName | the name of the table whose columns to use. |
array | $includeList | names of properties to include If omitted, all columns will be used in the order they appear in the table, but if a fieldProperty is already defined it is left untouched. |
- Returns
- array propertyDescriptors that where added, by property name
Connects to the DBMS and selects the database Stores the resulting resource on $this->connection PRECONDITION: $this->connection must be a valid DatabaseConnection instance
convertConditionArgumentToSql |
( |
|
$value | ) |
|
Gets next row as associative array, or false if none Associative rows must not be prefixed, like the ones resulting from SQLITE_ASSOC. Therefore they are built from php using $this->fieldNames which is initialized in _runQuery
- Returns
- Array Associative array with data from row fetch
getSingleValue |
( |
|
$query = '' , |
|
|
|
$error = "Query error" |
|
) |
| |
The documentation for this class was generated from the following file: