Week 08 - Day 1 - Safari Adventure

[mdewey]

ORM Safari!

We are taking a surprise trip to the Savannah for a safari to see all sorts of exotic animals. During our time their we want to keep track of all the animals we have seen. For this, we need to create a database, as well as a small console application to help record what we see.

Objectives

• Use an ORM to query against a database

Requirements

Additional Reading

NOTE: The Additional Resources section below is very helpful. Consider reading this after reading Explorer mode. Then make a plan for the assignment for digging in and writing code.

Explorer Mode (C#)

• [ ] Create a database called SafariVacation
  • [ ] This will have 1 table called SeenAnimals that has the following columns
  • Id / id (int)
  • Species / species (string)
  • CountOfTimesSeen / count_of_times_seen (int)
  • LocationOfLastSeen / location_of_last_seen (string)
  • NOTE: This should be made all in the code (C#/Ruby), and not created in the pgcli.
• [ ] Create a small console application, and create the following queries using your languages ORM.
  • [ ] Display all animals the user has seen
  • [ ] Update the CountOfTimesSeen and LocationOfLastSeen for an animal
  • [ ] Display all animals seen in the Jungle
  • [ ] Remove all animals that I have seen in the Desert.
  • [ ] Add all the CountOfTimesSeen and get a total number of animals seen
  • [ ] Get the CountOfTimesSeen of lions, tigers and bears

Explorer Mode (Ruby)

• [x] Create a database called safari_vacation
  • [x] This will have 1 table called animals that has the following columns
  • id (serial primary key)
  • species (string)
  • seen_count (int)
  • last_seen_location (string)
  • NOTE: This should be made all in the code (Ruby), and not created in the pgcli.
• [x] Use pgcli to create your animals table and insert a few species of your own.
• [x] Create a ruby file called 'safari.rb' Your application should prompt the user with a menu with the following options and corresponding actions
  • [x] Type display_all to show all the animals.
  • [x] Type 'incrementto then prompt the user for a species. Add1to theseen_count` for that species and display the new count.
  • [x] Type species to prompt for a specific species and show the details for just that species.
  • [x] Type 'spot' to prompt the user for a species and a location. Update that species last_seen_location
  • [x] Type 'extinct' to prompt the user for a location and delete all the species in that location
  • [x] Type 'totalto get the totalseen_count` of all animals

Adventure Mode (C#)

• [ ] Add a new column called LastSeenTime, with a type of DateTime. This will require you to add and run a new migration.

Adventure Mode (Ruby)

• [ ] Add a new column called last_seen_at, with a type of DateTime.
• [ ] Update the spot and increment menu options to record the current time as last_seen_at

Epic Mode

• [ ] Continue to make progress on your capstone project.

Additional Resources

Ruby

• Active Record Basics
  • Sections 1, 2, 3, 5
• Active Record Querying
  • Sections 1, 2, 3, 4, 5

.NET

Here are the interesting commands you will need for tonight's assignment

• To add Entity Framework to your project:

 dotnet add package Microsoft.EntityFrameworkCore.Design --version 2.1.3

 dotnet add package Npgsql.EntityFrameworkCore.PostgreSQL --version 2.1.2

• To create your database:

createdb <<DatabaseName>>

• To create the DbContext

dotnet ef dbcontext scaffold "server=localhost;database=<<DatabaseName>>" Npgsql.EntityFrameworkCore.PostgreSQL -c <<DatabaseName>>Context

• Add a migration:

 dotnet ef migrations add AddBaordGameTable

• Update your database

dotnet ef database update

• Documentation: Dotnet EF CLI Docs

[GarrettAnderson]

https://github.com/GarrettAnderson/Safari_Vacation

[gstark]

You did more here than required, which is awesome! However, some of the code needs to be adjusted. Come see me and we can clean it up and close the homework.