Question

Pls help me with this Node Js homework.

First implement this ejs file. Check out the TODO section and implement it.

Given:

ejs file:

<% include ../partials/header %>
<% include ../partials/menu %>
   <div class="container">
       <br>
       <div class="jumbotron">
       <h1 class="display-4">Fall 2018 Stats</h1>
       <p class="lead">Detailed information on how the Buffs are doing in the 2018 Football Season!</p>
       </div>
      
       <table class="table table-bordered" id="stats_table">
           <tr>
               <th class="align-bottom" rowspan="2">Game Date</th>
               <th class="align-bottom"rowspan="2">Opposing Team Name</th>
               <th class="text-center" colspan="2">Score</th>
               <th class="align-bottom" rowspan="2">Winner</th>
           </tr>
           <tr>
               <th>Home Score</th>
               <th>Opp. Score</th>
           </tr>
           <!-- TODO: Iterate over the Football_table data here
                       1. Display the information for each row (date, name, home score, visitor score)
                       2. Determine who the winner is and display it in the final column

                       If you're not sure how the logic should work here, review the code you add to the client-side javascript
                       that ran onload for Lab 5. We are doing the same kind of operations we had in Lab 5, but we are instead having
                       everything handled via server-side scriptes
           -->
          
       </table>
       <br>
       <table class="table text-center">
           <tr>
               <th>Wins</th>
               <th>Losses</th>
           </tr>
           <tr>
               <td> <!-- TODO: Display the total number of wins here.
                           This value should come from your server.js files query, don't calculate it in this file! --></td>
               <td> <!-- TODO: Display the total number of losses here.
                           This value should come from your server.js files query, don't calculate it in this file! --></td>
           </tr>
       </table>
      
   </div>
<% include ../partials/footer %>

Then complete the query function for me:

requirements:

    /team_stats - get request (no parameters)
           This route will require no parameters. It will require 3 postgres queries which will:
               1. Retrieve all of the football games in the Fall 2018 Season
               2. Count the number of winning games in the Fall 2018 Season
               3. Count the number of lossing games in the Fall 2018 Season
           The three query results will then be passed onto the team_stats view (pages/team_stats).
           The team_stats view will display all fo the football games for the season, show who won each game,
           and show the total number of wins/losses for the season.

What I got:

app.get('/team_stats',function(req,res){
//sql statement
//exeucute
//result to render data
res.render('pages/team_stats',{
my_title:"Team stats"
})

});

Answer 1

ejs file:

<% include ../partials/header %>
<% include ../partials/menu %>
   <div class="container">
       <br>
       <div class="jumbotron">
       <h1 class="display-4">Fall 2018 Stats</h1>
       <p class="lead">Detailed information on how the Buffs are doing in the 2018 Football Season!</p>
       </div>
      
       <table class="table table-bordered" id="stats_table">
           <tr>
               <th class="align-bottom" rowspan="2">Game Date</th>
               <th class="align-bottom"rowspan="2">Opposing Team Name</th>
               <th class="text-center" colspan="2">Score</th>
               <th class="align-bottom" rowspan="2">Winner</th>
           </tr>
           <tr>
               <th>Home Score</th>
               <th>Opp. Score</th>
           </tr>
           <!-- TODO: Iterate over the Football_table data here
                       1. Display the information for each row (date, name, home score, visitor score)
                       2. Determine who the winner is and display it in the final column

                       If you're not sure how the logic should work here, review the code you add to the client-side javascript
                       that ran onload for Lab 5. We are doing the same kind of operations we had in Lab 5, but we are instead having
                       everything handled via server-side scriptes
           -->
          
       </table>
       <br>
       <table class="table text-center">
           <tr>
               <th>Wins</th>
               <th>Losses</th>
           </tr>
           <tr>
               <td> <!-- TODO: Display the total number of wins here.
                           This value should come from your server.js files query, don't calculate it in this file! --></td>
               <td> <!-- TODO: Display the total number of losses here.
                           This value should come from your server.js files query, don't calculate it in this file! --></td>
           </tr>
       </table>
      
   </div>
<% include ../partials/footer %>

Then complete the query function for me:

requirements:

    /team_stats - get request (no parameters)
           This route will require no parameters. It will require 3 postgres queries which will:
               1. Retrieve all of the football games in the Fall 2018 Season
               2. Count the number of winning games in the Fall 2018 Season
               3. Count the number of lossing games in the Fall 2018 Season
           The three query results will then be passed onto the team_stats view (pages/team_stats).
           The team_stats view will display all fo the football games for the season, show who won each game,
           and show the total number of wins/losses for the season.

What I got:

app.get('/team_stats',function(req,res){
//sql statement
//exeucute
//result to render data
res.render('pages/team_stats',{
my_title:"Team stats"
})

});