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

Method updateColumn

lib/Db/FlexibleStorageMapper.php:71–83  ·  view source on GitHub ↗

@param array $column */

(int $datasetId, int $columnId, array $column)

Source from the content-addressed store, hash-verified

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

Callers 1

updateSchemaMethod · 0.80

Calls 3

setMethod · 0.80
eqMethod · 0.80
updateMethod · 0.45

Tested by

no test coverage detected