Skip to content

Instantly share code, notes, and snippets.

View PradalCyril's full-sized avatar

PRADAL Cyril PradalCyril

View GitHub Profile
@PradalCyril
PradalCyril / 05sql
Last active January 16, 2019 16:09
-- #1
SELECT equipe.nom, round(equipe.salaire,3) from equipe WHERE campus_mgr is null
-- #2
SELECT case when campus.nom_camp != 'Lorien' then equipe.nom else '#####' END from equipe INNER JOIN campus ON campus.id_camp = equipe.id_camp
-- #3
SELECT equipe.nom, LPAD(MONTH(date_embauche),2,0) from equipe
@PradalCyril
PradalCyril / 04 sql
Created January 10, 2019 14:19
-- #1
SELECT id_camp, localite from campus
-- #2
SELECT equipe.nom, campus.nom_camp from equipe INNER JOIN campus ON campus.id_camp=equipe.id_camp
-- #3
@PradalCyril
PradalCyril / middleware
Created January 8, 2019 13:49
var express = require('express');
var router = express.Router();
router.use(function (req, res, next) {
console.log('Time:', Date.now());
next();
});
/* GET home page. */
router.get('/', function (req, res, next) {
res.render('index', { title: 'Express' });
@PradalCyril
PradalCyril / 03sql
Created January 8, 2019 12:15
-- MySQL dump 10.13 Distrib 8.0.13, for osx10.14 (x86_64)
--
-- Host: localhost Database: cyril_p_wcs_bruxelles
-- ------------------------------------------------------
-- Server version 8.0.13
/*!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 */;
SET NAMES utf8mb4 ;
@PradalCyril
PradalCyril / express010
Created January 7, 2019 17:34
-- MySQL dump 10.13 Distrib 8.0.13, for osx10.14 (x86_64)
--
-- Host: localhost Database: cyril_p_wcs_bruxelles
-- ------------------------------------------------------
-- Server version 8.0.13
/*!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 */;
SET NAMES utf8mb4 ;
@PradalCyril
PradalCyril / user.js
Created January 7, 2019 15:58
var express = require('express');
var router = express.Router();
/* GET users listing. */
router.get('/', function(req, res, next) {
res.send('Hey ! It\'s a GET');
});
/* GET user with ID. */
router.get('/:id(\\d+)', function(req, res, next) {
@PradalCyril
PradalCyril / index.html
Created December 17, 2018 14:15
<!DOCTYPE html>
<html>
<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 -->
<script src="https://cdnjs.cloudflare.com/ajax/libs/redux/4.0.1/redux.min.js"></script>
@PradalCyril
PradalCyril / Express 5
Created December 10, 2018 15:06
const express = require('express');
const app = express();
const port = 3000;
var cors = require('cors')
const connexion = require('./conf');
const bodyParser = require('body-parser');
// Support JSON-encoded bodies
app.use(bodyParser.json());
// Support URL-encoded bodies
app.use(bodyParser.urlencoded({
@PradalCyril
PradalCyril / serveur http vieux
Created December 10, 2018 14:19
const http = require('http');
const port = 3000;
const requestHandler = (request, response) => {
console.log(request.url);
server
if (request.url == '/') {
response.writeHead(200, { 'Content-type': 'text/htlm' });
response.write('Bienvenue sur votre server!')
response.end();
@PradalCyril
PradalCyril / SQL 4
Created December 10, 2018 14:08
DELETE FROM movie
Where id='5'
DELETE FROM movie
Where id>='10'