Merge lp:~ahayzen/music-app/remix-sort-playlists into lp:music-app/remix

[Andrew Hayzen]

* Sort playlists by name

* Sort playlists by name

[Ubuntu Phone Apps Jenkins Bot (ubuntu-phone-apps-jenkins-bot)]

PASSED: Continuous integration, rev:714
http://91.189.93.70:8080/job/music-app-remix-ci/206/
Executed test runs:
    SUCCESS: http://91.189.93.70:8080/job/generic-mediumtests-utopic-python3/1351
        deb: http://91.189.93.70:8080/job/generic-mediumtests-utopic-python3/1351/artifact/work/output/*zip*/output.zip
    SUCCESS: http://91.189.93.70:8080/job/music-app-remix-utopic-amd64-ci/206

Click here to trigger a rebuild:
http://91.189.93.70:8080/job/music-app-remix-ci/206/rebuild

review: Approve (continuous-integration)

[lp:~ahayzen/music-app/remix-sort-playlists]

715. By Andrew Hayzen on 2014-10-29

* Merge of lp:music-app/remix

[Ubuntu Phone Apps Jenkins Bot (ubuntu-phone-apps-jenkins-bot)]

FAILED: Continuous integration, rev:715
http://91.189.93.70:8080/job/music-app-remix-ci/209/
Executed test runs:
    UNSTABLE: http://91.189.93.70:8080/job/generic-mediumtests-utopic-python3/1365
        deb: http://91.189.93.70:8080/job/generic-mediumtests-utopic-python3/1365/artifact/work/output/*zip*/output.zip
    SUCCESS: http://91.189.93.70:8080/job/music-app-remix-utopic-amd64-ci/209

Click here to trigger a rebuild:
http://91.189.93.70:8080/job/music-app-remix-ci/209/rebuild

review: Needs Fixing (continuous-integration)

[Victor Thompson (vthompson)]

There maybe some instances where the list isn't filtered when it should be, but this works well. Thanks!

review: Approve

[Victor Thompson (vthompson)]

Actually, could we add "COLLATE NOCASE" so this gets sorted so case doesn't matter? Right now it is sorted ]A-Za-z]

review: Needs Fixing

[lp:~ahayzen/music-app/remix-sort-playlists]

716. By Andrew Hayzen on 2014-10-29

* Make case insensitive

[Victor Thompson (vthompson)]

LGTM! Thanks!

review: Approve

[Ubuntu Phone Apps Jenkins Bot (ubuntu-phone-apps-jenkins-bot)]

FAILED: Continuous integration, rev:716
http://91.189.93.70:8080/job/music-app-remix-ci/210/
Executed test runs:
    UNSTABLE: http://91.189.93.70:8080/job/generic-mediumtests-utopic-python3/1366
        deb: http://91.189.93.70:8080/job/generic-mediumtests-utopic-python3/1366/artifact/work/output/*zip*/output.zip
    SUCCESS: http://91.189.93.70:8080/job/music-app-remix-utopic-amd64-ci/210

Click here to trigger a rebuild:
http://91.189.93.70:8080/job/music-app-remix-ci/210/rebuild

review: Needs Fixing (continuous-integration)

[Ubuntu Phone Apps Jenkins Bot (ubuntu-phone-apps-jenkins-bot)]

review: Approve (continuous-integration)

=== modified file 'playlists.js'
--- playlists.js	2014-10-22 20:46:01 +0000
+++ playlists.js	2014-10-29 00:46:30 +0000
@@ -180,7 +180,7 @@
 
     try {
         db.transaction(function (tx) {
-            var rs = tx.executeSql('SELECT * FROM playlist;')
+            var rs = tx.executeSql('SELECT * FROM playlist ORDER BY name COLLATE NOCASE;')
 
             for (var i = 0; i < rs.rows.length; i++) {
                 var dbItem = rs.rows.item(i)