本文整理汇总了PHP中Doctrine\DBAL\Query\QueryBuilder::getSql方法的典型用法代码示例。如果您正苦于以下问题：PHP QueryBuilder::getSql方法的具体用法？PHP QueryBuilder::getSql怎么用？PHP QueryBuilder::getSql使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Doctrine\DBAL\Query\QueryBuilder的用法示例。
在下文中一共展示了QueryBuilder::getSql方法的1个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: modifyCountQuery
/**
* Modify the query to count occurences of a value in a column
*
* @param QueryBuilder $table without prefix
* @param string $uniqueColumn name
* @param array $options for special behavior
* @param string $tablePrefix
*/
public function modifyCountQuery(QueryBuilder &$query, $uniqueColumn, $options = [], $tablePrefix = 't')
{
$query->select('COUNT(' . $tablePrefix . '.' . $uniqueColumn . ') AS count');
// Count only unique values
if (!empty($options['getUnique'])) {
$selectAlso = '';
if (isset($options['selectAlso'])) {
$selectAlso = ', ' . implode(', ', $options['selectAlso']);
}
// Modify the previous query
$query->select($tablePrefix . '.' . $uniqueColumn . $selectAlso);
$query->having('COUNT(*) = 1')->groupBy($tablePrefix . '.' . $uniqueColumn . $selectAlso);
// Create a new query with subquery of the previous query
$uniqueQuery = $this->connection->createQueryBuilder();
$uniqueQuery->select('COUNT(' . $tablePrefix . '.' . $uniqueColumn . ') AS count')->from('(' . $query->getSql() . ')', $tablePrefix);
// Apply params from the previous query to the new query
$uniqueQuery->setParameters($query->getParameters());
// Replace the new query with previous query
$query = $uniqueQuery;
}
return $query;
}