Contents

# Read about factories at https://github.com/thoughtbot/factory_girl

FactoryGirl.define do
  factory :adhoq_query, class: 'Adhoq::Query' do
    name        'A query'
    description 'Simple simple SELECT'
    query       'SELECT 1'

    trait :complex do
      name        'adhoq current use'
      description 'Simple analysys: count execution per query'
      query <<-SQL.strip_heredoc
        SELECT
          q.id
         ,q.name
         ,(
            SELECT COUNT(*)
            FROM  adhoq_executions exec
            INNER JOIN adhoq_reports r ON r.execution_id = exec.id
            WHERE exec.query_id = q.id
          ) AS use_count
        FROM
          adhoq_queries q
        ORDER BY
          use_count DESC, id ASC
      SQL
    end
  end
end

Version data entries

2 entries across 2 versions & 1 rubygems

Version	Path
adhoq-0.0.3	spec/factories/adhoq_queries.rb
adhoq-0.0.2	spec/factories/adhoq_queries.rb