* 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)
| 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 |
no test coverage detected