@param array $column */
(int $datasetId, array $column)
| 51 | |
| 52 | /** @param array<string,mixed> $column */ |
| 53 | public function createColumn(int $datasetId, array $column): array { |
| 54 | $sql = $this->db->getQueryBuilder(); |
| 55 | $sql->insert(self::COLUMN_TABLE)->values([ |
| 56 | 'dataset_id' => $sql->createNamedParameter($datasetId, IQueryBuilder::PARAM_INT), |
| 57 | 'name' => $sql->createNamedParameter($column['name']), |
| 58 | 'logical_type' => $sql->createNamedParameter($column['type']), |
| 59 | 'column_role' => $sql->createNamedParameter($column['role']), |
| 60 | 'display_position' => $sql->createNamedParameter($column['position'], IQueryBuilder::PARAM_INT), |
| 61 | 'nullable_flag' => $sql->createNamedParameter($column['nullable'] ? 1 : 0, IQueryBuilder::PARAM_INT), |
| 62 | 'default_aggregation' => $sql->createNamedParameter($column['defaultAggregation']), |
| 63 | ]); |
| 64 | $sql->executeStatement(); |
| 65 | $column['id'] = (int)$sql->getLastInsertId(); |
| 66 | $column['ref'] = 'c_' . $column['id']; |
| 67 | return $column; |
| 68 | } |
| 69 | |
| 70 | /** @param array<string,mixed> $column */ |
| 71 | public function updateColumn(int $datasetId, int $columnId, array $column): void { |
no outgoing calls
no test coverage detected