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; }