/**
* Add the constraints for a relationship count query on the same table.
*
* @param \Database\ORM\Builder $query
* @param \Database\ORM\Builder $parent
* @return \Database\ORM\Builder
*/
public function getRelationCountQueryForSelfJoin(Builder $query, Builder $parent)
{
$query->select(new Expression('count(*)'));
$tablePrefix = $this->query->getQuery()->getConnection()->getTablePrefix();
$query->from($this->table . ' as ' . $tablePrefix . ($hash = $this->getRelationCountHash()));
$key = $this->wrap($this->getQualifiedParentKeyName());
return $query->where($hash . '.' . $this->foreignKey, '=', new Expression($key));
}
/**
* Set the keys for a save update query.
*
* @param \Database\ORM\Builder $query
* @return \Database\ORM\Builder
*/
protected function setKeysForSaveQuery(Builder $query)
{
$query->where($this->getKeyName(), '=', $this->getKeyForSaveQuery());
return $query;
}
/**
* Add the constraints for a relationship count query.
*
* @param \Database\ORM\Builder $query
* @param \Database\ORM\Builder $parent
* @return \Database\ORM\Builder
*/
public function getRelationCountQuery(Builder $query, Builder $parent)
{
$query->select(new Expression('count(*)'));
$key = $this->wrap($this->getQualifiedParentKeyName());
return $query->where($this->getHasCompareKey(), '=', new Expression($key));
}
/**
* Set the keys for a save update query.
*
* @param \Database\ORM\Builder
* @return \Database\ORM\Builder
*/
protected function setKeysForSaveQuery(Builder $query)
{
$query->where($this->foreignKey, $this->getAttribute($this->foreignKey));
return $query->where($this->otherKey, $this->getAttribute($this->otherKey));
}
/**
* Set the keys for a save update query.
*
* @param \Database\ORM\Builder $query
* @return \Database\ORM\Builder
*/
protected function setKeysForSaveQuery(Builder $query)
{
$query->where($this->morphType, $this->morphClass);
return parent::setKeysForSaveQuery($query);
}
/**
* Add the constraints for a relationship count query.
*
* @param \Database\ORM\Builder $query
* @param \Database\ORM\Builder $parent
* @return \Database\ORM\Builder
*/
public function getRelationCountQuery(Builder $query, Builder $parent)
{
$query->select(new Expression('count(*)'));
$otherKey = $this->wrap($query->getModel()->getTable() . '.' . $this->otherKey);
return $query->where($this->getQualifiedForeignKey(), '=', new Expression($otherKey));
}
