plausible / ecto_ch / 4d43ff3460a53c8e57a2df8b2b31e459647bd402

88%

push

github

Support :comment column option in migrations (#282)

* Support :comment column option in migrations

The Ecto migration DSL allows a `:comment` option. ClickHouse fully supports column
comments, but the adapter previously honored only the table-level comment and
the `:default`/`:null` column options, silently dropping `:comment`.

This wires a `comment_expr/1` helper into `column_options/2` (used by CREATE
TABLE and ADD COLUMN) and into the `:modify` clause of `column_change/2`
(MODIFY COLUMN). The comment is emitted as an inline `COMMENT '...'` suffix
after the type and any DEFAULT/NULL expressions, matching ClickHouse syntax.

Single quotes in the comment are escaped via `Connection.escape_string/1`
(the same helper used for string DEFAULT literals), producing valid SQL.
Output is unchanged when `:comment` is absent.

* Apply suggestion from @ruslandoga

---------

Co-authored-by: ruslandoga <ruslandoga+gh@icloud.com>

3 of 3 new or added lines in 1 file covered. (100.0%)

923 of 1044 relevant lines covered (88.41%)

647.19 hits per line