Skip to content
Snippets Groups Projects
Select Git revision
  • 2551fd57c81f497005bb802107701134d9f4a4a2
  • master default
  • goodpaths
  • movie-page
  • front-bilel
  • vieille-branche
  • octofront
  • branche-TP-de-Tom
8 results

MoviePage.vue

Blame
  • equipe.controller.js 2.23 KiB
    const mysql = require('mysql');
    
    var secrets = require('../secrets.js');
    var dbhost = secrets.dbhost;
    var dbuser = secrets.dbuser;
    var dbpassword = secrets.dbpassword;
    var dbdatabase = secrets.dbdatabase;
    
    const dbConfig = {
      host: dbhost,
      user: dbuser,
      password: dbpassword,
      database: dbdatabase
    };
    
    function getClassementEquipe(req, res){
      var con = mysql.createConnection(dbConfig);
      var query = "SELECT Equipe.id as id,Equipe.name,SUM(score) AS score,COUNT(participantId) AS nbParticipant,COUNT(score) AS nbScores FROM Score JOIN Equipe ON Equipe.id=Score.equipeId WHERE Equipe.deleted = 0 AND Score.deleted = 0 GROUP BY equipeId ORDER BY score DESC;"
      con.connect();
      con.query(query, (err, result) => {
      if(err){
          console.log(err)
          return res.send({success: false})
      }
      return res.send(result)
      });
      con.end();
    }
    
    function getEquipes(req, res){
      var con = mysql.createConnection(dbConfig);
      var query = "SELECT id,name FROM Equipe WHERE deleted = 0 ORDER BY name ASC;"
      con.connect();
      con.query(query, (err, result) => {
      if(err){
          console.log(err)
          return res.send({success: false})
      }
      return res.send(result)
      });
      con.end();
    }
    
    function addNewEquipe(req, res){
      var con = mysql.createConnection(dbConfig);
      var query = "INSERT INTO `Equipe` (`name`) VALUES ('"+req.body.name+"');"
      con.connect();
      con.query(query, (err, result) => {
      if(err){
          console.log(err)
          return res.send({success: false})
      }
      return res.send(result)
      });
      con.end();
    }
    
    function updateEquipe(req, res){
      var con = mysql.createConnection(dbConfig);
      var query = "UPDATE Equipe SET name = '"+req.body.name+"' WHERE id="+req.body.id+";"
      con.connect();
      con.query(query, (err, result) => {
      if(err){
          console.log(err)
          return res.send({success: false})
      }
      return res.send(result)
      });
      con.end();
    }
    
    function deleteEquipe(req, res){
      var con = mysql.createConnection(dbConfig);
      var query = "UPDATE Equipe SET deleted = 1 WHERE id="+req.body.id+";"
      con.connect();
      con.query(query, (err, result) => {
      if(err){
          console.log(err)
          return res.send({success: false})
      }
      return res.send(result)
      });
      con.end();
    }
    
    module.exports = {getClassementEquipe,getEquipes,addNewEquipe,updateEquipe,deleteEquipe}