sele-nap

selena@selena-GL62M-7RDX:~$ ls
Bureau     Downloads  Modèles  Public  Téléchargements
Documents  Images     Musique  snap    Vidéos
selena@selena-GL62M-7RDX:~$ ls .
Bureau     Downloads  Modèles  Public  Téléchargements
Documents  Images     Musique  snap    Vidéos
selena@selena-GL62M-7RDX:~$ ls -a
.              Bureau     .gnupg    Musique   .ssh
..             .cache     Images    .pki      .sudo_as_admin_successful
.bash_history  .config    .local    .profile  Téléchargements

sele-nap

selena@selena-GL62M-7RDX:~/planets$ find
.
./inhabited
./inhabited/earth.jpeg
./inhabited/coruscant.jpeg
./inhabited/arrakis.jpeg
./inhabited/cybertron.jpeg
./real
./real/dwarf-planets
./real/gas-giants

sele-nap

const http = require('http');
const url = require('url')
const port = 8000;
const requestHandler = (request, response) => {
    const parsedUrl = url.parse(request.url, true)
    console.log(request.url);
    if (request.url === '/') {
      response.end('Hello Node.js Server!');
    } else {
        if (parsedUrl.query.name && parsedUrl.query.city) {

sele-nap

const http = require('http');
const url = require('url')
const port = 8000;
const requestHandler = (request, response) => {
    const parsedUrl = url.parse(request.url, true)
    console.log(request.url);
    if (request.url === '/') {
      response.end('Hello Node.js Server!');
    } else {
        if (parsedUrl.query.name && parsedUrl.query.city) {

sele-nap

const connection = require("./db-config");
const express = require("express");
const app = express();

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

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

sele-nap

const connection = require("./db-config");
const express = require("express");
const app = express();

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

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

sele-nap

const connection = require("./db-config");
const express = require("express");
const app = express();

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

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

sele-nap

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

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

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

sele-nap

mysql> SELECT lastname, firstname, role, name 
    -> FROM wizard 
    -> JOIN player ON wizard.id=player.wizard_id
    -> JOIN team ON team.id=player.team_id
    -> ORDER BY name ASC, role ASC, lastname ASC, firstname ASC;
+-----------------+-------------+--------+------------+
| lastname        | firstname   | role   | name       |
+-----------------+-------------+--------+------------+
| Black           | Sirius      | beater | Gryffindor |
| Brown           | Lavender    | beater | Gryffindor |

sele-nap

mysql> select t.name, count(*) as nb_student 
    -> from player p 
    -> join team t on t.id=p.team_id 
    -> group by t.name 
    -> order by nb_student desc;
+------------+------------+
| name       | nb_student |
+------------+------------+
| Gryffindor |         36 |
| Slytherin  |         21 |