Adding a CMS to Your Pyramid Web App Transcripts
Chapter: Appendix: Using SQLAchemy
Lecture: Concept: Ordering data
0:00 Databases are really good at filtering and ordering. Here's a function, find_all_packages and the idea is I would like really
0:08 a list of all the packages in the database showing the newest ones first and the oldest ones last. So we're going to do a query on package
0:16 and we don't do any filtering 'cause you know, we said in the name, we want them all but we are going to do an order by.
0:22 So we say query a package.orderby and then we always express these operations in terms of the type, so package.created.
0:30 And if we just said package, dot, created it would order ascending by the created date but we want descending, so we go to that descriptor created
0:38 and we say, .desc, we call the function to reverse the sort and then we just say give us all the packages, here they come.