phingofficial / phing

tests/Phing/Task/Optional/PDODelimitersTest.php

Indentation -141 removed lines

@@ -70,144 +70,3 @@
         // for some reason default splitter mangles spaces on subsequent lines
         $expected = [
             <<<'SQL'
-                insert into foo (bar, "strange;name""indeed") values ('bar''s value containing ;', 'a value for strange named column')
-                SQL,
-            <<<'SQL'
-                delete
-                 from
-                 foo where bar = 'some value'
-                SQL,
-            <<<'SQL'
-                update dump -- I should not be ignored
-                 set message = 'I am a string with \\ backslash \' escapes and semicolons;'
-                SQL,
-            <<<'SQL'
-                create procedure setfoo(newfoo int)
-                 begin
-                 set @foo = newfoo;
-                 end
-                SQL,
-            <<<'SQL'
-                insert into dump (message) values ('I am a statement not ending with a delimiter')
-                SQL,
-        ];
-        // and insists on "\n" linebreaks
-        foreach ($expected as &$query) {
-            $query = str_replace(["\n\n", "\r"], ["\n", ''], $query);
-        }
-
-        $this->mockTask->setSrc(new File(PHING_TEST_BASE . '/etc/tasks/ext/pdo/delimiters-normal.sql'));
-        $this->mockTask->setDelimiterType(PDOSQLExecTask::DELIM_NORMAL);
-        $this->project->setProperty('bar.value', 'some value');
-        $this->project->executeTarget('test');
-
-        $this->assertEquals($expected, $this->queries);
-    }
-
-    public function testDelimiterTypeRow(): void
-    {
-        // for some reason default splitter mangles spaces on subsequent lines
-        $expected = [
-            <<<'SQL'
-                insert into "duh" (foo) values ('duh')
-                SQL,
-            <<<'SQL'
-                update "duh?" -- I should not be ignored
-                 set foo = 'some value'
-                SQL,
-            <<<'SQL'
-                insert into dump (message) values ('I am a statement not ending with a delimiter')
-                SQL,
-        ];
-        // and insists on "\n" linebreaks
-        foreach ($expected as &$query) {
-            $query = str_replace(["\n\n", "\r"], ["\n", ''], $query);
-        }
-
-        $this->mockTask->setSrc(new File(PHING_TEST_BASE . '/etc/tasks/ext/pdo/delimiters-row.sql'));
-        $this->mockTask->setDelimiterType(PDOSQLExecTask::DELIM_ROW);
-        $this->mockTask->setDelimiter('duh');
-        $this->project->setProperty('foo.value', 'some value');
-        $this->project->executeTarget('test');
-
-        $this->assertEquals($expected, $this->queries);
-    }
-
-    /**
-     * Checks that PDOSQLExecTask properly understands PostgreSQL dialect
-     * (especially "dollar quoting") when working with 'pgsql:' URLs.
-     *
-     * @see http://www.phing.info/trac/ticket/499
-     * @see http://www.postgresql.org/docs/9.0/interactive/sql-syntax-lexical.html#SQL-SYNTAX-DOLLAR-QUOTING
-     */
-    public function testRequest499(): void
-    {
-        $expected = [
-            <<<'SQL'
-                select 1
-                # 2
-                SQL,
-            <<<'SQL'
-                select 'foo'
-                // 'bar'
-                SQL,
-            <<<'SQL'
-                insert into foo (bar, "strange;name""indeed") values ('bar''s value containing ;', 'a value for strange named column')
-                SQL,
-            <<<'SQL'
-                create function foo(text)
-                returns boolean as
-                $function$
-                BEGIN
-                    RETURN ($1 ~ $q$[\t\r\n\v\\]$q$);
-                END;
-                $function$
-                language plpgsql
-                SQL,
-            <<<'SQL'
-                CREATE FUNCTION phingPDOtest() RETURNS "trigger"
-                    AS $_X$
-                if (1)
-                {
-                    # All is well - just continue
-
-                    return;
-                }
-                else
-                {
-                    # Not good - this is probably a fatal error!
-                    elog(ERROR,"True is not true");
-
-                    return "SKIP";
-                }
-                $_X$
-                    LANGUAGE plperl
-                SQL,
-            "insert into foo (bar) \nvalues ('some value')",
-            <<<'SQL'
-                insert into foo (bar) values ($$ a dollar-quoted string containing a few quotes ' ", a $placeholder$ and a semicolon;$$)
-                SQL,
-            <<<'SQL'
-                create rule blah_insert
-                as on insert to blah do instead (
-                    insert into foo values (new.id, 'blah');
-                    insert into bar values (new.id, 'blah-blah');
-                )
-                SQL,
-            <<<'SQL'
-                insert into dump (message) values ('I am a statement not ending with a delimiter')
-                SQL,
-        ];
-        foreach ($expected as &$query) {
-            $query = str_replace(["\n\n", "\r"], ["\n", ''], $query);
-        }
-
-        $this->mockTask->setSrc(new File(PHING_TEST_BASE . '/etc/tasks/ext/pdo/delimiters-pgsql.sql'));
-        $this->mockTask->setUrl('pgsql:host=localhost;dbname=phing');
-        $this->mockTask->setDelimiterType(PDOSQLExecTask::DELIM_NORMAL);
-        $this->project->setProperty('bar.value', 'some value');
-        $this->project->executeTarget('test');
-
-        $this->assertEquals($expected, $this->queries);
-    }
-}

Switch Indentation -141 removed lines

@@ -70,144 +70,3 @@
         // for some reason default splitter mangles spaces on subsequent lines
         $expected = [
             <<<'SQL'
-                insert into foo (bar, "strange;name""indeed") values ('bar''s value containing ;', 'a value for strange named column')
-                SQL,
-            <<<'SQL'
-                delete
-                 from
-                 foo where bar = 'some value'
-                SQL,
-            <<<'SQL'
-                update dump -- I should not be ignored
-                 set message = 'I am a string with \\ backslash \' escapes and semicolons;'
-                SQL,
-            <<<'SQL'
-                create procedure setfoo(newfoo int)
-                 begin
-                 set @foo = newfoo;
-                 end
-                SQL,
-            <<<'SQL'
-                insert into dump (message) values ('I am a statement not ending with a delimiter')
-                SQL,
-        ];
-        // and insists on "\n" linebreaks
-        foreach ($expected as &$query) {
-            $query = str_replace(["\n\n", "\r"], ["\n", ''], $query);
-        }
-
-        $this->mockTask->setSrc(new File(PHING_TEST_BASE . '/etc/tasks/ext/pdo/delimiters-normal.sql'));
-        $this->mockTask->setDelimiterType(PDOSQLExecTask::DELIM_NORMAL);
-        $this->project->setProperty('bar.value', 'some value');
-        $this->project->executeTarget('test');
-
-        $this->assertEquals($expected, $this->queries);
-    }
-
-    public function testDelimiterTypeRow(): void
-    {
-        // for some reason default splitter mangles spaces on subsequent lines
-        $expected = [
-            <<<'SQL'
-                insert into "duh" (foo) values ('duh')
-                SQL,
-            <<<'SQL'
-                update "duh?" -- I should not be ignored
-                 set foo = 'some value'
-                SQL,
-            <<<'SQL'
-                insert into dump (message) values ('I am a statement not ending with a delimiter')
-                SQL,
-        ];
-        // and insists on "\n" linebreaks
-        foreach ($expected as &$query) {
-            $query = str_replace(["\n\n", "\r"], ["\n", ''], $query);
-        }
-
-        $this->mockTask->setSrc(new File(PHING_TEST_BASE . '/etc/tasks/ext/pdo/delimiters-row.sql'));
-        $this->mockTask->setDelimiterType(PDOSQLExecTask::DELIM_ROW);
-        $this->mockTask->setDelimiter('duh');
-        $this->project->setProperty('foo.value', 'some value');
-        $this->project->executeTarget('test');
-
-        $this->assertEquals($expected, $this->queries);
-    }
-
-    /**
-     * Checks that PDOSQLExecTask properly understands PostgreSQL dialect
-     * (especially "dollar quoting") when working with 'pgsql:' URLs.
-     *
-     * @see http://www.phing.info/trac/ticket/499
-     * @see http://www.postgresql.org/docs/9.0/interactive/sql-syntax-lexical.html#SQL-SYNTAX-DOLLAR-QUOTING
-     */
-    public function testRequest499(): void
-    {
-        $expected = [
-            <<<'SQL'
-                select 1
-                # 2
-                SQL,
-            <<<'SQL'
-                select 'foo'
-                // 'bar'
-                SQL,
-            <<<'SQL'
-                insert into foo (bar, "strange;name""indeed") values ('bar''s value containing ;', 'a value for strange named column')
-                SQL,
-            <<<'SQL'
-                create function foo(text)
-                returns boolean as
-                $function$
-                BEGIN
-                    RETURN ($1 ~ $q$[\t\r\n\v\\]$q$);
-                END;
-                $function$
-                language plpgsql
-                SQL,
-            <<<'SQL'
-                CREATE FUNCTION phingPDOtest() RETURNS "trigger"
-                    AS $_X$
-                if (1)
-                {
-                    # All is well - just continue
-
-                    return;
-                }
-                else
-                {
-                    # Not good - this is probably a fatal error!
-                    elog(ERROR,"True is not true");
-
-                    return "SKIP";
-                }
-                $_X$
-                    LANGUAGE plperl
-                SQL,
-            "insert into foo (bar) \nvalues ('some value')",
-            <<<'SQL'
-                insert into foo (bar) values ($$ a dollar-quoted string containing a few quotes ' ", a $placeholder$ and a semicolon;$$)
-                SQL,
-            <<<'SQL'
-                create rule blah_insert
-                as on insert to blah do instead (
-                    insert into foo values (new.id, 'blah');
-                    insert into bar values (new.id, 'blah-blah');
-                )
-                SQL,
-            <<<'SQL'
-                insert into dump (message) values ('I am a statement not ending with a delimiter')
-                SQL,
-        ];
-        foreach ($expected as &$query) {
-            $query = str_replace(["\n\n", "\r"], ["\n", ''], $query);
-        }
-
-        $this->mockTask->setSrc(new File(PHING_TEST_BASE . '/etc/tasks/ext/pdo/delimiters-pgsql.sql'));
-        $this->mockTask->setUrl('pgsql:host=localhost;dbname=phing');
-        $this->mockTask->setDelimiterType(PDOSQLExecTask::DELIM_NORMAL);
-        $this->project->setProperty('bar.value', 'some value');
-        $this->project->executeTarget('test');
-
-        $this->assertEquals($expected, $this->queries);
-    }
-}

Spacing -141 removed lines

@@ -70,144 +70,3 @@
         // for some reason default splitter mangles spaces on subsequent lines
         $expected = [
             <<<'SQL'
-                insert into foo (bar, "strange;name""indeed") values ('bar''s value containing ;', 'a value for strange named column')
-                SQL,
-            <<<'SQL'
-                delete
-                 from
-                 foo where bar = 'some value'
-                SQL,
-            <<<'SQL'
-                update dump -- I should not be ignored
-                 set message = 'I am a string with \\ backslash \' escapes and semicolons;'
-                SQL,
-            <<<'SQL'
-                create procedure setfoo(newfoo int)
-                 begin
-                 set @foo = newfoo;
-                 end
-                SQL,
-            <<<'SQL'
-                insert into dump (message) values ('I am a statement not ending with a delimiter')
-                SQL,
-        ];
-        // and insists on "\n" linebreaks
-        foreach ($expected as &$query) {
-            $query = str_replace(["\n\n", "\r"], ["\n", ''], $query);
-        }
-
-        $this->mockTask->setSrc(new File(PHING_TEST_BASE . '/etc/tasks/ext/pdo/delimiters-normal.sql'));
-        $this->mockTask->setDelimiterType(PDOSQLExecTask::DELIM_NORMAL);
-        $this->project->setProperty('bar.value', 'some value');
-        $this->project->executeTarget('test');
-
-        $this->assertEquals($expected, $this->queries);
-    }
-
-    public function testDelimiterTypeRow(): void
-    {
-        // for some reason default splitter mangles spaces on subsequent lines
-        $expected = [
-            <<<'SQL'
-                insert into "duh" (foo) values ('duh')
-                SQL,
-            <<<'SQL'
-                update "duh?" -- I should not be ignored
-                 set foo = 'some value'
-                SQL,
-            <<<'SQL'
-                insert into dump (message) values ('I am a statement not ending with a delimiter')
-                SQL,
-        ];
-        // and insists on "\n" linebreaks
-        foreach ($expected as &$query) {
-            $query = str_replace(["\n\n", "\r"], ["\n", ''], $query);
-        }
-
-        $this->mockTask->setSrc(new File(PHING_TEST_BASE . '/etc/tasks/ext/pdo/delimiters-row.sql'));
-        $this->mockTask->setDelimiterType(PDOSQLExecTask::DELIM_ROW);
-        $this->mockTask->setDelimiter('duh');
-        $this->project->setProperty('foo.value', 'some value');
-        $this->project->executeTarget('test');
-
-        $this->assertEquals($expected, $this->queries);
-    }
-
-    /**
-     * Checks that PDOSQLExecTask properly understands PostgreSQL dialect
-     * (especially "dollar quoting") when working with 'pgsql:' URLs.
-     *
-     * @see http://www.phing.info/trac/ticket/499
-     * @see http://www.postgresql.org/docs/9.0/interactive/sql-syntax-lexical.html#SQL-SYNTAX-DOLLAR-QUOTING
-     */
-    public function testRequest499(): void
-    {
-        $expected = [
-            <<<'SQL'
-                select 1
-                # 2
-                SQL,
-            <<<'SQL'
-                select 'foo'
-                // 'bar'
-                SQL,
-            <<<'SQL'
-                insert into foo (bar, "strange;name""indeed") values ('bar''s value containing ;', 'a value for strange named column')
-                SQL,
-            <<<'SQL'
-                create function foo(text)
-                returns boolean as
-                $function$
-                BEGIN
-                    RETURN ($1 ~ $q$[\t\r\n\v\\]$q$);
-                END;
-                $function$
-                language plpgsql
-                SQL,
-            <<<'SQL'
-                CREATE FUNCTION phingPDOtest() RETURNS "trigger"
-                    AS $_X$
-                if (1)
-                {
-                    # All is well - just continue
-
-                    return;
-                }
-                else
-                {
-                    # Not good - this is probably a fatal error!
-                    elog(ERROR,"True is not true");
-
-                    return "SKIP";
-                }
-                $_X$
-                    LANGUAGE plperl
-                SQL,
-            "insert into foo (bar) \nvalues ('some value')",
-            <<<'SQL'
-                insert into foo (bar) values ($$ a dollar-quoted string containing a few quotes ' ", a $placeholder$ and a semicolon;$$)
-                SQL,
-            <<<'SQL'
-                create rule blah_insert
-                as on insert to blah do instead (
-                    insert into foo values (new.id, 'blah');
-                    insert into bar values (new.id, 'blah-blah');
-                )
-                SQL,
-            <<<'SQL'
-                insert into dump (message) values ('I am a statement not ending with a delimiter')
-                SQL,
-        ];
-        foreach ($expected as &$query) {
-            $query = str_replace(["\n\n", "\r"], ["\n", ''], $query);
-        }
-
-        $this->mockTask->setSrc(new File(PHING_TEST_BASE . '/etc/tasks/ext/pdo/delimiters-pgsql.sql'));
-        $this->mockTask->setUrl('pgsql:host=localhost;dbname=phing');
-        $this->mockTask->setDelimiterType(PDOSQLExecTask::DELIM_NORMAL);
-        $this->project->setProperty('bar.value', 'some value');
-        $this->project->executeTarget('test');
-
-        $this->assertEquals($expected, $this->queries);
-    }
-}

Braces -141 removed lines

@@ -70,144 +70,3 @@
         // for some reason default splitter mangles spaces on subsequent lines
         $expected = [
             <<<'SQL'
-                insert into foo (bar, "strange;name""indeed") values ('bar''s value containing ;', 'a value for strange named column')
-                SQL,
-            <<<'SQL'
-                delete
-                 from
-                 foo where bar = 'some value'
-                SQL,
-            <<<'SQL'
-                update dump -- I should not be ignored
-                 set message = 'I am a string with \\ backslash \' escapes and semicolons;'
-                SQL,
-            <<<'SQL'
-                create procedure setfoo(newfoo int)
-                 begin
-                 set @foo = newfoo;
-                 end
-                SQL,
-            <<<'SQL'
-                insert into dump (message) values ('I am a statement not ending with a delimiter')
-                SQL,
-        ];
-        // and insists on "\n" linebreaks
-        foreach ($expected as &$query) {
-            $query = str_replace(["\n\n", "\r"], ["\n", ''], $query);
-        }
-
-        $this->mockTask->setSrc(new File(PHING_TEST_BASE . '/etc/tasks/ext/pdo/delimiters-normal.sql'));
-        $this->mockTask->setDelimiterType(PDOSQLExecTask::DELIM_NORMAL);
-        $this->project->setProperty('bar.value', 'some value');
-        $this->project->executeTarget('test');
-
-        $this->assertEquals($expected, $this->queries);
-    }
-
-    public function testDelimiterTypeRow(): void
-    {
-        // for some reason default splitter mangles spaces on subsequent lines
-        $expected = [
-            <<<'SQL'
-                insert into "duh" (foo) values ('duh')
-                SQL,
-            <<<'SQL'
-                update "duh?" -- I should not be ignored
-                 set foo = 'some value'
-                SQL,
-            <<<'SQL'
-                insert into dump (message) values ('I am a statement not ending with a delimiter')
-                SQL,
-        ];
-        // and insists on "\n" linebreaks
-        foreach ($expected as &$query) {
-            $query = str_replace(["\n\n", "\r"], ["\n", ''], $query);
-        }
-
-        $this->mockTask->setSrc(new File(PHING_TEST_BASE . '/etc/tasks/ext/pdo/delimiters-row.sql'));
-        $this->mockTask->setDelimiterType(PDOSQLExecTask::DELIM_ROW);
-        $this->mockTask->setDelimiter('duh');
-        $this->project->setProperty('foo.value', 'some value');
-        $this->project->executeTarget('test');
-
-        $this->assertEquals($expected, $this->queries);
-    }
-
-    /**
-     * Checks that PDOSQLExecTask properly understands PostgreSQL dialect
-     * (especially "dollar quoting") when working with 'pgsql:' URLs.
-     *
-     * @see http://www.phing.info/trac/ticket/499
-     * @see http://www.postgresql.org/docs/9.0/interactive/sql-syntax-lexical.html#SQL-SYNTAX-DOLLAR-QUOTING
-     */
-    public function testRequest499(): void
-    {
-        $expected = [
-            <<<'SQL'
-                select 1
-                # 2
-                SQL,
-            <<<'SQL'
-                select 'foo'
-                // 'bar'
-                SQL,
-            <<<'SQL'
-                insert into foo (bar, "strange;name""indeed") values ('bar''s value containing ;', 'a value for strange named column')
-                SQL,
-            <<<'SQL'
-                create function foo(text)
-                returns boolean as
-                $function$
-                BEGIN
-                    RETURN ($1 ~ $q$[\t\r\n\v\\]$q$);
-                END;
-                $function$
-                language plpgsql
-                SQL,
-            <<<'SQL'
-                CREATE FUNCTION phingPDOtest() RETURNS "trigger"
-                    AS $_X$
-                if (1)
-                {
-                    # All is well - just continue
-
-                    return;
-                }
-                else
-                {
-                    # Not good - this is probably a fatal error!
-                    elog(ERROR,"True is not true");
-
-                    return "SKIP";
-                }
-                $_X$
-                    LANGUAGE plperl
-                SQL,
-            "insert into foo (bar) \nvalues ('some value')",
-            <<<'SQL'
-                insert into foo (bar) values ($$ a dollar-quoted string containing a few quotes ' ", a $placeholder$ and a semicolon;$$)
-                SQL,
-            <<<'SQL'
-                create rule blah_insert
-                as on insert to blah do instead (
-                    insert into foo values (new.id, 'blah');
-                    insert into bar values (new.id, 'blah-blah');
-                )
-                SQL,
-            <<<'SQL'
-                insert into dump (message) values ('I am a statement not ending with a delimiter')
-                SQL,
-        ];
-        foreach ($expected as &$query) {
-            $query = str_replace(["\n\n", "\r"], ["\n", ''], $query);
-        }
-
-        $this->mockTask->setSrc(new File(PHING_TEST_BASE . '/etc/tasks/ext/pdo/delimiters-pgsql.sql'));
-        $this->mockTask->setUrl('pgsql:host=localhost;dbname=phing');
-        $this->mockTask->setDelimiterType(PDOSQLExecTask::DELIM_NORMAL);
-        $this->project->setProperty('bar.value', 'some value');
-        $this->project->executeTarget('test');
-
-        $this->assertEquals($expected, $this->queries);
-    }
-}

Upper-Lower-Casing -141 removed lines

@@ -70,144 +70,3 @@
         // for some reason default splitter mangles spaces on subsequent lines
         $expected = [
             <<<'SQL'
-                insert into foo (bar, "strange;name""indeed") values ('bar''s value containing ;', 'a value for strange named column')
-                SQL,
-            <<<'SQL'
-                delete
-                 from
-                 foo where bar = 'some value'
-                SQL,
-            <<<'SQL'
-                update dump -- I should not be ignored
-                 set message = 'I am a string with \\ backslash \' escapes and semicolons;'
-                SQL,
-            <<<'SQL'
-                create procedure setfoo(newfoo int)
-                 begin
-                 set @foo = newfoo;
-                 end
-                SQL,
-            <<<'SQL'
-                insert into dump (message) values ('I am a statement not ending with a delimiter')
-                SQL,
-        ];
-        // and insists on "\n" linebreaks
-        foreach ($expected as &$query) {
-            $query = str_replace(["\n\n", "\r"], ["\n", ''], $query);
-        }
-
-        $this->mockTask->setSrc(new File(PHING_TEST_BASE . '/etc/tasks/ext/pdo/delimiters-normal.sql'));
-        $this->mockTask->setDelimiterType(PDOSQLExecTask::DELIM_NORMAL);
-        $this->project->setProperty('bar.value', 'some value');
-        $this->project->executeTarget('test');
-
-        $this->assertEquals($expected, $this->queries);
-    }
-
-    public function testDelimiterTypeRow(): void
-    {
-        // for some reason default splitter mangles spaces on subsequent lines
-        $expected = [
-            <<<'SQL'
-                insert into "duh" (foo) values ('duh')
-                SQL,
-            <<<'SQL'
-                update "duh?" -- I should not be ignored
-                 set foo = 'some value'
-                SQL,
-            <<<'SQL'
-                insert into dump (message) values ('I am a statement not ending with a delimiter')
-                SQL,
-        ];
-        // and insists on "\n" linebreaks
-        foreach ($expected as &$query) {
-            $query = str_replace(["\n\n", "\r"], ["\n", ''], $query);
-        }
-
-        $this->mockTask->setSrc(new File(PHING_TEST_BASE . '/etc/tasks/ext/pdo/delimiters-row.sql'));
-        $this->mockTask->setDelimiterType(PDOSQLExecTask::DELIM_ROW);
-        $this->mockTask->setDelimiter('duh');
-        $this->project->setProperty('foo.value', 'some value');
-        $this->project->executeTarget('test');
-
-        $this->assertEquals($expected, $this->queries);
-    }
-
-    /**
-     * Checks that PDOSQLExecTask properly understands PostgreSQL dialect
-     * (especially "dollar quoting") when working with 'pgsql:' URLs.
-     *
-     * @see http://www.phing.info/trac/ticket/499
-     * @see http://www.postgresql.org/docs/9.0/interactive/sql-syntax-lexical.html#SQL-SYNTAX-DOLLAR-QUOTING
-     */
-    public function testRequest499(): void
-    {
-        $expected = [
-            <<<'SQL'
-                select 1
-                # 2
-                SQL,
-            <<<'SQL'
-                select 'foo'
-                // 'bar'
-                SQL,
-            <<<'SQL'
-                insert into foo (bar, "strange;name""indeed") values ('bar''s value containing ;', 'a value for strange named column')
-                SQL,
-            <<<'SQL'
-                create function foo(text)
-                returns boolean as
-                $function$
-                BEGIN
-                    RETURN ($1 ~ $q$[\t\r\n\v\\]$q$);
-                END;
-                $function$
-                language plpgsql
-                SQL,
-            <<<'SQL'
-                CREATE FUNCTION phingPDOtest() RETURNS "trigger"
-                    AS $_X$
-                if (1)
-                {
-                    # All is well - just continue
-
-                    return;
-                }
-                else
-                {
-                    # Not good - this is probably a fatal error!
-                    elog(ERROR,"True is not true");
-
-                    return "SKIP";
-                }
-                $_X$
-                    LANGUAGE plperl
-                SQL,
-            "insert into foo (bar) \nvalues ('some value')",
-            <<<'SQL'
-                insert into foo (bar) values ($$ a dollar-quoted string containing a few quotes ' ", a $placeholder$ and a semicolon;$$)
-                SQL,
-            <<<'SQL'
-                create rule blah_insert
-                as on insert to blah do instead (
-                    insert into foo values (new.id, 'blah');
-                    insert into bar values (new.id, 'blah-blah');
-                )
-                SQL,
-            <<<'SQL'
-                insert into dump (message) values ('I am a statement not ending with a delimiter')
-                SQL,
-        ];
-        foreach ($expected as &$query) {
-            $query = str_replace(["\n\n", "\r"], ["\n", ''], $query);
-        }
-
-        $this->mockTask->setSrc(new File(PHING_TEST_BASE . '/etc/tasks/ext/pdo/delimiters-pgsql.sql'));
-        $this->mockTask->setUrl('pgsql:host=localhost;dbname=phing');
-        $this->mockTask->setDelimiterType(PDOSQLExecTask::DELIM_NORMAL);
-        $this->project->setProperty('bar.value', 'some value');
-        $this->project->executeTarget('test');
-
-        $this->assertEquals($expected, $this->queries);
-    }
-}