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
67	Sandro Scarchilli
68	Benito Stefanelli	1928-09-02
69	Angelo Novi	1930-06-09
70	Antonio Casas	1911-11-11	He plays soccer three years...
71	Christian Bale	1974-01-30	Christian Charles Philip Ba...	http://ia.media-imdb.com/im...
72	Heath Ledger	1979-04-04	When a young, hunky 20 year...	http://ia.media-imdb.com/im...
73	Aaron Eckhart	1968-03-12		http://ia.media-imdb.com/im...
74	Michael Caine	1933-03-14	Born Maurice Micklewhite in...	http://ia.media-imdb.com/im...

Data

id	actor_id	movie_id	name
73	68	5	Member of Angel Eyes' Gang
74	69	5	Monk
75	70	5	Stevens
76	71	6	Bruce Wayne
77	72	6	Joker
78	73	6	Harvey Dent
79	74	6	Alfred
80	75	6	Rachel

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"