@param array $column */
(int $datasetId, int $columnId, array $column)
| 69 | |
| 70 | /** @param array<string,mixed> $column */ |
| 71 | public function updateColumn(int $datasetId, int $columnId, array $column): void { |
| 72 | $sql = $this->db->getQueryBuilder(); |
| 73 | $sql->update(self::COLUMN_TABLE) |
| 74 | ->set('name', $sql->createNamedParameter($column['name'])) |
| 75 | ->set('logical_type', $sql->createNamedParameter($column['type'])) |
| 76 | ->set('column_role', $sql->createNamedParameter($column['role'])) |
| 77 | ->set('display_position', $sql->createNamedParameter($column['position'], IQueryBuilder::PARAM_INT)) |
| 78 | ->set('nullable_flag', $sql->createNamedParameter($column['nullable'] ? 1 : 0, IQueryBuilder::PARAM_INT)) |
| 79 | ->set('default_aggregation', $sql->createNamedParameter($column['defaultAggregation'])) |
| 80 | ->where($sql->expr()->eq('dataset_id', $sql->createNamedParameter($datasetId, IQueryBuilder::PARAM_INT))) |
| 81 | ->andWhere($sql->expr()->eq('id', $sql->createNamedParameter($columnId, IQueryBuilder::PARAM_INT))); |
| 82 | $sql->executeStatement(); |
| 83 | } |
| 84 | |
| 85 | public function deleteColumn(int $datasetId, int $columnId): void { |
| 86 | $sql = $this->db->getQueryBuilder(); |
no test coverage detected