3 replies

Need to duplicate migration_defaults if multiple resources uses the same table

I have a resource called

User

User

User

User

it has this

postgres

postgres

postgres

postgres configuration:

    postgres do
      table "users"

      repo Marketplace.Repo

      migration_defaults roles: "[\"seller\"]"
    end

    postgres do
      table "users"

      repo Marketplace.Repo

      migration_defaults roles: "[\"seller\"]"
    end

    postgres do
      table "users"

      repo Marketplace.Repo

      migration_defaults roles: "[\"seller\"]"
    end

    postgres do
      table "users"

      repo Marketplace.Repo

      migration_defaults roles: "[\"seller\"]"
    end

I have a migration file for that specific resource with correctly created the

roles

roles

roles

roles field with the default value:

add :roles, {:array, :text}, null: false, default: ["seller"]

add :roles, {:array, :text}, null: false, default: ["seller"]

add :roles, {:array, :text}, null: false, default: ["seller"]

add :roles, {:array, :text}, null: false, default: ["seller"]

I also have another resource that uses the same table called

Bidder

Bidder

Bidder

Bidder.

it has this

postgres

postgres

postgres

postgres configuration:

  postgres do
    table "users"

    repo Marketplace.Repo
  end

  postgres do
    table "users"

    repo Marketplace.Repo
  end

  postgres do
    table "users"

    repo Marketplace.Repo
  end

  postgres do
    table "users"

    repo Marketplace.Repo
  end

If I try to create a migration file for that resource, it will alter the user table changing the

role

role

default to

nil

nil

nil

nil.

Can I stop it from doing it without having to duplicate that code in both resources?