- Set up a
SQLitedatabase - Scrape and save data into your database
- Use data to make ruby objects
In this lab you will set up your schema, scrape data, insert it into your db and then build out methods to manipulate your data.
For our purposes the Pokemon class is responsible for saving, adding,
removing, or changing anything about each Pokémon. Your scraper is not
responsible for knowing anything about them.
We have set up your scraper class for you, which you can see in
lib/scraper.rb. We have also created a schema_migration.sql file that will
run the SQL statement to set up your database in db/pokemon.db. Your only
job is to build out the methods to save and find pokemon in the database.
Our Pokemon class can be found in lib/pokemon.rb.
This is where you will build your methods.
Notice that #initialize requires keyword arguments.
When you use sql to insert into a database you write out the values by hand and insert them into the database. However, when you insert your Pokémon into the database you don't want to insert them into the query via string interpolation because of potential dangerous consequences. Instead we need to sanitize the data that goes into the query string you need to execute.
- Fork this repo, and clone your fork.
bundle install(if that doesn't work runbundle update)- Follow the pending RSPEC tests to get your sense of direction.
NOTE: We strongly encourage you to at least attempt the bonus. That being said, if you decide that you'd like to move on without completing the bonus section, simply comment out the bonus tests and re-run the test suite. So long as there are pending tests, Learn will not recognize your code as passing.
Now that we got every pokemon we want to get them ready to fight. (Did you really think you and Arel weren't going to have a battle after capturing every pokemon?) But if they battle we need to keep track of their hp (health power). And the only way to do that is to alter the database. What would be perfect is a sql query that adds an hp column and default value of 60 to every row. That sql command should be put into a migration file in db/.
Once the hp column is set up there should be an instance method called alter_hp that will allow us to change a specific pokemon's health to a new hp. It will need to take a new health power as a parameter.
Follow the pending specs for more information.
View Objectives: on Learn.co and start learning to code for free.