()
| 94 | } |
| 95 | |
| 96 | public function getScheduleMetadata() { |
| 97 | $sql = $this->db->getQueryBuilder(); |
| 98 | $sql->from(self::TABLE_NAME)->select('dataset')->selectAlias($sql->func()->max('schedule'), 'schedules') |
| 99 | ->where($sql->expr()->eq('user_id', $sql->createNamedParameter($this->userId)))->addgroupBy('dataset'); |
| 100 | $statement = $sql->executeQuery(); |
| 101 | $result = $statement->fetchAll(); |
| 102 | $statement->closeCursor(); |
| 103 | return $result; |
| 104 | } |
| 105 | |
| 106 | /** |
| 107 | * get all data load & schedule metadata |