Merge lp:~nik90/podbird/3-auto-clean-episodes into lp:podbird

[Nekhelesh Ramananthan]

Adds a settings option to auto-remove episodes older than a certain time period (based on their published date). The clean-up is done at app-startup once per day.

Adds a settings option to auto-remove episodes older than a certain time period (based on their published date). The clean-up is done at app-startup once per day.

Screenie: http://imgur.com/KjNdeP1

[lp:~nik90/podbird/3-auto-clean-episodes]

48. By Nekhelesh Ramananthan on 2015-03-11

Set default retention days to never

49. By Nekhelesh Ramananthan on 2015-03-11

Fixed listitem height

50. By Nekhelesh Ramananthan on 2015-03-27

Merged prerequisite lp:~nik90/podbird/2-add-button-feedback

[Michael Sheldon (michael-sheldon)]

Looks good :)

review: Approve

=== modified file 'app/podbird.qml'
--- app/podbird.qml	2015-03-27 15:38:51 +0000
+++ app/podbird.qml	2015-03-27 15:38:51 +0000
@@ -45,6 +45,16 @@
         downloader.cancel();
     }
 
+    Component.onCompleted: {
+        var today = new Date()
+        // Only perform cleanup of old episodes once a day
+        if (Math.floor((today - settings.lastCheck)/86400000) >= 1 && settings.retentionDays !== -1) {
+            console.log("[LOG]: Starting cleanup of old episodes..")
+            cleanUp(today, settings.retentionDays)
+            settings.lastCheck = today
+        }
+    }
+
     property string currentName
     property string currentArtist
     property string currentImage
@@ -61,6 +71,8 @@
     property var settings: Settings {
         // Set "Light.qml" as the default theme
         property string themeName: "Light.qml"
+        property int retentionDays: -1
+        property var lastCheck: new Date()
     }
 
     FileManager {
@@ -175,4 +187,23 @@
             }
         }
     }
+
+    function cleanUp(today, retentionDays) {
+        var dayToMs = 86400000; //1 * 24 * 60 * 60 * 1000
+        var db = Podcasts.init()
+        db.transaction(function (tx) {
+            var rs = tx.executeSql("SELECT rowid, * FROM Podcast ORDER BY name ASC");
+            for(var i = 0; i < rs.rows.length; i++) {
+                var podcast = rs.rows.item(i);
+                var rs2 = tx.executeSql("SELECT rowid, * FROM Episode WHERE podcast=?", [rs.rows.item(i).rowid]);
+                for (var j=0; j< rs2.rows.length; j++) {
+                    var diff = Math.floor((today - rs2.rows.item(j).published)/dayToMs)
+                    if (rs2.rows.item(j).downloadedfile && diff > retentionDays) {
+                        fileManager.deleteFile(rs2.rows.item(j).downloadedfile)
+                        tx.executeSql("UPDATE Episode SET downloadedfile = NULL WHERE guid = ?", [rs2.rows.item(j).guid]);
+                    }
+                }
+            }
+        });
+    }
 }

=== modified file 'app/ui/SettingsTab.qml'
--- app/ui/SettingsTab.qml	2015-03-27 15:38:51 +0000
+++ app/ui/SettingsTab.qml	2015-03-27 15:38:51 +0000
@@ -30,35 +30,86 @@
 
         ListModel {
             id: themeModel
-            ListElement { name: "Light"; file: "Light.qml" }
-            ListElement { name: "Dark"; file: "Dark.qml" }
-        }
-
-        ExpandableListItem {
-            id: themeSetting
-
-            model: themeModel
-            text: i18n.tr("Theme")
-            subText: podbird.settings.themeName.split(".qml")[0]
-
-            delegate: ListItem.Standard {
-                text: model.name
-
-                onClicked: {
-                    var themeElement = model.file
-                    podbird.settings.themeName = themeElement
-                    podbird.themeManager.source = themeElement
-                    themeSetting.expanded = false
+            Component.onCompleted: initialize()
+            function initialize() {
+                themeModel.append({ name: i18n.tr("Light"), file: "Light.qml" })
+                themeModel.append({ name: i18n.tr("Dark"), file: "Dark.qml" })
+            }
+        }
+
+        ListModel {
+            id: cleanupModel
+            Component.onCompleted: initialize()
+            function initialize() {
+                cleanupModel.append({ name: i18n.tr("Never"), value: -1 })
+                cleanupModel.append({ name: i18n.tr("7 days"), value: 7 })
+                cleanupModel.append({ name: i18n.tr("31 days"), value: 31 })
+                cleanupModel.append({ name: i18n.tr("90 days"), value: 90 })
+                cleanupModel.append({ name: i18n.tr("180 days"), value: 180 })
+                cleanupModel.append({ name: i18n.tr("360 days"), value: 360 })
+            }
+        }
+
+        Column {
+            id: settingsColumn
+
+            anchors.fill: parent
+
+            ExpandableListItem {
+                id: themeSetting
+
+                model: themeModel
+                text: i18n.tr("Theme")
+                subText: podbird.settings.themeName.split(".qml")[0]
+
+                delegate: ListItem.Standard {
+                    text: model.name
+
+                    onClicked: {
+                        var themeElement = model.file
+                        podbird.settings.themeName = themeElement
+                        podbird.themeManager.source = themeElement
+                        themeSetting.expanded = false
+                    }
+
+                    Icon {
+                        width: units.gu(2)
+                        height: width
+                        name: "ok"
+                        visible: podbird.settings.themeName === model.file
+                        anchors.right: parent.right
+                        anchors.rightMargin: units.gu(2)
+                        anchors.verticalCenter: parent.verticalCenter
+                    }
                 }
-
-                Icon {
-                    width: units.gu(2)
-                    height: width
-                    name: "ok"
-                    visible: podbird.settings.themeName === model.file
-                    anchors.right: parent.right
-                    anchors.rightMargin: units.gu(2)
-                    anchors.verticalCenter: parent.verticalCenter
+            }
+
+            ExpandableListItem {
+                id: cleanupSetting
+
+                listViewHeight: units.gu(36)
+                model: cleanupModel
+                text: i18n.tr("Remove episodes older than")
+                subText: podbird.settings.retentionDays === -1 ? i18n.tr("Never")
+                                                                : i18n.tr("%1 days").arg(podbird.settings.retentionDays)
+
+                delegate: ListItem.Standard {
+                    text: model.name
+
+                    onClicked: {
+                        podbird.settings.retentionDays = model.value
+                        cleanupSetting.expanded = false
+                    }
+
+                    Icon {
+                        width: units.gu(2)
+                        height: width
+                        name: "ok"
+                        visible: podbird.settings.retentionDays === model.value
+                        anchors.right: parent.right
+                        anchors.rightMargin: units.gu(2)
+                        anchors.verticalCenter: parent.verticalCenter
+                    }
                 }
             }
         }

=== modified file 'po/com.mikeasoft.podbird.pot'
--- po/com.mikeasoft.podbird.pot	2015-03-27 15:38:51 +0000
+++ po/com.mikeasoft.podbird.pot	2015-03-27 15:38:51 +0000
@@ -8,7 +8,7 @@
 msgstr ""
 "Project-Id-Version: \n"
 "Report-Msgid-Bugs-To: \n"
-"POT-Creation-Date: 2015-03-27 16:30+0100\n"
+"POT-Creation-Date: 2015-03-27 16:34+0100\n"
 "PO-Revision-Date: YEAR-MO-DA HO:MI+ZONE\n"
 "Last-Translator: FULL NAME <EMAIL@ADDRESS>\n"
 "Language-Team: LANGUAGE <[e-mail]>\n"
@@ -164,10 +164,51 @@
 msgid "Settings"
 msgstr ""
 
-#: ../app/ui/SettingsTab.qml:41
+#: ../app/ui/SettingsTab.qml:35
+msgid "Light"
+msgstr ""
+
+#: ../app/ui/SettingsTab.qml:36
+msgid "Dark"
+msgstr ""
+
+#: ../app/ui/SettingsTab.qml:44 ../app/ui/SettingsTab.qml:93
+msgid "Never"
+msgstr ""
+
+#: ../app/ui/SettingsTab.qml:45
+msgid "7 days"
+msgstr ""
+
+#: ../app/ui/SettingsTab.qml:46
+msgid "31 days"
+msgstr ""
+
+#: ../app/ui/SettingsTab.qml:47
+msgid "90 days"
+msgstr ""
+
+#: ../app/ui/SettingsTab.qml:48
+msgid "180 days"
+msgstr ""
+
+#: ../app/ui/SettingsTab.qml:49
+msgid "360 days"
+msgstr ""
+
+#: ../app/ui/SettingsTab.qml:62
 msgid "Theme"
 msgstr ""
 
-#: /home/krnekhelesh/Documents/Ubuntu-Projects/MP-Reviews/builddir/build-2-add-button-feedback-UbuntuSDK_for_armhf_GCC_ubuntu_sdk_14_10_utopic-Default/po/Podbird.desktop.in.h:1
+#: ../app/ui/SettingsTab.qml:92
+msgid "Remove episodes older than"
+msgstr ""
+
+#: ../app/ui/SettingsTab.qml:94
+#, qt-format
+msgid "%1 days"
+msgstr ""
+
+#: /home/krnekhelesh/Documents/Ubuntu-Projects/MP-Reviews/builddir/build-3-auto-clean-episodes-UbuntuSDK_for_armhf_GCC_ubuntu_sdk_14_10_utopic-Default/po/Podbird.desktop.in.h:1
 msgid "Podbird"
 msgstr ""