Fix(DB): Fix column encoding

[xsetbg.git] / print-stats.py

diff --git a/print-stats.py b/print-stats.py
index 415688edcb394ca6780ac17d5794af992bb5e94b..fe7cfa585c2c1287c3ecbee5c1177826c15754a0 100755 (executable)
--- a/print-stats.py
+++ b/print-stats.py
@@ -1,4 +1,4 @@
-#! /usr/bin/env python
+#! /usr/bin/env python3
 """Display stats: shown and non-shown files; oldest and newest and so on
 
 This file is a part of XSetBg.
@@ -12,12 +12,15 @@ from xsetbg_db import xsetbg_db
 if not xsetbg_db:
     sys.exit("Error: no database found")
 
-print "Total files:", xsetbg_db.select().count()
-print "Shown files:", xsetbg_db.select('last_shown IS NOT NULL').count()
-print "Not shown files:", xsetbg_db.select('last_shown IS NULL').count()
+print("Total files:", xsetbg_db.select().count())
+print("Images:", xsetbg_db.select('is_image = 1').count())
+print("Non-images:", xsetbg_db.select('is_image = 0').count())
+print("Unknown:", xsetbg_db.select('is_image IS NULL').count())
+print("Shown files:", xsetbg_db.select('last_shown IS NOT NULL').count())
+print("Not shown files:", xsetbg_db.select('last_shown IS NULL').count())
 last_shown = xsetbg_db.select('last_shown IS NOT NULL',
                               orderBy='last_shown')[0].last_shown
-print "Oldest:", asctime(localtime(last_shown))
+print("Oldest:", asctime(localtime(last_shown)))
 min_max = xsetbg_db.select().accumulateMany(('MIN', 'id'), ('MAX', 'id'))
-print "Min id:", min_max[0]
-print "Max id:", min_max[1]
+print("Min id:", min_max[0])
+print("Max id:", min_max[1])