Source of file SqlFormatterTest.php
Size: 3,784 Bytes - Last Modified: 2013-04-26T20:42:52+02:00
/home/theseer/Downloads/Symfony/vendor/jdorn/sql-formatter/tests/SqlFormatterTest.php
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149 | <?php require __DIR__.'/../lib/SqlFormatter.php'; // Force SqlFormatter to run in non-CLI mode for tests SqlFormatter::$cli = false; class SqlFormatterTest extends PHPUnit_Framework_TestCase { protected $sqlData; /** * @dataProvider formatHighlightData */ function testFormatHighlight($sql, $html) { $this->assertEquals(trim($html), trim(SqlFormatter::format($sql))); } /** * @dataProvider formatData */ function testFormat($sql, $html) { $this->assertEquals(trim($html), trim(SqlFormatter::format($sql, false))); } /** * @dataProvider highlightData */ function testHighlight($sql, $html) { $this->assertEquals(trim($html), trim(SqlFormatter::highlight($sql))); } function testUsePre() { SqlFormatter::$use_pre = false; $actual = SqlFormatter::highlight("test"); $expected = '<span style="color: #333;">test</span>'; $this->assertEquals($actual,$expected); SqlFormatter::$use_pre = true; $actual = SqlFormatter::highlight("test"); $expected = '<pre style="color: black; background-color: white;"><span style="color: #333;">test</span></pre>'; $this->assertEquals($actual,$expected); } function testSplitQuery() { $expected = array( "SELECT 'test' FROM MyTable;", "SELECT Column2 FROM SomeOther Table WHERE (test = true);" ); $actual = SqlFormatter::splitQuery(implode(';',$expected)); $this->assertEquals($expected, $actual); } function testSplitQueryEmpty() { $sql = "SELECT 1;SELECT 2;\n-- This is a comment\n;SELECT 3"; $expected = array("SELECT 1;","SELECT 2;","SELECT 3"); $actual = SqlFormatter::splitQuery($sql); $this->assertEquals($expected, $actual); } function testRemoveComments() { $expected = "SELECT\n * FROM\n MyTable"; $sql = "/* this is a comment */SELECT#This is another comment\n * FROM-- One final comment\n MyTable"; $actual = SqlFormatter::removeComments($sql); $this->assertEquals($expected, $actual); } function testCacheStats() { $stats = SqlFormatter::getCacheStats(); $this->assertGreaterThan(1,$stats['hits']); } function formatHighlightData() { $formatHighlightData = explode("\n\n",file_get_contents(__DIR__."/format-highlight.html")); $sqlData = $this->sqlData(); $return = array(); foreach($formatHighlightData as $i=>$data) { $return[] = array( $sqlData[$i], $data ); } //$return = array_slice($return, 0, 50); return $return; } function formatData() { $formatData = explode("\n\n",file_get_contents(__DIR__."/format.html")); $sqlData = $this->sqlData(); $return = array(); foreach($formatData as $i=>$data) { $return[] = array( $sqlData[$i], $data ); } //$return = array_slice($return, 0, 50); return $return; } function highlightData() { $highlightData = explode("\n\n",file_get_contents(__DIR__."/highlight.html")); $sqlData = $this->sqlData(); $return = array(); foreach($highlightData as $i=>$data) { $return[] = array( $sqlData[$i], $data ); } //$return = array_slice($return, 0, 50); return $return; } function sqlData() { if(!$this->sqlData) { $this->sqlData = explode("\n\n",file_get_contents(__DIR__."/sql.sql")); } /** $formatHighlight = array(); $highlight = array(); $format = array(); foreach($this->sqlData as $sql) { $formatHighlight[] = trim(SqlFormatter::format($sql)); $highlight[] = trim(SqlFormatter::highlight($sql)); $format[] = trim(SqlFormatter::format($sql, false)); } file_put_contents(__DIR__."/format-highlight.html", implode("\n\n",$formatHighlight)); file_put_contents(__DIR__."/highlight.html", implode("\n\n",$highlight)); file_put_contents(__DIR__."/format.html", implode("\n\n",$format)); /**/ return $this->sqlData; } } |