net-mail / mailbox-count

Count mailboxes in a SQL database

Official package sites : https://hackage.haskell.org/package/mailbox-count ·

/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 @

v0.0.6 :: 0 :: gentoo

Modified
License
AGPL-3
Keywords
amd64 ~arm64 ~ppc64 ~riscv ~x86
USE flags
test

General

test
Enable dependencies and/or preparations necessary to run tests (usually controlled by FEATURES=test but can be toggled independently)

dev-haskell / cabal : A framework for packaging Haskell software

dev-haskell / cmdargs : Command line argument processing

dev-haskell / configurator : Configuration management

dev-haskell / doctest : Test interactive Haskell examples

dev-haskell / filemanip : Expressive file and directory manipulation for Haskell

dev-haskell / hdbc : Haskell Database Connectivity

dev-haskell / hdbc-postgresql : PostgreSQL driver for HDBC

dev-haskell / hdbc-sqlite3 : Sqlite v3 driver for HDBC

dev-haskell / missingh : Large utility library

dev-haskell / tasty : Modern and extensible testing framework

dev-haskell / tasty-hunit : HUnit support for the Tasty test framework

dev-lang / ghc : The Glasgow Haskell Compiler

dev-haskell / cmdargs : Command line argument processing

dev-haskell / configurator : Configuration management

dev-haskell / hdbc : Haskell Database Connectivity

dev-haskell / hdbc-postgresql : PostgreSQL driver for HDBC

dev-haskell / hdbc-sqlite3 : Sqlite v3 driver for HDBC

dev-haskell / missingh : Large utility library

dev-haskell / tasty : Modern and extensible testing framework

dev-haskell / tasty-hunit : HUnit support for the Tasty test framework

dev-lang / ghc : The Glasgow Haskell Compiler

Repository mirror & CI · gentoo
Merge updates from master
hololeap · gentoo
*/*: Update EAPI to 8 for haskell packages
Signed-off-by: hololeap <hololeap@protonmail.com> Signed-off-by: Sam James <sam@gentoo.org>
Repository mirror & CI · gentoo
Merge updates from master
hololeap · gentoo
net-mail/mailbox-count: Stabilize for amd64
Signed-off-by: hololeap <hololeap@users.noreply.github.com> Signed-off-by: Sam James <sam@gentoo.org>
Repository mirror & CI · gentoo
Merge updates from master
matoro · gentoo
net-mail/mailbox-count: keyword 0.0.6 for ~riscv
Signed-off-by: Jakov Smolić <jsmolic@gentoo.org>
Repository mirror & CI · gentoo
Merge updates from master
matoro · gentoo
net-mail/mailbox-count: keyword 0.0.6 for ~arm64
Signed-off-by: Sam James <sam@gentoo.org>
Repository mirror & CI · gentoo
Merge updates from master
Michael Orlitzky · gentoo
net-mail/mailbox-count: add 0.0.6, drop 0.0.5
Signed-off-by: Michael Orlitzky <mjo@gentoo.org>
matoro · gentoo
net-mail/mailbox-count: keyword 0.0.5 for ~ppc64
Signed-off-by: Michael Orlitzky <mjo@gentoo.org>
Repository mirror & CI · gentoo
Merge updates from master
Sergei Trofimovich · gentoo
net-mail/mailbox-count: drop unsatisfiable alternative
Package-Manager: Portage-3.0.12, Repoman-3.0.2 Signed-off-by: Sergei Trofimovich <slyfox@gentoo.org>
Repository mirror & CI · gentoo
Merge updates from master
Jakov Smolic · gentoo
net-mail/mailbox-count: update homepage
Package-Manager: Portage-3.0.3, Repoman-3.0.0 Signed-off-by: Jakov Smolic <jakov.smolic@sartura.hr> Signed-off-by: Sergei Trofimovich <slyfox@gentoo.org>
Repository mirror & CI · gentoo
Merge updates from master
Michael Orlitzky · gentoo
net-mail/mailbox-count: new version 0.0.5.
This new version contains a one-line upstream fix to unbreak the build on ghc-8.0 and ghc-8.2 (but not higher or lower versions...). Poor Toralf. Closes: https://bugs.gentoo.org/708030 Package-Manager: Portage-2.3.84, Repoman-2.3.20 Signed-off-by: Michael Orlitzky <mjo@gentoo.org>
Repository mirror & CI · gentoo
Merge updates from master
Michael Orlitzky · gentoo
net-mail/mailbox-count: new version 0.0.4.
Another attempt to fix the semigroups mess. The semigroups package is supposed to offer a backwards-compatible API, but deleted their whole source tree in the minor release 0.18.2. And since the build system restricts package visibility to only things you've declared, we need to hack together a double-conditional both in the cabal build system and in the ebuild, to require old-enough semigroups with old-enough ghc, or alternately just a new enough GHC. Bug: https://bugs.gentoo.org/707836 Package-Manager: Portage-2.3.84, Repoman-2.3.20 Signed-off-by: Michael Orlitzky <mjo@gentoo.org>
Repository mirror & CI · gentoo
Merge updates from master
Michael Orlitzky · gentoo
net-mail/mailbox-count: new version 0.0.3.
This new version attempts to support both the ghc-7.10.1 and ghc-8.x compilers. The newer GHCs require monoid instances to be semigroups, but the semigroups package wasn't bundled with the GHC until then. However, requiring a "redundant" semigroups package seems to not hurt, and should theoretically fix the build with ghc-7.10.1 as well. Bug: https://bugs.gentoo.org/707836 Package-Manager: Portage-2.3.84, Repoman-2.3.20 Signed-off-by: Michael Orlitzky <mjo@gentoo.org>
Repository mirror & CI · gentoo
Merge updates from master
Sergei Trofimovich · gentoo
net-mail/mailbox-count: fix for ghc-8.4
Package-Manager: Portage-2.3.81, Repoman-2.3.20 Signed-off-by: Sergei Trofimovich <slyfox@gentoo.org>
Repository mirror & CI · gentoo
Merge updates from master
Michał Górny · gentoo
*/*: Inline mirror://hackage and update URIs
This change inlines mirror://hackage in all ebuilds, and updates URIs to the modern form (old URIs redirect to that). The change has been made using the following command: find -name '*.ebuild' -exec sed -r -i \ -e 's@mirror://hackage/@https://hackage.haskell.org/@g' \ -e 's@https://hackage.haskell.org/packages/archive/([^/]*)/([^/]*)/@https://hackage.haskell.org/package/\1-\2/@g' \ -e '/hackage\.haskell\.org/s@\$\{PN}-\$\{PV}@${P}@g' \ -e '/hackage\.haskell\.org/s@\$\{MY_PN}-\$\{PV}@${MY_P}@g' \ -e '/hackage\.haskell\.org/s@\$\{PN}-\$\{MY_PV}@${MY_P}@g' \ {} + Signed-off-by: Michał Górny <mgorny@gentoo.org>
Sergei Trofimovich · gentoo
dev-haskell/hdbc-sqlite3: move package from dev-haskell/hdbc-sqlite:2
Package-Manager: Portage-2.3.5, Repoman-2.3.2
Robin H. Johnson · gentoo
Drop $Id$ per council decision in bug #611234.
Signed-off-by: Robin H. Johnson <robbat2@gentoo.org>
Michael Orlitzky · gentoo
net-mail/mailbox-count: new package to count SQL mailboxes.
Package-Manager: portage-2.2.28