Class: RailsDb::SqlController
- Inherits:
-
ApplicationController
- Object
- ActionController::Base
- ApplicationController
- RailsDb::SqlController
- Defined in:
- app/controllers/rails_db/sql_controller.rb
Instance Method Summary collapse
Instance Method Details
#csv ⇒ Object
13 14 15 16 |
# File 'app/controllers/rails_db/sql_controller.rb', line 13 def csv load_query send_data(@sql_query.to_csv, type: 'text/csv; charset=utf-8; header=present', filename: 'results.csv') end |
#execute ⇒ Object
8 9 10 11 |
# File 'app/controllers/rails_db/sql_controller.rb', line 8 def execute load_query render :index end |
#import ⇒ Object
18 19 |
# File 'app/controllers/rails_db/sql_controller.rb', line 18 def import end |
#import_start ⇒ Object
21 22 23 24 25 26 27 28 29 30 |
# File 'app/controllers/rails_db/sql_controller.rb', line 21 def import_start @importer = SqlImport.new(params[:file]) result = @importer.import if result.ok? flash[:notice] = 'File was successfully imported' else flash[:alert] = "Error occurred during import: #{result.error.}" end render :import end |
#index ⇒ Object
4 5 6 |
# File 'app/controllers/rails_db/sql_controller.rb', line 4 def index load_query end |