Contents

require "activeadmin/sqlpage/version"

module ActiveAdmin
  module SqlPage
    class << self

      def register
        ActiveAdmin.register_page "SQL" do


          menu priority: 1, label: "SQL"

          content title: "SQL" do

            columns do
              column do

                form action: admin_sql_query_path, method: :post do |f|
                  div class: :table_tools do
                    input type: :hidden,
                      name: :authenticity_token,
                      value: form_authenticity_token

                    textarea name: :sql do
                      params[:sql]
                    end

                    button :submit
                  end
                end

                unless params[:sql].nil?

                  begin
                    result = ActiveRecord::Base.connection.exec_query( params[:sql] )
                  rescue Exception => e
                    result = ActiveRecord::Result.new( [:error], [[e.message]] )
                  end

                  table class: 'index_table index' do
                    thead do
                      tr do
                        result.columns.each do |name|
                          th name, class: :col
                        end
                      end
                    end
                    tbody do
                      result.rows.each_with_index do |col,i|
                        tr class: (0==i%2?'odd':'even') do
                          col.each do |val|
                            td val, class: :col
                          end
                        end
                      end
                    end
                  end

                end

              end
            end

          end

          page_action :query, method: :post do
            render action: :index, layout: false
          end


        end
      end

    end
  end
end

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
activeadmin-sqlpage-0.1.0	lib/activeadmin/sqlpage.rb