13 -- ActiveRecord -- Jeff Winkler

[palmbeachjeff]

• [x] Update Wiki
• [x] Attach Wiki
• [x] Find method in Ruby for:
  • [x] Select every team from the NFC North
  • [x] Select every team with at least 11 wins
  • [ ] Select every team with at least 8 wins that did not make the playoffs
  • [ ] Rename every team with fewer than 4 wins "Losers"
  • [ ] Select every team that plays in a city of fewer than 5 million people, and the name of the city
  • [ ] Select every AFC team that plays in a city that is shrinking in population
  • [ ] Select every city that has a team
  • [ ] Select every state that has a team
  • [ ] Select every team that plays in California
  • [ ] Find the 3 smallest cities with NFL teams
  • [ ] Find the number of teams in cities of between 1 million and 2 million (as of 2013)
  • [ ] Find the division with the largest average number of wins
  • [ ] List the names of the teams of the AFC in descending order of the size of their cities
  • [ ] Change the name of the 5th largest city in New Jersey to include the phrase "like the inventor"
  • [ ] Remove New Mexico and all its cities from the database with one line in the console. You can edit a line in file in app/models too. More method writing:
    • [ ] Define a method City.fastest_growing that returns the single fastest growing city
    • [ ] Define a method City.shrinking that returns all cities with decreasing population
    • [ ] Define a method Team#division_rivals that returns all other teams in the same (conference and) division
    • [ ] Define a method Team#division_leader? that checks whether a team has more wins than any other team in its (conference and) division
    • [ ] Define a method Team#division_winner? that checks whether a team leads its division and all its division rivals have played 16 games
• [ ] Make sure PR is made to this list

[palmbeachjeff]

Wiki

[palmbeachjeff]

Forgot to push, so here is Rails using Active Record: Team.where(division: 'North', conference:'NFC').map{|team| team.name}

--Select every team from the NFC North

Team.where('wins >= 11').map{|team| team.name}

Select every team with at least 11 wins

Team.where("wins >= 8 AND playoff = 0").map{|team| team.name}

Select every team with at least 8 wins that did not make the playoffs

Team.where('wins <= 5').map{|team| team.name}

Rename every team with fewer than 4 wins "Losers"

LOOK FOR WAY TO .UPDATE_ALL TO CHANGE TO "LOSERS"

Team.joins(:city).where("population_2013 < 5000000").map{|team| team.name + ", " + city.team.name}

--Select every team that plays in a city of fewer than 5 million people,

and the name of the city

Select every AFC team that plays in a city that is shrinking in population

City.joins(:teams).map{|city| city.name}

Select every city that has a team

State.joins(:teams).map{|state| state.name}