/** * simple update * * @covers Phossa\Query\Dialect\Common::update() */ public function testUpdate01() { // update $str1 = <<<EOT UPDATE "users" SET "uid" = 2, "uname" = 'phossa' WHERE "uid" = 10 EOT; $ins = $this->builder->update()->table("users")->set('uid', 2)->set('uname', 'phossa')->where('uid', 10); $this->assertEquals(preg_replace("/\r\n/", "\n", $str1), $ins->getStatement($this->settings)); // positioned params $str2 = 'UPDATE "users" SET "uid" = ?, "uname" = ? WHERE "uid" = ?'; $this->assertEquals(preg_replace("/\r\n/", "\n", $str2), $ins->getStatement(['positionedParam' => true])); }