Created
August 15, 2025 05:32
-
-
Save ken39arg/66c8594af76726afb03b84c46351d944 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # frozen_string_literal: true | |
| describe 'Ridgepole::Client#diff -> migrate' do | |
| context 'partial index' do | |
| subject { client } | |
| # PostgreSQL normalizes all where clauses to uppercase with parentheses | |
| let(:expected_dsl) do | |
| erbh(<<-ERB) | |
| create_table "users", force: :cascade do |t| | |
| t.string "email" | |
| t.string "name" | |
| t.boolean "active", default: true | |
| t.index ["email"], name: "idx_users_email", unique: true, where: "(email IS NOT NULL)" | |
| end | |
| ERB | |
| end | |
| before { subject.diff(actual_dsl).migrate } | |
| context 'normalized format' do | |
| let(:actual_dsl) { expected_dsl } | |
| it { | |
| expect(subject.dump).to match_ruby expected_dsl | |
| delta = subject.diff(actual_dsl) | |
| expect(delta.differ?).to be_falsey | |
| } | |
| end | |
| context 'without parentheses' do | |
| let(:actual_dsl) do | |
| erbh(<<-ERB) | |
| create_table "users", force: :cascade do |t| | |
| t.string "email" | |
| t.string "name" | |
| t.boolean "active", default: true | |
| t.index ["email"], name: "idx_users_email", unique: true, where: "email IS NOT NULL" | |
| end | |
| ERB | |
| end | |
| it { | |
| expect(subject.dump).to match_ruby expected_dsl | |
| delta = subject.diff(actual_dsl) | |
| expect(delta.differ?).to be_falsey | |
| } | |
| end | |
| context 'lowercase with parentheses' do | |
| let(:actual_dsl) do | |
| erbh(<<-ERB) | |
| create_table "users", force: :cascade do |t| | |
| t.string "email" | |
| t.string "name" | |
| t.boolean "active", default: true | |
| t.index ["email"], name: "idx_users_email", unique: true, where: "(email is not null)" | |
| end | |
| ERB | |
| end | |
| it { | |
| expect(subject.dump).to match_ruby expected_dsl | |
| delta = subject.diff(actual_dsl) | |
| expect(delta.differ?).to be_falsey | |
| } | |
| end | |
| context 'boolean condition' do | |
| let(:actual_dsl) do | |
| erbh(<<-ERB) | |
| create_table "users", force: :cascade do |t| | |
| t.string "email" | |
| t.string "name" | |
| t.boolean "active", default: true | |
| t.index ["email"], name: "idx_users_email_active", where: "active" | |
| end | |
| ERB | |
| end | |
| let(:expected_dsl) { actual_dsl } | |
| it { | |
| expect(subject.dump).to match_ruby expected_dsl | |
| delta = subject.diff(actual_dsl) | |
| expect(delta.differ?).to be_falsey | |
| } | |
| end | |
| context 'add_index without parentheses' do | |
| let(:actual_dsl) do | |
| erbh(<<-ERB) | |
| create_table "users", force: :cascade do |t| | |
| t.string "email" | |
| t.string "name" | |
| t.boolean "active", default: true | |
| end | |
| add_index "users", ["email"], name: "idx_users_email", unique: true, where: "email IS NOT NULL" | |
| ERB | |
| end | |
| it { | |
| expect(subject.dump).to match_ruby expected_dsl | |
| delta = subject.diff(actual_dsl) | |
| expect(delta.differ?).to be_falsey | |
| } | |
| end | |
| end | |
| end |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment