ReezeMoodaley/pokeGraph
Folders and files
| Name | Name | Last commit date | ||
|---|---|---|---|---|
Repository files navigation
GraphQL PokeAPI for the Pokedex passion project I'm working on.
**DEVELOPMENT START UP COMMAND**
npm start
**ENTRY POINT**
The API code is run from within the **bin/www file**.
**FILE BREAKDOWNS:**
createPool.js: This file is responsible for the creation of the pool object, the pool object is a collection of reusable DB connections, this allows us to work around the performance overhead of constantly creating and destroying db connection objects
dbQuery.js: This file is responsible for taking in the structured DbQuery, its parameters and then executing them against the database.
insertPokemonDB.js: This file is responsible for the construction of the bulk insert query that will seed the database and the seeding of the database, it contains 2 methods, **buildBulkInsertQuery** && **seedDB**:
buildBulkInsertQuery: this method takes in the data extracted from the pokemonCSV, removes and hidden characters, normalizes it and then constructs a query that will insert the data into the DB
seedb: this method takes the previously constructed query and executes it against the DB.
tableCreation.js: This file creates the pokemon table in our postgressql db.