carlosaore

const express = require("express");
const movies = require("./movies");
const connection = require("./config");

const port = 3000;
const app = express();

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

carlosaore

const express = require("express");
const movies = require("./movies");
const connection = require("./config");

const port = 3000;
const app = express();

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

carlosaore

// The firstname, lastname and age from the Person

SELECT firstname, lastname, age FROM sqladvanced.person;

+-------------+---------------+-----+
| firstname   | lastname      | age |
+-------------+---------------+-----+
| Arthur      | Pendragon     |  35 |
| Guenièvre   | NULL          |  30 |
| Merlin      | NULL          | 850 |

carlosaore

const express = require("express");
const movies = require("./movies");
const connection = require("./config");

const port = 3000;
const app = express();

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

carlosaore

const http = require('http');
const url = require('url');
const port = 8000;

const requestHandler = (request, response) => {
    console.log(request.url);
    const person = url.parse(request.url, true).query;
    if (person.name && person.city) {
        response.end(`hello ${person.name} from ${person.city}`);
    } else {

carlosaore

SELECT `firstname`, `lastname`, `role`, `name` AS `team_name` FROM wild_db_quest.player
  JOIN wild_db_quest.wizard ON wizard.id=player.wizard_id
  JOIN wild_db_quest.team ON player.team_id=team.id
  ORDER BY `team_name`;
  
SELECT `firstname`, `lastname`, `role`, `name` AS `team_name` FROM wild_db_quest.player
  JOIN wild_db_quest.wizard ON wizard.id=player.wizard_id
  JOIN wild_db_quest.team ON player.team_id=team.id
  ORDER BY `role`;
  

carlosaore

Carlos@DESKTOP-IO6SQE6 MINGW64 ~/Documents/WCS/planets
$ find
.
./fictional
./fictional/arrakis.jpeg
./fictional/coruscant.jpeg
./fictional/cybertron.jpeg
./inhabited
./inhabited/arrakis.jpeg
./inhabited/coruscant.jpeg

carlosaore

Carlos@DESKTOP-IO6SQE6 MINGW64 ~/Documents
$ cd WCS

Carlos@DESKTOP-IO6SQE6 MINGW64 ~/Documents/WCS
$ pwd
/c/Users/Carlos/Documents/WCS

Carlos@DESKTOP-IO6SQE6 MINGW64 ~/Documents/WCS
$ ls
hello-world/  log.txt  wild-git/