Contents

require 'spec_helper'

describe 'Defining many-to-one association' do
  include_context 'users and tasks'

  before do
    conn[:tasks].insert id: 2, user_id: 1, title: 'Go to sleep'
  end

  it 'extends relation with association methods' do
    configuration.relation(:tags) { use :assoc_macros }
    configuration.relation(:task_tags) { use :assoc_macros }

    configuration.relation(:tasks) do
      use :assoc_macros

      many_to_many :tags,
        join_table: :task_tags,
        left_key: :task_id,
        right_key: :tag_id

      def with_tags
        association_left_join(:tags, select: [:name])
      end

      def with_tags_and_tag_id
        association_left_join(:tags, select: {
                                tags: [:name], task_tags: [:tag_id]
                              })
      end

      def by_tag(name)
        with_tags.where(name: name)
      end

      def all
        select(:id, :title)
      end
    end

    tasks = container.relations.tasks

    expect(tasks.all.with_tags.to_a).to eql([
      { id: 1, title: 'Finish ROM', name: 'important' },
      { id: 2, title: 'Go to sleep', name: nil }
    ])

    expect(tasks.all.with_tags_and_tag_id.to_a).to eql([
      { id: 1, title: 'Finish ROM', tag_id: 1, name: 'important' },
      { id: 2, title: 'Go to sleep', tag_id: nil, name: nil }
    ])

    expect(tasks.all.by_tag("important").to_a).to eql([
      { id: 1, title: 'Finish ROM', name: 'important' }
    ])

    expect(tasks.by_tag("not-here").to_a).to be_empty
  end
end

Version data entries

3 entries across 3 versions & 1 rubygems

Version	Path
rom-sql-0.7.0	spec/unit/many_to_many_spec.rb
rom-sql-0.7.0.rc1	spec/unit/many_to_many_spec.rb
rom-sql-0.7.0.beta1	spec/unit/many_to_many_spec.rb