Skip to content

A Ruby on Rails web app that converts csv files into normalized databases

License

Notifications You must be signed in to change notification settings

spencerbartz/csv_normalizer

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

31 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Welcome to My CSV Normalizer

  1. This is a Ruby on Rails project using Rails 4.2.6 and Ruby 2.3.1. In case you don't have Nokogiri installed, install it now.
  2. This project requires use of MySQL and knowledge of how to edit database.yml to configure it. You must provide your own username and password for your local MySql instance.
  3. I have tested the app on Ubuntu. I do not own or have access to a Mac.
  4. Upon patching the repo with my submission, and getting mysql working, open up a terminal, cd into the root directory and run
% bundle install
% rake db:drop && rake db:create && rake db:migrate

This will set up your empty database.

  1. To start the rails server run
% rails s
  1. Visit localhost:3000 and upload a file. The example file included in this assignment as well as a malformed one are available in app/helpers/example_data.csv and app/helpers/bad_example.csv respectively. Attempting to upload malformed files is an idempotent operation that does not alter the database in any way.

  2. To run the test suite, cd into the app root directory and run

% rspec spec

You should see a message with the output of 28 test cases with (96.47%) code coverage.

If you have trouble getting this it to work, please contact me at spencerbartz@gmail.com

HAVE FUN!

About

A Ruby on Rails web app that converts csv files into normalized databases

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published