Where conditions in Ruby on Rails - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the where method do in Rails ActiveRecord?

The where method filters database records based on given conditions and returns matching records as an ActiveRecord relation.

beginner

How do you write a where condition to find users with age 30?

You write: User.where(age: 30). This finds all users whose age is exactly 30.

intermediate

Can you use multiple conditions in a single where call? How?

Yes. Pass a hash with multiple keys: User.where(age: 30, active: true) finds users aged 30 who are active.

intermediate

How do you use SQL fragments in where for more complex queries?

You can pass a string with placeholders: User.where("age > ?", 25) finds users older than 25.

intermediate

What is the benefit of chaining multiple where calls?

Chaining where calls combines conditions with AND, making queries easier to read and build step-by-step.

What does User.where(active: true) return?

A All users who are active

B All users who are inactive

C All users regardless of status

D An error

The where method filters users with active set to true.

How do you find users with age greater than 20 using where?

A User.where(age.gt(20))

B User.where(age: '> 20')

C User.where(age > 20)

D User.where('age > ?', 20)

Use a SQL fragment with placeholder: User.where('age > ?', 20).

What happens if you chain where calls like User.where(active: true).where(age: 30)?

A Returns users active only

B Returns users active or age 30

C Returns users active and age 30

D Throws an error

Chained where calls combine conditions with AND.

Which of these is a valid way to use where with multiple conditions?

A All of the above

B User.where('age = 25 AND active = true')

C User.where(['age = ? AND active = ?', 25, true])

D User.where(age: 25, active: true)

All shown ways are valid to specify multiple conditions.

What type of object does where return?

A Array of records

B ActiveRecord::Relation

C Hash

D String

where returns an ActiveRecord Relation, which can be further chained.

Explain how to use the where method in Rails to filter records with multiple conditions.

Think about combining conditions with AND and using hashes or SQL strings.

Describe the difference between passing a hash and a SQL string to the where method.

Consider when you need more than just equals comparisons.

Practice

1. What does the where method do in Rails ActiveRecord?

easy

A. Creates a new database table

B. Deletes records from the database

C. Updates all records without conditions

D. Filters records based on given conditions

Solution

1. Step 1: Understand the purpose of where

   The where method is used to specify conditions to filter records in a database query.

2. Step 2: Compare with other database actions

   Deleting, creating tables, or updating all records are different methods like delete, migrations, or update_all.

3. Final Answer:

   Filters records based on given conditions -> Option D

4. Quick Check:

   where filters records = C [OK]

Hint: Remember: where narrows down records by conditions [OK]

Common Mistakes:

• Confusing where with delete or update methods
• Thinking where creates or deletes tables
• Assuming where modifies all records without conditions

2. Which of the following is the correct syntax to find users with age 30 using where?

easy

A. User.where('age == ?', 30)

B. User.where(age: 30)

C. User.where(age == 30)

D. User.where(age = 30)

Solution

1. Step 1: Identify correct hash syntax for where

   Using a hash like age: 30 is the standard way to filter by attribute value.

2. Step 2: Check other options for syntax errors

   User.where('age == ?', 30) uses invalid SQL operator ==; User.where(age == 30) uses invalid Ruby comparison inside where; User.where(age = 30) uses assignment instead of comparison.

3. Final Answer:

   User.where(age: 30) -> Option B

4. Quick Check:

   Hash syntax for where = A [OK]

Hint: Use hash syntax for simple where conditions [OK]

Common Mistakes:

• Using == inside where instead of hash or string
• Using = instead of : or ? for conditions
• Confusing string and hash syntax

3. What will this code return?

User.where("name LIKE ?", "%John%")

medium

A. All users with name containing 'John'

B. All users with name exactly 'John'

C. Syntax error due to quotes

D. No users because LIKE is invalid

Solution

1. Step 1: Understand the SQL LIKE operator

   LIKE with % means match any characters before or after 'John', so it finds names containing 'John'.

2. Step 2: Check the where syntax

   The string with placeholder and argument is correct syntax for complex conditions.

3. Final Answer:

   All users with name containing 'John' -> Option A

4. Quick Check:

   LIKE with % means contains = A [OK]

Hint: LIKE with % means contains substring [OK]

Common Mistakes:

• Thinking LIKE matches exact string only
• Confusing syntax with invalid quotes
• Assuming LIKE is not supported in where

4. Identify the error in this code:

User.where(age > 25)

medium

A. Incorrect use of > inside where without string

B. Should use User.find instead of where

C. No error, code works fine

D. Missing quotes around condition string

Solution

1. Step 1: Check syntax of where conditions

   Conditions with operators like > must be inside a string or hash syntax; direct Ruby expressions are invalid.

2. Step 2: Identify correct usage

   Correct usage is User.where("age > ?", 25) or User.where("age > 25").

3. Final Answer:

   Incorrect use of > inside where without string -> Option A

4. Quick Check:

   Operators need string syntax in where = D [OK]

Hint: Use strings for operators like > in where [OK]

Common Mistakes:

• Writing Ruby expressions directly inside where
• Forgetting to quote conditions with operators
• Using find instead of where for filtering

5. How can you chain multiple where conditions to find users who are active and older than 18?

hard

A. User.where(active: true, age > ?, 18)

B. User.where('active = true AND age > ?')

C. User.where(active: true).where('age > ?', 18)

D. User.where(active == true).where(age > 18)

Solution

1. Step 1: Understand chaining of where

   Multiple where calls can be chained to combine conditions, each filtering further.

2. Step 2: Check syntax of each where call

   First where uses hash for simple boolean, second uses string with placeholder for age condition.

3. Step 3: Evaluate other options

   User.where(active: true, age > ?, 18) uses invalid Ruby expression without quotes; User.where('active = true AND age > ?') uses placeholder without bind argument; User.where(active == true).where(age > 18) uses invalid Ruby expressions.

4. Final Answer:

   User.where(active: true).where('age > ?', 18) -> Option C

5. Quick Check:

   Chain where with hash and string = B [OK]

Hint: Chain where calls for multiple conditions [OK]

Common Mistakes:

• Mixing hash and string in one where call incorrectly
• Using == inside where instead of : or placeholders
• Not chaining where calls properly