Script 'mail_helper' called by obssrc Hello community, here is the log from the commit of package python-pymssql for openSUSE:Factory checked in at 2023-10-31 20:25:57 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Comparing /work/SRC/openSUSE:Factory/python-pymssql (Old) and /work/SRC/openSUSE:Factory/.python-pymssql.new.17445 (New) ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Package is "python-pymssql" Tue Oct 31 20:25:57 2023 rev:3 rq:1121378 version:2.2.10 Changes: -------- --- /work/SRC/openSUSE:Factory/python-pymssql/python-pymssql.changes 2023-08-14 22:35:34.324344545 +0200 +++ /work/SRC/openSUSE:Factory/.python-pymssql.new.17445/python-pymssql.changes 2023-10-31 20:26:16.463206408 +0100 @@ -1,0 +2,10 @@ +Mon Oct 30 20:52:41 UTC 2023 - Martin Hauke <mardnh@gmx.de> + +- Update to version 2.2.10 + * Add python 3.12 support. + * Do not try to drop temporary tables in clear_db(). + * test_sqlalchemy: update for compatibility with SQLAlchemy >2.0. +- Update to version 2.2.9 + * Update changelog. + +------------------------------------------------------------------- Old: ---- pymssql-2.2.8.tar.gz New: ---- pymssql-2.2.10.tar.gz ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Other differences: ------------------ ++++++ python-pymssql.spec ++++++ --- /var/tmp/diff_new_pack.OqN2zv/_old 2023-10-31 20:26:17.191233148 +0100 +++ /var/tmp/diff_new_pack.OqN2zv/_new 2023-10-31 20:26:17.195233295 +0100 @@ -16,9 +16,8 @@ # -%{?!python_module:%define python_module() python-%{**} python3-%{**}} Name: python-pymssql -Version: 2.2.8 +Version: 2.2.10 Release: 0 Summary: A simple database interface to MS-SQL for Python License: LGPL-2.1-only @@ -58,5 +57,5 @@ %files %{python_files} %license LICENSE %doc ChangeLog.rst README.rst -%{python_sitearch}/* +%{python_sitearch}/pymssql* ++++++ pymssql-2.2.8.tar.gz -> pymssql-2.2.10.tar.gz ++++++ diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/pymssql-2.2.8/.github/workflows/test_linux.yml new/pymssql-2.2.10/.github/workflows/test_linux.yml --- old/pymssql-2.2.8/.github/workflows/test_linux.yml 2023-07-31 00:21:30.000000000 +0200 +++ new/pymssql-2.2.10/.github/workflows/test_linux.yml 2023-10-26 23:49:27.000000000 +0200 @@ -7,6 +7,8 @@ paths-ignore: - docs/** - ChangeLog* + - .github/workflows/test_macos.yml + - .github/workflows/test_windows.yml tags: - 'v[0-9]+.[0-9]+.[0-9]+' - 'v[0-9]+.[0-9]+.[0-9]+rc[0-9]+' @@ -16,6 +18,8 @@ paths-ignore: - docs/** - ChangeLog* + - .github/workflows/test_macos.yml + - .github/workflows/test_windows.yml jobs: @@ -24,8 +28,8 @@ runs-on: ${{ matrix.os }} strategy: matrix: - python-version: ['3.6', '3.7', '3.8', '3.9', '3.10', '3.11'] - os: [ubuntu-18.04] + python-version: ['3.6', '3.7', '3.8', '3.9', '3.10', '3.11', '3.12'] + os: [ubuntu-20.04] services: SQLServer: @@ -54,7 +58,7 @@ python dev/build.py \ --ws-dir=./freetds \ --dist-dir=./dist \ - --freetds-version="1.3.13" \ + --freetds-version="1.4.3" \ --with-openssl=yes \ --enable-krb5 \ --sdist \ @@ -81,7 +85,10 @@ strategy: matrix: arch: [i686, x86_64] - manylinux: [manylinux1, manylinux2010, manylinux2014, manylinux_2_24] + manylinux: [manylinux1, manylinux2010, manylinux2014, manylinux_2_28] + exclude: + - arch: i686 + manylinux: manylinux_2_28 steps: diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/pymssql-2.2.8/.github/workflows/test_macos.yml new/pymssql-2.2.10/.github/workflows/test_macos.yml --- old/pymssql-2.2.8/.github/workflows/test_macos.yml 2023-07-31 00:21:30.000000000 +0200 +++ new/pymssql-2.2.10/.github/workflows/test_macos.yml 2023-10-26 23:49:27.000000000 +0200 @@ -7,6 +7,9 @@ paths-ignore: - docs/** - ChangeLog* + - .github/workflows/test_linux.yml + - .github/workflows/test_windows.yml + - dev/build_manylinux_wheels.sh tags: - 'v[0-9]+.[0-9]+.[0-9]+' - 'v[0-9]+.[0-9]+.[0-9]+rc[0-9]+' @@ -16,6 +19,9 @@ paths-ignore: - docs/** - ChangeLog* + - .github/workflows/test_linux.yml + - .github/workflows/test_windows.yml + - dev/build_manylinux_wheels.sh jobs: build: @@ -23,7 +29,7 @@ runs-on: ${{ matrix.os }} strategy: matrix: - python-version: ['3.6', '3.7', '3.8', '3.9', '3.10', '3.11'] + python-version: ['3.6', '3.7', '3.8', '3.9', '3.10', '3.11', '3.12'] os: [macos-latest] steps: @@ -52,7 +58,7 @@ python dev/build.py \ --ws-dir=./freetds \ --dist-dir=./dist \ - --freetds-version="1.3.13" \ + --freetds-version="1.4.3" \ --with-openssl=yes \ --sdist \ --static-freetds diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/pymssql-2.2.8/.github/workflows/test_windows.yml new/pymssql-2.2.10/.github/workflows/test_windows.yml --- old/pymssql-2.2.8/.github/workflows/test_windows.yml 2023-07-31 00:21:30.000000000 +0200 +++ new/pymssql-2.2.10/.github/workflows/test_windows.yml 2023-10-26 23:49:27.000000000 +0200 @@ -7,6 +7,9 @@ paths-ignore: - docs/** - ChangeLog* + - .github/workflows/test_macos.yml + - .github/workflows/test_linux.yml + - dev/build_manylinux_wheels.sh tags: - 'v[0-9]+.[0-9]+.[0-9]+' - 'v[0-9]+.[0-9]+.[0-9]+rc[0-9]+' @@ -16,6 +19,9 @@ paths-ignore: - docs/** - ChangeLog* + - .github/workflows/test_macos.yml + - .github/workflows/test_linux.yml + - dev/build_manylinux_wheels.sh jobs: build: @@ -25,7 +31,7 @@ strategy: fail-fast: false matrix: - python-version: ['3.6', '3.7', '3.8', '3.9', '3.10', '3.11'] + python-version: ['3.6', '3.7', '3.8', '3.9', '3.10', '3.11', '3.12'] os: [windows-latest] python-architecture: [x86, x64] @@ -43,7 +49,7 @@ - name: Install OpenSSL x86 if: matrix.python-architecture == 'x86' - run: choco install openssl --forcex86 + run: choco install openssl --forcex86 --version=1.1.1.2100 - name: Install OpenSSL x64 if: matrix.python-architecture == 'x64' @@ -54,7 +60,7 @@ choco install gperf python -m pip install --upgrade pip pip install -r dev/requirements-dev.txt - python dev/build.py --ws-dir=freetds --dist-dir=dist --sdist --freetds-version="1.3.13" + python dev/build.py --ws-dir=freetds --dist-dir=dist --sdist --freetds-version="1.4.3" pip install pymssql --no-index -f dist python -c "import pymssql; print(pymssql.version_info())" diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/pymssql-2.2.8/ChangeLog.rst new/pymssql-2.2.10/ChangeLog.rst --- old/pymssql-2.2.8/ChangeLog.rst 2023-07-31 01:07:46.000000000 +0200 +++ new/pymssql-2.2.10/ChangeLog.rst 2023-10-26 23:49:27.000000000 +0200 @@ -1,6 +1,26 @@ Recent Changes ============== +Version 2.2.10 - 2023-10-20 - Mikhail Terekhov +=============================================== + +General +------- + +- Publish Linux wheels for Python-3.12 + +Version 2.2.9 - 2023-10-13 - Mikhail Terekhov +============================================== + +General +------- + +- Use FreeTDS-1.4.3 for official wheels on PyPi (fix #847). +- Build wheels for Python-3.12. Thanks to Raphael Jacob (fix #851, #855). +- Use manylinux_2_28 instead of manylinux_2_24 when building wheels in GitHub actions. +- Fix build with OpenSSL on Windows. Thanks to PrimozGodec (fix #839). + + Version 2.2.8 - 2023-07-30 - Mikhail Terekhov ============================================== diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/pymssql-2.2.8/PKG-INFO new/pymssql-2.2.10/PKG-INFO --- old/pymssql-2.2.8/PKG-INFO 2023-07-31 01:08:48.412727400 +0200 +++ new/pymssql-2.2.10/PKG-INFO 2023-10-26 23:53:45.686357700 +0200 @@ -1,6 +1,6 @@ Metadata-Version: 2.1 Name: pymssql -Version: 2.2.8 +Version: 2.2.10 Summary: DB-API interface to Microsoft SQL Server for Python. (new Cython-based version) Author: Damien Churchill Author-email: damoxc@gmail.com @@ -22,6 +22,7 @@ Classifier: Programming Language :: Python :: 3.9 Classifier: Programming Language :: Python :: 3.10 Classifier: Programming Language :: Python :: 3.11 +Classifier: Programming Language :: Python :: 3.12 Classifier: Programming Language :: Python :: Implementation :: CPython Classifier: Topic :: Database Classifier: Topic :: Database :: Database Engines/Servers @@ -111,18 +112,21 @@ Recent Changes ============== -Version 2.2.8 - 2023-07-30 - Mikhail Terekhov -============================================== +Version 2.2.10 - 2023-10-20 - Mikhail Terekhov +=============================================== General ------- -- Compatibility with Cython. Thanks to matusvalo (Matus Valo) (fix #826). +- Publish Linux wheels for Python-3.12 -Version 2.2.7 - 2022-11-15 - Mikhail Terekhov +Version 2.2.9 - 2023-10-13 - Mikhail Terekhov ============================================== General ------- -- Build wheels for Python-3.6 (fix 787). +- Use FreeTDS-1.4.3 for official wheels on PyPi (fix #847). +- Build wheels for Python-3.12. Thanks to Raphael Jacob (fix #851, #855). +- Use manylinux_2_28 instead of manylinux_2_24 when building wheels in GitHub actions. +- Fix build with OpenSSL on Windows. Thanks to PrimozGodec (fix #839). diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/pymssql-2.2.8/dev/build_manylinux_wheels.sh new/pymssql-2.2.10/dev/build_manylinux_wheels.sh --- old/pymssql-2.2.8/dev/build_manylinux_wheels.sh 2023-07-31 00:21:30.000000000 +0200 +++ new/pymssql-2.2.10/dev/build_manylinux_wheels.sh 2023-10-26 23:49:27.000000000 +0200 @@ -48,13 +48,13 @@ --ws-dir=./freetds \ --dist-dir=. \ --prefix=/usr/local \ - --freetds-version="1.3.13" \ + --freetds-version="1.4.3" \ --with-openssl=yes \ --enable-krb5 \ --static-freetds # Install Python dependencies and compile wheels -PYTHONS="cp36-cp36m cp37-cp37m cp38-cp38 cp39-cp39 cp310-cp310 cp311-cp311" +PYTHONS="cp36-cp36m cp37-cp37m cp38-cp38 cp39-cp39 cp310-cp310 cp311-cp311 cp312-cp312" for i in $PYTHONS; do PYBIN="/opt/python/$i/bin" if [ -d ${PYBIN} ] ; then diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/pymssql-2.2.8/setup.py new/pymssql-2.2.10/setup.py --- old/pymssql-2.2.8/setup.py 2023-07-31 00:21:30.000000000 +0200 +++ new/pymssql-2.2.10/setup.py 2023-10-26 23:49:27.000000000 +0200 @@ -167,7 +167,7 @@ if BITNESS == 32: e.library_dirs.append("c:/Program Files (x86)/OpenSSL-Win32/lib") else: - e.library_dirs.append("c:/Program Files/OpenSSL-Win64/lib") + e.library_dirs.append("c:/Program Files/OpenSSL/lib") else: if LINK_KRB5: @@ -324,6 +324,7 @@ "Programming Language :: Python :: 3.9", "Programming Language :: Python :: 3.10", "Programming Language :: Python :: 3.11", + "Programming Language :: Python :: 3.12", "Programming Language :: Python :: Implementation :: CPython", "Topic :: Database", "Topic :: Database :: Database Engines/Servers", diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/pymssql-2.2.8/src/pymssql/version.h new/pymssql-2.2.10/src/pymssql/version.h --- old/pymssql-2.2.8/src/pymssql/version.h 2023-07-31 01:08:48.000000000 +0200 +++ new/pymssql-2.2.10/src/pymssql/version.h 2023-10-26 23:53:45.000000000 +0200 @@ -1 +1 @@ -#define PYMSSQL_VERSION "2.2.8" \ No newline at end of file +#define PYMSSQL_VERSION "2.2.10" \ No newline at end of file diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/pymssql-2.2.8/src/pymssql.egg-info/PKG-INFO new/pymssql-2.2.10/src/pymssql.egg-info/PKG-INFO --- old/pymssql-2.2.8/src/pymssql.egg-info/PKG-INFO 2023-07-31 01:08:48.000000000 +0200 +++ new/pymssql-2.2.10/src/pymssql.egg-info/PKG-INFO 2023-10-26 23:53:45.000000000 +0200 @@ -1,6 +1,6 @@ Metadata-Version: 2.1 Name: pymssql -Version: 2.2.8 +Version: 2.2.10 Summary: DB-API interface to Microsoft SQL Server for Python. (new Cython-based version) Author: Damien Churchill Author-email: damoxc@gmail.com @@ -22,6 +22,7 @@ Classifier: Programming Language :: Python :: 3.9 Classifier: Programming Language :: Python :: 3.10 Classifier: Programming Language :: Python :: 3.11 +Classifier: Programming Language :: Python :: 3.12 Classifier: Programming Language :: Python :: Implementation :: CPython Classifier: Topic :: Database Classifier: Topic :: Database :: Database Engines/Servers @@ -111,18 +112,21 @@ Recent Changes ============== -Version 2.2.8 - 2023-07-30 - Mikhail Terekhov -============================================== +Version 2.2.10 - 2023-10-20 - Mikhail Terekhov +=============================================== General ------- -- Compatibility with Cython. Thanks to matusvalo (Matus Valo) (fix #826). +- Publish Linux wheels for Python-3.12 -Version 2.2.7 - 2022-11-15 - Mikhail Terekhov +Version 2.2.9 - 2023-10-13 - Mikhail Terekhov ============================================== General ------- -- Build wheels for Python-3.6 (fix 787). +- Use FreeTDS-1.4.3 for official wheels on PyPi (fix #847). +- Build wheels for Python-3.12. Thanks to Raphael Jacob (fix #851, #855). +- Use manylinux_2_28 instead of manylinux_2_24 when building wheels in GitHub actions. +- Fix build with OpenSSL on Windows. Thanks to PrimozGodec (fix #839). diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/pymssql-2.2.8/src/pymssql.egg-info/SOURCES.txt new/pymssql-2.2.10/src/pymssql.egg-info/SOURCES.txt --- old/pymssql-2.2.8/src/pymssql.egg-info/SOURCES.txt 2023-07-31 01:08:48.000000000 +0200 +++ new/pymssql-2.2.10/src/pymssql.egg-info/SOURCES.txt 2023-10-26 23:53:45.000000000 +0200 @@ -88,7 +88,6 @@ tests/test_memory.py tests/test_pymssql.py tests/test_queries.py -tests/test_query_parameters.py tests/test_sprocs.py tests/test_sqlalchemy.py tests/test_threaded.py diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/pymssql-2.2.8/tests/helpers.py new/pymssql-2.2.10/tests/helpers.py --- old/pymssql-2.2.8/tests/helpers.py 2023-07-31 00:21:30.000000000 +0200 +++ new/pymssql-2.2.10/tests/helpers.py 2023-10-26 23:49:27.000000000 +0200 @@ -412,7 +412,8 @@ 'from sys.objects where type in (\'%s\')' % '", "'.join(type) conn.execute_query(sql) for row in conn: - delete_sql.append(drop_sql % dict(row)) + if row['name'][0] not in ('#','@'): + delete_sql.append(drop_sql % dict(row)) for sql in delete_sql: conn.execute_non_query(sql) diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/pymssql-2.2.8/tests/test_query_parameters.py new/pymssql-2.2.10/tests/test_query_parameters.py --- old/pymssql-2.2.8/tests/test_query_parameters.py 2023-02-23 22:45:52.000000000 +0100 +++ new/pymssql-2.2.10/tests/test_query_parameters.py 1970-01-01 01:00:00.000000000 +0100 @@ -1,48 +0,0 @@ -# -*- coding: utf-8 -*- -""" -Test queries. -""" - -import unittest - -import pytest - -from .helpers import pymssqlconn, drop_table - - -@pytest.mark.mssql_server_required -class TestQueryParameters(unittest.TestCase): - - table_name = 'testtab' - - @classmethod - def setup_class(cls): - cls.conn = pymssqlconn(encryption='as') - drop_table(cls.conn, cls.table_name) - cls.createTestTable() - - @classmethod - def teardown_class(cls): - drop_table(cls.conn, cls.table_name) - cls.conn.close() - - @classmethod - def createTestTable(cls): - query = f"INSERT INTO {cls.table_name} (int_col, text_col) VALUES (%d, %s);" - with cls.conn.cursor() as c: - c.execute(""" - CREATE TABLE testtab ( - int_col int, - text_col text - )""") - for x in range(10): - c.execute(query, (x, f"Column {x}")) - - - def test_609(self): - with self.conn.cursor() as c: - #c.execute('SELECT * FROM testtab WHERE int_col=%d', (1,)) - c.execute(f'SELECT * FROM {self.table_name} WHERE int_col=%d', (0, )) - rows = c.fetchall() - print(f"AAAAAAAAAAAAAAAAAAA: {rows}") - self.assertEqual(len(rows), 1) diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/pymssql-2.2.8/tests/test_sqlalchemy.py new/pymssql-2.2.10/tests/test_sqlalchemy.py --- old/pymssql-2.2.8/tests/test_sqlalchemy.py 2023-07-31 00:21:30.000000000 +0200 +++ new/pymssql-2.2.10/tests/test_sqlalchemy.py 2023-10-26 23:49:27.000000000 +0200 @@ -13,8 +13,7 @@ import sqlalchemy as sa except ImportError: pytest.skip('SQLAlchemy is not available', allow_module_level=True) -from sqlalchemy.orm import sessionmaker -from sqlalchemy.ext.declarative import declarative_base +from sqlalchemy.orm import sessionmaker, declarative_base engine = sa.create_engine( 'mssql+pymssql://%s:%s@%s:%s/%s' % ( @@ -71,6 +70,6 @@ s = SAObj(name='foobar', data=['one']) self.sess.add(s) self.sess.commit() - res = self.sess.execute(sa.select([self.saotbl.c.data])) + res = self.sess.execute(sa.select(self.saotbl.c.data)) row = res.fetchone() - eq_(row['data'], ['one']) + eq_(row[0], ['one'])