1.0.0 • Published 2 years ago
ps-accessibility-questionnaire v1.0.0
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.
1.0.0
2 years ago