ashleawalker29 / ptcg_inventory

http://ptcg-inventory.herokuapp.com/index
1 stars 0 forks source link

Populate DB with all card information. #9

Closed ashleawalker29 closed 4 years ago

ashleawalker29 commented 4 years ago

The database only has information for the sets Shining Legends and Darkness Ablaze. It needs to be populated locally and then pushed to the heroku server.

Verify that it works locally and on heroku by checking the pages based on the set names and information added.

ashleawalker29 commented 4 years ago

All Gen 1 Cards have been populated:

ptcg_inventory=# select distinct set_name from card_inventory_cards;                     
         set_name          
---------------------------
 Team Rocket
 Base Set
 Base Set 2
 Jungle
 Gym Challenge
 Fossil
 Wizards Black Star Promos
 Gym Heroes
 Legendary Collection

This corresponds with the list of Gen 1 card sets.

Screen Shot 2020-09-01 at 7 43 22 PM
ashleawalker29 commented 4 years ago

All Gen 2 cards have been populated:

ptcg_inventory=# select distinct set_name from card_inventory_cards;
        set_name          
---------------------------
 Southern Islands
 Neo Genesis
 Skyridge
 Neo Destiny
 Aquapolis
 Expedition Base Set
 Neo Revelation
 Neo Discovery

This corresponds with the list of Gen 2 card sets.

Screen Shot 2020-09-01 at 8 11 41 PM
ashleawalker29 commented 4 years ago

All Gen 3 cards have been populated:

ptcg_inventory=# select distinct set_name from card_inventory_cards;
          set_name          
----------------------------
 POP Series 4
 EX Team Magma vs Team Aqua
 EX Deoxys
 EX Crystal Guardians
 EX FireRed & LeafGreen
 EX Ruby & Sapphire
 EX Dragon Frontiers
 EX Team Rocket Returns
 EX Dragon
 POP Series 3
 Nintendo Black Star Promos
 EX Delta Species
 POP Series 2
 EX Sandstorm
 EX Unseen Forces
 EX Emerald
 EX Trainer Kit
 EX Trainer Kit 2
 EX Hidden Legends
 EX Holon Phantoms
 EX Legend Maker
 POP Series 5
 EX Power Keepers

This corresponds with the list of Gen 3 card sets.

Screen Shot 2020-09-02 at 10 26 10 AM
ashleawalker29 commented 4 years ago

All Gen 4 cards have been populated:

ptcg_inventory=# select distinct set_name from card_inventory_cards;                         
            set_name              
-----------------------------------
 Legends Awakened
 Majestic Dawn
 Diamond & Pearl
 Secret Wonders
 Platinum
 Diamond & Pearl Black Star Promos
 Great Encounters
 POP Series 6
 Diamond & Pearl Trainer Kit
 Stormfront
 Mysterious Treasures

This corresponds with the list of Gen 4 card sets:

Screen Shot 2020-09-02 at 10 52 45 AM
ashleawalker29 commented 4 years ago

All Gen 5 cards have been populated:

ptcg_inventory-# FROM card_inventory_cards;
             set_name              
-----------------------------------
 Plasma Freeze
 Emerging Powers
 Plasma Blast
 Boundaries Crossed
 Next Destinies
 Black & White Base Set
 Dark Explorers
 Plasma Storm
 Legendary Treasures
 Black & White Promos

This corresponds with the list of Gen 5 card sets (except for the McDonald's Collection 2012 which is not being counted):

Screen Shot 2020-09-02 at 12 25 04 PM
ashleawalker29 commented 4 years ago

All Gen 6 cards have been populated:

ptcg_inventory=# select distinct set_name from card_inventory_cards;
             set_name              
-----------------------------------
 Evolutions
 Kalos Starter Set
 Generations
 BREAKpoint
 Flashfire
 Phantom Forces
 Steam Siege
 Primal Clash
 Fates Collide
 X & Y
 Roaring Skies
 Furious Fists
 X & Y Promos
 Ancient Origins
 BREAKthrough

This corresponds with the list of Gen 6 card sets (except for the McDonald's Collections which are not being counted):

Screen Shot 2020-09-02 at 12 53 31 PM
ashleawalker29 commented 4 years ago

All Gen 7 cards have been populated:

ptcg_inventory=# select distinct set_name from card_inventory_cards;
             set_name              
-----------------------------------
 Sun & Moon Promos
 Sun & Moon
 Guardians Rising
 Burning Shadows
 Shining Legends
 Crimson Invasion
 Ultra Prism
 Forbidden Light
 Celestial Storm
 Dragon Majesty
 Lost Thunder
 Team Up
 Detective Pikachu
 Unbroken Bonds
 Unified Minds
 Hidden Fates
 Cosmic Eclipse

This corresponds with the list of Gen 7 card sets:

Screen Shot 2020-09-02 at 2 49 04 PM
ashleawalker29 commented 4 years ago

All Gen 8 cards (all that have been released as of today) have been populated:

ptcg_inventory=# select distinct set_name from card_inventory_cards;
             set_name              
-----------------------------------
 Sword & Shield Promos
 Sword & Shield
 Rebel Clash
 Darkness Ablaze

This corresponds with the list of Gen 8 card sets:

Screen Shot 2020-09-02 at 3 02 08 PM
ashleawalker29 commented 4 years ago

All cards have been populated.