/**
* @see DataAnalyzerInterface::runAndMakeMessages()
*/
public function runAndMakeMessages(AnalyzerSupportedDataProvider $dataProvider, $columnName)
{
$acceptableValues = BooleanSanitizerUtil::getAcceptableValues();
$inPart = SQLOperatorUtil::resolveOperatorAndValueForOneOf('oneOf', $acceptableValues);
$where = DatabaseCompatibilityUtil::lower($columnName) . ' NOT ' . $inPart;
$count = $dataProvider->getCountByWhere($where);
if ($count > 0) {
$label = '{count} value(s) have invalid check box values. ';
$label .= 'These values will be set to false upon import.';
$this->addMessage(Zurmo::t('ImportModule', $label, array('{count}' => $count)));
}
}
public function testLower()
{
$this->assertEquals('lower(tempColumn)', DatabaseCompatibilityUtil::lower('tempColumn'));
}
