#Twistory2.0

Day by day, exactly as happened 100 years ago, World War 1
described in real time as seen from Italy.

##New User Setup Steps

MySQL setup steps

1. Login to your MySQL server
   mysql -u root -p

2. Create a database called twistory_db
   CREATE DATABASE twistory_db;

3. Create a new MySQL user (note: this user is only for dev/test purposes)
   CREATE USER 'twistory_user'@'localhost' IDENTIFIED BY '1914';

4. Tell MySQL to grant privileges to the new user above so that it can perform operations on the twistory_db database
   GRANT ALL PRIVILEGES ON twistory_db.* to 'twistory_user'@'localhost';

5. Confirm the privileges above
   FLUSH PRIVILEGES;

Git setup steps

Clone the Twistory2.0 repository hosted on GitHub.
git clone https://github.com/DavideDiCarlo/Twistory2.0.git

Rails setup steps

1. Enter the base directory of the Rails app
   cd Twistory2.0

2. Install required gems, as per Gemfile
   sudo bundle install

3. Run database migrations, in order to create/modify the required tables
   sudo bundle exec rake db:migrate

4. Let's check if the migrations ran correctly, login with the twistory_user user created above (password: '1914')
   mysql -u twistory_user -p

   • Show the databases
     SHOW DATABASES;

   • Select the database
     USE twistory_db;

   • Show the tables in the twistory_db database
     SHOW TABLES;

If you see

Tables_in_twistory_db
feeds
schema_migrations
users

then all is good

Running the app

1. On your local machine, start the Rails server
   rails s

2. Launch your favorite browser, and verify that the app actually works by typing the following on your address bar
   http://localhost:3000

3. (Optional) If you do not see any images, or the webpage layout looks messy, then run the following commands
   sudo bundle exec rake assets:clean RAILS_ENV=development
sudo bundle exec rake assets:clobber RAILS_ENV=development
sudo bundle exec rake assets:precompile RAILS_ENV=development

After creating feeds, you want to periodically push them to a specified Twitter account.
Run the following task manually or, preferably, periodically in a cron job
sudo bundle exec rake twitter_connection:twitter_task

###You're done! Enjoy history in the making :)