assertEquals(
$expected,
Formatter::format($query, array('type' => $type))
);
}
public function formatQueries()
{
return array(
array(
'SELECT 1',
'SELECT' . "\n" .
' 1',
'html'
),
array(
'SELECT 1 # Comment',
'SELECT' . "\n" .
' 1 ',
'html'
),
array(
'SELECT HEX("1")',
'SELECT' . "\n" .
' HEX("1")',
'html'
),
array(
'SELECT * FROM foo WHERE bar=1',
'SELECT' . "\n" .
' *' . "\n" .
'FROM' . "\n" .
' foo' . "\n" .
'WHERE' . "\n" .
' bar = 1',
'html'
),
array(
'CREATE PROCEDURE SPTEST() BEGIN FROM a SELECT *; END',
'CREATE' . "\n" .
'PROCEDURE SPTEST()' . "\n" .
'BEGIN' . "\n" .
'FROM' . "\n" .
' a' . "\n" .
'SELECT' . "\n" .
' *;' . "\n" .
'END',
'html'
),
array(
'INSERT INTO foo VALUES (0, 0, 0), (1, 1, 1)',
'INSERT' . "\n" .
'INTO' . "\n" .
' foo' . "\n" .
'VALUES' .
'(0, 0, 0),' .
'(1, 1, 1)',
'html'
),
array(
'SELECT 1',
"\x1b[35mSELECT\n \x1b[92m1\e[0m",
'cli'
),
);
}
}