Function httpGet

cloud-sql/sqlserver/mssql/index.js:137–181

(req, res)

// Serve the index page, showing vote tallies.
const httpGet = async (req, res) => {
  try {
    // Get the 5 most recent votes.
    const recentVotesQuery = pool
      .request()
      .query(
        'SELECT TOP(5) candidate, time_cast FROM votes ORDER BY time_cast DESC'
      );

    // Get votes
    const stmt =
      'SELECT COUNT(vote_id) as count FROM votes WHERE candidate=@candidate';

    const tabsQuery = pool
      .request()
      .input('candidate', mssql.VarChar(6), 'TABS')
      .query(stmt);

    const spacesQuery = pool
      .request()
      .input('candidate', mssql.VarChar(6), 'SPACES')
      .query(stmt);

    // Run queries concurrently, and wait for them to complete
    // This is faster than await-ing each query object as it is created

    const recentVotes = await recentVotesQuery;
    const tabsVotes = await tabsQuery;
    const spacesVotes = await spacesQuery;

    res.render('index.pug', {
      recentVotes: recentVotes.recordset,
      tabCount: tabsVotes.recordset[0].count,
      spaceCount: spacesVotes.recordset[0].count,
    });
  } catch (err) {
    logger.error(err);
    res
      .status(500)
      .send(
        'Unable to load page. Please check the application logs for more details.'
      )
      .end();
  }
};

app.get('/', httpGet);