Skip to content

Instantly share code, notes, and snippets.

View juliaheller's full-sized avatar
🐜
learning, working, learning, working...

Julia Jimenez Blasco juliaheller

🐜
learning, working, learning, working...
1 follower · 5 following
  • Berlin
  • 06:18 (UTC -12:00)
View GitHub Profile
@juliaheller
juliaheller / Express 5 - DELETE method and data deletion
Created March 15, 2020 20:05
const express = require("express");
const app = express();
const port = 3008;
const connection = require("./conf");
const bodyParser = require("body-parser");
// Support JSON-encoded bodies
app.use(bodyParser.json());
// Support URL-encoded bodies
app.use(
bodyParser.urlencoded({
@juliaheller
juliaheller / Express 4 - PUT method and data modification
Created March 15, 2020 19:55
const express = require("express");
const app = express();
const port = 3008;
const connection = require("./conf");
const bodyParser = require("body-parser");
// Support JSON-encoded bodies
app.use(bodyParser.json());
// Support URL-encoded bodies
app.use(
bodyParser.urlencoded({
@juliaheller
juliaheller / Express 3 - POST method and inserting data
Created March 15, 2020 19:04
const express = require("express");
const app = express();
const port = 3008;
const connection = require("./conf");
const bodyParser = require("body-parser");
app.use(bodyParser.json());
app.use(
bodyParser.urlencoded({
@juliaheller
juliaheller / Express2
Created March 15, 2020 17:53
const express = require("express");
const app = express();
const port = 3008;
const connection = require("./conf");
app.get("/", (request, response) => {
response.send("You are on the Homepage");
});
app.get("/api/movies", (request, response) => {
@juliaheller
juliaheller / gist:977dbf3690b7aa5a5bb990b8731cb8ea
Last active March 14, 2020 21:00
Express 1 - Discover Express
const express = require("express");
const app = express();
const port = 3008;
app.get("/", (request, response) => {
response.send("You are on the Homepage");
});
app.get("/api/movies", (request, response) => {
response.send("All films");
@juliaheller
juliaheller / Discover NodeJS
Created March 13, 2020 20:14
const readline = require("readline");
const rl = readline.createInterface({
input: process.stdin,
output: process.stdout
});
rl.question("How old are you? ", function(age) {
calculateYear(parseInt(age));
process.exit(0);
});
@juliaheller
juliaheller / 03 - Data handling
Created March 10, 2020 12:54
mysql> insert into school(name, country, capacity) values (Beauxbatons Academy of Magic, France, 550), (Castelobruxo, Brasil, 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);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Academy of Magic, France, 550), (Castelobruxo, Brasil, 380), (Durmstrang Institu' at line 1
mysql> insert into school(name, country, capacity) values ('Beauxbatons Academy of Magic', 'France', 550), ('Castelobruxo', 'Brasil', 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 o
@juliaheller
juliaheller / 02 - Retrieving information with SELECT
Created March 10, 2020 11:52
mysql> select * from wizard where birthday between '1975-01-01' and '1985-01-01';
+----+-----------+----------+------------+-------------+---------------------------------------+-----------+
| 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 |
| 4 | ron | weasley | 1980-03-01 | | Best friend of Harry | 0 |
| 5 | ginny | weasley | 1981-08-11 | | Sister of Ron and girlfriend of Harry | 0 |
| 6 | fred | weasley | 1978-04-01 | | | 0 |
| 7 | george | weasley | 1978-04-01 | |
@juliaheller
juliaheller / Sprint launch
Last active February 7, 2020 11:34
Sprint launch Quest
Backlog und Burndown Chart
@juliaheller
juliaheller / !Mocha
Created January 31, 2020 08:20 — forked from joma74/!Mocha
Install mocha locally
All about mocha