Contents

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

FactoryBot.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

    trait :greeting do
      name        { 'greeting' }
      description { 'Static query for testing data' }
      query       { 'SELECT "hello" AS name ,"English greeting message" AS description' }
    end
  end
end

Version data entries

4 entries across 4 versions & 1 rubygems

Version	Path
adhoq-1.0.2	spec/factories/adhoq_queries.rb
adhoq-1.0.1	spec/factories/adhoq_queries.rb
adhoq-1.0.0	spec/factories/adhoq_queries.rb
adhoq-0.5.0	spec/factories/adhoq_queries.rb