Levelup

🕵️‍♀️ Task

Select the director record with the id 3.

movies

id (integer)
title (string)
year (integer)
duration (integer)
description (text)
image (string)
director_id (integer)

directors

id (integer)
name (string)
dob (date)
bio (text)
image (string)

actors

id (integer)
name (string)
dob (date)
bio (text)
image (string)

characters

id (integer)
actor_id (integer)
movie_id (integer)
name (string)

📖Method

The find method searches for a row/record by it’s primary key (conventionally named id). The find method requires an argument that will be used to look up the object from the table.

Data

id	title	year	duration	description	image	director_id

Data

id	name	dob	bio	image

Data

id	name	dob	bio	image
75	Maggie Gyllenhaal	1977-11-16	Academy Award-nominated act...	http://ia.media-imdb.com/im...
76	Gary Oldman	1958-03-21	Gary Oldman, the son of a w...	http://ia.media-imdb.com/im...
92	Henry Fonda	1905-05-16	Born in Grand Island, Nebra...	http://ia.media-imdb.com/im...
93	Joseph Sweeney	1882-07-26
94	Ed Begley	1901-03-25	Charismatic character star ...	http://ia.media-imdb.com/im...
77	Monique Gabriela Curnen	1977-09-07	Monique Gabriela Curnen is ...	http://ia.media-imdb.com/im...
78	Ron Dean		Ron Dean is a character act...	http://ia.media-imdb.com/im...
79	Cillian Murphy	1976-05-25	Striking Irish actor Cillia...	http://ia.media-imdb.com/im...

Data

id	actor_id	movie_id	name
81	76	6	Gordon
82	2	6	Lucius Fox
83	77	6	Ramirez
84	78	6	Wuertz
85	79	6	Scarecrow
86	80	6	Lau
87	81	6	Mayor
88	82	6	Maroni

Examples

Find the customer with the primary key 10.

customer = Customer.find(10)
=> #<Customer id: 10, first_name: "Ryan"

Find the store with the primary key 56.

store = Store.find(56)
=> #<Store id: 56, name: "JC Penny's"