Your message dated Sun, 22 Nov 2020 12:34:25 +0000
with message-id <[email protected]>
and subject line Bug#966410: fixed in python-sqlalchemy-utils 0.36.8-1
has caused the Debian Bug report #966410,
regarding python-sqlalchemy-utils: does not run tests in packaging
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
966410: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=966410
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: python-sqlalchemy-utils
Version: 0.36.3-3
Severity: normal
Tags: patch
User: [email protected]
Usertags: origin-ubuntu groovy ubuntu-patch
Dear Maintainer,
In an attempt to improve the reliability of the sqlalchemy-utils
package, I've added autopkgtests to ensure that the tests are runnable
rather than skipping all testing.
*** /tmp/tmpwwcschk3/bug_body
In Ubuntu, the attached patch was applied to achieve the following:
* Enable autopkgtests for python-sqlalchemy-utils.
- d/rules: Run tests in autopkgtests.
- d/t/control: Configure functional tests.
- d/t/python-sqlalchemy-utils: Setup and run functional tests.
- d/p/disable-dateutil-tests.patch: Remove dateutil tests.
- d/rules: Add note that we execute tests in autopkgtests.
Thanks for considering the patch.
-- System Information:
Debian Release: bullseye/sid
APT prefers groovy
APT policy: (500, 'groovy')
Architecture: amd64 (x86_64)
Foreign Architectures: i386
Kernel: Linux 5.4.0-29-generic (SMP w/8 CPU threads)
Kernel taint flags: TAINT_PROPRIETARY_MODULE, TAINT_OOT_MODULE,
TAINT_UNSIGNED_MODULE
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8), LANGUAGE not set
Shell: /bin/sh linked to /usr/bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled
diff -Nru
python-sqlalchemy-utils-0.36.3/debian/patches/disable-dateutil-tests.patch
python-sqlalchemy-utils-0.36.3/debian/patches/disable-dateutil-tests.patch
--- python-sqlalchemy-utils-0.36.3/debian/patches/disable-dateutil-tests.patch
1970-01-01 01:00:00.000000000 +0100
+++ python-sqlalchemy-utils-0.36.3/debian/patches/disable-dateutil-tests.patch
2020-07-28 08:35:39.000000000 +0200
@@ -0,0 +1,40 @@
+Description: python-dateutil is broken without a timezone gzip.
+Author: Chris MacNaughton <[email protected]>
+Bug-Ubuntu: https://bugs.launchpad.net/bugs/1887664
+Forwarded: not-needed
+---
+This patch header follows DEP-3: http://dep.debian.net/deps/dep3/
+--- a/tests/types/test_timezone.py
++++ b/tests/types/test_timezone.py
+@@ -11,9 +11,6 @@ def Visitor(Base):
+ class Visitor(Base):
+ __tablename__ = 'visitor'
+ id = sa.Column(sa.Integer, primary_key=True)
+- timezone_dateutil = sa.Column(
+- timezone.TimezoneType(backend='dateutil')
+- )
+ timezone_pytz = sa.Column(
+ timezone.TimezoneType(backend='pytz')
+ )
+@@ -32,21 +29,16 @@ class TestTimezoneType(object):
+
+ def test_parameter_processing(self, session, Visitor):
+ visitor = Visitor(
+- timezone_dateutil=u'America/Los_Angeles',
+ timezone_pytz=u'America/Los_Angeles'
+ )
+
+ session.add(visitor)
+ session.commit()
+
+- visitor_dateutil = session.query(Visitor).filter_by(
+- timezone_dateutil=u'America/Los_Angeles'
+- ).first()
+ visitor_pytz = session.query(Visitor).filter_by(
+ timezone_pytz=u'America/Los_Angeles'
+ ).first()
+
+- assert visitor_dateutil is not None
+ assert visitor_pytz is not None
+
+
diff -Nru python-sqlalchemy-utils-0.36.3/debian/patches/series
python-sqlalchemy-utils-0.36.3/debian/patches/series
--- python-sqlalchemy-utils-0.36.3/debian/patches/series 1970-01-01
01:00:00.000000000 +0100
+++ python-sqlalchemy-utils-0.36.3/debian/patches/series 2020-07-28
08:35:39.000000000 +0200
@@ -0,0 +1 @@
+disable-dateutil-tests.patch
diff -Nru python-sqlalchemy-utils-0.36.3/debian/rules
python-sqlalchemy-utils-0.36.3/debian/rules
--- python-sqlalchemy-utils-0.36.3/debian/rules 2020-05-08 11:44:02.000000000
+0200
+++ python-sqlalchemy-utils-0.36.3/debian/rules 2020-07-28 08:35:39.000000000
+0200
@@ -10,6 +10,7 @@
override_dh_auto_test:
ifeq (,$(findstring nocheck, $(DEB_BUILD_OPTIONS)))
+ # autopkg tests are configured to setup dependencies and run tests
echo "Do not run tests right now:"
echo "need to setup mysql and postgres before running them"
echo "and set SQLALCHEMY_UTILS_TEST_DB
SQLALCHEMY_UTILS_TEST_POSTGRESQL_USER SQLALCHEMY_UTILS_TEST_MYSQL_USER"
diff -Nru python-sqlalchemy-utils-0.36.3/debian/tests/control
python-sqlalchemy-utils-0.36.3/debian/tests/control
--- python-sqlalchemy-utils-0.36.3/debian/tests/control 1970-01-01
01:00:00.000000000 +0100
+++ python-sqlalchemy-utils-0.36.3/debian/tests/control 2020-07-28
08:35:19.000000000 +0200
@@ -0,0 +1,12 @@
+Tests: python-sqlalchemy-utils
+Depends:
+ @, @builddeps@,
+ mysql-server,
+ postgresql-all,
+ python3-colour,
+ python3-cryptography,
+ python3-phonenumbers,
+ python3-pg,
+ python3-pg8000,
+Restrictions: needs-root, allow-stderr
+
diff -Nru python-sqlalchemy-utils-0.36.3/debian/tests/python-sqlalchemy-utils
python-sqlalchemy-utils-0.36.3/debian/tests/python-sqlalchemy-utils
--- python-sqlalchemy-utils-0.36.3/debian/tests/python-sqlalchemy-utils
1970-01-01 01:00:00.000000000 +0100
+++ python-sqlalchemy-utils-0.36.3/debian/tests/python-sqlalchemy-utils
2020-07-28 08:35:19.000000000 +0200
@@ -0,0 +1,29 @@
+#!/bin/bash
+#---------------------
+# Testing sqlalchemy-utils
+#---------------------
+ret=0
+
+# Prepare Postgres and Mysql
+sed -i 's/local\s\+all\s\+postgres\s\+peer/local all postgres trust\nhost all
postgres 127.0.0.1\/32 trust/' /etc/postgresql/*/main/pg_hba.conf
+echo "default-authentication-plugin=mysql_native_password" >>
/etc/mysql/mysql.conf.d/mysqld.cnf
+systemctl restart postgresql
+systemctl restart mysql
+
+# Cleanup existing test databases
+psql -c 'drop database sqlalchemy_utils_test;' -U postgres
+mysql -e 'drop database sqlalchemy_utils_test;'
+mysql -e "ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password
BY '';"
+
+set -e
+# Setup test databases
+psql -c 'create database sqlalchemy_utils_test;' -U postgres
+psql -c 'create extension hstore;' -d sqlalchemy_utils_test -U postgres
+mysql -e 'create database sqlalchemy_utils_test;'
+
+export SQLALCHEMY_UTILS_TEST_MYSQL_USER="root"
+export SQLALCHEMY_UTILS_TEST_POSTGRESQL_USER="postgres"
+export SQLALCHEMY_UTILS_TEST_DB="sqlalchemy_utils_test"
+
+# Run tests
+pytest-3 sqlalchemy_utils tests
--- End Message ---
--- Begin Message ---
Source: python-sqlalchemy-utils
Source-Version: 0.36.8-1
Done: Thomas Goirand <[email protected]>
We believe that the bug you reported is fixed in the latest version of
python-sqlalchemy-utils, which is due to be installed in the Debian FTP archive.
A summary of the changes between this version and the previous one is
attached.
Thank you for reporting the bug, which will now be closed. If you
have further comments please address them to [email protected],
and the maintainer will reopen the bug report if appropriate.
Debian distribution maintenance software
pp.
Thomas Goirand <[email protected]> (supplier of updated python-sqlalchemy-utils
package)
(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing [email protected])
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256
Format: 1.8
Date: Sun, 22 Nov 2020 13:04:47 +0100
Source: python-sqlalchemy-utils
Architecture: source
Version: 0.36.8-1
Distribution: unstable
Urgency: medium
Maintainer: Debian OpenStack <[email protected]>
Changed-By: Thomas Goirand <[email protected]>
Closes: 966410
Changes:
python-sqlalchemy-utils (0.36.8-1) unstable; urgency=medium
.
* New upstream release.
* Applied patch from Ubuntu adding autopkgtests (Closes: #966410).
Checksums-Sha1:
d31e75c93dd223bee5de44e3fb07d5ff5909e42f 2645
python-sqlalchemy-utils_0.36.8-1.dsc
3e732a53faf817441ed5f70848b835d90b8956e1 104276
python-sqlalchemy-utils_0.36.8.orig.tar.xz
e8925a728af1a4f9068b509ca50f1f8df54e8b6b 4368
python-sqlalchemy-utils_0.36.8-1.debian.tar.xz
05171f73ea11974d508d3df83b56afc46ed802a6 9007
python-sqlalchemy-utils_0.36.8-1_amd64.buildinfo
Checksums-Sha256:
49d635d18670a6a189dc61909467a46ff7f30408230b2581bef39a8d48888d90 2645
python-sqlalchemy-utils_0.36.8-1.dsc
6e6d6f180f3520a00b7bfaa34978042f53ce56d61d70c09913b62794e2e4b3b4 104276
python-sqlalchemy-utils_0.36.8.orig.tar.xz
cbc8a39d0b629fd589e0697328d7a998fe3fcb9f2faae75c5d24fe02bdc47624 4368
python-sqlalchemy-utils_0.36.8-1.debian.tar.xz
ff6dd60084bdb0364e49317f3223158b21f04efb1a0cc4fd4fe65b7c021526c0 9007
python-sqlalchemy-utils_0.36.8-1_amd64.buildinfo
Files:
7693d8fb951bfca542b9e9c75862cd93 2645 python optional
python-sqlalchemy-utils_0.36.8-1.dsc
396469aec7ca46d4dcbbcbd8a61e06e3 104276 python optional
python-sqlalchemy-utils_0.36.8.orig.tar.xz
5ad744a40ebbe1551e972cd7a1e29375 4368 python optional
python-sqlalchemy-utils_0.36.8-1.debian.tar.xz
810276a7a50eb3580a06c3b89a01459d 9007 python optional
python-sqlalchemy-utils_0.36.8-1_amd64.buildinfo
-----BEGIN PGP SIGNATURE-----
iQIzBAEBCAAdFiEEoLGp81CJVhMOekJc1BatFaxrQ/4FAl+6VDAACgkQ1BatFaxr
Q/73PxAAnm26Q7ES/Y4L6ptZdBrOKNHYy4qqFqIXNpdn0cX5DJpfV7CQUDESwGRS
y3CwwpKSHAq51widq9f6GrzkeSkSxMM7azONFB9tbiDlZ2zyOnT0jd/tj6TDl9CN
VYPjlir2sHI8zPyJaNpm8sd7S/BtBimm5KBB8fbhkbWFJdnwNzWgN4zGNHqvdUei
/SFSs501upox5TH5CbDdthprr2jHa4rIgjXujV/7ZLh2r1oZRdnrX9ZXJPtjqg72
BrLVuS7RKTUytJ/FW6FnZmaQxbgNssGe3olGweVke64xY8dEmlVkVgSessIZ6X6d
xAs8wcSW3OzKhcd8Xo0Qb6v7NmsvmTJf+NCD86Y0Mt4/sjUXfA4IjVMmJhMDCS1J
nzxq2H0fKgS7l47EpiHSlBetjOubzmRXOmPFldbAAy/HTBFqv462hrBmwxm+eIH0
h0XTr/LUv2VcqSHXtymjeuAkWO43tAhk2aFH6j2RVBHZXW/JM/CfWIojqeDxmNqn
gNk+AlQtPnynMVX3NeNXXTnQY4OtdE++XOELuxRB/yZAC9h0LjV5LVfgj2LApAcv
yNYkNFdwqL2OWuy5FOQ6s7eDVuNpQDFSQcT6Fb3MFqxym31aK31mIYmGz0zs2z5B
3UO9Jw0mf0xEJedlYqC8hFRmQGlGvKVFn5/sSiWpuFYqKjxZNW8=
=SXc8
-----END PGP SIGNATURE-----
--- End Message ---