diff options
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 de9ed8b..08b7377 100644 --- a/tests/Utils/FormatterTest.php +++ b/tests/Utils/FormatterTest.php @@ -506,6 +506,48 @@ class FormatterTest extends TestCase "\x1b[0m", 'html' => '<span class="sql-reserved">JOIN</span> tbl2 <span class="sql-reserved">ON</span> c1 = c2', ], + 'named param' => [ + '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' => [ + '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>', + ], ]; } } |