public function loadRecords(xatacard_layout_Schema $schema, $query)
{
$tablename = $schema->getProperty('table');
if (!$tablename) {
throw new Exception(sprintf("MySQL datasource cannot load a records from schema '%s' because the schema does not specify a table", $schema->getLabel()));
}
$queryTool = new Dataface_QueryTool($tablename, df_db(), $query);
$res = $queryTool->loadSet('', true, true, false);
// preview should be disabled... we need full records
if (PEAR::isError($res)) {
throw new Exception(sprintf("MySQL datasource failed to load records: %s", $res->getMessage()));
}
$out = new xatacard_layout_RecordSet();
$out->setSchema($schema);
$out->setDatasource($this);
$out->setFound($queryTool->found());
$out->setCardinality($queryTool->cardinality());
$out->setStart($queryTool->start());
$out->setEnd($queryTool->end());
$out->setLimit($queryTool->limit());
$records = $queryTool->getRecordsArray();
if (PEAR::isError($records)) {
throw new Exception(sprintf("MySQL datasource cannot load records from schema '%s' because an error occurred in the query: %s", $schema->getLabel(), $records->getMessage()));
}
foreach ($records as $rec) {
$out->addRecord($this->buildRecord($schema, $rec));
}
return $out;
}
