Skip to content

Instantly share code, notes, and snippets.

View vmalep's full-sized avatar

Pierre van Male vmalep

2 followers · 5 following
  • Belgium
View GitHub Profile
@vmalep
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
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
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
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
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
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
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
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
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
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),