本文整理匯總了PHP中DatabaseCompatibilityUtil::getOperatorAndValueWherePart方法的典型用法代碼示例。如果您正苦於以下問題：PHP DatabaseCompatibilityUtil::getOperatorAndValueWherePart方法的具體用法？PHP DatabaseCompatibilityUtil::getOperatorAndValueWherePart怎麽用？PHP DatabaseCompatibilityUtil::getOperatorAndValueWherePart使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類DatabaseCompatibilityUtil的用法示例。
在下文中一共展示了DatabaseCompatibilityUtil::getOperatorAndValueWherePart方法的3個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: addWherePartByClauseInformationForConcatedAttributes
/**
* Add a sql string to the where array base on the $operatorType, $value and $tableAliasAndColumnNames concated
* together. How the sql string is built depends on if the value is a string or not.
* @param string $operatorType
* @param mixed $value
* @param array $where
* @param integer $whereKey
* @param array $tableAliasAndColumnNames
*/
protected static function addWherePartByClauseInformationForConcatedAttributes($operatorType, $value, &$where, $whereKey, $tableAliasAndColumnNames)
{
assert('is_string($operatorType)');
assert('is_array($where)');
assert('is_int($whereKey)');
assert('is_array($tableAliasAndColumnNames) && count($tableAliasAndColumnNames) == 2');
$quote = DatabaseCompatibilityUtil::getQuote();
if (is_string($value) || is_array($value) && count($value) > 0 || $value !== null) {
$first = ModelJoinBuilder::makeColumnNameWithTableAlias($tableAliasAndColumnNames[0][0], $tableAliasAndColumnNames[0][1]);
$second = ModelJoinBuilder::makeColumnNameWithTableAlias($tableAliasAndColumnNames[1][0], $tableAliasAndColumnNames[1][1]);
$concatedSqlPart = DatabaseCompatibilityUtil::concat(array($first, '\' \'', $second));
$where[$whereKey] = "({$concatedSqlPart} " . DatabaseCompatibilityUtil::getOperatorAndValueWherePart($operatorType, $value) . ")";
}
}示例2: testGetOperatorAndValueWherePartForNullOrEmpty
public function testGetOperatorAndValueWherePartForNullOrEmpty()
{
$queryPart = DatabaseCompatibilityUtil::getOperatorAndValueWherePart('isNull', null);
$compareQueryPart = "IS NULL";
// Not Coding Standard
$this->assertEquals($compareQueryPart, $queryPart);
$queryPart = DatabaseCompatibilityUtil::getOperatorAndValueWherePart('isNotNull', null);
$compareQueryPart = "IS NOT NULL";
// Not Coding Standard
$this->assertEquals($compareQueryPart, $queryPart);
$queryPart = DatabaseCompatibilityUtil::getOperatorAndValueWherePart('isEmpty', null);
$compareQueryPart = "= ''";
// Not Coding Standard
$this->assertEquals($compareQueryPart, $queryPart);
$queryPart = DatabaseCompatibilityUtil::getOperatorAndValueWherePart('isNotEmpty', null);
$compareQueryPart = "!= ''";
// Not Coding Standard
$this->assertEquals($compareQueryPart, $queryPart);
}示例3: addWherePartByClauseInformation
/**
* Add a sql string to the where array. How the sql string is built depends on if the value is a string or not.
* @param $operatorType
* @param $value
* @param $where
* @param $whereKey
* @param $tableAliasName
* @param $columnName
*/
protected function addWherePartByClauseInformation($operatorType, $value, &$where, $whereKey, $tableAliasName, $columnName)
{
assert('is_string($operatorType)');
assert('is_array($where)');
assert('is_int($whereKey)');
assert('is_string($tableAliasName)');
assert('is_string($columnName)');
if (is_string($value) || is_array($value) && count($value) > 0 || $value !== null || $value === null && SQLOperatorUtil::doesOperatorTypeAllowNullValues($operatorType)) {
$where[$whereKey] = "(" . self::resolveWhereColumnContentForModifier($tableAliasName, $columnName) . " " . DatabaseCompatibilityUtil::getOperatorAndValueWherePart($operatorType, $value) . ")";
}
}