MyPokedex

MyPokedex aim to create a sqlite database of the data of the first generation of pokemon. Data will be estrapolated from the italian wiki pages.

1: Scraping General Data

• Visit Pokedex di Kanto wiki list
• Go to the code for extracting data
• Execute the code in the browser console
• The result is here: pokedex_list.json

2: Get the MN list and related pokemons

• Similar as in the first step this code will get the mn data and related list one at a time
• Go to every MN page and get the json
• Join in one single file and you will obtain this: MN_list.json

3: Populate database

• Create tables
• Get pokemon list from json and insert to database
• Extract all pokemon types and insert into another table
• Get MN list and insert into database
• Insert in another table the association between the pokemon and the MN if he can learn it

This is done in node.js in the file app.js

This is the ER of the database:

RESULT

The generated database is available here: sqliteDatabase