PntDao

PntMysqlDao

PntPdoDao

PntSqliteDao

__construct

_runQuery

addFieldPropTo_row

addFieldPropsTo_table

addSqlFromSpec

beginTransaction

clearParams

commit

connect

convertConditionArgumentToSql

convertToSql

dataSeek

getAssocRow

getAssocRows

getColumnCount

getConnection

getDbmsName

getErrNo

getError

getFieldNames

getInsertId

getPropertyType

getRow

getRowCount

getSingleValue

in

joinAllById

limit

param

prefixColumnNames

quote

release

replacePlaceholders

returns true, dataSeek should be supported too */ function supportsSelectRowCount

rollBack

runQuery

select_from

setConnection

setDefaultConnection

setQueryToDeleteFrom_where_equals

setQueryToInsertObject_table_fieldMap

setQueryToSaveObject_table_fieldMap

where_equals

<?php
/* Copyright (c) MetaClass, 2003-2017

Distrubuted and licensed under under the terms of the GNU Affero General Public License
version 3, or (at your option) any later version.

This program is distributed WITHOUT ANY WARRANTY; without even the implied warranty 
of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
	
See the License, http://www.gnu.org/licenses/agpl.txt */

Gen::includeClass('PntDbError', 'pnt/db');

/** Objects of this class are used for generating and executing database queries.
* This class is the superclass for common functionality that applies to most of the databases
* Currently only subclasses for mySQL and SqlLight are available, but
* it is easy to add subclasses for the databases you need, als long as 
* these databases support explicit LEFT JOIN syntax (Oracle does not).
* @see http://www.phppeanuts.org/site/index_php/Pagina/50
*
* This abstract superclass provides behavior for the concrete
* subclass QueryHandler in the root classFolder or in the application classFolder. 
* To keep de application developers code (including localization overrides) 
* separated from the framework code override methods in the 
* concrete subclass rather then modify them here.
* @see http://www.phppeanuts.org/site/index_php/Menu/178
* @package pnt/db/dao
*/
class PntDao {
	public $connection; //instance of DatabaseConnection
	public $query = '';
	public $rowCount=0; //assigned in _runQuery -- before 1.2 beta 1 this was: $aantalRecords 
	public $columnCount=0;  //assigned in getFieldNames() -- before 1.2 beta 1 this was: $aantalVelden 
	public $result;		  //assigned in _runQuery
	public $insertId;        //assigned in _runQuery
	public $error;           //errorMessage assigned in _runQuery
	public $errNo = 0; 		//assigned in _runQuery
	public $parameters;    //assigend in clearParams
	// we did not factor out the default error message because it is not meant for the end users anyway
	/** Index of current row (the one that can be fetched) in resultSet */
	public $rowIndex;
	/** $dbSource cache, see PntDatabasenConnection::getDBSource() */
	public $dbSource;