Skip to content

Instantly share code, notes, and snippets.

View gaetan-cordonnier's full-sized avatar

Gaëtan Cordonnier gaetan-cordonnier

View GitHub Profile
@gaetan-cordonnier
gaetan-cordonnier / index.js
Last active December 14, 2020 10:49
Middlewares dans Express
const express = require("express");
const port = 3000;
const app = express();
// route superMiddleware + function middleware
app.get(
"/superMiddleware",
(req, res, next) => {
res.send("hello world");
@gaetan-cordonnier
gaetan-cordonnier / wizard.sql
Last active December 10, 2020 07:22
SQL Quest #2
SELECT firstname, lastname, name, role
FROM wizard
JOIN player ON wizard_id=wizard.id
JOIN team ON team_id=team.id
ORDER BY name, role, lastname, firstname;
SELECT firstname, lastname, role
FROM wizard
JOIN player ON wizard_id=wizard.id
AND role='seeker'
@gaetan-cordonnier
gaetan-cordonnier / index.js
Created December 7, 2020 23:45
Express Quest #5
const express = require("express");
const movies = require("./movies");
const connection = require("./config");
const port = 3000;
const app = express();
// connexion à la Database
connection.connect(function (err) {
if (err) {
@gaetan-cordonnier
gaetan-cordonnier / index.js
Created December 7, 2020 23:30
Express Quest #4
const express = require("express");
const movies = require("./movies");
const connection = require("./config");
const port = 3000;
const app = express();
// connexion à la Database
connection.connect(function (err) {
if (err) {
@gaetan-cordonnier
gaetan-cordonnier / index.js
Created December 7, 2020 22:29
Express Quest #3
const express = require("express");
const movies = require("./movies");
const connection = require("./config");
const port = 3000;
const app = express();
// connexion à la Database
connection.connect(function (err) {
if (err) {
@gaetan-cordonnier
gaetan-cordonnier / index.js
Last active December 7, 2020 23:25
Express Quest #2
const express = require("express");
const movies = require("./movies");
const port = 3000;
const app = express();
const connection = require("./config");
// connexion à la Database
connection.connect(function (err) {
if (err) {
console.error("error connecting: " + err.stack);
@gaetan-cordonnier
gaetan-cordonnier / gist:b58cca953750b91fba14009efcde1470
Created November 30, 2020 12:29
Node.js - Créer un serveur HTTP
const http = require("http");
const url = require("url");
const port = 8000;
const requestHandler = (request, response) => {
const urlValue = request.url;
const parseUrl = url.parse(urlValue, true);
const nameValue = parseUrl.query;
if (request.url === "/") {