parser = new PgsqlParser(); } public function testUnicodeDoubleQuotedIdentifier() { $parameters = ['a000' => ['foo', 'bar']]; $sql = <<rebuild($sql, $parameters); $this->assertEquals($sql, $statement); } public function testCStyleStringConstants() { $parameters = ['foo' => ['bar', 'baz']]; $sql = <<rebuild($sql, $parameters); $this->assertEquals($sql, $statement); $sql = <<rebuild($sql, $parameters); $this->assertEquals($sql, $statement); } public function testDollarQuotedStrings() { $parameters = ['foo' => ['bar', 'baz']]; $sql = 'SELECT $$:foo$$'; list ($statement, $values) = $this->rebuild($sql, $parameters); $this->assertEquals($sql, $statement); $sql = 'SELECT $tag$ :foo $tag$'; list ($statement, $values) = $this->rebuild($sql, $parameters); $this->assertEquals($sql, $statement); $sql = 'SELECT $outer$ nested strings $inner$:foo$inner$ $outer$'; list ($statement, $values) = $this->rebuild($sql, $parameters); $this->assertEquals($sql, $statement); $sql = 'SELECT $€$hello$€$'; list ($statement, $values) = $this->rebuild($sql, $parameters); $this->assertEquals($sql, $statement); $sql = 'SELECT $€$hello$€'; list ($statement, $values) = $this->rebuild($sql, $parameters); $this->assertEquals($sql, $statement); } public function testTypeCasting() { $parameters = ['TEXT' => ['bar', 'baz']]; $sql = <<rebuild($sql, $parameters); $this->assertEquals($sql, $statement); } public function testArrayAccessor() { $parameters = ['2' => ['bar', 'baz']]; $sql = <<rebuild($sql, $parameters); $this->assertEquals($sql, $statement); } public function testInvalidPlaceholderName() { $parameters = [']' => ['bar', 'baz']]; $sql = <<rebuild($sql, $parameters); $this->assertEquals($sql, $statement); } }