Skip to content
Snippets Groups Projects
Select Git revision
  • f7a6ca5db790ef225e1fdc91f68864d07f12bc33
  • main default
  • tp2
  • tp1
  • tp3
  • tp3-correction
  • tp2-correction
  • tp1-correction
  • admins
9 results

test_calculator.py

Blame
  • Forked from an inaccessible project.
    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}