public function read(Hive $parent)
{
$container = Hive_Container::factory($parent, $this);
if ($parent->prepared()) {
// Create child model
$child = Hive::factory($this->model);
// Import meta data
$parent_meta = Hive::meta($parent);
$child_meta = Hive::meta($child);
// Create a new query
$query = $child->query_select();
// Apply JOINs
$query->join($this->table);
foreach ($this->using['child'] as $local => $remote) {
$query->on($child_meta->column($local), '=', "{$this->table}.{$remote}");
}
foreach ($this->using['parent'] as $local => $remote) {
$query->where("{$this->table}.{$remote}", '=', $parent->{$local});
}
// Return the result as an array of child objects
$results = $query->as_object($child)->execute($parent_meta->db)->as_array($this->key);
$container->values($results);
}
return $container;
}
public function read(Hive $parent)
{
$container = Hive_Container::factory($parent, $this);
if ($parent->prepared()) {
// Create child model
$child = Hive::factory($this->model);
// Import meta data
$parent_meta = Hive::meta($parent);
$child_meta = Hive::meta($child);
// Create a new query
$query = $child->query_select();
// Apply JOINs
$query->join($parent_meta->table);
foreach ($this->using as $parent_field => $child_field) {
$query->on($parent_meta->column($parent_field), '=', $child_meta->column($child_field));
}
// Apply parent WHERE conditions
$parent->query_conditions($query);
// Return the result as an array of child objects
$results = $query->as_object($child)->execute($parent_meta->db)->as_array($this->key);
$container->values($results);
}
return $container;
}
