public function testAssemble()
{
$clause = new ReplaceClause();
$clause->setTable('tester');
$this->assertEquals('REPLACE INTO tester ()', QueryAssembler::stringify($clause));
$clause->addField((new FieldExpression())->setField('id'));
$this->assertEquals('REPLACE INTO tester (id)', QueryAssembler::stringify($clause));
}
public function testAssemble()
{
$statement = new ReplaceStatement();
$insert = new ReplaceClause();
$insert->setTable('tbl');
$statement->addClause($insert);
$this->assertEquals('REPLACE INTO tbl ()', QueryAssembler::stringify($statement));
$insert->addField((new FieldExpression())->setField('id'));
$insert->addField((new FieldExpression())->setField('name'));
$this->assertEquals('REPLACE INTO tbl (id, name)', QueryAssembler::stringify($statement));
$values = new ValuesClause();
$values->addExpression(new ValueExpression());
$values->addExpression((new ValueExpression())->setValue("Test"));
$statement->addClause($values);
$this->assertEquals('REPLACE INTO tbl (id, name) ' . 'VALUES (NULL, "Test")', QueryAssembler::stringify($statement));
}
