Skip to content

Instantly share code, notes, and snippets.

@cormobro
cormobro / photo.jpg
Created October 24, 2018 14:43
photo photo
http://image.noelshack.com/fichiers/2018/43/3/1540392176-44674138-2208939812728054-5404966649797279744-n.jpg
@cormobro
cormobro / dwssap.sh
Created November 13, 2019 16:30
dwssap
cat /etc/passwd | grep "*:" | cut -d ":" -f1 | sed -n 'n;p' | rev | sort -r | awk 'NR >= '$FT_LINE1' && NR <= '$FT_LINE2'' | tr '\n' ',' | sed '$ s/.$/./' | sed 's/, */, /g'
@cormobro
cormobro / Makefile
Created January 8, 2020 14:43
makefile felix
NAME=libft.a
CC=gcc
CFLAGS=-Wall -Wextra -Werror
RM=rm -f
LDLIBS=-lft
@cormobro
cormobro / Inpace.sql
Created March 16, 2019 18:50
base de donnees Inpace
CREATE TABLE Prix (
id_pr int,
cluxe_pr int NOT NULL,
csobre_pr int NOT NULL,
cstandard_pr int NOT NULL,
fsobre_pr int NOT NULL,
fluxe_pr int NOT NULL,
fstandard_pr int NOT NULL,
PRIMARY KEY (id_pr)
);
@cormobro
cormobro / query.sql
Created January 14, 2019 12:45
query.sql
-- #1
SELECT nom, salaire FROM `equipe` WHERE campus_mgr IS NULL
-- #2
SELECT IF(id_camp=140, "#####", nom) FROM `equipe`
-- #3
SELECT nom, SUBSTR(date_embauche, 6, 2) FROM `equipe`
-- #4
SELECT nom, IF(SUBSTR(date_embauche, 1, 4)!=2017, "13", 13 - SUBSTR(date_embauche, 6, 2)) FROM `equipe`
-- #5
SELECT nom, fonction, date_embauche, campus.nom_camp, campus.nom_camp FROM `equipe` INNER JOIN campus ON equipe.id_camp=campus.id_camp WHERE campus.nom_camp="nurn"
@cormobro
cormobro / index.js
Last active January 14, 2019 09:20
send mail
var express = require('express');
var router = express.Router();
const nodemailer = require("nodemailer");
/* GET home page. */
router.get('/', function(req, res, next) {
res.render('index', { title: 'Express' });
});
router.get('/askForCookiesRecipe', function(req, res, next) {
@cormobro
cormobro / index.js
Created January 10, 2019 14:22
index
var express = require('express');
var router = express.Router();
/* GET home page. */
router.get('/', function(req, res, next) {
res.render('index', { title: 'Express' });
});
router.get('/superMiddleware', (req, res, next) => {
console.log("hello middleware");
@cormobro
cormobro / queries.sql
Created January 10, 2019 10:35
queries for sql
-- #1
SELECT id_camp, localite FROM `campus` WHERE 1;
-- #2
SELECT equipe.nom, campus.nom_camp FROM equipe INNER JOIN campus ON equipe.id_camp=campus.id_camp;
-- #3
SELECT nom FROM `equipe` WHERE fonction="assistant" AND id_camp > 120
-- #4
SELECT nom FROM `equipe` WHERE fonction!="assistant" AND date_embauche LIKE "2017%"
-- #5
SELECT nom FROM `equipe` WHERE nom LIKE "%a%" AND nom LIKE "%r%"
@cormobro
cormobro / bonaert_f_wcs_bruxelles2.sql
Created January 8, 2019 17:33
bonaert_f_wcs_bruxelles2.sql
-- MySQL dump 10.13 Distrib 5.7.23, for osx10.9 (x86_64)
--
-- Host: localhost Database: sql3
-- ------------------------------------------------------
-- Server version 5.7.23
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
@cormobro
cormobro / index.js
Created January 8, 2019 15:17
index.js
var express = require('express');
var router = express.Router();
/* PUT */
router.put('/:name', function(req, res, next) {
res.send('Hey my name is'+ req.params.name);
});
/* DELETE */