/** * Tests the JDatabaseQuery::where method. * * @return void * * @since 11.3 */ public function testWhere() { $q = new JDatabaseQueryInspector($this->dbo); $this->assertThat($q->where('foo = 1'), $this->identicalTo($q), 'Tests chaining.'); $this->assertThat(trim($q->where), $this->equalTo('WHERE foo = 1'), 'Tests rendered value.'); // Add another column. $q->where(array('bar = 2', 'goo = 3')); $this->assertThat(trim($q->where), $this->equalTo('WHERE foo = 1 AND bar = 2 AND goo = 3'), 'Tests rendered value after second use and array input.'); // Clear the where $q->where = null; $q->where(array('bar = 2', 'goo = 3'), 'OR'); $this->assertThat(trim($q->where), $this->equalTo('WHERE bar = 2 OR goo = 3'), 'Tests rendered value with glue.'); }