ActiveRecord CRUD

It give viewers a simple concept to make CRUD using Ruby

SWBATs

• Get comfortable with checking rake -T
• Practice setting up a table and a model
• Practice CRUD in ActiveRecord
• Understand the use case for global variables in Ruby
• Use the colorize gem to make the console outputs pretty

Outline

Welcome to the ActiveRecord obstacle run! Before you begin:

1. cd to starter_kit
2. run bundle
3. run rake db:migrate
4. run rake -T

After the last command, you will notice a remind_me_about: rake task. This is a carefully created process reminder for the key deliverables for this lecture. Even if you feel confident with AR, please check the instructions every time.

You will be working in groups. Good news is that if your database setup looks the same, you can just send schema.rb and development.sqlite files after each person drives to hand over the database to the next person.

Hint: For this lab, it is best that you have two terminals open: one in your VS Code and another on a split screen. Run the remind_me_about commands on the split screen and follow them in the VS Code.

Roadmap

The goal of this obstacle course is for you to practice CRUD and to end with two models (and tables) in your project: Plant and Person. You have been already given a ready Plant class and corresponding table. In the database, there are already a few instances of Plant class.

1. Run rake remind_me_about:adding_table and follow the instructions to create a Person table with name attribute (string)
2. Run rake remind_me_about:adding_column and follow the instructions to add likes_plants? attribute (boolean) NOTE: Hopefully, this will result in an error please read it and debug it together (it's a gotcha and that's fine!)
3. Run rake remind_me_about:rolling_back and follow the instructions to roll back just last migration because of course everyone loves plants!
4. Run rake remind_me_about:adding_column and follow the instructions to add free_time attribute (string), which will tell us when the person is free to water the plants and age (integer) hint you can do that in one file!

HEADS UP: for all the next steps you can stay in the same rake console session!

5. Run rake remind_me_about:creating_an_instance and follow the instructions to create 3 instances of Person class and save them to the database
6. Run rake remind_me_about:reading_instances and follow the instructions to read more about each Person
7. Oho! One of the folks just had birthday! Run rake remind_me_about:updating_an_instance and follow the instructions to change their age
8. In the quarantine time, everyone is free to water the plants all day. Run rake remind_me_about:updating_all_instances and follow the instructions to change everyone's free time
9. Oops, it turns out you need to water cacti 0.0 Find a plant with the "cactus" name and delete it from the database. Run rake remind_me_about:deleting_an_instance and follow the instructions.
10. If everyone is watering the plants, it's a recipe for a disaster. All plants died. Run rake remind_me_about:deleting_all_instances and follow the instructions to bid the last goodbye to all the green friends.