Fetching results

class Atk4\Data\Model

Model linked to a persistence is your “window” into DataSet and you get several ways which allow you to fetch the data.

Iterate through model data

Atk4\Data\Model::getIterator()

Create your persistence object first then iterate it:

$db = \Atk4\Data\Persistence::connect($dsn);
$m = new Model_Client($db);

foreach ($m as $id => $entity) {
    echo $id . ': ' . $entity->get('name') . "\n";
}

Note

changing query parameter during iteration will has no effect until you finish iterating.

Raw Data Fetching

If you do not care about the hooks and simply wish to get the data, you can fetch it:

foreach ($m->getPersistence()->prepareIterator($m) as $row) {
    var_dump($row); // array
}

The $row will also contain value for “id” and it’s up to you to find it yourself if you need it.

Atk4\Data\Model::export()

Will fetch and output array of hashes which will represent entirety of data-set. Similarly to other methods, this will have the data mapped into your fields for you and server-side expressions executed that are embedded in the query.

By default - onlyFields will be presented as well as system fields.

Fetching data through action

You can invoke and iterate action (particularly SQL) to fetch the data:

foreach ($m->action('select')->getRowsIterator() as $row) {
    var_dump($row); // array
}

This has the identical behavior to $m->getPersistence()->prepareIterator($m).