module

Prostore::Adapter::Postgres::DDL

PostgreSQL DDL builders (ADR-0014). Mirrors SQLite::DDL but emits PG idiomatic syntax: GENERATED BY DEFAULT AS IDENTITY, real BOOLEAN, ALTER TABLE ADD CONSTRAINT, etc.

Instance methods

quote_ident(name : String) : String

Source

quote_string(s : String) : String

Source

render_action(action : Symbol) : String

Source

render_column(field : Schema::Field, table : String | Nil = nil) : String

Source

render_create_index(table : String, idx : Schema::Index, concurrently : Bool = false) : String

Source

render_create_table(definition : Schema::Definition, pk_lookup : Hash(String, Array(String))) : String

Source

render_enum_check(field : Schema::Field, table : String | Nil = nil) : String | Nil

Render the CHECK (...) clause that constrains an enum column to its declared member set (ADR-0016). Returns nil for non-enum fields. When a table name is supplied the constraint is emitted in named form so the AlterEnumMembers step can drop and re-add it by name at migration time.

Source

render_foreign_key_clause(fk : Schema::ForeignKey, target_pk_columns : Array(String)) : String

Source