/**
* Test for RETURNING clause.
*
* @return void
*
* @since 11.3
*/
public function testReturning()
{
$q = new JDatabaseQueryPostgresql($this->dbo);
$this->assertThat($q->returning('id'), $this->identicalTo($q), 'Tests chaining.');
$this->assertThat(trim($q->returning), $this->equalTo('RETURNING id'), 'Tests rendered value.');
}
/**
* Tests the JDatabasePostgresqlQuery::DateAdd method
*
* @param datetime $date The date or datetime to add to.
* @param string $interval The maximum length of the text.
* @param string $datePart The part of the date to be added to (such as day or micosecond).
* @param string $expected The expected result.
*
* @return void
*
* @dataProvider seedDateAdd
* @since 13.1
*/
public function testDateAdd($date, $interval, $datePart, $expected)
{
$this->assertEquals($expected, $this->_instance->dateAdd($date, $interval, $datePart));
}
/**
* Tests the JDatabasePostgresqlQuery::DateAdd method
*
* @param datetime $date The date or datetime to add to.
* @param string $interval The maximum length of the text.
* @param string $datePart The part of the date to be added to (such as day or micosecond).
* @param string $expected The expected result.
*
* @return void
*
* @dataProvider seedDateAdd
* @since 13.1
*/
public function testDateAdd($date, $interval, $datePart, $expected)
{
$this->assertThat($this->_instance->dateAdd($date, $interval, $datePart), $this->equalTo($expected));
}