phpPeanuts  2.2.0
phpPeanuts framework
 All Data Structures Namespaces Files Functions Variables
Public Member Functions | Data Fields
PntMysqlDao Class Reference

Inherits PntDao.

Inherited by PntQueryHandler.

Public Member Functions

 getDbmsName ()
 
 _runQuery ($error="Query error")
 
 logQuery ($sql)
 
 getFieldNames ()
 
 dataSeek ($index)
 
 getSingleValue ($query='', $error="Query error")
 
 convertToSql ($value)
 
 convertConditionArgumentToSql ($value)
 
 quote ($string)
 
 getAssocRows ($max=null)
 
 getAssocRow ()
 
 release ()
 
 connect ()
 
 beginTransaction ()
 
 commit ()
 
 rollBack ()
 
- Public Member Functions inherited from PntDao
 __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)
 

Data Fields

 $winMinTimeLimit = 65
 
- Data Fields inherited from PntDao
 $connection
 
 $query = ''
 
 $rowCount =0
 
 $columnCount =0
 
 $result
 
 $insertId
 
 $error
 
 $errNo = 0
 
 $parameters
 
 $rowIndex
 
 $dbSource
 

Member Function Documentation

_runQuery (   $error = "Query error")
beginTransaction ( )
commit ( )
connect ( )

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)
convertToSql (   $value)
dataSeek (   $index)
getAssocRow ( )

Gets next row as associative array, or false if none

getAssocRows (   $max = null)

Gets rows starting at current pointer position !Does no longer Reset record pointer

Parameters
number$maxThe maximum number of rows to get. If null all remaining rows are returned. Returns an array of associative row arrays (indexed[rowIndex][rowName])
getDbmsName ( )
getFieldNames ( )
getSingleValue (   $query = '',
  $error = "Query error" 
)
logQuery (   $sql)
quote (   $string)
release ( )
rollBack ( )

Field Documentation

$winMinTimeLimit = 65

connect can take long to fail on PHP5.3.0, and on windows the time spent is counted as execution time. This value will be set using set_time_limit if time_limit is lower on windows


The documentation for this class was generated from the following file: