const express= require('express')

module.exports = function (server) {

  const router = express.Router()
  server.use('/api',router)

  const taskList = require('../api/taskList/taskList')
  router.route('/taskList').get(taskList.getTaskList)

  router.get('/taskList/:id?',(req,res) =>{
    if(req.params.id) id = parseInt(req.params.id)
    return taskList.getTaskListById(id)
  })


}

const con = require('../../config/database')

//console.log(con.connectionCheck())
function getTaskList(req,res){
  return con.query('SELECT * FROM TB_TASKLIST',res)
}

function getTaskListById(id,res){
  //return console.log(id)
    return con.queryById(`SELECT * FROM TB_TASKLIST WHERE COD_ID_USER_TASK_LIST like ${id}`,res)
    console.log(res)
}

module.exports = {getTaskList,getTaskListById}

const mysql = require('mysql')
const connection = mysql.createConnection({
host : 'localhost',
port: 3306,
user:'root',
password:'',
database:'db_lifeapp'
})


function connectionCheck(){
  connection.connect(function(err) {
    if(err) console.log(err)
    console.log("conectado")
  })
}

function query(sqlQry,res){
  connection.query(sqlQry,function (err,results,fields) {
    if(err){
      res.json(err)
    }else{
      res.json(results)
      console.log("Query Executada")
    }
  })
}

function queryById(sqlQry,res){
  connection.query(sqlQry,function (err,results,fields) {
    if(err){
      console.log(err)
    }else{
      console.log("executado")
      res.json(results)

    }
  })
}

module.exports = {connectionCheck,query,queryById}

C:Usersfelipe.sangiorgeDesktopProjetoAPPBackendnode_modulesmysqllibprotocolParser.js:80
        throw err; // Rethrow non-MySQL errors
        ^

TypeError: Cannot read property 'json' of undefined
    at Query._callback (C:Usersfelipe.sangiorgeDesktopProjetoAPPBackendconfigdatabase.js:35:10)
    at Query.Sequence.end (C:Usersfelipe.sangiorgeDesktopProjetoAPPBackendnode_modulesmysqllibprotocolsequencesSequence.js:88:24)
    at Query._handleFinalResultPacket (C:Usersfelipe.sangiorgeDesktopProjetoAPPBackendnode_modulesmysqllibprotocolsequencesQuery.js:139:8)
    at Query.EofPacket (C:Usersfelipe.sangiorgeDesktopProjetoAPPBackendnode_modulesmysqllibprotocolsequencesQuery.js:123:8)
    at Protocol._parsePacket (C:Usersfelipe.sangiorgeDesktopProjetoAPPBackendnode_modulesmysqllibprotocolProtocol.js:279:23)
    at Parser.write (C:Usersfelipe.sangiorgeDesktopProjetoAPPBackendnode_modulesmysqllibprotocolParser.js:76:12)
    at Protocol.write (C:Usersfelipe.sangiorgeDesktopProjetoAPPBackendnode_modulesmysqllibprotocolProtocol.js:39:16)
    at Socket.<anonymous> (C:Usersfelipe.sangiorgeDesktopProjetoAPPBackendnode_modulesmysqllibConnection.js:103:28)
    at emitOne (events.js:96:13)
    at Socket.emit (events.js:188:7)