Levelup

🕵️‍♀️ Task

Select the first record from the movies table.

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

When called on an ActiveRecord::Relation, .first returns the first record from the collection. If the collection is empty, .first returns nil.

You can optionally pass an Integer argument to .first. This will return n number of records from the ActiveRecord::Relation. If the collection is empty when you pass an argument, .first returns an empty Array.

Similar methods exist for second, third, fourth, fifth, forty_two, last, second_to_last, and third_to_last.

Data

id	title	year	duration	description	image	director_id
33	American History X	1998	119	A former neo-nazi skinhead ...	http://ia.media-imdb.com/im...	25
34	Apocalypse Now	1979	153	During the U.S.-Viet Nam Wa...	http://ia.media-imdb.com/im...	2
35	Terminator 2: Judgment Day	1991	137	The cyborg who once tried t...	http://ia.media-imdb.com/im...	26
36	Memento	2000	113	A man, suffering from short...	http://ia.media-imdb.com/im...	5
37	Saving Private Ryan	1998	169	Following the Normandy Land...	http://ia.media-imdb.com/im...	7
38	City Lights	1931	87	The Tramp struggles to help...	http://ia.media-imdb.com/im...	27
39	Dr. Strangelove or: How I L...	1964	95	An insane general starts a ...	http://ia.media-imdb.com/im...	28
40	Alien	1979	117	After investigating an S.O....	http://ia.media-imdb.com/im...	29

Data

id	name	dob	bio	image
33	Roman Polanski	1933-08-18	Roman Polanski is a Polish ...	http://ia.media-imdb.com/im...
34	Fritz Lang	1890-12-05	Fritz Lang was born in Vien...	http://ia.media-imdb.com/im...

Data

id	name	dob	bio	image
33	Michael V. Gazzo	1923-04-05	Michael Vincente Gazzo was ...	http://ia.media-imdb.com/im...
34	G.D. Spradlin	1920-08-31	G.D. Spradlin started his c...	http://ia.media-imdb.com/im...
35	Richard Bright	1937-06-28	Fair complexioned, cold-eye...
36	Gastone Moschin	1929-06-08
37	Tom Rosqui	1928-06-12	American character actor wi...
38	Bruno Kirby	1949-04-28	Native New Yorker and Itali...	http://ia.media-imdb.com/im...
39	Frank Sivero	1952-01-06		http://ia.media-imdb.com/im...
40	Francesca De Sapio		Born in Rome, Italy. After ...

Data

id	actor_id	movie_id	name
33	25	3	Kay
34	31	3	Vito Corleone (as Robert De...
35	29	3	Fredo Corleone
36	27	3	Connie Corleone
37	32	3	Hyman Roth
38	33	3	Frankie Pentangeli
39	34	3	Senator Pat Geary
40	35	3	Al Neri

Examples

Select the first customer from the list of customer records.

customer = Customer.all.first
=> #<Customer id: 1, first_name: "Sierra">

Select the first store from the list of store records.

store = Store.all.first
=> #<Store id: 3, name: "H&M">