summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorMichal Čihař <michal@cihar.com>2016-02-19 13:48:34 +0100
committerMichal Čihař <michal@cihar.com>2016-02-19 13:48:34 +0100
commit9ab1488b5d0c70eef07c1a1561f869f2597056e4 (patch)
tree7e104541cdb00b3abaa1ab15404faa153e784929
parentc8519316041f0dfebac6da459058edd9f014096e (diff)
downloadsql-parser-9ab1488b5d0c70eef07c1a1561f869f2597056e4.zip
sql-parser-9ab1488b5d0c70eef07c1a1561f869f2597056e4.tar.gz
sql-parser-9ab1488b5d0c70eef07c1a1561f869f2597056e4.tar.bz2
Add formatter test for procedure
Signed-off-by: Michal Čihař <michal@cihar.com>
-rw-r--r--tests/Utils/FormatterTest.php11
1 files changed, 11 insertions, 0 deletions
diff --git a/tests/Utils/FormatterTest.php b/tests/Utils/FormatterTest.php
index a1552ca..81b9b28 100644
--- a/tests/Utils/FormatterTest.php
+++ b/tests/Utils/FormatterTest.php
@@ -47,6 +47,17 @@ class FormatTest extends TestCase
'<span class="sql-reserved">WHERE</span>' . "\n" .
' bar = <span class="sql-number">1</span>'
),
+ array(
+ 'CREATE PROCEDURE SPTEST() BEGIN FROM a SELECT *; END',
+ '<span class="sql-reserved">CREATE</span>' . "\n" .
+ '<span class="sql-reserved">PROCEDURE</span> SPTEST()' . "\n" .
+ '<span class="sql-keyword">BEGIN</span>' . "\n" .
+ '<span class="sql-reserved">FROM</span>' . "\n" .
+ ' a' . "\n" .
+ '<span class="sql-reserved">SELECT</span>' . "\n" .
+ ' *;' . "\n" .
+ '<span class="sql-keyword">END</span>'
+ ),
);
}
}