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 Meet Peewee First Queries

Posted by Conrad Landicho
Conrad Landicho
3,312 Points

sort by ascending

Hi guys, Can anyone tell me what I'm doing wrong here? I'm trying to sort by ascending, as specified in the code challenge. Thanks for any insights you can provide.

queries.py 
from models import Challenge

all_challenges = Challenge.select()

Challenge.create(language='Ruby', name='Booleans')

sorted_challenges = all_challenges.order_by(Challenge.asc())

3 Answers

Stuart Wright
Stuart Wright
41,120 Points
Stuart Wright
Stuart Wright
41,120 Points

The correct syntax for your last line is:

sorted_challenges = all_challenges.order_by(Challenge.steps)

Note that ascending is default, so there's no need to specify, but if you prefer to be explicit, you would write:

sorted_challenges = all_challenges.order_by(Challenge.steps).asc()
Mike Wagner
Mike Wagner
23,559 Points
Mike Wagner
Mike Wagner
23,559 Points

If you change the final line to 

sorted_challenges = all_challenges.order_by(Challenge.steps)

it will give you the desired result.

Conrad Landicho
Conrad Landicho
3,312 Points
Conrad Landicho
Conrad Landicho
3,312 Points

cool ... it worked ! Thanks guys :-)