protected function getExistingRelRecordPairs(dmDoctrineTable $refTable) { $columns = array(); foreach ($refTable->getRelationHolder()->getLocals() as $relationAlias => $relation) { $columns[] = $relation->getLocalColumnName(); } if (2 !== count($columns)) { return array(); } return dmDb::pdo(sprintf('SELECT r.%s, r.%s FROM %s r', $columns[0], $columns[1], $refTable->getTableName()))->fetchAll(PDO::FETCH_ASSOC); }
protected function getExistingRelRecordPairs(dmDoctrineTable $refTable) { $columns = array(); foreach ($refTable->getRelationHolder()->getLocals() as $relationAlias => $relation) { $columns[] = $relation->getLocalColumnName(); } if (2 !== count($columns)) { $columns = array_unique($columns); //fix: whenever association is badly made, same column can appear twice if (2 !== count($columns)) { return array(); } } return dmDb::pdo(sprintf('SELECT r.%s, r.%s FROM %s r', $columns[0], $columns[1], $refTable->getTableName()))->fetchAll(PDO::FETCH_ASSOC); }