Pewee Help Phython

Question

Question: Create a function named search_challenges that takes two arguments, name and language. Return all Challenges where the name field contains name argument and the language field is equal to the language argument. Use == for equality. You don't need boolean and or binary & for this, just put both conditions in your where().
Can I get a step by step walk through and break down of this challenge because i'm confused.
Code:
```crud.py
from models import Challenge
def create_challenge(name, language, steps=1):
    Challenge.create(name=name,
                     language=language,
                     steps=steps)
```

Vittorio Somaschini · Accepted Answer

Hello Devin,
I hope I can make it clear:
first create the function:

def search_challenges(name, language):

Pretty standard, I am sure this is not a problem for you.
Inside the function, we need to SELECT (and return) all the challenges that match those 2 criteria without using and or &; so we simply separate the 2 conditions with a comma:
How do we write the conditions?
First one, challenge name contains name:
Challenge.name.contains(name)
Second one, Challenge.language== language.
So, to conclude we can actually write a single command inside the function like this:
return Challenge.select().where(Challenge.name.contains(name), Challenge.language==language)
Select is the database command to retrieve information and where is used to match the conditions. Since code challenge does not want us to use AND or &, we can use a comma to separate the 2 needed conditions.
I had to paste the final code even if I do not like it but it was needed to understand it better I think.
Let me know if ok
Vittorio

Welcome to the Treehouse Community

Looking to learn something new?

Devin Scheu

Devin Scheu

Pewee Help Phython

1 Answer

Vittorio Somaschini

Vittorio Somaschini

Rafael Pastrana

Rafael Pastrana

Andrew Winkler

Andrew Winkler