public function testShouldCreateSqlUpdateStatementWithParameters() { $table = "test"; $value = StringUtils::generateRandomAlphaNumeric(10); $update = new UpdateStatement($table); $update->addParameter("content", $value); $update->where(Restrictions::eq("id", ':id')); $update->addParameter(":id", 1001, true); $sql = $update->toSql(); $this->assertThat(trim($sql), $this->equalTo("UPDATE {$table} SET content=:content WHERE (id = :id)")); $this->assertThat($update->hasParameters(), $this->isTrue()); $parameters = $update->getParameters(); $this->assertThat(array_shift($parameters), $this->equalTo($value)); $this->assertThat(array_pop($parameters), $this->equalTo(1001)); }