/** * 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; }