order_by mechanism

[metab0t]

In some cases, I want to iterate rows in a table with ORDER BY clause. It would be nice to have a rows_order_by function similar to rows_where.
In a more general case, rows_filter function might be added to allow more customized filtering to iterate rows.

[simonw]

I think a neat way to do this would be with an optional argument for .rows_where():

rows = db["table"].rows_where("age > 10", order_by="age desc")

If you want everything you can use this:

rows = db["table"].rows_where(order_by="age desc")

It's a tiny bit weird calling .rows_where() without a where clause, but I think it makes sense here - especially since .rows is a property that can't take any arguments - though under the hood it actually does this:

sqlite-utils/sqlite_utils/db.py

Lines 436 to 443 in ad6ac19

	@property
	def rows(self):
	return self.rows_where()
	def rows_where(self, where=None, where_args=None):
	if not self.exists():
	return []
	sql = "select * from [{}]".format(self.name)

[simonw]

Released in 2.6

[simonw]

Documentation here: https://sqlite-utils.readthedocs.io/en/stable/python-api.html#listing-rows

[metab0t]

Thanks for your hard work!