CODEWITHSUNDEEP
mysqlnode.jsexpress
Rsrd
Rsrd

Reputation: 23

can´t make your two or more methods in same route

the link to the project https://github.com/Kammikazy/project i can´t make work my get two or more methods in same route i have the code 404 i using mysql nodejs and express my code
controller alliances 

const User = require('../models/Alliances')

const findAlianca = async (connection,  req, res) => {

  const Allianca = await User.find(connection, req.session.user.username)
  if (!Allianca) {
 res.status(404).send('Nenhuma cidade encontrada.');
 return;
}
console.log("dddd");
          req.session.Allianca = Allianca
          res.locals.Allianca = Allianca
res.render('Administration/Alliances')
  }

  module.exports = {
   findAlianca
  }

route aliance

const express = require('express')
const router = express.Router()
const connection = require('../../Config/database')
const controllerAdmin = require('../../controllers/Administration')
const controlleruser = require('../../controllers/Alliances')
router.get('/Administration/Alliances', (req, res) => controllerAdmin.findcidade3(connection, req, res))
router.get('/Administration/Alliances/limitado', (req, res) => controlleruser.findAlianca(connection, req, res))


module.exports = app => app.use('/', router)

models aliance

const find = (connection,username) => { return new Promise((resolve, reject) => { connection.query(SELECT alianca.nome,alianca.N_membros,alianca.TAG FROM user INNER JOIN alianca ON user.cod_alianca=alianca.id WHERE user.username='${username}', (err, result) => { if(err){ reject(err) }else{ resolve(result) } }) }) }

    module.exports = {
        find
    }

alliance.jade

extends layout
block title
   .col-xs-6.col-xs-offset-3.col-sm-6.col-sm-offset-3
   .col-sm-4(style='width:76%')
    div.panel.panel-primary(style='height:50px') Alliances Page
    div.panel.panel-primary(style='height:700px')  fdssdklfsdklfjskldfjkldsjfl
      if locals.user.cod_alianca==null
         p You Dont Have Alliances
      else 
         br
         span Your Aliance
         span= locals.Allianca.nome
   .col-xs-2.panel-red(style='width:24%;height:100%;text-align:center')

my app 

require('./routes/Administration/Alliances')(app)

my connection db

const mysql = require('mysql')
const config = require( "./config.json" )
const connection =mysql.createConnection({
 host:config.host,
 user:config.user,
 password:config.password,
 database:config.database,
// port:config.port
});

connection.connect((err) =>{
    if(err){
        console.log(err)
        process.exit(0)
    }else{
    console.log('database on')
}
})

what i doing wrong i can´t find the solution for my problem

Upvotes: 1

Views: 118

Answers (2)

Rsrd
Rsrd

Reputation: 23

the soluction for my problem 

const express = require('express')
    const router = express.Router()
    const connection = require('../../Config/database')
    const controllerAdmin = require('../../controllers/Administration')
    const controlleruser = require('../../controllers/Alliances')

    router.get('/Administration/Alliances', (req, res, next) => {
        //Do something here and to add data to your request use
      controllerAdmin.findcidade3(connection, req, res)
        next();
    }, (req, res, next) => {
        //Can continue this cycle of calling next function until last `sendResponse` function is reached.
        //Can even set `error` in request for `sendResponse`
      controlleruser.findAlianca(connection, req, res)
    })
   module.exports = app => app.use('/', router)

Upvotes: 0

NAVIN
NAVIN

Reputation: 3317

Not sure what you are asking however if you want to call multiple function in same route/API you can do following:

Using expressJs you can use next function like:

app.get('/Administration/Alliances', (req, res, next) => { 
    //Do something here and to add data to your request use
    req.body.newData = 'newData';
    //after this just call next function
    next();
}, (req, res, next) => {
    //Can continue this cycle of calling next function until last `sendResponse` function is reached.
    //Can even set `error` in request for `sendResponse` 
    req.error = "Some error";
    next();
}, (req, res) => {
    if(req.error) {
        res.status(400).send(req.error);
    } else {
        res.status(200).send(req.body.result);
    }
});

Upvotes: 0

Related Questions