From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from lists.gentoo.org (pigeon.gentoo.org [208.92.234.80]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (2048 bits)) (No client certificate requested) by finch.gentoo.org (Postfix) with ESMTPS id 58BB9158004 for ; Wed, 24 Apr 2024 11:59:54 +0000 (UTC) Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id 9B838E29F6; Wed, 24 Apr 2024 11:59:53 +0000 (UTC) Received: from smtp.gentoo.org (woodpecker.gentoo.org [IPv6:2001:470:ea4a:1:5054:ff:fec7:86e4]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits)) (No client certificate requested) by pigeon.gentoo.org (Postfix) with ESMTPS id 80B8FE29F6 for ; Wed, 24 Apr 2024 11:59:53 +0000 (UTC) Received: from oystercatcher.gentoo.org (oystercatcher.gentoo.org [148.251.78.52]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits)) (No client certificate requested) by smtp.gentoo.org (Postfix) with ESMTPS id C80103430D3 for ; Wed, 24 Apr 2024 11:59:52 +0000 (UTC) Received: from localhost.localdomain (localhost [IPv6:::1]) by oystercatcher.gentoo.org (Postfix) with ESMTP id 6340B1751 for ; Wed, 24 Apr 2024 11:59:51 +0000 (UTC) From: "Michael Orlitzky" To: gentoo-commits@lists.gentoo.org Content-Transfer-Encoding: 8bit Content-type: text/plain; charset=UTF-8 Reply-To: gentoo-dev@lists.gentoo.org, "Michael Orlitzky" Message-ID: <1713959983.3c8b6585a9ba887e45fc53823cf520d5f986027f.mjo@gentoo> Subject: [gentoo-commits] repo/gentoo:master commit in: net-mail/mailbox-count/ X-VCS-Repository: repo/gentoo X-VCS-Files: net-mail/mailbox-count/metadata.xml X-VCS-Directories: net-mail/mailbox-count/ X-VCS-Committer: mjo X-VCS-Committer-Name: Michael Orlitzky X-VCS-Revision: 3c8b6585a9ba887e45fc53823cf520d5f986027f X-VCS-Branch: master Date: Wed, 24 Apr 2024 11:59:51 +0000 (UTC) Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-commits@lists.gentoo.org X-Auto-Response-Suppress: DR, RN, NRN, OOF, AutoReply X-Archives-Salt: dee67aad-77b3-426f-ac3a-d3dbfe268afa X-Archives-Hash: fff24cfd15ba1731df532b1394f85617 commit: 3c8b6585a9ba887e45fc53823cf520d5f986027f Author: Michael Orlitzky gentoo org> AuthorDate: Wed Apr 24 11:57:55 2024 +0000 Commit: Michael Orlitzky gentoo org> CommitDate: Wed Apr 24 11:59:43 2024 +0000 URL: https://gitweb.gentoo.org/repo/gentoo.git/commit/?id=3c8b6585 net-mail/mailbox-count: trim down longdescription Signed-off-by: Michael Orlitzky gentoo.org> net-mail/mailbox-count/metadata.xml | 162 +++++------------------------------- 1 file changed, 22 insertions(+), 140 deletions(-) diff --git a/net-mail/mailbox-count/metadata.xml b/net-mail/mailbox-count/metadata.xml index 4831484d5891..134a467564f6 100644 --- a/net-mail/mailbox-count/metadata.xml +++ b/net-mail/mailbox-count/metadata.xml @@ -1,144 +1,26 @@ - - 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 - @ - + + mjo@gentoo.org + Michael Orlitzky + + + haskell@gentoo.org + Gentoo Haskell + + + 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 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. +