diff options
| author | Dan Ungureanu <udan1107@gmail.com> | 2017-05-12 19:48:32 +0300 |
|---|---|---|
| committer | Dan Ungureanu <udan11@users.noreply.github.com> | 2017-05-16 21:58:07 +0300 |
| commit | 93167f30e093869e501939b7f0d42cf65965b2f9 (patch) | |
| tree | 4797c4a891a67ebf5acf381449646a1122a4103f /tests/Utils | |
| parent | 867a9285327d26e4e23b5d098974c8fc3447bc06 (diff) | |
| download | sql-parser-93167f30e093869e501939b7f0d42cf65965b2f9.zip sql-parser-93167f30e093869e501939b7f0d42cf65965b2f9.tar.gz sql-parser-93167f30e093869e501939b7f0d42cf65965b2f9.tar.bz2 | |
Improved format of INSERT queries.
Signed-off-by: Dan Ungureanu <udan1107@gmail.com>
Diffstat (limited to 'tests/Utils')
| -rw-r--r-- | tests/Utils/FormatterTest.php | 12 |
1 files changed, 3 insertions, 9 deletions
diff --git a/tests/Utils/FormatterTest.php b/tests/Utils/FormatterTest.php index 12e9912..f90281d 100644 --- a/tests/Utils/FormatterTest.php +++ b/tests/Utils/FormatterTest.php @@ -430,17 +430,11 @@ class FormatTest extends TestCase ), 'insert' => array( 'query' => 'insert into foo values (0, 0, 0), (1, 1, 1)', - 'text' => 'INSERT' . "\n" . - 'INTO' . "\n" . - ' foo' . "\n" . + 'text' => 'INSERT INTO foo' . "\n" . 'VALUES(0, 0, 0),(1, 1, 1)', - 'cli' => "\x1b[35mINSERT" . "\n" . - "\x1b[35mINTO" . "\n" . - " \x1b[39mfoo" . "\n" . + 'cli' => "\x1b[35mINSERT \x1b[35mINTO \x1b[39mfoo" . "\n" . "\x1b[35mVALUES\x1b[39m(\x1b[92m0\x1b[39m, \x1b[92m0\x1b[39m, \x1b[92m0\x1b[39m)\x1b[39m,\x1b[39m(\x1b[92m1\x1b[39m, \x1b[92m1\x1b[39m, \x1b[92m1\x1b[39m)" . "\x1b[0m", - 'html' => '<span class="sql-reserved">INSERT</span>' . '<br/>' . - '<span class="sql-reserved">INTO</span>' . '<br/>' . - ' foo' . '<br/>' . + 'html' => '<span class="sql-reserved">INSERT</span> <span class="sql-reserved">INTO</span> 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>)', ), 'string as alias' => array( |