diff options
| author | Radosław Kowalewski <rk@srsbiz.pl> | 2019-04-19 09:49:51 +0200 |
|---|---|---|
| committer | Radosław Kowalewski <rk@srsbiz.pl> | 2019-04-19 09:49:51 +0200 |
| commit | 3adf389870cc6b3c9cf7dd279a3f253d02e1ad64 (patch) | |
| tree | fff9d251aeea3ecfdf71b1f2dca8dae8ce5d74f0 /tests/Utils/FormatterTest.php | |
| parent | 0eb16ef5e3acacbc792be336754e42d98791a33f (diff) | |
| download | sql-parser-3adf389870cc6b3c9cf7dd279a3f253d02e1ad64.zip sql-parser-3adf389870cc6b3c9cf7dd279a3f253d02e1ad64.tar.gz sql-parser-3adf389870cc6b3c9cf7dd279a3f253d02e1ad64.tar.bz2 | |
Recognize question mark as parameter, add formatter for parameters
Diffstat (limited to 'tests/Utils/FormatterTest.php')
| -rw-r--r-- | tests/Utils/FormatterTest.php | 42 |
1 files changed, 42 insertions, 0 deletions
diff --git a/tests/Utils/FormatterTest.php b/tests/Utils/FormatterTest.php index d39ff9e..10eae3a 100644 --- a/tests/Utils/FormatterTest.php +++ b/tests/Utils/FormatterTest.php @@ -506,6 +506,48 @@ class FormatTest extends TestCase "\x1b[0m", 'html' => '<span class="sql-reserved">JOIN</span> tbl2 <span class="sql-reserved">ON</span> c1 = c2', ), + 'named param' => array( + 'query' => 'select * from tbl where col = :param', + 'text' => 'SELECT' . "\n" . + ' *' . "\n" . + 'FROM' . "\n" . + ' tbl' . "\n" . + 'WHERE' . "\n" . + ' col = :param', + 'cli' => "\x1b[35mSELECT" . "\n" . + " \x1b[39m*" . "\n" . + "\x1b[35mFROM" . "\n" . + " \x1b[39mtbl" . "\n" . + "\x1b[35mWHERE" . "\n" . + " \x1b[39mcol = \x1b[31m:param" . "\x1b[0m", + 'html' => '<span class="sql-reserved">SELECT</span>' . '<br/>' . + ' *' . '<br/>' . + '<span class="sql-reserved">FROM</span>' . '<br/>' . + ' tbl' . '<br/>' . + '<span class="sql-reserved">WHERE</span>' . '<br/>' . + ' col = <span class="sql-parameter">:param</span>', + ), + 'anon param' => array( + 'query' => 'select * from tbl where col = ?', + 'text' => 'SELECT' . "\n" . + ' *' . "\n" . + 'FROM' . "\n" . + ' tbl' . "\n" . + 'WHERE' . "\n" . + ' col = ?', + 'cli' => "\x1b[35mSELECT" . "\n" . + " \x1b[39m*" . "\n" . + "\x1b[35mFROM" . "\n" . + " \x1b[39mtbl" . "\n" . + "\x1b[35mWHERE" . "\n" . + " \x1b[39mcol = \x1b[31m?" . "\x1b[0m", + 'html' => '<span class="sql-reserved">SELECT</span>' . '<br/>' . + ' *' . '<br/>' . + '<span class="sql-reserved">FROM</span>' . '<br/>' . + ' tbl' . '<br/>' . + '<span class="sql-reserved">WHERE</span>' . '<br/>' . + ' col = <span class="sql-parameter">?</span>', + ), ); } } |