Levelup

🕵️‍♀️ Task

Select the fourth record from the movies table and retrieve the value from the title column.

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

You can access attributes of an ActiveRecord object by using square brackets, [], and the name of the column as a Symbol or String. It’s similar to how you retrieve values from a Hash by using keys.

Data

id	title	year	duration	description	image	director_id

Data

id	name	dob	bio	image

Data

id	name	dob	bio	image

Data

id	actor_id	movie_id	name
657	593	46	Young Woman in Bath
658	594	46	Old Woman in Bath
659	595	46	Bill Watson
660	596	46	Forest Ranger #1
661	597	46	Forest Ranger #2
662	598	46	Grady Daughter
663	599	47	Guido
664	600	47	Dora

Examples

Select the tenth record from customers table and the retrieve the value from the email column

customer = Customer.all[9]
customer["email"]
=> "[email protected]"

Select the third record from Course table and the retrieve the value from the title column

course = Course.all[2]
course[:title]
=> "Application Development"