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 Keenan Smith
.a{fill-rule:evenodd;}techdegree
Keenan Smith
Python Development Techdegree Student 5,487 Points

My search_challenge function doesn't work

I thought I was adding the function correctly, but im getting a syntax error. Am i missing something else?

crud.py 
from models import Challenge


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

def search_challenges():
    challenge = challenge.where(Challenge.content.contains(name, language)

1 Answer

Joseph Yhu
.a{fill-rule:evenodd;}techdegree seal-36
Joseph Yhu
PHP Development Techdegree Graduate 48,640 Points

Your code (for reference):

def search_challenges():
    challenge = challenge.where(Challenge.content.contains(name, language)

Two basic things first:

  1. Your function needs to have two parameters: name and language.
  2. Your function needs to return a value, which is all Challenges that meet the criteria.

Now for the specifics:

  1. You don't have to create a variable called challenge and assign the results of the query to it; you can just return the query results.
  2. The c in challenge.where should be capitalized.
  3. You should have a select() in between Challenge and where.
  4. Challenge.name must contain the name argument, but Challenge.language must equal the language argument.

My solution:

def search_challenges(name, language):
    return Challenge.select().where(Challenge.name.contains(name), Challenge.language == language)