• Creation/management of users (employees)
• Creation/management of students
• Creation/management of activities
• Assignment of students to teachers
• Assignment of activities to students
• Input and retrieval of student data on their activity performance

• Changed teacher landing page to actually show up when a teacher logs in
• Allowed evaluators to access the page where they can assign students to teachers

• Text boxes at the top of most tables in the system look kind of like you can use them to input new data, but they are actually just there to allow the user to filter the contents of the table
• Users cannot edit their own data, such as password or username etc.
• Administrators adding a user to the system causes and error and the new user is not stored
• The shortcut links for assigned students in the sidebar lead to an error page, although student pages can still be accessed through other links
• Editing an existing activity in the system causes and error and does not save the edits
• There is an extra link on the evaluator landing page that leads to an error page
• There is no link to the add student page on the student list page, although the add student page can still be accessed through other links

This project only needs to run on a hosting service somewhere in the cloud, such as heroku or amazon aws. It requires no local installation.

List of python libraries to install with pip: flask flask-login psycopg2

To Run manually (not using heroku) python app.py go to http://127.0.0.1:5000/ in your browser

Not necessary for the project to function. Just useful for development purposes.

Postgres version: 9.6.5

Config details:

Postgres Username: postgres,

Postgres Password: password,

db name: jacobs_ladder_digitization

Running ./update_schema_local_safe.sh will take the most recent schema changes and update your local db instance. It will also repopulate the database with the default test data. This script will not update the schema if there is an error in the alters; however, if the alters apply correctly and the repopulation does not work correctly then you will have an updated schema without proper data.

See Ryan to get a db instance set up on your local machine.

Postgres Version 9.6.5

Config details (in this case this is an actual heroku config var):

Layout: postgres://username:password@host:port/db_name

Running ./update_schema_remote.sh will take the most recent schema changes and update the heroku db instance. It will also repopulate the database with the default test data. Running this script is dangerous if the alters are not guaranteed to run correctly because the database will be empty and without any tables if the alters do not apply correctly. The latest schema should be tested locally before it is applied to the remote database.

This article will walk you through creating a new heroku instance if you need to move the hosting and want to continue to use heroku: https://devcenter.heroku.com/articles/getting-started-with-python

I have included additional information about how we used heroku so that it can be ported to whatever hosting service is chosen for future use.

You should have this installed on your local machine: heroku-cli/6.14.37

You need to set up an account with heroku

The instructions for setting up an account can be found here (click on "free Heroku Account"): https://devcenter.heroku.com/articles/getting-started-with-python#introduction

Ryan will have to give you access to the heroku app using heroku access:add someone@example.com where the email address is the one associated with your heroku account

Once you have access, you will need to add the heroku remote to your local repository. This can be done with the following command: heroku git:remote -a jacobs-ladder-digitization

After that point, you can push to the heroku remote using git push heroku and pull from it using git pull heroku etc.

You can also run a local instance of the application by running heroku local. This will set up the application to run on http://0.0.0.0:5000/

Heroku knows that our application is a python application

Heroku uses the special file "Procfile" to determine how to execute the application. In our case it executes app.py

Heroku uses requirements.txt to track dependencies for python applications. If you have a python module that you want to use somewhere in our application then it (and its version numer) need to be added to this file. If you do not then Heroku will not install your module on the remote server and our application will fail.

Heroku uses runtime.txt to track which version of python it should be using. We are currently using python 2.7.4. Heroku can only use either 2.7.4 or 3.6.