Skip to content

Instantly share code, notes, and snippets.

View GuillaumeLoup's full-sized avatar

Guillaume GuillaumeLoup

13 followers · 3 following
  • Bordeaux
View GitHub Profile
@GuillaumeLoup
GuillaumeLoup / index.html
Created June 6, 2019 08:32
quete introduction à redux
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8" />
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<title>Counter Redux</title>
<meta name="viewport" content="width=device-width, initial-scale=1">
<!-- Redux CDN -->
<script src="https://cdnjs.cloudflare.com/ajax/libs/redux/4.0.1/redux.min.js"></script>
@GuillaumeLoup
GuillaumeLoup / fichier.sql
Created May 28, 2019 09:13
quete sql avancé
SELECT team.name, COUNT(wizard_id) AS nb_players
FROM player
JOIN team ON team.id=player.team_id
JOIN wizard ON wizard.id=player.wizard_id
GROUP BY team.name
ORDER BY nb_players DESC;
SELECT team.name
@GuillaumeLoup
GuillaumeLoup / quete_jointures_null.sql
Created May 24, 2019 12:33
quete jointures sql
select * from wizard
left join player on player.wizard_id=wizard.id
where player.role IS NULL;
@GuillaumeLoup
GuillaumeLoup / deleteexpress.sql
Created May 20, 2019 11:40
app.delete('/api/movies/:id', (req, res) => {
const idMovie = req.params.id;
connection.query('DELETE FROM movie WHERE id = ?', [idMovie], err => {
if (err) {
console.log(err);
res.status(500).send("Erreur lors de la suppression d'un film");
} else {
res.sendStatus(200);
}
});
@GuillaumeLoup
GuillaumeLoup / putexpress.js
Created May 20, 2019 09:59
app.put("/api/movies/:id", (req, res) => {
const formData = req.body;
const idMovie = req.params.id;
connection.query("UPDATE movie SET ? WHERE id=?", [formData, idMovie], err => {
if (err){
console.log(err);
res.status(500).send("erreur lors de la modification");
}else{
res.sendStatus(200);
}
@GuillaumeLoup
GuillaumeLoup / postAMovie.js
Created May 20, 2019 08:49
const express = require('express');
const app = express();
const port = 3000;
const connection = require("./conf");
const bodyParser = require("body-parser");
app.get("/api/movies", (req, res) => {
connection.query("SELECT * from movie", (err, results) => {
if (err) {
@GuillaumeLoup
GuillaumeLoup / routesql.sql
Created May 15, 2019 16:02
const express = require('express');
const app = express();
const port = 3001;
const connection = require("./conf");
app.get("/api/movies", (req, res) => {
connection.query("SELECT * from movie", (err, results) => {
if (err) {
@GuillaumeLoup
GuillaumeLoup / index.js
Last active May 14, 2019 15:36
const express = require('express');
const app = express();
const port = 3000;
app.get('/api/movies', (request, response) => {
response.send("Récupération de tous les films");
});
app.get('/api/movies/:id', (req, response) => {
const id = req.params.id;
response.json({ id: `${id}` });
@GuillaumeLoup
GuillaumeLoup / file1.sql
Created May 14, 2019 09:21
mysql> INSERT INTO school (name, country, capacity)
-> VALUES ("Beauxbatons Academy of Magic", "France", 550),
-> ("Castelobruxo", "Brazil", 380),
-> ("Durmstrang Institute", "Norway", 570),
-> ("Hogwarts School of Witchcraft and Wizardry", "United Kingdom", 450),
-> ("Ilvermorny School of Witchcraft and Wizardry", "USA", 300),
-> ("Koldovstoretz", "Russia", 125),
-> ("Mahoutokoro School of Magic", "Japan", 800),
-> ("Uagadou School of Magic", "Uganda", 350);
@GuillaumeLoup
GuillaumeLoup / index.js
Last active May 13, 2019 17:06
quete node requete http
const http = require("http");
const port = 3000;
const requestHandler = (request, response) => {
console.log(request.url);
let sentence;
let url = request.url.split('/');
console.log(url[1]);
switch(url[1]){
case 'contact' :