parser; return $parser->rebuild($sql, $parameters); } public function testReplaceMultipleUsesOfNamedParameter() { $parameters = ['foo' => 'bar']; $sql = "SELECT :foo AS a, :foo AS b"; list ($statement, $values) = $this->rebuild($sql, $parameters); $expectedStatement = "SELECT :foo AS a, :foo__1 AS b"; $expectedValues = ['foo' => 'bar', 'foo__1' => 'bar']; $this->assertEquals($expectedStatement, $statement); $this->assertEquals($expectedValues, $values); } public function testReplaceNumberedParameter() { $parameters = ['bar', 'baz', null]; $sql = "SELECT ? AS a, ? AS b FROM table WHERE id = ?"; list ($statement, $values) = $this->rebuild($sql, $parameters); $expectedStatement = "SELECT :__1 AS a, :__2 AS b FROM table WHERE id = :__3"; $expectedValues = ['__1' => 'bar', '__2' => 'baz', '__3' => null]; $this->assertEquals($expectedStatement, $statement); $this->assertEquals($expectedValues, $values); } public function testReplaceArrayAsParameter() { $parameters = ['foo' => ['bar', 'baz']]; $sql = "SELECT :foo"; list ($statement, $values) = $this->rebuild($sql, $parameters); $expectedStatement = "SELECT :foo_0, :foo_1"; $expectedValues = ['foo_0' => 'bar', 'foo_1' => 'baz']; $this->assertEquals($expectedStatement, $statement); $this->assertEquals($expectedValues, $values); $parameters = [['bar', 'baz']]; $sql = "SELECT ?"; list ($statement, $values) = $this->rebuild($sql, $parameters); $expectedStatement = "SELECT :__1, :__2"; $expectedValues = ['__1' => 'bar', '__2' => 'baz']; $this->assertEquals($expectedStatement, $statement); $this->assertEquals($expectedValues, $values); } public function testDoubleQuotedIdentifier() { $parameters = ['foo' => ['bar', 'baz']]; $sql = <<rebuild($sql, $parameters); $this->assertEquals($sql, $statement); $sql = <<rebuild($sql, $parameters); $this->assertEquals($sql, $statement); } public function testStringConstants() { $parameters = ['foo' => ['bar', 'baz']]; $sql = <<rebuild($sql, $parameters); $this->assertEquals($sql, $statement); $sql = <<rebuild($sql, $parameters); $this->assertEquals($sql, $statement); $sql = <<rebuild($sql, $parameters); $this->assertEquals($sql, $statement); } public function testEscapedCharactersInStringConstants() { $parameters = ['foo' => ['bar', 'baz']]; $sql = <<rebuild($sql, $parameters); $this->assertEquals($sql, $statement); $sql = <<< 'SQL' SELECT "Escaping \" :foo \"" SQL; list ($statement, $values) = $this->rebuild($sql, $parameters); $this->assertEquals($sql, $statement); // $sql = << 'bar', 'foo_0' => 'baz']; // list ($statement, $values) = $this->rebuild($sql, $parameters); // $this->assertEquals($expectedStatement, $statement); // $this->assertEquals($expectedValues, $values); $sql = <<rebuild($sql, $parameters); $this->assertEquals($sql, $statement); $sql = <<rebuild($sql, $parameters); $this->assertEquals($sql, $statement); $sql = <<rebuild($sql, $parameters); $this->assertEquals($sql, $statement); } public function testIssue107() { $sql = "UPDATE table SET `value`=:value, `blank`='', `value2` = :value2, `blank2` = '', `value3`=:value3 WHERE id = :id"; $parameters = ['value'=> 'string', 'id'=> 1, 'value2'=> 'string', 'value3'=>'string']; list ($statement, $values) = $this->rebuild($sql, $parameters); $this->assertEquals($statement, $sql); $this->assertEquals($values, $parameters); } }