Skip to content

Instantly share code, notes, and snippets.

View Lio-code's full-sized avatar

Lio Lio-code

  • Anglet
View GitHub Profile
@Lio-code
Lio-code / markdown-details-collapsible.md
Created July 24, 2022 12:02 — forked from pierrejoubert73/markdown-details-collapsible.md
How to add a collapsible section in markdown.

A collapsible section containing markdown

Click to expand!

Heading

  1. A numbered
  2. list
    • With some
    • Sub bullets
@Lio-code
Lio-code / Lionel_06 - SQL avancé
Created June 10, 2020 16:51
1/ Retourne le nom des équipes et le nombre de joueurs par équipe, le tout classé par nombre de joueurs par équipe, de la plus nombreuse à la moins nombreuse.
mysql> SELECT name, COUNT(*) as number_player
-> FROM team t
-> JOIN player p ON p.team_id=t.id
-> GROUP BY team_id
-> ORDER BY number_player DESC;
+------------+---------------+
| name | number_player |
+------------+---------------+
@Lio-code
Lio-code / gist:6b04f322bde2d993c2678b5056dd524e
Created June 8, 2020 10:49
Lionel 06 - SQL avancé
mysql> SELECT * FROM player p
-> JOIN team t
-> ON t.id=p.team_id;
+------+-----------+---------+--------+-----------------+----+------------+
| id | wizard_id | team_id | role | enrollment_date | id | name |
+------+-----------+---------+--------+-----------------+----+------------+
| 1 | 1 | 4 | beater | 1995-10-09 | 4 | Hufflepuff |
| 2 | 2 | 1 | chaser | 1995-08-17 | 1 | Gryffindor |
| 3 | 3 | 1 | seeker | 1994-12-03 | 1 | Gryffindor |
| 4 | 4 | 3 | chaser | 1995-03-24 | 3 | Slytherin |
@Lio-code
Lio-code / gist:8f7440370b5b6122ff4b25b56f1e41a1
Created June 7, 2020 16:37
mysql> SELECT lastname, firstname, role, name FROM player
JOIN team ON team.id=player.team_id
JOIN wizard ON wizard.id=player.wizard_id
ORDER BY name;
+-----------------+-------------+--------+------------+
| lastname | firstname | role | name |
+-----------------+-------------+--------+------------+
| | Cadogan | keeper | Gryffindor |
| Weasley | Ginevra | keeper | Gryffindor |
| Longbottom | Alice | beater | Gryffindor |
@Lio-code
Lio-code / gist:f7e41a29d6617d95d39db61ca523ba9e
Created June 4, 2020 19:50
Express 5 - Méthode DELETE et suppression de données
const express = require('express');
const app = express();
const port = 3000;
const connection = require('./conf');
// Support JSON-encoded bodies
app.use(express.json());
// Support URL-encoded bodies
app.use(express.urlencoded({
extended: true
@Lio-code
Lio-code / gist:c3aaadc588a67ada72878a4baa2ff47b
Last active June 4, 2020 19:51
Express 4 - Méthode PUT et modification de données
const express = require('express');
const app = express();
const port = 3000;
const connection = require('./conf');
// Support JSON-encoded bodies
app.use(express.json());
// Support URL-encoded bodies
app.use(express.urlencoded({
extended: true
@Lio-code
Lio-code / gist:55195ed7b349ff21d375be975aa3406d
Created June 4, 2020 15:44
Lionel - Express 3 - Méthode POST et insertion de données
const express = require('express');
const app = express();
const port = 3000;
const connection = require('./conf');
//Midleware
// Support JSON-encoded bodies
app.use(express.json());
// Support URL-encoded bodies
app.use(express.urlencoded({
@Lio-code
Lio-code / gist:3672db00c87c5c485b948137e64c9e7a
Created June 3, 2020 12:45
Lionel - Express 2 - Express, MySQL, Postman
const express = require('express');
const app = express();
const port = 3000;
const connection = require('./conf');
app.get('/api/movies', (req, res) => {
// connection à la base de données, et sélection des employés
connection.query('SELECT * from movie', (err, results) => {
@Lio-code
Lio-code / gist:a6196df3ef69fbae6d0c9c794f7b4f62
Created June 2, 2020 19:10
Lionel - Express 1 - Découverte d'Express
const express = require('express');
const app = express();
const port = 3000;
app.get('/', (request, response) => {
response.send('Bienvenue sur Express');
});
app.get('/api/movies', (request, response) => {
@Lio-code
Lio-code / gist:35b0f37e6468748404be526b4bd37795
Created June 2, 2020 14:51
Lionel - Node.js - Créer un serveur HTTP
const http = require('http');
const port = 8000;
const url = require('url');
const requestHandler = (request, response) => {
console.log(request.url);
const parsedUrl = url.parse(request.url, true).query;
console.log(parsedUrl);
if (parsedUrl.name && parsedUrl.city) {