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

Method delete

lib/Db/StorageMapper.php:192–213  ·  view source on GitHub ↗

* delete data * @param int $datasetId * @param $dimension1 * @param $dimension2 * @param string|null $user_id * @return bool * @throws Exception */

(int $datasetId, $dimension1, $dimension2, ?string $user_id = null)

Source from the content-addressed store, hash-verified

190 * @throws Exception
191 */
192 public function delete(int $datasetId, $dimension1, $dimension2, ?string $user_id = null)
193 {
194 if ($user_id) $this->userId = $user_id;
195
196 $sql = $this->db->getQueryBuilder();
197 $sql->delete(self::TABLE_NAME)
198 ->where($sql->expr()->eq('user_id', $sql->createNamedParameter($this->userId)))
199 ->andWhere($sql->expr()->eq('dataset', $sql->createNamedParameter($datasetId)));
200
201 // a %(*) does not work for null columns. in case it is just %, don't apply the where clause at all
202 if ($dimension1 !== '*') {
203 $dimension1 = str_replace('*', '%', $dimension1);
204 $sql->andWhere($sql->expr()->like('dimension1', $sql->createNamedParameter($dimension1)));
205 }
206 if ($dimension2 !== '*') {
207 $dimension2 = str_replace('*', '%', $dimension2);
208 $sql->andWhere($sql->expr()->like('dimension2', $sql->createNamedParameter($dimension2)));
209 }
210
211 $sql->executeStatement();
212 return true;
213 }
214
215 /**
216 * Simulate delete data

Callers 2

deleteWithFilterMethod · 0.45
deleteByDatasetMethod · 0.45

Calls 1

eqMethod · 0.80

Tested by

no test coverage detected