* copy a data load * * @NoAdminRequired * @param int $dataloadId * @return bool * @throws Exception */
(int $dataloadId)
| 153 | * @throws Exception |
| 154 | */ |
| 155 | public function copy(int $dataloadId) { |
| 156 | $sql = $this->db->getQueryBuilder(); |
| 157 | $sql->select('*')->from(self::TABLE_NAME)->where($sql->expr() |
| 158 | ->eq('user_id', $sql->createNamedParameter($this->userId))) |
| 159 | ->andWhere($sql->expr()->eq('id', $sql->createNamedParameter($dataloadId))); |
| 160 | $statement = $sql->executeQuery(); |
| 161 | $record = $statement->fetch(); |
| 162 | |
| 163 | if ($record) { |
| 164 | $insertSql = $this->db->getQueryBuilder(); |
| 165 | $insertSql->insert(self::TABLE_NAME)->values([ |
| 166 | 'user_id' => $insertSql->createNamedParameter($this->userId), |
| 167 | 'name' => $insertSql->createNamedParameter($record['name'] . ' (copy)'), |
| 168 | 'dataset' => $insertSql->createNamedParameter($record['dataset']), |
| 169 | 'datasource' => $insertSql->createNamedParameter($record['datasource']), |
| 170 | 'option' => $insertSql->createNamedParameter($record['option']), |
| 171 | 'storage_mapping' => $insertSql->createNamedParameter($record['storage_mapping'] ?? null), |
| 172 | ]); |
| 173 | $insertSql->executeStatement(); |
| 174 | return true; |
| 175 | } else { |
| 176 | return false; |
| 177 | } |
| 178 | } |
| 179 | |
| 180 | /** |
| 181 | * delete a dataload |