本文整理匯總了PHP中SqlFormatter::compress方法的典型用法代碼示例。如果您正苦於以下問題：PHP SqlFormatter::compress方法的具體用法？PHP SqlFormatter::compress怎麽用？PHP SqlFormatter::compress使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類SqlFormatter的用法示例。
在下文中一共展示了SqlFormatter::compress方法的5個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: testUnionAll
/**
* Method to test union().
*
* @return void
*
* @covers Windwalker\Query\Query::union
*/
public function testUnionAll()
{
$query = $this->getQuery();
$query->unionAll($this->getQuery()->select('*')->from('foo')->where('a = b')->order('id'))->union($this->getQuery()->select('*')->from('foo')->where('a = b')->order('id'));
$sql = '( SELECT * FROM foo WHERE a = b ORDER BY id) UNION ALL ( SELECT * FROM foo WHERE a = b ORDER BY id)';
$this->assertEquals(\SqlFormatter::compress($sql), \SqlFormatter::compress($query));
}示例2: foreach
<tr>
<th>Original</th>
<th>Compressed</th>
</tr>
<?php
foreach ($statements as $sql) {
?>
<tr>
<td>
<pre><?php
echo $sql;
?>
</pre>
</td>
<td><pre><?php
echo SqlFormatter::compress($sql);
?>
</pre></td>
</tr>
<?php
}
?>
</table>
<h1>Splitting SQL Strings Into Individual Queries</h1>
<div>
Usage:
<pre>
<?php 示例3: testReplace
/**
* Method to test replace().
*
* @return void
*
* @covers Windwalker\Query\Postgresql\PostgresqlQueryBuilder::replace
*/
public function testReplace()
{
$expected = "REPLACE INTO {$this->qn}foo{$this->qn} (a,b) VALUES (c, d, e), (f, g, h)";
$actual = PostgresqlQueryBuilder::replace('foo', array('a', 'b'), array('c, d, e', 'f, g, h'));
$this->assertEquals(\SqlFormatter::compress($expected), \SqlFormatter::compress($actual));
}示例4: testCompress
/**
* @dataProvider compressData
*/
function testCompress($sql, $html)
{
$this->assertEquals(trim($html), trim(SqlFormatter::compress($sql)));
}示例5: print_sql
function print_sql($query)
{
if ($GLOBALS['cli']) {
print_vars($query);
} else {
if (class_exists('SqlFormatter')) {
// Hide it under a "database icon" popup.
#echo overlib_link('#', '<i class="oicon-databases"> </i>', SqlFormatter::highlight($query));
$query = SqlFormatter::compress($query);
echo '<p>', SqlFormatter::highlight($query), '</p>';
} else {
print_vars($query);
}
}
}