| 177 | } |
| 178 | |
| 179 | public function deleteRecord(int $datasetId, int $recordId): void { |
| 180 | $sql = $this->db->getQueryBuilder(); |
| 181 | $sql->delete(self::VALUE_TABLE) |
| 182 | ->where($sql->expr()->eq('dataset_id', $sql->createNamedParameter($datasetId, IQueryBuilder::PARAM_INT))) |
| 183 | ->andWhere($sql->expr()->eq('record_id', $sql->createNamedParameter($recordId, IQueryBuilder::PARAM_INT))) |
| 184 | ->executeStatement(); |
| 185 | |
| 186 | $sql = $this->db->getQueryBuilder(); |
| 187 | $sql->delete(self::RECORD_TABLE) |
| 188 | ->where($sql->expr()->eq('dataset_id', $sql->createNamedParameter($datasetId, IQueryBuilder::PARAM_INT))) |
| 189 | ->andWhere($sql->expr()->eq('id', $sql->createNamedParameter($recordId, IQueryBuilder::PARAM_INT))) |
| 190 | ->executeStatement(); |
| 191 | } |
| 192 | |
| 193 | public function deleteRecords(int $datasetId): int { |
| 194 | $sql = $this->db->getQueryBuilder(); |