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

Method createColumn

lib/Db/FlexibleStorageMapper.php:53–68  ·  view source on GitHub ↗

@param array $column */

(int $datasetId, array $column)

Source from the content-addressed store, hash-verified

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 {

Callers 3

createDatasetMethod · 0.80
updateSchemaMethod · 0.80

Calls

no outgoing calls

Tested by

no test coverage detected