Skip to content

Instantly share code, notes, and snippets.

@ken39arg
Created August 15, 2025 05:32
Show Gist options
  • Select an option

  • Save ken39arg/66c8594af76726afb03b84c46351d944 to your computer and use it in GitHub Desktop.

Select an option

Save ken39arg/66c8594af76726afb03b84c46351d944 to your computer and use it in GitHub Desktop.
# 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