spfohman/phase-3-active-record-theater-work

Practice Code Challenge Theater Work

Learning Goals

• Write Active Record Migrations
• Connect between tables using Active Record Associations
• Write class and instance methods using Active Record
• Use Active Record to query the database

Introduction

The Flatiron Theater Company is holding Auditions!

An actor may only Audition for one Role, while a Role may have many Auditions for it!

Getting started

run bundle install

Migrations

Create your migrations.

• Auditions should have an actor(string), location(string) and belong_to a role(integer)

• Roles should only have a character_name

auditions Table

Column	Type
actor	string
location	string
phone	integer
hired	boolean
role_id	integer

roles Table

Column	Type
character_name	string

Relationship

• What associations will this need?
• (i.e. has_many, has_many through, and belongs_to)

Audition

• Audition#role returns an instance of role associated with this audition
• Audition#call_back will change the the hired attribute to true

Roles

• Role#auditions returns all of the auditions associated with this role
• Role#actors returns an array of names from the actors associated with this role
• Role#locations returns an array of locations from the auditions associated with this role
• Role#lead returns the first instance of the audition that was hired for this role or returns a string 'no actor has been hired for this role'
• Role#understudy returns the second instance of the audition that was hired for this role or returns a string 'no actor has been hired for understudy for this role'