本文整理汇总了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) . ")";
}
}