README.txt for catalog website on AWS server

1. IP address and ssh port for reviewer IP: 52.35.38.167 ssh port: 2200

2. URL for the web application http://ec2-52-35-38-167.us-west-2.compute.amazonaws.com/

3. Software installed Software installed: apache2, libapache2-mod-wsgi, git, postgresql, python-psycopg2, python-flask, python-sqlalchemy, unattended-upgrades, apt-listchanges

Config changes: (1) created sudo user grader and added /etc/sudoers.d/grader file (2) modified /etc/ssh/sshd_config file: (a) Port 2200; (b) PermitRootLogin no; (c) AllowUsers grader (3) apache config file: /etc/apache2/sites-enabled/default.conf add one line: WSGIScriptAlias / /var/www/html/myapp.wsgi (4) in /var/www/html directory create file myapp.wsgi. Catalog application program is at /home/grader/catalog/. So added /home/grader/catalog to python search path. (5) for automatic application upgrade by using unattended-upgrades. Default setting.

Catalog application change: (1) Previous web application used sqlite3. Now database changes to psotgresql. (2) create catalog user to access database: createuser -dRSP catalog # password is 1234 (3) create database in psql terminal: create database catalogitemwithuser (4) databse_setup.py, lotsofitem.py, project.py connects to the postgresql database: engine = create_engine('postgresql://catalog:1234@localhost/catalogitemwithuser') (5) to handle flask logging, I added log handling in project.py and error log file is at /var/log/apache2/catalog.error (6) each endpoint need to establish connection with database in the beginning and tear down after request. Add function get_session() and close_session().

4. Google oauth credential json file for login/logout this json file is not included in the repository

5. To login as grader. Pulic key is in the comments.

######################

Folder Structure

###################### catalog:

1. database_setup.py: setup database catalogitemwithuser.db and object User, Catalog, Item
2. lotsofitem.py: Populate catalogitemwithuser.db
3. project.py: using Flask framework to define website each endpoint behavior. Access address ec2-52-35-38-167.us-west-2.compute.amazonaws.com

templates: webpage templates for each endpoint to be used in project.py

static: css file for webpage style.

############################################

availabe endpoints for catalog website

############################################

1. show all catalogs and latest 10 updated items http://ec2-52-35-38-167.us-west-2.compute.amazonaws.com/ or http://ec2-52-35-38-167.us-west-2.compute.amazonaws.com/catalogs
2. show all items for one catalog http://ec2-52-35-38-167.us-west-2.compute.amazonaws.com/catalog/string:catalog_name/items
3. edit one catalog (user must login) http://ec2-52-35-38-167.us-west-2.compute.amazonaws.com/catalog/string:catalog_name/edit
4. delete one catalog (user must loging. If delete one catalog successfully, all items under this catalog will also be deleted) http://ec2-52-35-38-167.us-west-2.compute.amazonaws.com/catalog/string:catalog_name/delete
5. create one catalog (user must login) http://ec2-52-35-38-167.us-west-2.compute.amazonaws.com/catalog/new
6. show one particular item http://ec2-52-35-38-167.us-west-2.compute.amazonaws.com/catalog/string:catalog_name/string:item_name
7. edit one item (user must login) http://ec2-52-35-38-167.us-west-2.compute.amazonaws.com/catalog/string:catalog_name/string:item_name/edit 8 delete one item (user must login) http://ec2-52-35-38-167.us-west-2.compute.amazonaws.com/catalog/string:catalog_name/string:item_name/delete 9 create one item (user must login) http://ec2-52-35-38-167.us-west-2.compute.amazonaws.com/catalog/newitem 10 user login http://ec2-52-35-38-167.us-west-2.compute.amazonaws.com/login
8. user logout http://ec2-52-35-38-167.us-west-2.compute.amazonaws.com/disconnect
9. API json endpoint http://ec2-52-35-38-167.us-west-2.compute.amazonaws.com/catalogs?format=json http://ec2-52-35-38-167.us-west-2.compute.amazonaws.com/catalog/<string:catalog_name/items?format=json http://ec2-52-35-38-167.us-west-2.compute.amazonaws.com/catalog/string:catalog_name/string:item_name?format=json