diff options
| author | Damian Dlugosz <bigfootdd@gmail.com> | 2017-01-23 23:37:35 +0100 |
|---|---|---|
| committer | Damian Dlugosz <bigfootdd@gmail.com> | 2017-02-01 23:33:23 +0100 |
| commit | f810a7bf08ced39a5e731b8b824bc2ed642d96be (patch) | |
| tree | 79e26ece54bb56ceed465ae37fa7b3775e731633 | |
| parent | 8f857c00f27c25dd7a6807dfbf47dc231a1531ea (diff) | |
| download | sql-parser-f810a7bf08ced39a5e731b8b824bc2ed642d96be.zip sql-parser-f810a7bf08ced39a5e731b8b824bc2ed642d96be.tar.gz sql-parser-f810a7bf08ced39a5e731b8b824bc2ed642d96be.tar.bz2 | |
Testing Insert
| -rw-r--r-- | tests/Utils/FormatterTest.php | 18 |
1 files changed, 12 insertions, 6 deletions
diff --git a/tests/Utils/FormatterTest.php b/tests/Utils/FormatterTest.php index 5816a98..355027b 100644 --- a/tests/Utils/FormatterTest.php +++ b/tests/Utils/FormatterTest.php @@ -361,14 +361,20 @@ class FormatTest extends TestCase 'insert' => array( 'query' => 'insert into foo values (0, 0, 0), (1, 1, 1)', 'text' => - 'SELECT' . "\n" . - ' HEX("1")', + 'INSERT' . "\n" . + 'INTO' . "\n" . + ' foo' . "\n" . + 'VALUES(0, 0, 0),(1, 1, 1)', 'cli' => - "\x1b[35mSELECT" . "\n" . - " \x1b[95mHEX\x1b[39m(\x1b[91m\"1\"\x1b[39m)" . "\x1b[0m", + "\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", 'html' => - '<span class="sql-reserved">SELECT</span>' . '<br/>' . - ' <span class="sql-keyword">HEX</span>(<span class="sql-string">"1"</span>)', + '<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>)', ), ); } |