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

Method writeValue

lib/Db/FlexibleStorageMapper.php:140–177  ·  view source on GitHub ↗

@param array{canonical:mixed,text_value:?string,decimal_value:?string,datetime_value:?string}|null $value */

(int $datasetId, int $recordId, int $columnId, ?array $value)

Source from the content-addressed store, hash-verified

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();

Callers 2

writeValuesMethod · 0.80

Calls 4

deleteValueMethod · 0.95
eqMethod · 0.80
setMethod · 0.80
updateMethod · 0.45

Tested by

no test coverage detected