using-custom-table-names.rb

#!/usr/bin/env ruby
require "rom-sql"
require "rom-repository"
require "byebug"

module Persistence
  module Relations
    class Configurations < ROM::Relation[:sql]
      gateway :bonuses

      schema(:bns_configurations, infer: true, as: :configurations) do
        associations do
          has_many :rush_hours_configuration
          has_many :global_checks_configuration
        end
      end
    end
  end
end

config = ROM::Configuration.new(default: [:sql, "sqlite::memory"],
                                bonuses: [:sql, "postgres://localhost/rom_sql"])

config.gateways[:bonuses].tap do |gateway|
  migration = gateway.migration do
    change do
      create_table :bns_configurations do
        primary_key :id
      end
    end
  end

  migration.apply gateway.connection, :up
end

config.register_relation Persistence::Relations::Configurations

container = ROM.container(config)

puts container.relations[:configurations].class.dataset # => bns_configurations