X-Git-Url: https://git.phdru.name/?p=xsetbg.git;a=blobdiff_plain;f=dump_db.py;h=ea6b0f16ea8e7254dbc2bca9dc1f9fe3cde4bb5b;hp=8c80932bb70172da338ae15a8f256c09e9cc3c15;hb=HEAD;hpb=76c9a423c497a1b7c2831087e02e6d8dbda5cb58

diff --git a/dump_db.py b/dump_db.py
index 8c80932..ca3c6a7 100755
--- 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)
+    )