/**
* @covers Amiss\Sql\Query\Select::buildFields
*/
public function testBuildFieldsWithNoFieldsOrMeta()
{
$criteria = new Query\Select();
$criteria->fields = null;
$meta = null;
$fields = $criteria->buildFields($meta);
$this->assertEquals('*', $fields);
}
protected function buildQuery($index, $relatedMeta, $viaMeta, $sourceToViaOn, $viaToDestOn, $criteria)
{
$viaFields = $viaMeta->fields;
$relatedFields = $relatedMeta->fields;
$query = new Query\Select();
list($query->where, $query->params) = $this->buildRelatedClause($index, 't2');
if ($criteria instanceof Query\Select) {
$query->page = $criteria->page;
$query->limit = $criteria->limit;
$query->args = $criteria->args;
$query->offset = $criteria->offset;
$query->order = $criteria->order;
$query->forUpdate = $criteria->forUpdate;
}
$queryFields = $query->buildFields($relatedMeta, 't1');
$sourcePkFields = array();
foreach ($sourceToViaOn as $l => $r) {
$field = $viaFields[$r];
$sourcePkFields[] = $field['name'];
}
$joinOn = array();
foreach ($viaToDestOn as $l => $r) {
$joinOn[] = 't2.`' . $viaFields[$l]['name'] . '` = t1.`' . $relatedFields[$r]['name'] . '`';
}
$joinOn = implode(' AND ', $joinOn);
list($where, $params, $props) = $query->buildClause(null);
if ($criteria) {
list($cWhere, $cParams, $cProps) = $criteria->buildClause($relatedMeta);
if ($cWhere) {
$params = array_merge($cParams, $params);
$props = array_merge($props, $cProps);
$where .= ' AND (' . $cWhere . ')';
}
}
$order = $query->buildOrder($relatedMeta, 't1');
list($limit, $offset) = $query->getLimitOffset();
$vt = ($viaMeta->schema ? "`{$viaMeta->schema}`." : null) . "`{$viaMeta->table}`";
$rt = ($relatedMeta->schema ? "`{$relatedMeta->schema}`." : null) . "`{$relatedMeta->table}`";
$sql = "\n SELECT \n {$queryFields}, t2." . '`' . implode('`, t2.`', $sourcePkFields) . '`' . "\n FROM\n {$vt} t2\n INNER JOIN\n {$rt} t1\n ON ({$joinOn})\n WHERE {$where} " . ($order ? "ORDER BY {$order} " : '') . ' ' . ($limit ? "LIMIT " . (int) $limit . " " : '') . ' ' . ($offset ? "OFFSET " . (int) $offset . " " : '') . ' ' . ($query->forUpdate ? 'FOR UPDATE' : '');
return array($sql, $params, $sourcePkFields, $props);
}
