phpPeanuts  2.2.0
phpPeanuts framework
 All Data Structures Namespaces Files Functions Variables
Public Member Functions
PntSqliteDao Class Reference

Inherits PntDao.

Public Member Functions

 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 ()
 
- 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)
 

Additional Inherited Members

- 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")
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$objthe object to add fieldProperties to
String$tableNamethe name of the table whose columns to use.
array$includeListnames 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
beginTransaction ( )
commit (   $seconds = 15)
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 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
getDbmsName ( )
getFieldNames ( )
getSingleValue (   $query = '',
  $error = "Query error" 
)
initFieldNames ( )
quote (   $string)
release ( )
rollBack ( )

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