Have SQLite sort our sidebar tables #1

New Issue

anna · 2021-10-04T07:53:50-04:00

anna commented

2021-10-04 07:53:50 -04:00

Rather than sorting through GTK, we can use the SQL "ORDER BY" statement to sort our sidebar list inside the database engine.

anna added this to the Emmental 2.6 milestone 2021-10-07 11:06:12 -04:00

anna commented

2021-10-07 11:10:23 -04:00

We can find the position of a playlist inside the sorted list through:

sqlite> SELECT * FROM
			(SELECT rowid,name,ROW_NUMBER()
             OVER (ORDER BY lower(name))
             FROM artists)
        WHERE rowid=3;
3|BArtist|2

We can find the position of a playlist inside the sorted list through: ``` sqlite> SELECT * FROM (SELECT rowid,name,ROW_NUMBER() OVER (ORDER BY lower(name)) FROM artists) WHERE rowid=3; 3|BArtist|2 ```

anna referenced this issue from a commit

2021-10-11 11:53:25 -04:00

db: Create a new Model class

anna referenced this issue from a commit

2021-10-11 11:53:25 -04:00

db: Create a new Child class

anna closed this issue

2021-10-11 11:53:48 -04:00

anna referenced this issue from a commit

2021-10-11 11:58:48 -04:00

db: Create a new Model class

anna referenced this issue from a commit