cleroy117’s gists

cleroy117 / challenge.js

Last active April 22, 2021 16:08

	import React from "react";
	import ReactDOM from "react-dom";
	import App from "./App";
	import reportWebVitals from "./reportWebVitals";

	import {
	ApolloClient,
	InMemoryCache,
	gql,
	ApolloProvider,

cleroy117 / chalenge.ts

Last active April 19, 2021 08:42

	interface myUser {
	name: string;
	age?: number;
	birthday?: string;
	}


	const prettyPrintWilder = (users : myUser[]) => {
	console.log("########################");
	users.map((el : myUser) => {

cleroy117 / app.js

Created January 20, 2021 10:59 — forked from fidelisrafael/app.js

Easy way to export data to XLS format using Node.js

	// clone this gist to a empty folder, the run:
	// npm init (and follow steps)
	// npm install express --save
	// npm install swig --save
	// node app.js and open http://localhost:3000

	function App() {

	var express = require('express');

cleroy117 / middleware.js

Last active December 7, 2020 10:43

	const express = require("express");
	const router = express.Router();


	router.get(
	"/superMiddleware",
	function (req, res, next) {
	s;
	console.log("hello middleware");
	next();

cleroy117 / gist:eea8663566c68448faeae8e83e835bf4

Last active December 2, 2020 07:45

	const express = require("express");
	const connection = require("./config");
	const app = express();

	const port = 3050;

	app.listen(port, (err) => {
	if (err) {
	throw new Error("Something bad happen");
	}

cleroy117 / gist:fdf124b8d75628610c04643288261e52

Last active November 30, 2020 11:18

	mysql> SELECT w.lastname, w.firstname, p.role, t.name
	FROM wizard w
	JOIN player p ON w.id=p.wizard_id
	JOIN team t ON t.id=p.team_id
	ORDER BY t.name, p.role, w.lastname, w.firstname;
	+-----------------+-------------+--------+------------+
	\| lastname \| firstname \| role \| name \|
	+-----------------+-------------+--------+------------+
	\| Black \| Sirius \| beater \| Gryffindor \|
	\| Brown \| Lavender \| beater \| Gryffindor \|

cleroy117 / gist:ce4df6c5d7137fb5fba9373e6e66128b

Created November 28, 2020 16:43

	const connection = require("./config");
	const express = require("express");
	const port = 6667;
	const app = express();
	app.use(express.json());

	connection.then((connection) => {
	console.log(`connected on database as id ${connection.threadId}`);

	app.get("/", (req, res) => {

cleroy117 / gist:c288c6aa5e1bf4d4adfc3a22a41d4f31

Last active November 28, 2020 09:40

	const connection = require("./config");
	const express = require("express");
	const port = 6667;
	const app = express();
	app.use(express.json());

	connection.then((connection) => {
	app.get("/", (req, res) => {
	res.send("Welcome to my favorite movie lists !!!");
	connection

cleroy117 / gist:572a037b9dfdaf38c17b1eb236669b52

Created November 26, 2020 20:31

	/*connection.query ne fonctionne pas :/
	Vu avec Pierre : j'utilise du coup connection.execute.then
	Avec cette méthode,
	je ne traite pas les cas où l'on a une erreur et
	on retourne un status(400).send('erreur')
	Bisou
	----------------------------------------------------------------
	*/

	const connection = require("./config");

cleroy117 / gist:3e61925cdeeeb0070ab2930ff13bfcdd

Created November 25, 2020 19:17

	const connection = require("./config");
	const express = require("express");
	const port = 3005;
	const app = express();

	connection.then((connection) => {
	app.get("/", (req, res) => {
	res.send("Welcome to my favorite movie lists !!!");
	connection
	.execute("SELECT * FROM movies")