Handle creation of custom repositories for a template

[terrywbrady]

Table change

• Add column custom_repository_owner_template_id, allows null

Preferences screen

• Allow preferred repositories to be selected (from standard set, custom_repository_owner_template_id is null)
  • stored in template_repositories
• Allow custom repositories to be defined
  • stored in repositories table

Research Outputs Screen

Use cases

• No preferred repos or custom repos exist (in production)
• Preferred repos exist (on stage)
• Preferred repos + custom repos exist
• No preferred + custom repos exist

Current Logic in stage

• Check for preferred
  • if exists, apply filters
  • otherwise, apply filters to standard list

Repositories

  scope :by_template, lambda { |template_id|
    joins(:templates).where('templates.id = :template_id', template_id: template_id)
  }

ResearchOutputsController

  def repository_search
    @plan = Plan.find_by(id: params[:plan_id])
    @research_output = ResearchOutput.new(plan: @plan)
    authorize @research_output

    @search_results = Repository.by_template(@plan.template.id)
    @search_results = if @search_results.any?
                        @search_results.by_type(repo_search_params[:type_filter])
                      else
                        Repository.by_type(repo_search_params[:type_filter])
                      end
    @search_results = @search_results.by_subject(repo_search_params[:subject_filter])
    @search_results = @search_results.search(repo_search_params[:search_term])

    @search_results = @search_results.order(:name).page(params[:page])
  end

New logic needed

• Check for preferred list
  • If exists, get UNION preferred and custom, apply filters
  • Otherwise get UNION standard and custom, apply filters

Repositories

  scope :preferred_by_template, lambda { |template_id|
    where(%{
      exists (
        select 1
        from template_repositories tr
        where tr.template_id=:template_id
        and tr.repository_id=repositories.id
      )
    },
          template_id: template_id)
  }

  scope :custom_by_template, lambda { |template_id|
    where(%{custom_repository_owner_template_id=:template}, template_id: template_id)
  }

  scope :preferred_or_custom_by_template, lambda { |template_id|
    where(%{
      custom_repository_owner_template_id=:template_id OR exists (
        select 1
        from template_repositories tr
        where tr.template_id=:template_id
        and tr.repository_id=repositories.id
      )
    },
          template_id: template_id)
  }

  scope :standard_or_custom_by_template, lambda { |template_id|
    where(%{custom_repository_owner_template_id=:template_id OR custom_repository_owner_template_id is null},
          template_id: template_id)
  }

ResearchOutputsController

  def repository_search
    @plan = Plan.find_by(id: params[:plan_id])
    template = @plan.template
    @research_output = ResearchOutput.new(plan: @plan)
    authorize @research_output

    @search_results = template.template_repositories.any? ? 
         Repository.preferred_or_custom_by_template(template.id) :
         Repository.standard_or_custom_by_template(template.id)
    @search_results = @search_results.by_type(repo_search_params[:type_filter])
    @search_results = @search_results.by_subject(repo_search_params[:subject_filter])
    @search_results = @search_results.search(repo_search_params[:search_term])

    @search_results = @search_results.order(:name).page(params[:page])
  end

[terrywbrady]

Question (from slack): When a template has custom repositories...

• Will the template ALWAYS have a preferred list of repositories
• Or, is it possible that users of the template could choose between the full set of standard repos AND the list of custom repos