Skip to content

Instantly share code, notes, and snippets.

View BastienSaulnier's full-sized avatar
🏠
Working from home

BastienSaulnier BastienSaulnier

🏠
Working from home
5 followers · 13 following
  • Lille, France
View GitHub Profile
@BastienSaulnier
BastienSaulnier / index.js
Last active December 9, 2019 11:44
Express 6 - GET en détail - Wild Code School
const connection = require("./conf");
const express = require("express");
const app = express();
const port = process.env.PORT || 3000;
/* --- GET All --- */
app.get("/api/movies", (req, res) => {
let sql = "SELECT * FROM movie";
const sqlValues = [];
@BastienSaulnier
BastienSaulnier / index.html
Created December 2, 2019 14:44
Redux - Un compteur avec Redux et JavaScript - Wild Code School
<!DOCTYPE html>
<html lang="fr">
<head>
<meta charset="UTF-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0" />
<meta http-equiv="X-UA-Compatible" content="ie=edge" />
<title>Redux Counter</title>
<script src="https://cdnjs.cloudflare.com/ajax/libs/redux/4.0.1/redux.min.js"></script>
</head>
</head>
@BastienSaulnier
BastienSaulnier / request.sql
Last active November 27, 2019 13:51
06 - SQL Advanced - Wild Code School
mysql> SELECT team.name, COUNT(player.team_id) AS nb_player
-> FROM team
-> JOIN player ON player.team_id = team.id
-> GROUP BY team.name
-> ORDER BY nb_player DESC;
+------------+-----------+
| name | nb_player |
+------------+-----------+
| Gryffindor | 36 |
@BastienSaulnier
BastienSaulnier / request.sql
Created November 27, 2019 08:50
05 SQL - Les Jointures - Wild Code School
mysql> SELECT w.firstname, w.lastname, p.role, t.name
-> FROM player p
-> JOIN wizard w ON w.id=p.wizard_id
-> JOIN team t ON t.id=p.team_id
-> ORDER BY t.name ASC, p.role ASC, w.lastname ASC, w.firstname ASC;
+-------------+-----------------+--------+------------+
| firstname | lastname | role | name |
+-------------+-----------------+--------+------------+
| Sirius | Black | beater | Gryffindor |
@BastienSaulnier
BastienSaulnier / index.js
Created November 20, 2019 12:05
05 express Wild Code School
const connection = require("./conf");
const bodyParser = require("body-parser");
const express = require("express");
const app = express();
const port = process.env.PORT || 3000;
app.use(bodyParser.json());
app.get("/api/movies", (req, res) => {
// TODO récupération des données (étape 2)
@BastienSaulnier
BastienSaulnier / index.js
Created November 20, 2019 11:58
04 - express Wild Code School
const connection = require("./conf");
const bodyParser = require("body-parser");
const express = require("express");
const app = express();
const port = process.env.PORT || 3000;
app.use(bodyParser.json());
app.get("/api/movies", (req, res) => {
// TODO récupération des données (étape 2)
@BastienSaulnier
BastienSaulnier / index.js
Created November 19, 2019 17:28
03 - express WIld Code School
const connection = require("./conf");
const bodyParser = require("body-parser");
const express = require("express");
const app = express();
const port = process.env.PORT || 3000;
app.use(bodyParser.json());
app.post("/api/movies", (req, res) => {
// TODO récupérer les données (étape 2)
@BastienSaulnier
BastienSaulnier / index.js
Created November 19, 2019 11:08
02 - express Wild Code School
const connection = require("./conf");
const express = require("express");
const app = express();
const port = process.env.PORT || 3000;
app.get("/api/movies", (req, res) => {
// TODO récupération des données (étape 2)
connection.query("SELECT * FROM movie", (err, results) => {
// TODO envoyer les données récupérées (étape 3)
if (err) {
@BastienSaulnier
BastienSaulnier / index.js
Created November 19, 2019 11:08
02 - express Wild Code School
const connection = require("./conf");
const express = require("express");
const app = express();
const port = process.env.PORT || 3000;
app.get("/api/movies", (req, res) => {
// TODO récupération des données (étape 2)
connection.query("SELECT * FROM movie", (err, results) => {
// TODO envoyer les données récupérées (étape 3)
if (err) {
@BastienSaulnier
BastienSaulnier / index.js
Created November 19, 2019 10:25
01 - express Wild Code School
const express = require("express");
const app = express();
const port = process.env.PORT || 3000;
app.get("/", (req, res) => {
res.send("Hello World");
});
app.get("/api/movies", (req, res) => {
res.send("Recupération de tout les films...");