server.js

const express = require('express');
var path = require("path");
const app = express()
const port = 4444

app.use(express.static('front-end/dist'))
app.use(express.json());

const { Pool } = require('pg');
const pool = new Pool({
  user: 'postgres',
  host: 'postgres',
  database: 'ctagdb',
  password: 'postgres',
  port: 5432,
});

pool.connect((err, client, release) => {
  if (err) {
    return console.error('Error acquiring client', err.stack)
  }

  client.query('SELECT NOW()', (err, result) => {
    release()
    if (err) {
      return console.error('Error executing query', err.stack)
    }
    console.log(result.rows)
  })
});

app.get('/', (req, res) => {
  res.status(200).send("Server up and running!");
});

// Get User Data
app.get('/profile/:userhash', (req, res) => {
  userhash = req.params.userhash;
  console.log(userhash);

  pool.query(`SELECT * FROM ctag_profile WHERE hashpoint='${userhash}'`)
    .then((data) => {
      res.status(200).send(data);
    })
    .catch((err) => {
      res.status(500).send(err);
    });
})

app.post('/profile', (req, res) => {

});

app.listen(port, () => console.log(`Example app listening on port ${port}!`));

module.exports = app;