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