Fix(DB): Fix column encoding

[xsetbg.git] / dump_db.py

diff --git a/dump_db.py b/dump_db.py
index 8c80932bb70172da338ae15a8f256c09e9cc3c15..ca3c6a74be70213190721f1940f564607e9eb79a 100755 (executable)
--- a/dump_db.py
+++ b/dump_db.py
@@ -1,18 +1,20 @@
-#! /usr/bin/env python
+#! /usr/bin/env python3
 """Dump the DB sorted by date
 
 This file is a part of XSetBg.
 
 """
 
-__author__ = "Oleg Broytman <phd@phdru.name>"
-__copyright__ = "Copyright (C) 2006-2014 PhiloSoft Design"
-__license__ = "GNU GPL"
-
-from operator import itemgetter
+import sys
+from xsetbg_conf import xsetbg_conf
 from xsetbg_db import xsetbg_db
 
-for key, value in sorted(xsetbg_db.items(), key=itemgetter(1), reverse=1):
-   if key.startswith('/'):
-      print value, key
-xsetbg_db.close()
+if not xsetbg_db:
+    sys.exit("Error: no database found")
+
+fs_encoding = xsetbg_conf.get("images", "fs_encoding")
+for row in xsetbg_db.select(orderBy='-last_shown'):
+    sys.stdout.buffer.write(
+        ('%d %s %s\n' % (row.id, row.last_shown, row.full_name
+                         )).encode(fs_encoding)
+    )