@param array{canonical:mixed,text_value:?string,decimal_value:?string,datetime_value:?string}|null $value */
(int $datasetId, int $recordId, int $columnId, ?array $value)
| 138 | |
| 139 | /** @param array{canonical:mixed,text_value:?string,decimal_value:?string,datetime_value:?string}|null $value */ |
| 140 | public function writeValue(int $datasetId, int $recordId, int $columnId, ?array $value): void { |
| 141 | $sql = $this->db->getQueryBuilder(); |
| 142 | $sql->select('id') |
| 143 | ->from(self::VALUE_TABLE) |
| 144 | ->where($sql->expr()->eq('dataset_id', $sql->createNamedParameter($datasetId, IQueryBuilder::PARAM_INT))) |
| 145 | ->andWhere($sql->expr()->eq('record_id', $sql->createNamedParameter($recordId, IQueryBuilder::PARAM_INT))) |
| 146 | ->andWhere($sql->expr()->eq('column_id', $sql->createNamedParameter($columnId, IQueryBuilder::PARAM_INT))); |
| 147 | $valueId = $sql->executeQuery()->fetchOne(); |
| 148 | |
| 149 | if ($value === null) { |
| 150 | if ($valueId !== false) { |
| 151 | $this->deleteValue((int)$valueId); |
| 152 | } |
| 153 | return; |
| 154 | } |
| 155 | |
| 156 | if ($valueId === false) { |
| 157 | $sql = $this->db->getQueryBuilder(); |
| 158 | $sql->insert(self::VALUE_TABLE)->values([ |
| 159 | 'dataset_id' => $sql->createNamedParameter($datasetId, IQueryBuilder::PARAM_INT), |
| 160 | 'record_id' => $sql->createNamedParameter($recordId, IQueryBuilder::PARAM_INT), |
| 161 | 'column_id' => $sql->createNamedParameter($columnId, IQueryBuilder::PARAM_INT), |
| 162 | 'text_value' => $sql->createNamedParameter($value['text_value']), |
| 163 | 'decimal_value' => $sql->createNamedParameter($value['decimal_value']), |
| 164 | 'datetime_value' => $sql->createNamedParameter($value['datetime_value']), |
| 165 | ]); |
| 166 | $sql->executeStatement(); |
| 167 | return; |
| 168 | } |
| 169 | |
| 170 | $sql = $this->db->getQueryBuilder(); |
| 171 | $sql->update(self::VALUE_TABLE) |
| 172 | ->set('text_value', $sql->createNamedParameter($value['text_value'])) |
| 173 | ->set('decimal_value', $sql->createNamedParameter($value['decimal_value'])) |
| 174 | ->set('datetime_value', $sql->createNamedParameter($value['datetime_value'])) |
| 175 | ->where($sql->expr()->eq('id', $sql->createNamedParameter((int)$valueId, IQueryBuilder::PARAM_INT))) |
| 176 | ->executeStatement(); |
| 177 | } |
| 178 | |
| 179 | public function deleteRecord(int $datasetId, int $recordId): void { |
| 180 | $sql = $this->db->getQueryBuilder(); |
no test coverage detected