ps-accessibility-back-end

PS accessibility questionnaire back-end app with Houston, Boston and Toronto intern teams

postgres database setup

To create tables in postgres:

Paste the contents of Table Creation.txt into the Query Tool and run.

To populate the database:

Paste the contents of Table Populate.txt into the Query Tool and run. Paste the contents of Insert_from_excel_test_info.sql into the Query Tool and run.

Credentials

Create a new file called credentials.js within the backend folder and enter this code:

const Pool = require('pg').Pool
const pool = new Pool({
  user: 'postgres',
  host: 'localhost',
  database: '[DATABASE_NAME]',
  password: '[YOUR_PASSWORD]',
  port: 5432,
});
module.exports = pool;

Modify the database and password field accordingly.

To download the dependencies:

run npm i express pg multer in the command line.

To run the server:

run node server.js in the command line.