gistfile1.txt

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

const client = new Client();
client.connect()
  .then(() => {
     const sticky = await client.query("SELECT * FROM product_index WHERE product_sticky::boolean = 'true'")
         .then((results) => results.rows);
     const lowstock = await client.query("SELECT * FROM product_index WHERE product_sticky::boolean = 'true'");
      .then((results) => results.rows);
     return { sticky, lowstock };
   })
    .then((results) => {
        console.log('results?', results);
        client.end();
        res.render('home', results);    
    })
    .catch((err) => {
        console.log('error'. err);
        client.end();
        res.send('Something bad happened');
    });
});