(int $datasetId, int $columnId)
| 83 | } |
| 84 | |
| 85 | public function deleteColumn(int $datasetId, int $columnId): void { |
| 86 | $sql = $this->db->getQueryBuilder(); |
| 87 | $sql->delete(self::VALUE_TABLE) |
| 88 | ->where($sql->expr()->eq('dataset_id', $sql->createNamedParameter($datasetId, IQueryBuilder::PARAM_INT))) |
| 89 | ->andWhere($sql->expr()->eq('column_id', $sql->createNamedParameter($columnId, IQueryBuilder::PARAM_INT))) |
| 90 | ->executeStatement(); |
| 91 | |
| 92 | $sql = $this->db->getQueryBuilder(); |
| 93 | $sql->delete(self::COLUMN_TABLE) |
| 94 | ->where($sql->expr()->eq('dataset_id', $sql->createNamedParameter($datasetId, IQueryBuilder::PARAM_INT))) |
| 95 | ->andWhere($sql->expr()->eq('id', $sql->createNamedParameter($columnId, IQueryBuilder::PARAM_INT))) |
| 96 | ->executeStatement(); |
| 97 | } |
| 98 | |
| 99 | public function findRecordId(int $datasetId, string $dimensionKey): ?int { |
| 100 | $sql = $this->db->getQueryBuilder(); |
no test coverage detected