Why query interface abstracts SQL in Ruby on Rails - See It in Action

Why Query Interface Abstracts SQL in Rails

📖 Scenario: You are building a simple Rails app to manage books in a library. You want to fetch books based on their publication year without writing raw SQL queries.

🎯 Goal: Learn how Rails query interface abstracts SQL by using ActiveRecord methods to fetch data.

📋 What You'll Learn

Create a Book model with sample data

Add a variable to set a publication year threshold

Use ActiveRecord query methods to get books published after the threshold year

Display the filtered books using Rails conventions

💡 Why This Matters

🌍 Real World

In real Rails apps, developers use ActiveRecord queries to get data without writing SQL, making apps safer and easier to maintain.

💼 Career

Understanding how Rails abstracts SQL is essential for backend developers working with databases in Rails projects.

1

DATA SETUP: Create the Book model with sample data

Create a Book model with these exact entries: title: 'Ruby Basics', year: 2015, title: 'Rails Advanced', year: 2018, title: 'JavaScript Essentials', year: 2012.

Ruby on Rails

# Create Book records with exact titles and years
# Your code here

Need a hint?

Use Book.create with title and year keys for each book.

2

CONFIGURATION: Add a publication year threshold variable

Add a variable called year_threshold and set it to 2014.

Ruby on Rails

Book.create(title: 'Ruby Basics', year: 2015)
Book.create(title: 'Rails Advanced', year: 2018)
Book.create(title: 'JavaScript Essentials', year: 2012)

# Set the year threshold
# Your code here

Need a hint?

Just create a variable year_threshold and assign 2014.

3

CORE LOGIC: Use ActiveRecord query to get books published after the threshold

Use Book.where('year > ?', year_threshold) and assign the result to a variable called recent_books.

Ruby on Rails

Book.create(title: 'Ruby Basics', year: 2015)
Book.create(title: 'Rails Advanced', year: 2018)
Book.create(title: 'JavaScript Essentials', year: 2012)

year_threshold = 2014

# Query books published after year_threshold
# Your code here

Need a hint?

Use Book.where with a SQL condition string and year_threshold as parameter.

4

COMPLETION: Display the filtered books using Rails conventions

Use recent_books.each do |book| and inside the block, access book.title and book.year to display each book.

Ruby on Rails

Book.create(title: 'Ruby Basics', year: 2015)
Book.create(title: 'Rails Advanced', year: 2018)
Book.create(title: 'JavaScript Essentials', year: 2012)

year_threshold = 2014

recent_books = Book.where('year > ?', year_threshold)

# Loop through recent_books and display title and year
# Your code here

Need a hint?

Use each do |book| to loop and access book.title and book.year.