DboSource assumes data source has method queryAssociation

[ghost]

Created by skoranda (at gmail), 22nd Apr 2013. (originally Lighthouse ticket #3780):

---

The function queryAssociation in DboSource.php assumes that the data source instance has a queryAssociation() method in this code fragment:

if (!empty($fetch) && is_array($fetch)) {
if ($recursive > 0) {
foreach ($linkModel->associations() as $type1) {
foreach ($linkModel->{$type1} as $assoc1 => $assocData1) {
$deepModel = $linkModel->{$assoc1};
$tmpStack = $stack;
$tmpStack[] = $assoc1;

                            if ($linkModel->useDbConfig === $deepModel->useDbConfig) {
                                $db = $this;
                            } else {
                                $db = ConnectionManager::getDataSource($deepModel->useDbConfig);
                            }
                            $db->queryAssociation($linkModel, $deepModel, $type1, $assoc1, $assocData1, $queryData, true, $fetch, $recursive - 1, $tmpStack);
                        }
                    }
                }
            }

and then again in this code fragment:

if ($recursive > 0) {
foreach ($linkModel->associations() as $type1) {
foreach ($linkModel->{$type1} as $assoc1 => $assocData1) {
$deepModel = $linkModel->{$assoc1};

                            if ($type1 === 'belongsTo' || ($deepModel->alias === $modelAlias && $type === 'belongsTo') || ($deepModel->alias !== $modelAlias)) {
                                $tmpStack = $stack;
                                $tmpStack[] = $assoc1;
                                if ($linkModel->useDbConfig == $deepModel->useDbConfig) {
                                    $db = $this;
                                } else {
                                    $db = ConnectionManager::getDataSource($deepModel->useDbConfig);
                                }
                                $db->queryAssociation($linkModel, $deepModel, $type1, $assoc1, $assocData1, $queryData, true, $fetch, $recursive - 1, $tmpStack);
                            }
                        }
                    }
                }

Not all data sources will have a queryAssociation method, especially when using models that do not use a relational database as the data store.

[ghost]

22nd Apr 2013, Jose Lorenzo Rodríguez said:

---

What it does assume is that for fetching association data other datasources must also be a database drivers. Otherwise it would make little sense trying to get them.

As a workaround for now, try to not fetch associations if you are using disimilar datasources. You can limit them by using $recursive = -1 in your model.

[ghost]

22nd Apr 2013, Mark Story said:

---

What should happen when you attempt to load associated data in a non-relational datastore? If queryAssociation() wasn't called then nothing would happen.

[lorenzo]

No follow ups on this issue after 6 months, closing