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'
),
array(
'SELECT coditm AS Item, descripcion AS Descripcion, contenedores AS Contenedores, IF(suspendido = 1, Si, NO) AS Suspendido FROM `DW_articulos` WHERE superado = 0',
'SELECT' . "\n" .
' coditm AS Item,' . "\n" .
' descripcion AS Descripcion,' . "\n" .
' contenedores AS Contenedores,' . "\n" .
' IF(suspendido = 1, Si, NO) AS Suspendido' . "\n" .
'FROM' . "\n" .
' `DW_articulos`' . "\n" .
'WHERE' . "\n" .
' superado = 0',
'html',
),
);
}
}