one_to_one-assoc with multiple keys

[wuarmin]

Hey,

I tried following, but could not make it work:

module Models
  class Unit < Sequel::Model(DB[Sequel[:public][:units]])
    one_to_one :agency, class: "Models::Agency", right_key: [:company_id, :number], left_key: [:company_id, :profit_number]

    dataset_module do
      def all
        eager(:agency).all # the resulting assoc-sql tries to join with wrong keys
        # PG::UndefinedColumn: ERROR:  column agencies.unit_id does not exist
        # SELECT * FROM "public"."agencies" WHERE ("public"."agencies"."unit_id" IN ('TST123', 'TST456'))
      end
    end
  end
end

What am I doing wrong?
Thanks and best regards

[jeremyevans]

left_key/right_key are for one_through_one associations (using a join table). You probably want key/primary_key.