/**
* Tests the \Joomla\Database\DatabaseQuery::from method.
*
* @return void
*
* @covers \Joomla\Database\DatabaseQuery::from
* @since 1.0
*/
public function testFrom()
{
$this->assertThat($this->instance->from('#__foo'), $this->identicalTo($this->instance), 'Tests chaining.');
$this->assertThat(trim(TestHelper::getValue($this->instance, 'from')), $this->equalTo('FROM #__foo'), 'Tests rendered value.');
// Add another column.
$this->instance->from('#__bar');
$this->assertThat(trim(TestHelper::getValue($this->instance, 'from')), $this->equalTo('FROM #__foo,#__bar'), 'Tests rendered value after second use.');
}
/**
* registerQueryTables
*
* @param DatabaseQuery $query
*
* @return DatabaseQuery
*/
public function registerQueryTables(DatabaseQuery $query)
{
foreach ($this->tables as $alias => $table) {
if ($table['join'] == 'FROM') {
$query->from($query->quoteName($table['name']) . ' AS ' . $query->quoteName($alias));
} else {
$query->join($table['join'], $query->quoteName($table['name']) . ' AS ' . $query->quoteName($alias) . ' ' . $table['condition']);
}
}
return $query;
}
