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:
``javascript
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.