| 82 | } |
| 83 | |
| 84 | public function getAllDataloadMetadata() { |
| 85 | $sql = $this->db->getQueryBuilder(); |
| 86 | $sql->from(self::TABLE_NAME)->select('dataset')->selectAlias($sql->func()->count('id'), 'dataloads') |
| 87 | ->selectAlias($sql->func()->max('schedule'), 'schedules')->where($sql->expr() |
| 88 | ->eq('user_id', $sql->createNamedParameter($this->userId))) |
| 89 | ->addgroupBy('dataset'); |
| 90 | $statement = $sql->executeQuery(); |
| 91 | $result = $statement->fetchAll(); |
| 92 | $statement->closeCursor(); |
| 93 | return $result; |
| 94 | } |
| 95 | |
| 96 | public function getScheduleMetadata() { |
| 97 | $sql = $this->db->getQueryBuilder(); |