function testRemoveComments()
{
$expected = SqlFormatter::format("SELECT\n * FROM\n MyTable", false);
$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);
}
</div>
<table>
<tr>
<th>Original</th>
<th>Comments Removed</th>
</tr>
<?php
foreach ($comment_statements as $sql) {
?>
<tr>
<td>
<pre><?php
echo SqlFormatter::highlight($sql);
?>
</pre>
</td>
<td>
<pre><?php
echo SqlFormatter::highlight(SqlFormatter::removeComments($sql));
?>
</pre>
</td>
</tr>
<?php
}
?>
</table>
</body>
</html>
