/** * Render a Insert object * @param Query\Insert $query * @return string */ public static function render(Query\Insert $query) { return Compiler::withDb($query->getDb(), function () use($query) { $table = $query->getTable(); $select = $query->getSelect(); return Compiler::expression(array('INSERT', $query->getType(), Compiler::word('INTO', $table !== null ? Aliased::render($table) : null), Columns::render($query->getColumns()), Compiler::word('VALUES', Values::combine($query->getValues())), Compiler::word('SET', Set::combine($query->getSet())), $select !== null ? Select::render($select) : null)); }); }
/** * Render Update object * @param Query\Update $query * @return string */ public static function render(Query\Update $query) { return Compiler::withDb($query->getDb(), function () use($query) { return Compiler::expression(array('UPDATE', $query->getType(), Aliased::combine($query->getTable()), Join::combine($query->getJoin()), Compiler::word('SET', Set::combine($query->getSet())), Compiler::word('WHERE', Condition::combine($query->getWhere())), Compiler::word('ORDER BY', Direction::combine($query->getOrder())), Compiler::word('LIMIT', $query->getLimit()))); }); }
/** * @covers ::combine */ public function testCombine() { $set1 = new SQL\Set('name1', 'param1'); $set2 = new SQL\Set('name2', 'param2'); $this->assertEquals('name1 = ?, name2 = ?', Compiler\Set::combine(array($set1, $set2))); }