http://bo0ks-review.herokuapp.com/

This website has a list of books and provide some information about the books using the goodreads API as well as a user registration and authentication system. Registered users will have the ability to search for books, leave reviews and rate for individual books

• This project is written in python 3.
• Use Flask framework.
• PostgreSQL for database
• Use Bootstrap, CSS and JS in front-end

• Registering users
• Logging users in and out
• Allowing users to search a database of 5000 books (by the author, title or ISBN)
• Showing relevant information and reviews of the selected book
• Allowing users to leave reviews and ratings of their own
• Connecting to Goodreads API to show further information
• Returning data in a JSON format if the user reaches the "api/" route

1. Create App on Heroku.

2. On app’s “Overview” page, click the “Configure Add-ons” button.

3. In the “Add-ons” section of the page, type in and select “Heroku Postgres.

4. Choose the “Hobby Dev - Free” plan, which will give you access to a free PostgreSQL database that will support up to 10,000 rows of data. Click “Provision..

5. Click the “Heroku Postgres :: Database” link.

6. Click on “Settings”, and then “View Credentials.”. This information to hock my App to the DB

7. Use the Credentials to connect the application with the DB

• run python create_table.py in order to execute SQL query to create the enrollments table
• run python import.py to read the books SCV file and load it to the database table

• create_table.py: Contain the SQL query to create books, users and reviews tables.

• import.py: Read the CSV books file and load the data into books table.

• app.py: application file

• wtform_fields: Contain wtforms class for each forms and validator

• Procfile: To declare the process type, in this app the type is "web" and Identify thread operation

• requirements.txt: Contain a list of items to be installed, use the command to install all of items pip install -r requirements.txt

# Clone repo
$ git clone https://github.com/MotazBellah/books_review

# Install all dependencies
$ pip install -r requirements.txt

# Run
$ python app.py

# Go to 127.0.0.1:5000 on your web browser.