Skip to content

Instantly share code, notes, and snippets.

@alyson-b69
alyson-b69 / request.sql
Last active September 21, 2020 14:09
KAAEMLOTT BDD Atelier
# Ecrire les requêtes qui permettent d afficher
# Le prénom, nom et âge des personnages
SELECT firstname, lastname, age FROM person;
+-------------+---------------+-----+
| firstname | lastname | age |
+-------------+---------------+-----+
| Arthur | Pendragon | 35 |
| Guenièvre | NULL | 30 |
@alyson-b69
alyson-b69 / middleware.js
Created September 28, 2020 09:13
middelware quest
const express = require("express");
const app = express();
const port = 3000;
app.get("/supermiddleware", middleware, (req, res) => {
res.send("Hello World !");
});
function middleware(req, res, next) {
console.log("Hello middleware");
@alyson-b69
alyson-b69 / routing.js
Created September 28, 2020 09:55
routing
const express = require("express");
const router = express.Router();
const db = require("../mysql");
router.get("/", (req, res) => {
db.query("SELECT id, email, name FROM user", (err, results) => {
if (err) {
res.status(500).json({
error: err.message,
sql: err.sql,
@alyson-b69
alyson-b69 / database.sql
Created September 29, 2020 10:24
Express blog - Atelier fil route
CREATE TABLE author
(
id INTEGER NOT NULL
AUTO_INCREMENT PRIMARY KEY,
nom VARCHAR
(50) NOT NULL
);
CREATE TABLE `post`
(
import { SimpleEndCustomer, TrackerLogs } from 'redux/types';
import moment from 'moment';
import { colorUsage } from 'stylesheet';
import { InjectedIntl } from 'react-intl';
interface DataItem {
y: number;
x?: any;
z?: any;
label?: string;