Contents

# frozen_string_literal: true

module Motor
  class RunQueriesController < ApiBaseController
    wrap_parameters :data

    load_and_authorize_resource :query, only: :show, parent: false

    before_action :build_query, only: :create
    authorize_resource :query, only: :create

    def show
      render_result
    end

    def create
      render_result
    end

    private

    def render_result
      query_result = Queries::RunQuery.call(@query, variables_hash: params[:variables])

      if query_result.error
        render json: { errors: [{ detail: query_result.error }] }, status: :unprocessable_entity
      else
        render json: query_result_hash(query_result)
      end
    end

    def query_result_hash(query_result)
      {
        data: query_result.data,
        meta: {
          columns: query_result.columns
        }
      }
    end

    def build_query
      @query = Motor::Queries::Persistance.build_from_params(query_params)
    end

    def query_params
      params.require(:data).permit(:sql_body, preferences: {})
    end
  end
end

Version data entries

5 entries across 5 versions & 1 rubygems

Version	Path
motor-admin-0.1.57	app/controllers/motor/run_queries_controller.rb
motor-admin-0.1.56	app/controllers/motor/run_queries_controller.rb
motor-admin-0.1.55	app/controllers/motor/run_queries_controller.rb
motor-admin-0.1.54	app/controllers/motor/run_queries_controller.rb
motor-admin-0.1.53	app/controllers/motor/run_queries_controller.rb