* Simulate delete data * @param int $datasetId * @param $dimension1 * @param $dimension2 * @return array * @throws Exception */
(int $datasetId, $dimension1, $dimension2)
| 221 | * @throws Exception |
| 222 | */ |
| 223 | public function deleteSimulate(int $datasetId, $dimension1, $dimension2) |
| 224 | { |
| 225 | $sql = $this->db->getQueryBuilder(); |
| 226 | $sql->from(self::TABLE_NAME) |
| 227 | ->selectAlias($sql->func()->count('*'), 'count') |
| 228 | ->where($sql->expr()->eq('user_id', $sql->createNamedParameter($this->userId))) |
| 229 | ->andWhere($sql->expr()->eq('dataset', $sql->createNamedParameter($datasetId))); |
| 230 | |
| 231 | if ($dimension1 !== '*') { |
| 232 | $dimension1 = str_replace('*', '%', $dimension1); |
| 233 | $sql->andWhere($sql->expr()->like('dimension1', $sql->createNamedParameter($dimension1))); |
| 234 | } |
| 235 | |
| 236 | if ($dimension2 !== '*') { |
| 237 | $dimension2 = str_replace('*', '%', $dimension2); |
| 238 | $sql->andWhere($sql->expr()->like('dimension2', $sql->createNamedParameter($dimension2))); |
| 239 | } |
| 240 | |
| 241 | $statement = $sql->executeQuery(); |
| 242 | $result = $statement->fetch(); |
| 243 | $statement->closeCursor(); |
| 244 | |
| 245 | return $result; |
| 246 | } |
| 247 | |
| 248 | /** |
| 249 | * delete data |