Beginner Node Help- take 2

masmithrpg — Mon, 15 Oct 2018 18:40:43 +0000

I am very new at HTML, NODE, PUG, etc. I'm trying to build a golf

score application. I have created the first part that allows me to
CRUD the courses. This part is working.
I have 2 tables, courses and scores.

After displaying a list of courses, i select a course and load 6
blank HTML table records to allow entry of golfers and scores each of
the 18 holes.
Now is where i'm confused and need some guidance.

         in my .pug file, how do i display an output field that displays a 
         running total of my score?

         On my submit button, i'm not getting to my POST, but i cannot figure 
         out why

         I want to be able to hit save on this screen and either Insert or 
         Update, depending on whether i have already saved.  Should that be 
         handled within a single POST?  It seems like i should, but i don't 
         know enough about Node to know

         I am processing my courses and scores within a single index.js file.  
         Should i be separating the courses/holes into separate .js files?

         Thats enough for now
         Thanks for any guidance you can provide

        app.get('/scores/keepscore', function(req, res) {

res.render('scores/keepscore', { title: 'ScoreCard' ,form_action: /scores/update})
})
app.post('/scores/update', function(req, res) {
console.log('i got to the update')
let stmt = new db.dbstmt(dbconn)
console.log(req)
var sql =
INSERT INTO ${schema}.SCORECARD (COURSE,GOLFER, GDATE, HOLE1,HOLE2,HOLE3,HOLE4, HOLE5, HOLE6, HOLE7, HOLE8, HOLE9, HOLE10, HOLE11, HOLE12, HOLE13, HOLE14, HOLE15, HOLE16, HOLE17, HOLE18) VALUES ('${req.body.COURSE}','${req.body.GOLFER}',CURRENT_DATE, ${req.body.HOLER1}, ${req.body.HOLE2}, ${req.body.HOLE3},${req.body.HOLE4}, ${req.body.HOLE5}, ${req.body.HOLE6}, ${req.body.HOLE7}, ${req.body.HOLE8}, ${req.body.HOLE9},${req.body.HOLE10}, ${req.body.HOLE11}, ${req.body.HOLE12},${req.body.HOLE13}, ${req.body.HOLE14}, ${req.body.HOLE15}, ${req.body.HOLE16}, ${req.body.HOLE17}, ${req.body.HOLE18} ) with NC
stmt.exec(sql, function(result, err){
console.log(err)
res.redirect('/scores/keepscore')
stmt.close()
})
})

Beginner Node Help

masmithrpg — Mon, 15 Oct 2018 17:43:56 +0000

DEV Community: masmithrpg

Beginner Node Help- take 2

Beginner Node Help