Skip to content

Instantly share code, notes, and snippets.

View barthflo's full-sized avatar

barthflo

3 followers · 1 following
View GitHub Profile
@barthflo
barthflo / WCS - SQL 05 - JOINS
Created December 8, 2020 12:09
SELECT w.firstname, w.lastname, p.role, t.name FROM wizard w
LEFT JOIN player p ON p.wizard_id=w.id
LEFT JOIN team t ON p.team_id=t.id
ORDER BY t.name;
+-------------+-----------------+--------+------------+
| firstname | lastname | role | name |
+-------------+-----------------+--------+------------+
| Remus | Lupin | NULL | NULL |
| Horace | Slughorn | NULL | NULL |
| Padma | Patil | NULL | NULL |
@barthflo
barthflo / WCS - Express 4 - DELETE method
Created December 4, 2020 17:22
const connection = require('./config');
const express = require("express");
const port = 3000;
const app = express();
connection.connect(err => {
if(err){
console.log('error connecting: ' + err.stack);
return;
@barthflo
barthflo / WCS - Express 3 - PUT method
Created December 4, 2020 17:11
const connection = require('./config');
const express = require("express");
const port = 3000;
const app = express();
connection.connect(err => {
if(err){
console.log('error connecting: ' + err.stack);
return;
@barthflo
barthflo / WCS - Express 3 - POST data
Created November 29, 2020 15:06
const connection = require('./config');
const express = require("express");
const port = 3000;
const app = express();
connection.connect(err => {
if(err){
console.log('error connecting: ' + err.stack);
return;
@barthflo
barthflo / WCS - Express 2 - Read from the database
Created November 29, 2020 14:35
const connection = require('./config');
const express = require("express");
const port = 3000;
const app = express();
connection.connect(err => {
if(err){
console.log('error connecting: ' + err.stack);
return;
@barthflo
barthflo / WCS - Node.js - Creating an http server
Last active November 28, 2020 12:11
const http = require('http');
const port = 8000;
const url = require('url');
const requestHandler = (request, response) => {
const parsedUrl = url.parse(request.url, true);
if(parsedUrl.query.name && parsedUrl.query.city){
response.end(`Hello, ${parsedUrl.query.name} from ${parsedUrl.query.city}`);
}else{
response.end("Please provide name AND city parameters");
@barthflo
barthflo / WCS - Mysql quest 3
Created November 21, 2020 21:03
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),
('Ilvermorny School of Witchcraft and Wizardry','USA', 300),
('Koldovstoretz', 'Russia', 125),
('Mahoutokoro School of Magic', 'Japan', 800),
('Uagadou School of Magic', 'Uganda', 350);
Query OK, 8 rows affected (0.00 sec)
@barthflo
barthflo / WCS -Mysql quest 2
Created November 21, 2020 20:46
mysql> SELECT * FROM wizard
-> ;
+----+-----------+------------+------------+-------------+-------------------------------------------------------------+-----------+
| id | firstname | lastname | birthday | birth_place | biography | is_muggle |
+----+-----------+------------+------------+-------------+-------------------------------------------------------------+-----------+
| 1 | harry | potter | 1980-07-31 | london | | 0 |
| 2 | hermione | granger | 1979-09-19 | | Friend of Harry Potter | 0 |
| 3 | lily | potter | 1960-01-30 | | mother of Harry Potter | 0 |
| 4 | ron | weasley | 1980-03-01 | | Best friend of Harry | 0 |
| 5 | ginny | weasley | 1981-08-11 |
@barthflo
barthflo / WCS - 09-Bootstrap
Created October 12, 2020 12:41
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css" integrity="sha384-JcKb8q3iqJ61gNV9KGb8thSsNjpSL0n8PARn9HuZOnIxN0hoP+VmmDGMN5t9UJ0Z" crossorigin="anonymous">
<title>Bootstrap Quest</title>
</head>
<body>
@barthflo
barthflo / favourite.movie.js
Created September 28, 2020 13:23
WCS - Basics of JS - Discover the language
const movieName = "The Grand Budapest Hotel";
const movieDirector = "Wes Anderson";
const releaseDate = 2014;
alert(`${movieName} directed by ${movieDirector}, was released in ${releaseDate.toString()}.`);