diff options
| author | Damian Dlugosz <bigfootdd@gmail.com> | 2017-01-23 23:52:36 +0100 |
|---|---|---|
| committer | Damian Dlugosz <bigfootdd@gmail.com> | 2017-02-01 23:33:23 +0100 |
| commit | ac5d4b119b4372673f5192f05a94109b7112edab (patch) | |
| tree | af5873a6f42d4cf15ba8d6b764c0715caa8bdc8b /tests/Utils | |
| parent | d92d5f996dd5ffa8f4300a684790ded68c375221 (diff) | |
| download | sql-parser-ac5d4b119b4372673f5192f05a94109b7112edab.zip sql-parser-ac5d4b119b4372673f5192f05a94109b7112edab.tar.gz sql-parser-ac5d4b119b4372673f5192f05a94109b7112edab.tar.bz2 | |
Testing string as alias
Diffstat (limited to 'tests/Utils')
| -rw-r--r-- | tests/Utils/FormatterTest.php | 18 |
1 files changed, 15 insertions, 3 deletions
diff --git a/tests/Utils/FormatterTest.php b/tests/Utils/FormatterTest.php index 22018e6..ca867af 100644 --- a/tests/Utils/FormatterTest.php +++ b/tests/Utils/FormatterTest.php @@ -381,13 +381,25 @@ class FormatTest extends TestCase "\x1b[35mINSERT" . "\n" . "\x1b[35mINTO" . "\n" . " \x1b[39mfoo" . "\n" . - "\x1b[35mVALUES\e[39m(\e[92m0\e[39m, \e[92m0\e[39m, \e[92m0\e[39m)\e[39m,\e[39m(\e[92m1\e[39m, \e[92m1\e[39m, \e[92m1\e[39m)" . "\x1b[0m", + "\x1b[35mVALUES\x1b[39m(\x1b[92m0\x1b[39m, \x1b[92m0\x1b[39m, \x1b[92m0\x1b[39m)\x1b[39m,\x1b[39m(\x1b[92m1\x1b[39m, \x1b[92m1\x1b[39m, \x1b[92m1\x1b[39m)" . "\x1b[0m", 'html' => '<span class="sql-reserved">INSERT</span>' . '<br/>' . '<span class="sql-reserved">INTO</span>' . '<br/>' . ' foo' . '<br/>' . '<span class="sql-reserved">VALUES</span>(<span class="sql-number">0</span>, <span class="sql-number">0</span>, <span class="sql-number">0</span>),(<span class="sql-number">1</span>, <span class="sql-number">1</span>, <span class="sql-number">1</span>)', ), + 'string as alias' => array( + 'query' => 'select "Text" as bar', + 'text' => + 'SELECT' . "\n" . + ' "Text" AS bar', + 'cli' => + "\x1b[35mSELECT" . "\n" . + " \x1b[91m\"Text\" \x1b[35mAS \x1b[39mbar" . "\x1b[0m", + 'html' => + '<span class="sql-reserved">SELECT</span>' . '<br/>' . + ' <span class="sql-string">"Text"</span> <span class="sql-reserved">AS</span> bar', + ), ); } @@ -484,7 +496,7 @@ class FormatTest extends TestCase "\x1b[35mSELECT\n \x1b[92m1\x1b[0m", array('type' => 'cli'), ), - array( + array( # Covered by 'string as alias' 'SELECT "Text" AS BAR', "\x1b[35mSELECT\n \x1b[91m\"Text\" \x1b[35mAS \x1b[39mBAR\x1b[0m", array('type' => 'cli'), @@ -528,7 +540,7 @@ class FormatTest extends TestCase ' < s > nxss <span class="sql-comment">/*s<s>xss*/</span>', array('type' => 'html'), ), - array( + array( # Covered by 'escape cli' "select 'text\x1b[33mcolor-inj' from tbl", "\x1b[35mSELECT\n \x1b[91m'text\\x1B[33mcolor-inj'\n\x1b[35mFROM\n \x1b[39mtbl\x1b[0m", array('type' => 'cli'), |