9 files changed, 408 insertions, 0 deletions
diff --git a/debian/TODO b/debian/TODO
new file mode 100644
index 0000000..0ff43b8
--- /dev/null
+++ b/debian/TODO
@@ -0,0 +1,7 @@
+TODO
+====
+
+  * check/verify/extend options in manpage for current upstream version.
+  * upstream manpage.
+
+ -- Daniel Baumann <daniel.baumann@progress-linux.org>  Mon, 08 Feb 2021 12:55:51 +0100
diff --git a/debian/changelog b/debian/changelog
new file mode 100644
index 0000000..fe95c4d
--- /dev/null
+++ b/debian/changelog
@@ -0,0 +1,249 @@
+pgcli (4.0.1-1) sid; urgency=medium
+
+  * Uploading to sid.
+  * Merging upstream version 4.0.1.
+
+ -- Daniel Baumann <daniel.baumann@progress-linux.org>  Wed, 01 Nov 2023 05:39:50 +0100
+
+pgcli (3.5.0-5) sid; urgency=medium
+
+  * Uploading to sid.
+  * Building with fixed psycopg3 (Closes: #1029182).
+
+ -- Daniel Baumann <daniel.baumann@progress-linux.org>  Mon, 23 Jan 2023 09:26:07 +0100
+
+pgcli (3.5.0-4) sid; urgency=medium
+
+  * Uploading to sid.
+  * Updating to standards version 4.6.2.
+  * Updating psycopg3 depends (Closes: #1029182).
+
+ -- Daniel Baumann <daniel.baumann@progress-linux.org>  Thu, 19 Jan 2023 07:17:12 +0100
+
+pgcli (3.5.0-3) sid; urgency=medium
+
+  * Uploading to sid.
+  * Depending on updated python3-pgspecial (Closes: #1023453).
+
+ -- Daniel Baumann <daniel.baumann@progress-linux.org>  Wed, 16 Nov 2022 05:57:41 +0100
+
+pgcli (3.5.0-2) sid; urgency=medium
+
+  * Uploading to sid.
+  * Updating psycopg depends (Closes: #1021367).
+
+ -- Daniel Baumann <daniel.baumann@progress-linux.org>  Mon, 10 Oct 2022 17:36:23 +0200
+
+pgcli (3.5.0-1) sid; urgency=medium
+
+  * Uploading to sid.
+  * Merging upstream version 3.5.0.
+  * Updating to standards version 4.6.1.
+
+ -- Daniel Baumann <daniel.baumann@progress-linux.org>  Wed, 21 Sep 2022 03:44:59 +0200
+
+pgcli (3.4.1-1) sid; urgency=medium
+
+  * Uploading to sid.
+  * Merging upstream version 3.4.1.
+
+ -- Daniel Baumann <daniel.baumann@progress-linux.org>  Sat, 26 Mar 2022 06:37:10 +0100
+
+pgcli (3.4.0-1) sid; urgency=medium
+
+  * Uploading to sid.
+  * Merging upstream version 3.4.0.
+
+ -- Daniel Baumann <daniel.baumann@progress-linux.org>  Wed, 02 Mar 2022 13:22:08 +0100
+
+pgcli (3.3.1-1) sid; urgency=medium
+
+  * Uploading to sid.
+  * Merging upstream version 3.3.1.
+  * Updating upstream copyright for 2022.
+
+ -- Daniel Baumann <daniel.baumann@progress-linux.org>  Sat, 22 Jan 2022 07:37:25 +0100
+
+pgcli (3.3.0-1) sid; urgency=medium
+
+  * Uploading to sid.
+  * Merging upstream version 3.3.0.
+  * Updating packaging copyright for 2022.
+
+ -- Daniel Baumann <daniel.baumann@progress-linux.org>  Fri, 14 Jan 2022 15:48:00 +0100
+
+pgcli (3.2.0-1) sid; urgency=medium
+
+  * Uploading to sid.
+  * Merging upstream version 3.2.0.
+  * Updating python debhelper sequence.
+  * Updating watch file.
+  * Updating to standards version 4.6.0.
+
+ -- Daniel Baumann <daniel.baumann@progress-linux.org>  Mon, 06 Sep 2021 06:17:57 +0200
+
+pgcli (3.1.0-3) sid; urgency=medium
+
+  * Uploading to sid.
+  * Removing testsuite field, no tests yet in the package.
+
+ -- Daniel Baumann <daniel.baumann@progress-linux.org>  Sat, 27 Feb 2021 17:31:19 +0100
+
+pgcli (3.1.0-2) sid; urgency=medium
+
+  * Uploading to sid.
+  * Manually sorting fields in control.
+  * Adding rules-requires-root field.
+  * Removing trailing slash in URL in copyright.
+  * Repeating section per binary package in control for consistency reasons.
+  * Correcting postgres spelling in package long-description.
+  * Correcting postgres spelling in manpage description.
+  * Adding TODO file.
+
+ -- Daniel Baumann <daniel.baumann@progress-linux.org>  Mon, 08 Feb 2021 13:16:26 +0100
+
+pgcli (3.1.0-1) sid; urgency=medium
+
+  * Uploading to sid.
+  * Adding myself as maintainer, thanks Lennart.
+  * Updating vcs fields.
+  * Updating to debhelper version 13.
+  * Updating to standards version 4.5.1.
+  * Updating homepage field.
+  * Dropping versions from depends fulfilled by buster.
+  * Updating package descriptions.
+  * Updating and harmonizing copyright file.
+  * Removing gbp.conf.
+  * Updating watch file.
+  * Removing vendorizing patch for cli-helpers and depending on it directly, now
+    that it's in debian.
+  * Removing patch to change dependency version for python3-pgspecial
+    (backporting it to buster needs a few packages anyway, so one more doesn't
+    make much of a difference, but we'll save the upstream diff here).
+  * Switching rules to use unchanged pybuild since we're using cli-helpers now.
+  * Correcting typo in timeformat in changelog.
+  * Moving manpage to subdirectory within debian sources.
+  * Reformating, harmonizing and updating manpage.
+  * Wrap-and-sorting debian directory.
+  * Removing some automatically detected python depends.
+  * Adding python3-sqlparse to build-depends rather than python3-pgspecial, needed to run the test target.
+
+ -- Daniel Baumann <daniel.baumann@progress-linux.org>  Mon, 08 Feb 2021 12:21:23 +0100
+
+pgcli (3.1.0-0.3) unstable; urgency=medium
+
+  * Non-maintainer upload.
+  * Installing bash-completion (Closes: #902121).
+
+ -- Daniel Baumann <daniel.baumann@progress-linux.org>  Sun, 07 Feb 2021 09:05:38 +0100
+
+pgcli (3.1.0-0.2) unstable; urgency=medium
+
+  * Non-maintainer upload.
+  * Uploading pgcli to unstable now that pendulum passed NEW:
+    - pgcli will still not work due to missing pytzdata (NEW; depends of pendulum),
+      but it will as soon pytzdata is accepted.
+    - the current pgcli in unstable doesn't work anyway because of python3-harmonze,
+      so we're not worse off by uploading now.
+
+ -- Daniel Baumann <daniel.baumann@progress-linux.org>  Sun, 07 Feb 2021 07:36:00 +0100
+
+pgcli (3.1.0-0.1) experimental; urgency=medium
+
+  * Non-maintainer upload.
+  * New upstream release, using pendulum (Closes: #972598).
+  * Refreshing 0001-Change-dependencies-and-rename-entrypoint.patch.
+
+ -- Daniel Baumann <daniel.baumann@progress-linux.org>  Sat, 30 Jan 2021 09:59:01 +0100
+
+pgcli (3.0.0-1) unstable; urgency=medium
+
+  * New upstream release (Closes: #959973)
+
+ -- Lennart Weller <lhw@ring0.de>  Fri, 08 May 2020 10:29:31 +0200
+
+pgcli (2.2.0-4) unstable; urgency=medium
+
+  * Add dependencies on tabulate and terminaltables (Closes: #950621)
+
+ -- Lennart Weller <lhw@ring0.de>  Wed, 12 Feb 2020 16:11:13 +0100
+
+pgcli (2.2.0-3) unstable; urgency=medium
+
+  * pkg-resources hard dependency for minimal systems (Closes: #944455)
+
+ -- Lennart Weller <lhw@ring0.de>  Tue, 14 Jan 2020 11:22:17 +0100
+
+pgcli (2.2.0-2) unstable; urgency=medium
+
+  * New upstream release (Closes: #917963)
+  * New debian Standards-Version 4.4.1
+
+ -- Lennart Weller <lhw@ring0.de>  Sun, 12 Jan 2020 22:31:03 +0100
+
+pgcli (1.9.1-1) unstable; urgency=medium
+
+  * New upstream release (Closes: #894321)
+  * Vendorized version of cli_helpers library
+
+ -- Lennart Weller <lhw@ring0.de>  Wed, 25 Apr 2018 14:36:42 +0200
+
+pgcli (1.6.0-1) unstable; urgency=medium
+
+  * New upstream release
+  * Fixes issues with psycopg2 (Closes: #865630)
+
+ -- Lennart Weller <lhw@ring0.de>  Fri, 30 Jun 2017 11:41:22 +0200
+
+pgcli (1.4.0-1) unstable; urgency=medium
+
+  * New upstream release
+
+ -- Lennart Weller <lhw@ring0.de>  Mon, 06 Mar 2017 15:14:26 +0100
+
+pgcli (1.3.1-2) unstable; urgency=medium
+
+  * Added pkg-ressources as dependency
+
+ -- Lennart Weller <lhw@ring0.de>  Wed, 11 Jan 2017 12:42:09 +0100
+
+pgcli (1.3.1-1) unstable; urgency=medium
+
+  * New upstrem release (Closes: #844394)
+
+ -- Lennart Weller <lhw@ring0.de>  Tue, 15 Nov 2016 14:54:59 +0100
+
+pgcli (1.1.0-1) unstable; urgency=low
+
+  * New upstream release
+
+ -- Lennart Weller <lhw@ring0.de>  Wed, 27 Jul 2016 14:43:23 +0200
+
+pgcli (1.0.0-1) unstable; urgency=medium
+
+  * Imported new upstream release (Closes: #829021)
+  * Added python3-humanize dependency
+  * Updated debian Standards-Version
+  * Added manpage
+  * Updated Vcs links
+
+ -- Lennart Weller <lhw@ring0.de>  Fri, 01 Jul 2016 10:53:56 +0200
+
+pgcli (0.20.1-3) unstable; urgency=medium
+
+  * Merged upstream patch to support prompt_toolkit == 0.57 (Closes: #811478)
+  * Updated Build-Depends for pgspecial
+
+ -- Lennart Weller <lhw@ring0.de>  Tue, 19 Jan 2016 13:44:14 +0100
+
+pgcli (0.20.1-2) unstable; urgency=medium
+
+  * Added patch to get pgcli to work with prompt_toolkit >= 0.51
+
+ -- Lennart Weller <lhw@ring0.de>  Fri, 27 Nov 2015 14:15:20 +0100
+
+pgcli (0.20.1-1) unstable; urgency=low
+
+  * Initial release (Closes: #794250)
+
+ -- Lennart Weller <lhw@ring0.de>  Fri, 31 Jul 2015 18:16:30 +0200
diff --git a/debian/control b/debian/control
new file mode 100644
index 0000000..f6f5858
--- /dev/null
+++ b/debian/control
@@ -0,0 +1,36 @@
+Source: pgcli
+Section: database
+Priority: optional
+Maintainer: Daniel Baumann <daniel.baumann@progress-linux.org>
+Uploaders:
+ Lennart Weller <lhw@ring0.de>,
+Build-Depends:
+ debhelper-compat (= 13),
+ dh-sequence-python3,
+ python3,
+ python3-setuptools,
+ python3-sqlparse (>= 0.3),
+ python3-psycopg (>= 3.1.7-4~),
+Rules-Requires-Root: no
+Standards-Version: 4.6.2
+Homepage: https://www.pgcli.com
+Vcs-Browser: https://git.progress-linux.org/users/daniel.baumann/debian/packages/pgcli
+Vcs-Git: https://git.progress-linux.org/users/daniel.baumann/debian/packages/pgcli
+
+Package: pgcli
+Section: database
+Architecture: all
+Depends:
+ python3-cli-helpers,
+ python3-pendulum,
+ python3-pgspecial (>= 2),
+ python3-pkg-resources,
+ python3-prompt-toolkit (>= 3.0),
+ python3-sqlparse (>= 0.3),
+ python3-tabulate,
+ python3-terminaltables,
+ ${misc:Depends},
+ ${python3:Depends},
+Description: CLI for PostgreSQL with auto-completion and syntax highlighting
+ pgcli is a command line interface for PostgreSQL with auto-completion and
+ syntax highlighting. It is also capable of pretty printing tabular data.
diff --git a/debian/copyright b/debian/copyright
new file mode 100644
index 0000000..943b062
--- /dev/null
+++ b/debian/copyright
@@ -0,0 +1,39 @@
+Format: https://www.debian.org/doc/packaging-manuals/copyright-format/1.0/
+Upstream-Name: pgcli
+Upstream-Contact: Amjith Ramanujam <amjith.r@gmail.com>
+Source: https://www.pgcli.com
+
+Files: *
+Copyright: 2014-2022 Amjith Ramanujam <amjith.r@gmail.com>
+License: BSD-3-clause
+
+Files: debian/*
+Copyright: 2015-2020 Lennart Weller <lhw@ring0.de>
+           2021-2022 Daniel Baumann <daniel.baumann@progress-linux.org>
+License: BSD-3-clause
+
+License: BSD-3-clause
+ Redistribution and use in source and binary forms, with or without
+ modification, are permitted provided that the following conditions are met:
+ .
+ * Redistributions of source code must retain the above copyright notice, this
+   list of conditions and the following disclaimer.
+ .
+ * Redistributions in binary form must reproduce the above copyright notice,
+   this list of conditions and the following disclaimer in the documentation
+   and/or other materials provided with the distribution.
+ .
+ * Neither the name of dbcli nor the names of its
+   contributors may be used to endorse or promote products derived from
+   this software without specific prior written permission.
+ .
+ THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
+ AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
+ IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
+ DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE LIABLE
+ FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL
+ DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR
+ SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER
+ CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,
+ OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
+ OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
diff --git a/debian/manpages/pgcli.1 b/debian/manpages/pgcli.1
new file mode 100644
index 0000000..0628377
--- /dev/null
+++ b/debian/manpages/pgcli.1
@@ -0,0 +1,62 @@
+.TH "PGCLI" "1" "3.1.0" "pgcli" "DBCLI"
+
+.SH NAME
+pgcli \- CLI for PostgreSQL with auto-completion and syntax highlighting
+
+.SH SYNOPSIS
+\fBpgcli\fR [\fIOPTIONS\fR] [\fIDATABASE\fR] [\fIUSERNAME\fR]
+
+.SH DESCRIPTION
+pgcli is a command line interface for PostgreSQL with auto-completion and
+syntax highlighting. It is also capable of pretty printing tabular data.
+
+.SH OPTIONS
+
+.IP "\-h|\-\-host \fITEXT\fR" 4
+Host address of the postgres database.
+
+.IP "\-p|\-\-port \fIINTEGER\fR" 4
+Port number at which the postgres instance is listening.
+
+.IP "\-U|\-\-user \fITEXT\fR" 4
+User name to connect to the postgres database.
+
+.IP "\-W|\-\-password" 4
+Force password prompt.
+
+.IP "\-w|\-\-no-password" 4
+Never prompt for password.
+
+.IP "\-v|\-\-version" 4
+Version of pgcli.
+
+.IP "\-d|\-\-dbname \fITEXT\fR" 4
+Database name to connect to.
+
+.IP "\-\-pgclirc \fITEXT\fR" 4
+Location of pgclirc file.
+
+.IP "\-\-help" 4
+Show this message and exit.
+
+.SH EXAMPLES
+$ pgcli local_database
+.TP
+$ pgcli postgres://amjith:passw0rd@example.com:5432/app_db
+.TP
+$ pgcli -h localhost -p 5432 -U amjith app_db
+
+.SH SEE ALSO
+litecli(1)
+.TP
+mycli(1)
+.TP
+iredis(1)
+
+.SH HOMEPAGE
+More information about pgcli and the DBCLI project can be found on the homepage at https://www.pgcli.com and https://www.dbcli.com.
+
+.SH AUTHORS
+pgcli was written by Amjith Ramanujam <amjith.r@gmail.com>.
+.TP
+This manual page was written by Lennart Weller <lhw@ring0.de>, for the Debian project (but may be used by others).
diff --git a/debian/pgcli.manpages b/debian/pgcli.manpages
new file mode 100644
index 0000000..2fb19fb
--- /dev/null
+++ b/debian/pgcli.manpages
@@ -0,0 +1 @@
+debian/manpages/*
diff --git a/debian/rules b/debian/rules
new file mode 100755
index 0000000..f837a53
--- /dev/null
+++ b/debian/rules
@@ -0,0 +1,10 @@
+#!/usr/bin/make -f
+
+export PYBUILD_NAME=pgcli
+
+%:
+	dh ${@} --buildsystem=pybuild
+
+execute_after_dh_auto_install:
+	mkdir -p debian/pgcli/usr/share/bash-completion/completions
+	cp pgcli-completion.bash debian/pgcli/usr/share/bash-completion/completions/pgcli
diff --git a/debian/source/format b/debian/source/format
new file mode 100644
index 0000000..163aaf8
--- /dev/null
+++ b/debian/source/format
@@ -0,0 +1 @@
+3.0 (quilt)
diff --git a/debian/watch b/debian/watch
new file mode 100644
index 0000000..e20100f
--- /dev/null
+++ b/debian/watch
@@ -0,0 +1,3 @@
+version=4
+opts=filenamemangle=s/.+\/v?(\d\S+)\.tar\.gz/pgcli-$1\.tar\.gz/ \
+https://github.com/dbcli/pgcli/tags .*/v?(\d\S+)\.tar\.gz