Select Git revision
MoviePage.vue
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}