Пример #1
0
 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);
 }
Пример #2
0
 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);
 }