Sysc4806 Group 42

Memebers

• Derek Stride
• Justin Fleming
• Justin Krol
• Noah Segal

Project

We will be doing the 4th year project site.

Backlog

Issues for Milestone 1 Complete

• Issue #20 Project Objects + Test
• Issue #16 Configure Postgresql on Heroku
• Issue #21 Add an initial landing page
• Issue #10 Prof Entity
• Issue #9 Student Entity
• Issue #8 Project Model Entity
• Issue #7 Set up database Models
• Issue #6 Student Menu Page
• Issue #5 Project Model
• Issue #4 Project Coordinator Model
• Issue #3 Student Model
• Issue #2 Prof Model
• Issue #29 Deploy to Heroku

Issues for Milestone 2 Complete

• Issue #11 File Attatchments Entity
• Issue #14 Prof menu
• Issue #13 File Uploads
• Issue #41 Ensure Availability is Persisted
• Issue #39 Create Oral Presentation View
• Issue #14 Prof Menu
• PR #44 Presentation Template
• PR #46 Professor & Project Page
• PR #43 File Uploads for Prosal and Final report
• Issue #33 Set up S3 buckets and configure heroku to access them
• Issue #34 Setup a local storage bucket API for local dev and test
• PR #32 File Attachment Entity
• Issue #52 Move Malformed TimeSlot Exception to Constructor

Issues for Milestone 3

• Issue #12 Authentication and Authorization
• Issue #15 Oral Presentation Availability Picker
• Issue #40 Create Logic for picking a time that works for professor and students
• Issue #50 Add Integration Tests for HomeController
• Issue #49 Add Bootstrap, main.css, and header+footer fragments
• Issue #48 Attach AutherizedUser records to Existing student/professor records
• Issue #47 Add basic authentication
• Issue #55 Enable profs to create, archive, delete, and edit projects
• Issue #54 Only allow the project coordinator to create prof accounts
• Issue #53 Uploaded files with the same name delete previous versions
• Issue #51 Change Project and professor controller to search by Id instead of grab first

Unassigned issues

Setup

Requirements

Tested on MacOS 10.13.3

1. IntelliJ IDEA with Maven
2. JDK 1.8
3. Homebrew

Clone the project

Clone the project using the link here.

Resolve Maven dependencies

Resolve dependencies using Maven (this can be done in IntelliJ).

Install Postgresql

$ brew install postgres

To see which users exist for your postgres server:

$ psql postgres
postgres=# \du

After installing, you may already have a couple of users by default:

                                    List of roles
 Role name  |                         Attributes                         | Member of
------------+------------------------------------------------------------+-----------
 myusername | Superuser, Create role, Create DB                          | {}
 postgres   | Superuser, Create role, Create DB, Replication, Bypass RLS | {}

Create the Postgres DB

$ psql postgres
postgres=# CREATE DATABASE project_manager_dev;

Set up environment variables

Note: unless you've changed it, the password will probably be "".

$ export SYSC_DATABASE_URL="jdbc:postgresql://localhost/project_manager_dev" # do not change this
$ export SYSC_DATABASE_USERNAME="myusername" # change this to your postgres username
$ export SYSC_DATABASE_PASSWORD="mypassword" # change this to "" or the password you set

Run the server

This must be done from the same console in which you set your environment variables.

$ mvn spring-boot:run

By default, this will run the server on http://localhost:8080.