/**
* Constructor.
*
* @param PDO $PdoConnection optional PDO database connection
*
* @return SQL\InsertQueryBuilder
*/
public function __construct(\PDO $PdoConnection = null)
{
parent::__construct($PdoConnection);
$this->queryType = self::TYPE_INSERT;
$this->sqlParts['into'] = array('table' => null, 'columns' => array());
$this->sqlParts['values'] = array();
$this->sqlParts['select'] = null;
$this->boundParams['values'] = array();
$this->boundParams['select'] = array();
}
/**
* Returns the parent object
* Allows for conditional statements in a fluid interface.
*
* @return \SQL\Proxy\QueryConditionalProxy|\SQL\Base\QueryBuilder
*/
public function _endif()
{
return $this->query->_endif();
}
/**
* @expectedException SQL\Exception\QueryBuilderException
*/
public function testEndIfAlone()
{
$this->queryBuilder->_endif(true);
}
/**
* @dataProvider debugQueryProvider
*/
public function testDebugQuery($query, $params, $expected, $expectedQuoted, $expectedQuotedPDO)
{
$this->assertEquals($expected, QueryBuilder::debugQuery($query, $params, false));
$this->assertEquals($expectedQuoted, QueryBuilder::debugQuery($query, $params, true));
$this->assertEquals($expectedQuotedPDO, QueryBuilder::debugQuery($query, $params, true, self::$pdo));
}
/**
* Constructor.
*
* @param PDO $PdoConnection optional PDO database connection
*
* @return SQL\Base\WhereQueryBuilder
*/
public function __construct(\PDO $PdoConnection = null)
{
parent::__construct($PdoConnection);
$this->sqlParts['where'] = array();
$this->boundParams['where'] = array();
}