Improve readability with new lines

[dcrystalj]

My atlas.hcl

data "external_schema" "gorm" {
  program = [
    "go",
    "run",
    "./loader",
  ]
}

env "gorm" {
  src = data.external_schema.gorm.url
  dev = "docker://postgres/16/dev"
  migration {
    dir = "file://db/migrations"
    format = golang-migrate
  }
  format {
    migrate {
      diff = "{{ sql . \" \" }}"
    }
  }
}

Migrations created are quite unreadable. Is there a way to have new line in front of ADD column or ALTER COLUMN ?

[luantranminh]

@dcrystalj Could you please share what your migrations look like and what your desired state is?

[dcrystalj]

Sorry I did not provide example.

The issue with readability is only with long lines being too long. Here are my real examples:

ALTER TABLE "public"."raw_activity" ADD COLUMN "order_plan" integer NOT NULL, ADD COLUMN "order_counter" integer NOT NULL, ADD COLUMN "finish_setup_date" timestamptz NULL, ADD COLUMN "finish_setup_time" timestamptz NULL;

CONSTRAINT "fk_salary_variable_log_salary_person" FOREIGN KEY ("salary_person_id") REFERENCES "public"."salary_person" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION,

[luantranminh]

@dcrystalj Ah, you're right. It would be better if the formatter could produce something like:

ALTER TABLE "public"."raw_activity"
  ADD COLUMN "order_plan" INTEGER NOT NULL,
  ADD COLUMN "order_counter" INTEGER NOT NULL,
  ADD COLUMN "finish_setup_date" TIMESTAMPTZ NULL,
  ADD COLUMN "finish_setup_time" TIMESTAMPTZ NULL; 

instead of a long line of SQL. But sadly, there is no option for this formatting style at the moment. I'll let you know if an improvement on it is released.

[rotemtam]

https://atlasgo.io/versioned/diff#indented-sql

[luantranminh]

thanks @rotemtam , but it seems like a slightly different case. Intended sql works for CREATE TABLE but keep ALTER TABLE and CONSTRAINT in one line.