MCPcopy Create free account
hub / github.com/Rello/analytics / copy

Method copy

lib/Db/DataloadMapper.php:155–178  ·  view source on GitHub ↗

* copy a data load * * @NoAdminRequired * @param int $dataloadId * @return bool * @throws Exception */

(int $dataloadId)

Source from the content-addressed store, hash-verified

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

Callers 2

fetchMethod · 0.45
apiMethod · 0.45

Calls 2

eqMethod · 0.80
fetchMethod · 0.80

Tested by 2

fetchMethod · 0.36
apiMethod · 0.36