Skip to content
McMaldoPublic

About

My First API made with Node.js + Express

Resources

Stars

0 stars

Watchers

1 watching

Forks

Latest commit

 

History

1 Commit

Folders and files

NameName
Last commit message
Last commit date
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Listado de ENDPOINTS

1- Conteo de todos los paises disponibles

  • returns {count: int} numero total de todos los paises disponibles;
api.get('/countries', (req, res) => {
    db.query(`SELECT COUNT(*) FROM countries;`, (err,results) => {
        if(err) {
            res.status(500).json({message : err.message});
            return;
        }
        res.json(results);
    });
});

2- Muestra de todos los paises disponibles

  • returns {array} listado de todos los paises ordenados por mayor area con datos como:
    • name
    • area
    • national_day
    • region_name
    • continent_name
api.get('/countries/all', (req, res) => {
    db.query(`SELECT countries.name, countries.area, countries.national_day,
        regions.name AS region, continents.name AS continent FROM countries 
        INNER JOIN regions ON regions.region_id = countries.region_id
        INNER JOIN continents ON continents.continent_id = regions.continent_id
        ORDER BY countries.area DESC;`, (err,results) => {
        if(err) {
            res.status(500).json({message : err.message});
            return;
        }
        res.json(results);
    });
});

3- Busqueda de un Pais

  • param {:name} Nombre del pais a buscar
  • returns {array} detalles del pais como:
    • name
    • area
    • national_day
    • region_name
    • continent_name
api.get('/countries/:name', (req, res) => {
    const {name} = req.params;
    console.log(req);
    db.query(`SELECT countries.name, countries.area, countries.national_day,
        regions.name AS region, continents.name AS continent FROM countries 
        INNER JOIN regions ON regions.region_id = countries.region_id
        INNER JOIN continents ON continents.continent_id = regions.continent_id
        WHERE countries.name = ?`, [name], (err,results) => {
        if(err) {
            res.status(500).json({message : err.message});
            return;
        }
        if(results == ''){
            res.status(500).json({message : "country undefined"});
            return;
        }
        res.json(results);
    });
});

How to Create NodeAPI

1- command

npm init -y
npm install express
npm install --save-dev nodemon

2- add to package.json:

  "scripts": {
    "test": "echo \"Error: no test specified\" && exit 1",
    "start": "node index.js", //add
    "dev": "nodemon index.js" //add
  },

3- command

npm install dotenv
npm install mysql2

4- create .env file

DB_HOST=...
DB_USER=...
DB_PASS=...
DB_NAME=...

5- create index.js

const express = require('express');
const mysql = require('mysql2');
require('dotenv').config();

const api = express();
api.use(express.json());
const db = mysql.createConnection({
    host: process.env.DB_HOST,
    user: process.env.DB_USER,
    password: process.env.DB_PASS,
    database: process.env.DB_NAME
})

db.connect((err) => {
    if(err){
        console.log("connection error", err);
        return;
    }
    console.log('connection okey')
})
const PORT = 3000;
api.listen(PORT, () => console.log(`port: ${PORT}`))

6- add "CORS Unlock" to Chrome Finally- NodeAPI already made

About

My First API made with Node.js + Express

Resources

Stars

0 stars

Watchers

1 watching

Forks

Releases

Packages

Used by

Contributors

Languages