function test_withJoin() { $join = new SQL_Query_Join(); $query = new SQL_Query(''); $query->setFrom($join); $this->assertEquals($join, $query->getFrom()); }
function test_join() { $query = new SQL_Query(); $join = new SQL_Query_Join(); $join->addJoin(array('t' => 'table', 'table1'), new SQL_Condition('table.x', '=', 'table1.x')); $query->setFrom($join); $ren = new $this->_renderer($query); $this->assertStringEquals('table t INNER JOIN table1 ON table.x = table1.x', $ren->renderFrom()); }