X-Git-Url: http://gitweb.michael.orlitzky.com/?a=blobdiff_plain;ds=sidebyside;f=doc%2Fmailbox-countrc.example;h=26390085297171f43bb5cc73e4c70e8146d2013f;hb=35545d80ed25fd8c0c1d5a0d02a7504dbbfd5868;hp=8a3529de5d9f310b65c4186473771f7e4df27fa5;hpb=7a19ab91c57bfe9c3fb8a6e4105f300c7f638e2d;p=mailbox-count.git

diff --git a/doc/mailbox-countrc.example b/doc/mailbox-countrc.example
index 8a3529d..2639008 100644
--- a/doc/mailbox-countrc.example
+++ b/doc/mailbox-countrc.example
@@ -2,7 +2,7 @@
 # Sample configuration file for mailbox-count.
 #
 
-# The name of the database to which we should connect.
+# The name of the database (or file, if SQLite) to which we should connect.
 #
 # Default: The name of the current user (Postgres only)
 #
@@ -16,28 +16,46 @@
 # detail = true
 
 
-# Hostname where the database is located.
+# SQL query used to produce the detail report. This should return the
+# set of all (domain, username) pairs. See the default value for an
+# example.
+#
+# Default: "SELECT domain,username FROM mailbox ORDER BY domain;"
+#
+# detail_query = "SELECT domain,username FROM mailbox LIMIT 1000;"
+
+
+# Hostname where the database is located (Postgres-only).
 #
 # Default: None, a UNIX domain socket connection is attempted (Postgres only)
 #
 # host = "localhost"
 
 
-# Password used to connect to the database.
+# Password used to connect to the database (Postgres-only).
 #
 # Default: None (assumes passwordless authentication)
 #
 # password = "hunter2"
 
 
-# Port number used to connect to the database.
+# Port number used to connect to the database (Postgres-only).
 #
 # Default: None, a UNIX domain socket connection is attempted (Postgres only)
 #
 # port = 5432
 
 
-# Username used to connect to the database.
+# SQL query used to produce the summary report. This should return
+# (domain, user count) pairs. See the default value for an
+# example.
+#
+# Default: "SELECT domain,COUNT(username) FROM mailbox GROUP BY domain ORDER BY domain;"
+#
+# summary_query = "SELECT domain,COUNT(username) as cnt GROUP BY domain ORDER by cnt;"
+
+
+# Username used to connect to the database (Postgres-only).
 #
 # Default: The current user
 #