vmalep’s gists

vmalep / index.html

Created December 16, 2021 21:18

Quest 358

	<!DOCTYPE html>
	<html lang="en">
	<head>
	<meta charset="UTF-8" />
	<meta name="viewport" content="width=device-width, initial-scale=1.0" />
	<title>Document</title>
	</head>
	<body>
	<p id="counter-render"></p>
	<button id="button-increment">Increment</button>

vmalep / gist:05fee66e4df2f6192d4f60122524b9f1

Created December 1, 2021 09:52

	const connection = require('./db-config');
	const express = require('express');
	const app = express();
	const Joi = require('joi');

	const port = process.env.PORT \|\| 3000;

	connection.connect((err) => {
	if (err) {
	console.error('error connecting: ' + err.stack);

vmalep / gist:f6455e6f0322097b0148703413b260d7

Created November 30, 2021 12:58

	queries:
	SELECT t.name, COUNT(*) AS nb_player
	FROM player as p
	JOIN team AS t ON p.team_id=t.id
	GROUP by t.id
	ORDER BY nb_player DESC;

	SELECT t.name
	FROM player as p
	JOIN team AS t ON p.team_id=t.id

vmalep / gist:a0cd37f52fbcdbaba22bd2baf9490bdd

Created November 29, 2021 21:39

	Queries:
	SELECT w.lastname, w.firstname, p.role, t.name
	FROM player AS p
	JOIN wizard AS w ON p.wizard_id=w.id
	JOIN team AS t ON p.team_id=t.id
	ORDER BY t.name, p.role, w.lastname, w.firstname;

	SELECT w.lastname, w.firstname
	FROM player AS p
	JOIN wizard AS w ON p.wizard_id=w.id

vmalep / gist:f74b83c95e9f671ccf5332cc23ac6e11

Created November 16, 2021 21:51

	app.post('/api/movies', (req, res) => {
	const { title, director, year, color, duration } = req.body
	connection.promise().query(
	'INSERT INTO movies(title, director, year, color, duration) VALUES (?, ?, ?, ?, ?)',
	[title, director, year, color, duration])
	.then(result => {
	const id = result.insertId
	const createdMovie = { id, title, director, year, color, duration }
	res.status(201).json(createdMovie)
	res.redirect('Movie successfully saved')

vmalep / gist:26760259d88eacc83e90d0682c1c5264

Created November 16, 2021 20:59

	app.get('/api/movies', (req, res) => {
	let sql = 'SELECT * FROM movies'
	if(req.query.color === '1') {
	sql += ' WHERE color = 1'
	}

	if(req.query.max_duration){
	const maxDuration = parseInt(req.query.max_duration)
	sql.includes('WHERE') ? sql += ' AND ' : sql += ' WHERE'
	sql += ` duration <= ${maxDuration}`

vmalep / gist:db22caffd7dab54deed3dfc5fc614b39

Created November 10, 2021 07:32

	app.delete('/api/movies/:id', (req, res) => {
	const movieId = req.params.id;
	connection.promise().query(
	'DELETE FROM movies WHERE id = ?',
	[movieId],)
	.then(result=>res.status(200).send('🎉 Movie deleted!'))
	.catch(err=>{
	console.log(err)
	res.status(500).send('😱 Error deleting an movie')
	})

vmalep / gist:ab3521401cb77f1fccb553e86608857e

Created November 8, 2021 17:27

	app.put('/api/movies/:id', (req, res) => {
	const movieId = req.params.id
	const moviePropsToUpdate = req.body
	connection.promise().query(
	'UPDATE movies SET ? WHERE id = ?',
	[moviePropsToUpdate, movieId],)
	.then(result=>res.status(200).send('Movie updated successfully 🎉'))
	.catch(err=>{
	console.log(err)
	res.status(500).send('Error updating a movie')

vmalep / gist:941173acd3c708caa6184e3872770f91

Created November 8, 2021 14:28

	app.post('/api/users', (req, res) => {
	const { firstname, lastname, email } = req.body
	connection.promise().query(
	'INSERT INTO users(firstname, lastname, email) VALUES (?, ?, ?)',
	[firstname, lastname, email],)
	.then(result=>res.status(201).send('User successfully saved')
	.catch(err=>res.status(500).send('Error saving the user'))
	)
	})

vmalep / gist:25cf3aebc9e7e2c6fd351bf0aed0a69a

Created November 8, 2021 08:24

Quest 485 - Pierre van Male

	mysql> USE wild_db_quest;
	Reading table information for completion of table and column names
	You can turn off this feature to get a quicker startup with -A

	Database changed
	mysql> INSERT INTO school (name, country, capacity)
	-> VALUES ('Beauxbatons Academy of Magic', 'France', 550),
	-> ('Castelobruxo', 'Brazil', 380),
	-> ('Durmstrang Institute', 'Norway', 570),
	-> ('Hogwarts School of Witchcraft and Wizardry', 'United Kingdom', 450),

Pierre van Male vmalep