Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Python Using Databases in Python Gettin' CRUD-y With It CRUD: Search Function

Posted by rtkacddqbo
rtkacddqbo
9,662 Points

Create a function named search_challenges that takes two arguments, name and language. Return all Challenges where the n

Hi there, been having problems with this one. I can't seem to get past it using what I think to be right code. Any help?

"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()."

crud.py 
from models import Challenge
from peewee import *


def create_challenge(name, language, steps=1):
    Challenge.create(name=name,
                     language=language,
                     steps=steps)

def search_challenges(name, language):
    return Challenge.select().where(
        Challenge.contents.contains(name), 
        Challenge.language == language)
Nikolay Nogin
Nikolay Nogin
22,154 Points
Nikolay Nogin
Nikolay Nogin
22,154 Points

Hi, Ross, you are almost there, but you are searching in contents field, that doesn't exist.

2 Answers

Ture Paulson
Ture Paulson
2,175 Points
Ture Paulson
Ture Paulson
2,175 Points 
from models import Challenge


def create_challenge(name, language, steps=1):
    Challenge.create(name=name,
                     language=language,
                     steps=steps)

def search_challenges(name,language):
    chal = Challenge.select()

    ans = chal.where((Challenge.name.contains(name)),(Challenge.language==language))
    return ans
Pratham Mishra
Pratham Mishra
14,191 Points
Pratham Mishra
Pratham Mishra
14,191 Points

Hi there, I went through ur code, and I think there's no use of the parenthesis in: ans = chal.where((Challenge.name.contains(name)),(Challenge.language==language)) This line can be written like: ans = chal.where(Challenge.name.contains(name), Challenge.language==language)

Neslihan Kara
Neslihan Kara
11,259 Points

hi only this code is enough. I didn't need to do load all the entries in a variable as Ture Paulson did.

def search_challenges(name, language):
    return Challenge.select().where(Challenge.name.contains(name), Challenge.language==language)
rtkacddqbo
rtkacddqbo
9,662 Points
rtkacddqbo
rtkacddqbo
9,662 Points

Thank you @Nikolay Nogin! I should have been searching for names in name, not contents :)