/**
* example14: replace
*
* @covers Phossa\Query\Dialect\Common::replace()
*/
public function testReadme14()
{
// builder object
$users = $this->builder;
// 01: mysql replace
$this->assertEquals("REPLACE LOW_PRIORITY INTO `users` (`user_id`, `user_name`) VALUES (3, 'phossa')", $users->replace(['user_id' => 3, 'user_name' => 'phossa'])->addHint('low_priority')->getStatement());
// 02: sqlite replace
$sqlite = new Builder(new Sqlite(), 'users');
$this->assertEquals('INSERT INTO "users" ("user_id", "user_name") VALUES (3, \'phossa\') ON CONFLICT REPLACE', $sqlite->replace(['user_id' => 3, 'user_name' => 'phossa'])->getStatement());
}
