summaryrefslogtreecommitdiffstats
path: root/tests
diff options
context:
space:
mode:
Diffstat (limited to 'tests')
-rw-r--r--tests/Lexer/TokenTest.php6
-rw-r--r--tests/Utils/FormatterTest.php42
2 files changed, 48 insertions, 0 deletions
diff --git a/tests/Lexer/TokenTest.php b/tests/Lexer/TokenTest.php
index 535f933..68d3b00 100644
--- a/tests/Lexer/TokenTest.php
+++ b/tests/Lexer/TokenTest.php
@@ -74,6 +74,12 @@ class TokenTest extends TestCase
$tok = new Token('@`foo`', Token::TYPE_SYMBOL, Token::FLAG_SYMBOL_VARIABLE);
$this->assertEquals($tok->value, 'foo');
+
+ $tok = new Token(':foo', Token::TYPE_SYMBOL, Token::FLAG_SYMBOL_PARAMETER);
+ $this->assertEquals($tok->value, 'foo');
+
+ $tok = new Token('?', Token::TYPE_SYMBOL, Token::FLAG_SYMBOL_PARAMETER);
+ $this->assertEquals($tok->value, '?');
}
public function testInlineToken()
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/>' .
+ '&nbsp;&nbsp;&nbsp;&nbsp;*' . '<br/>' .
+ '<span class="sql-reserved">FROM</span>' . '<br/>' .
+ '&nbsp;&nbsp;&nbsp;&nbsp;tbl' . '<br/>' .
+ '<span class="sql-reserved">WHERE</span>' . '<br/>' .
+ '&nbsp;&nbsp;&nbsp;&nbsp;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/>' .
+ '&nbsp;&nbsp;&nbsp;&nbsp;*' . '<br/>' .
+ '<span class="sql-reserved">FROM</span>' . '<br/>' .
+ '&nbsp;&nbsp;&nbsp;&nbsp;tbl' . '<br/>' .
+ '<span class="sql-reserved">WHERE</span>' . '<br/>' .
+ '&nbsp;&nbsp;&nbsp;&nbsp;col = <span class="sql-parameter">?</span>',
+ ),
);
}
}