Project 1

Web Programming with Python and JavaScript

Created by Sergey L. Sundukovskiy

File Content

book.py

Contains definition of all Model Objects (User, Book, Author, Review) and responsible for creating tables

Book and Author have a many to many relationship
Book and Review have a one to many relationship

import.py

Contains logic for reading books.csv file and populating tables

application.py

Contains main application logic

index.html

Contains hmtl code for displaying home page of the app

login.html

Contains html and python code for allowing user to login
If login information is not correct or user does not exist warning message
will be displayed, otherwise user will be redirected to the search page

register.html

Contains html and python code for allowing user to register
If user tries to register with already registered email address
warning message will be displayed, otherwise user will be redirected to
the login page

search.html

Contains html and python code for displaying book search results
If user enters search query that yields no results, warning message
will be displayed

book.html

Contains html and python code for displaying detailed book information.
It allows user to review the book. If user already reviewed the book, he/she
will not be allowed to submit another book review

requirements.txt

Contains 3rd party libraries.
In addition to provided libraries added 'requests' lib

Short Description

Initial project implementation used sqlalchemy orm. After that it was
refactored to use raw sql

For proper execution DATABASE_URL environment variable must be set to
postgres://sojelnptnsncxh:6d44b0816915c80507f801b9b514d0ca1928e959438b9d128f862c4d022b0bb9@ec2-107-22-175-33.compute-1.amazonaws.com:5432/d38636j4dsvs33

In order to prep the DB 'python import.py' must be executed first