/deno-web-final-project-zheyun

A Deno Web project of the course Web Software Development @ Aalto University

Primary LanguageEJS

web-final-project-zheyun

This is the final project of CS-C3170 - Web Software Development. Student: Zheyun Wu.

Online Demo (Heroku)

https://web-final-project-zheyun.herokuapp.com/

Run Locally

1. Database schema

CREATE TABLE users (
  id SERIAL PRIMARY KEY,
  email VARCHAR(320) NOT NULL,
  password CHAR(60) NOT NULL
);

CREATE UNIQUE INDEX ON users((lower(email)));

CREATE TABLE reports (
  id SERIAL PRIMARY KEY,
  date DATE NOT NULL,
  time VARCHAR NOT NULL,

  sleep_duration INTEGER,
  sleep_quality INTEGER,
  time_on_sports INTEGER,
  time_on_study INTEGER,
  regularity_quality_eating INTEGER,
  mood INTEGER,

  user_id INTEGER REFERENCES users(id) NOT NULL
);

2. Edit db settings in "./config/config.js"

3. Run the app:

deno run --allow-read --allow-env --allow-net --unstable app.js