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

Method deleteSimulate

lib/Db/StorageMapper.php:223–246  ·  view source on GitHub ↗

* Simulate delete data * @param int $datasetId * @param $dimension1 * @param $dimension2 * @return array * @throws Exception */

(int $datasetId, $dimension1, $dimension2)

Source from the content-addressed store, hash-verified

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

Callers

nothing calls this directly

Calls 3

countMethod · 0.80
eqMethod · 0.80
fetchMethod · 0.80

Tested by

no test coverage detected