/**
* Check table and data
*
* @param Table $table
* @throws \Exception Throw when error found
*/
public function check(Table $table)
{
$columns = $table->getColumns();
$filters = $table->getFilters();
$successfulFilters = [];
foreach ($filters as $id => $filterData) {
$successfulNames = [];
foreach ($filterData as $name => $value) {
$test = $this->checkFilter($name, $columns[$id]['type'], $value, null);
if ($test !== null) {
$successfulNames[$name] = $value;
}
}
if (count($successfulNames) > 0) {
$successfulFilters[$id] = $successfulNames;
}
}
$table->setFilters($successfulFilters);
}
/**
* Check table and data
*
* @param Table $table
* @throws \Exception Throw when error found
*/
public function check(Table $table)
{
foreach ($table->getColumns() as $id => $params) {
if (!isset($params['field_name'])) {
throw new \Exception("No 'field_name' param for ID {$id}");
}
}
$backupAndOps = $this->andOps;
$columns = $table->getColumns();
$successfulFilters = [];
foreach ($table->getFilters() as $column => $filters) {
$successfulNames = [];
foreach ($filters as $name => $value) {
if ($this->buildFilter($columns[$column]['field_name'], $columns[$column]['type'], $name, $value)) {
$successfulNames[$name] = $value;
}
}
if (count($successfulNames) > 0) {
$successfulFilters[$column] = $successfulNames;
}
}
$table->setFilters($successfulFilters);
$this->andOps = $backupAndOps;
}
/**
* Check table and data
*
* @param Table $table
* @throws Throws when error found
* @return GenericDBAdapter
*/
public function check(Table $table)
{
$columns = $table->getColumns();
foreach ($columns as $id => $params) {
if (!isset($params['sql_id'])) {
throw new \Exception("No 'sql_id' param for ID {$id}");
}
}
$backupSqlAnds = $this->sqlAnds;
$backupSqlParams = $this->sqlParams;
$successfulFilters = [];
foreach ($table->getFilters() as $column => $filterData) {
$successfulNames = [];
foreach ($filterData as $name => $value) {
if ($this->buildFilter($columns[$column]['sql_id'], $columns[$column]['type'], $name, $value)) {
$successfulNames[$name] = $value;
}
}
if (count($successfulNames) > 0) {
$successfulFilters[$column] = $successfulNames;
}
}
$table->setFilters($successfulFilters);
$this->sqlAnds = $backupSqlAnds;
$this->sqlParams = $backupSqlParams;
return $this;
}
