CODEWITHSUNDEEP
sqlruby-on-railssqliteruby-on-rails-5
T.Aloufi
T.Aloufi

Reputation: 39

Saving an sqllite3 database as csv file in Ruby on Rails 5

I am currently working on a project and I want to know how to save an sqllite database in rails as a csv file. I want it when you click the button, the current database on the system download. Can anybody help me? Thanks!

Upvotes: 0

Views: 223

Answers (1)

MarsAtomic
MarsAtomic

Reputation: 10673

Your problem isn't really specific to Rails. Instead, you're mostly dealing with an administrative issue. You should write a script to export your database as csv, something like this:

#!/bin/bash
./bin/sqlite3 ./my_app/db/my_database.db <<!
.headers on
.mode csv
.output my_output_file.csv
select * from my_table;
!

This script exports a single table. If you have additional tables, you'll want to add them to your script.

The only Rails related issue is the matter of calling that script. Save the script within your application structure; I'd suggest my_app/assets or some similar location.

Now you can run that script using system(command) where command is the absolute path for your script, within a set of double-quotes.

Upvotes: 1

Related Questions