Skip to content

Instantly share code, notes, and snippets.

View clrko's full-sized avatar
🤓

Claire Lenfant-Kodia clrko

🤓
11 followers · 4 following
View GitHub Profile
@clrko
clrko / challenge.ts
Last active November 9, 2020 09:51
challenge Dcouverte TypeScripte
const prettyPrintWilder = (users: { name: string; age?: number ; birthday?: string}[]) => {
console.log("########################");
users.map((el) => {
console.log(`${el.name} is ${el.age} years old`);
});
console.log("########################");
};
// # autre synthaxe
// interface User {
@clrko
clrko / index.js
Created June 5, 2020 16:28
Quest8_node_express_delete
const express = require('express');
const connection = require('./conf');
const app = express();
const port = 8000;
app.use(express.json());
app.use(express.urlencoded({
extended: true
}));
@clrko
clrko / Quest7_node_express_put
Last active June 5, 2020 16:30
index.js
const express = require('express');
const connection = require('./conf');
const app = express();
const port = 8000;
app.use(express.json());
app.use(express.urlencoded({
extended: true
}));
@clrko
clrko / index.js
Last active June 5, 2020 16:35
Quest6_node_express_post
const express = require('express');
const connection = require('./conf');
const app = express();
const port = 8000;
app.use(express.json());
app.use(express.urlencoded({
extended: true
}));
@clrko
clrko / wild_db_quest2.sql
Created June 4, 2020 09:00
Quest6_database_mysql
SELECT name, COUNT(*)
FROM player
JOIN team
ON player.team_id = team.id
GROUP BY name
ORDER BY COUNT(*) DESC;
SELECT name, COUNT(*)
FROM team
JOIN player
@clrko
clrko / wild_db_quest.sql
Created June 3, 2020 19:42
Quest5_database_mysql
SELECT lastname, firstname, role, name
FROM wizard
INNER JOIN player
ON wizard.id = player.wizard_id
INNER JOIN team
ON player.team_id = team.id
ORDER BY name, role, lastname, firstname ASC;
SELECT firstname, lastname
@clrko
clrko / index.js
Created June 1, 2020 13:44
Quest5_node_express_bdd
const express = require('express');
const connection = require('./conf');
const app = express();
const port = 3000;
// écoute de l'url "/api/employees"
app.get('/api/employees', (req, res) => {
// connection à la base de données, et sélection des employés
connection.query('SELECT * from employee', (err, results) => {
if (err) {
@clrko
clrko / index.js
Created June 1, 2020 12:45
Quest4_node_express_routes
const express = require('express');
const app = express();
const port = 3000;
app.get('/', (request, response) => {
response.send('Bienvenue sur Express');
});
app.get('/api/movies', (request, response) => {
response.send('Récupération de tous les films');
@clrko
clrko / server.js
Created June 1, 2020 12:16
Quest3_node_server
const http = require('http');
const url = require('url');
const port = 8000;
const requestHandler = (request, response) => {
const requestedUrl = request.url
const parsedUrl = url.parse(requestedUrl, true);
const name = parsedUrl.query.name
const city = parsedUrl.query.city
@clrko
clrko / requests.http
Created June 1, 2020 08:51
Quest_2_requests
### GET application status
GET https://http-practice.herokuapp.com/status
### GET application status (format JSON)
GET https://http-practice.herokuapp.com/status
Accept: application/json
### GET fictional wilders (format JSON for PHP 2nd page)
GET https://http-practice.herokuapp.com/wilders?language=PHP&page=2
Accept: application/json