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

Reply via email to