CtoD
CtoD is a tool for exporting a CSV data to database.
Installation
Add this line to your application's Gemfile:
gem 'ctoD'
And then execute:
$ bundle
Or install it yourself as:
$ gem install ctoD
Usage
It comes with ctoD command.
# Display help.
% ctoD
Commands:
ctoD create_table CSV DATABASE # Create a database table for CSV
ctoD export CSV DATABASE # Export CSV data to DATABASE
ctoD help [COMMAND] # Describe available commands or one specific command
ctoD table_columns CSV # Show column name and type pairs for a table based on given CSV
ctoD version # Show CtoD version
# Export movies.csv data to a table named 'movies' at postgres movies database.
% ctoD export movies.csv postgres://localhost/movies
# Export movies.csv data to movies.sqlite3 database file.
% ctoD export movies.csv sqlite3://localhost/${HOME}/.db/movies.sqlite3
# Check table column schema to be created based on given CSV.
% ctoD table_columns movies.csv
Contributing
- Fork it
- Create your feature branch (
git checkout -b my-new-feature) - Commit your changes (
git commit -am 'Add some feature') - Push to the branch (
git push origin my-new-feature) - Create new Pull Request