From 65bb6654e931adfeafc407c3554f25f77691d321 Mon Sep 17 00:00:00 2001 From: Michael Orlitzky Date: Fri, 15 Jul 2016 18:06:06 -0400 Subject: net-mail/mailbox-count: new package to count SQL mailboxes. Package-Manager: portage-2.2.28 --- net-mail/mailbox-count/Manifest | 1 + .../mailbox-count/mailbox-count-0.0.2-r1.ebuild | 35 +++++ net-mail/mailbox-count/metadata.xml | 144 +++++++++++++++++++++ 3 files changed, 180 insertions(+) create mode 100644 net-mail/mailbox-count/Manifest create mode 100644 net-mail/mailbox-count/mailbox-count-0.0.2-r1.ebuild create mode 100644 net-mail/mailbox-count/metadata.xml (limited to 'net-mail/mailbox-count') diff --git a/net-mail/mailbox-count/Manifest b/net-mail/mailbox-count/Manifest new file mode 100644 index 000000000000..831867e01389 --- /dev/null +++ b/net-mail/mailbox-count/Manifest @@ -0,0 +1 @@ +DIST mailbox-count-0.0.2.tar.gz 20644 SHA256 6eef4b2300a8a5a53bb44ec8c192324025ebddcdc81c2ba145f812a941dba3fd SHA512 98e39927382719295260c64bd5888244000dbbb3fbd7f6405dcffe78a4fc5f1dea7f8236542e58eb0118bb421c19225a8be0560b92c7688c0701418c7221d569 WHIRLPOOL e8a01030415a3be24926d9b0f6ba812a706d361f065c3b8a7622ab532f31282f4d506e976f1fefdf208039ddc95e1e9b8002e27e01d67ca3648cb85cf7cff7e8 diff --git a/net-mail/mailbox-count/mailbox-count-0.0.2-r1.ebuild b/net-mail/mailbox-count/mailbox-count-0.0.2-r1.ebuild new file mode 100644 index 000000000000..2fc2721c9dfa --- /dev/null +++ b/net-mail/mailbox-count/mailbox-count-0.0.2-r1.ebuild @@ -0,0 +1,35 @@ +# Copyright 1999-2016 Gentoo Foundation +# Distributed under the terms of the GNU General Public License v2 +# $Id$ + +EAPI=6 + +# ebuild generated by hackport 0.4.2 + +CABAL_FEATURES="bin test-suite" +inherit haskell-cabal + +DESCRIPTION="Count mailboxes in a SQL database" +HOMEPAGE="http://hackage.haskell.org/package/mailbox-count" +SRC_URI="mirror://hackage/packages/archive/${PN}/${PV}/${P}.tar.gz" + +LICENSE="GPL-3" +SLOT="0" +KEYWORDS="~amd64 ~x86" +IUSE="" + +RDEPEND="" +DEPEND="${RDEPEND} + >=dev-haskell/cabal-1.16.0 + >=dev-haskell/cmdargs-0.10 + >=dev-haskell/configurator-0.2 + >=dev-haskell/hdbc-2.4 + >=dev-haskell/hdbc-postgresql-2.3 + >=dev-haskell/hdbc-sqlite-2.3 + >=dev-haskell/missingh-1.2 + >=dev-haskell/tasty-0.8 + >=dev-haskell/tasty-hunit-0.8 + >=dev-lang/ghc-7.6.1 + test? ( >=dev-haskell/doctest-0.9 + >=dev-haskell/filemanip-0.3.6 ) +" diff --git a/net-mail/mailbox-count/metadata.xml b/net-mail/mailbox-count/metadata.xml new file mode 100644 index 000000000000..fb7f98befbe3 --- /dev/null +++ b/net-mail/mailbox-count/metadata.xml @@ -0,0 +1,144 @@ + + + + + mjo@gentoo.org + Michael Orlitzky + + + haskell@gentoo.org + Gentoo Haskell + + + /Usage/: + + @ + mailbox-count [OPTIONS] + @ + + Mailbox-count produces a simple count of mailboxes that exist + per-domain in some SQL database. The default queries are compatible + with the schema used by PostfixAdmin <http://postfixadmin.sourceforge.net/>, + but it is possible to supply your own queries via the @--summary-query@ + and @--detail-query@ options. + + The summary report lists each domain, along with the number of + mailboxes owned by that domain. The order is determined by the summary + query, which lists the domains alphabetically by default. + + The default detail report shows the same, but also contains a list of + each individual mailbox (again in alphabetical order) belonging to the + domains. + + /Input/: + + None. + + /Output/: + + Either a summary, or detailed report (with @--detail@) of the + number of mailboxes per-domain contained in the database. + + /Options/: + + @ + \--database + @ + + The name of the database (or file, if SQLite) to which we should + connect. + + Default: The name of the current user (Postgres only). + + @ + \--detail + @ + + Produce a detailed report listing all mailboxes by domain. + + @ + \--detail-query + @ + + 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;\" + + @ + \--host + @ + + Hostname where the database is located (Postgres-only). + + Default: None, a UNIX domain socket connection is attempted (Postgres only) + + @ + \--password + @ + + Password used to connect to the database (Postgres-only). + + Default: None (assumes passwordless authentication) + + @ + \--port + @ + Port number used to connect to the database (Postgres-only). + + Default: None, a UNIX domain socket connection is attempted (Postgres only) + + @ + \--summary-query + @ + + 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;\" + + @ + \--username + @ + + Username used to connect to the database (Postgres-only). + + Default: The current user + + /Examples/: + + The default summary report: + + @ + $ mailbox-count --database=postfixadmin.sqlite3 + Summary (number of mailboxes per domain) + \---------------------------------------- + example.com: 3 + example.invalid: 1 + example.net: 2 + example.org: 1 + @ + + The more detailed report: + + @ + $ mailbox-count --detail --database=postfixadmin.sqlite3 + Detail (list of all mailboxes by domain) + \---------------------------------------- + example.com (3): + &#x20; user1 + &#x20; user3 + &#x20; user5 + example.invalid (1): + &#x20; user7 + example.net (2): + &#x20; user2 + &#x20; user4 + example.org (1): + &#x20; user6 + @ + + -- cgit v1.2.3