Skip to content

Instantly share code, notes, and snippets.

View s4mf3nn's full-sized avatar
👋

Samir s4mf3nn

👋
8 followers · 7 following
View GitHub Profile
@s4mf3nn
s4mf3nn / randomColorGenerator
Created November 7, 2019 14:42
const getRandomColor = () => {
const letters = '0123456789ABCDEF';
let color = '#';
for (let i = 0; i < 6; i++) {
color += letters[Math.floor(Math.random() * 16)];
}
return color;
};
@s4mf3nn
s4mf3nn / router.js
Created June 3, 2019 07:54
Express & SQL - Atelier Fil Rouge
const express = require('express');
const app = express();
const { PORT, db } = require('./conf');
app.disable('x-powered-by');
app.listen(PORT, () => {
console.log(`API root available at http://localhost:${PORT}/`);
});
@s4mf3nn
s4mf3nn / conf.js
Last active May 27, 2019 15:47
Fichiers d'initialisation pour Express JS
const PORT = 8080;
const mysql = require('mysql');
const db = mysql.createConnection({
host: 'localhost',
user: 'root',
password: [Secret],
database: "blog-G2"
});
@s4mf3nn
s4mf3nn / index.html
Last active May 27, 2019 12:40
Redux JS
<!DOCTYPE html>
<html lang="fr">
<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 -->
@s4mf3nn
s4mf3nn / sql06.sql
Last active May 27, 2019 08:00
-- 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.
SELECT name, COUNT(*) AS nb_players
FROM team AS t
JOIN player AS p
ON t.id = p.team_id
GROUP BY team_id
ORDER BY nb_players DESC;
+------------+------------+
@s4mf3nn
s4mf3nn / index.js
Created May 20, 2019 09:42
Express 5 - Méthode DELETE et suppression de données
const express = require('express');
const app = express();
const port = process.env.PORT || 3000;
const connection = require('./conf');
const bodyParser = require('body-parser');
// Support JSON-encoded bodies
app.use(bodyParser.json());
// Support URL-encoded bodies
app.use(
bodyParser.urlencoded({
@s4mf3nn
s4mf3nn / index.js
Created May 20, 2019 08:48
Express 4 - Méthode PUT et modification de données
const express = require('express');
const app = express();
const port = process.env.PORT || 3000;
const connection = require('./conf');
const bodyParser = require('body-parser');
// Support JSON-encoded bodies
app.use(bodyParser.json());
// Support URL-encoded bodies
app.use(
bodyParser.urlencoded({
@s4mf3nn
s4mf3nn / index.js
Created May 20, 2019 07:53
Express 3 - Méthode POST et insertion de données
const express = require('express')
const app = express()
const connection = require('./conf')
const bodyParser = require('body-parser')
// Support JSON-encoded bodies
app.use(bodyParser.json())
// Support URL-encoded bodies
app.use(
bodyParser.urlencoded({
extended: true,
@s4mf3nn
s4mf3nn / conf.js
Last active May 16, 2019 09:25
Express 2 - Express, MySQL, Postman
const pass = require('./pwd');
const mysql = require('mysql');
const connection = mysql.createConnection({
host: 'localhost',
user: 'root',
password: pass,
database: 'wild_db_quest'
});
@s4mf3nn
s4mf3nn / index.js
Last active May 15, 2019 15:52
Express 1 - Découverte d'Express
const express = require('express');
const app = express();
const port = process.env.PORT || 3000;
const movies = [
{
id: 1,
name: 'movie1'
},
{