From dc96c20fa2ed56c469d8538c03bc193ce80a7c44 Mon Sep 17 00:00:00 2001
From: Oleg Broytman <phd@phdru.name>
Date: Wed, 26 Oct 2022 20:17:06 +0300
Subject: [PATCH] Tests, CI: Run tests with Python 3.11

---
 .github/workflows/run-tests.yaml |  2 +-
 docs/news.rst                    |  5 +++++
 setup.py                         |  5 +++--
 tox.ini                          | 12 ++++++------
 4 files changed, 15 insertions(+), 9 deletions(-)

diff --git a/.github/workflows/run-tests.yaml b/.github/workflows/run-tests.yaml
index aae7413..baafe49 100644
--- a/.github/workflows/run-tests.yaml
+++ b/.github/workflows/run-tests.yaml
@@ -8,7 +8,7 @@ jobs:
     strategy:
       matrix:
         os: [ubuntu-latest, windows-latest]
-        python-version: ["2.7", "3.5", "3.6", "3.7", "3.8", "3.9", "3.10"]
+        python-version: ["2.7", "3.5", "3.6", "3.7", "3.8", "3.9", "3.10", "3.11"]
         include:
         - os: ubuntu-latest
           os-name: Linux
diff --git a/docs/news.rst b/docs/news.rst
index d4ec879..a557348 100644
--- a/docs/news.rst
+++ b/docs/news.rst
@@ -1,6 +1,11 @@
 News
 ====
 
+Version 0.3.1 (in development)
+------------------------------
+
+* Python 3.11.
+
 Version 0.3.0 (2021-09-24)
 --------------------------
 
diff --git a/setup.py b/setup.py
index 2647b09..911b3ac 100755
--- a/setup.py
+++ b/setup.py
@@ -11,7 +11,7 @@ if sys.version_info[:2] == (2, 7):
     execfile(versionpath, sqlconvert_version)  # noqa: F821 'execfile' Py3
 
 elif sys.version_info >= (3, 4):
-    exec(open(versionpath, 'rU').read(), sqlconvert_version)
+    exec(open(versionpath, 'r').read(), sqlconvert_version)
 
 else:
     raise ImportError("sqlconvert requires Python 2.7 or 3.4+")
@@ -20,7 +20,7 @@ setup(
     name='sqlconvert',
     version=sqlconvert_version['__version__'],
     description='Broytman sqlconvert',
-    long_description=open('README.rst', 'rU').read(),
+    long_description=open('README.rst', 'r').read(),
     long_description_content_type="text/x-rst",
     author='Oleg Broytman',
     author_email='phd@phdru.name',
@@ -54,6 +54,7 @@ setup(
         'Programming Language :: Python :: 3.8',
         'Programming Language :: Python :: 3.9',
         'Programming Language :: Python :: 3.10',
+        'Programming Language :: Python :: 3.11',
     ],
     packages=['sqlconvert'],
     scripts=['scripts/mysql2sql'],
diff --git a/tox.ini b/tox.ini
index e9b04fc..6eaedf2 100644
--- a/tox.ini
+++ b/tox.ini
@@ -1,6 +1,6 @@
 [tox]
 minversion = 3.15
-envlist = py27,py3{4,5,6,7,8,9,10}{,-sqlite},py{27,39}-flake8
+envlist = py27,py3{4,5,6,7,8,9,10,11}{,-sqlite},py{27,36,311}-flake8
 
 # Base test environment settings
 [testenv]
@@ -18,7 +18,7 @@ whitelist_externals =
     createdb
     dropdb
 
-[testenv:{py27,py34,py35,py36,py37,py38,py39,py310}]
+[testenv:py{27,34,35,36,37,38,39,310,311}]
 commands =
     {[testenv]commands}
     {envpython} -m pytest
@@ -26,14 +26,14 @@ commands =
     cmp.py -i tests/mysql2sql/test.out test.out
     rm.py -f test.out
 
-[testenv:{py27,py34,py35,py36,py37,py38,py39,py310}-sqlite]
+[testenv:py{27,34,35,36,37,38,39,310,311}-sqlite]
 commands =
     {[testenv]commands}
     -rm.py -f /tmp/test.sqdb
     {envpython} -m pytest -D sqlite:///tmp/test.sqdb
     rm.py -f /tmp/test.sqdb
 
-[testenv:{py27,py34,py35,py36,py37,py38,py39,py310}-sqlite-w32]
+[testenv:py{27,34,35,36,37,38,39,310,311}-sqlite-w32]
 platform = win32
 commands =
     {[testenv]commands}
@@ -41,7 +41,7 @@ commands =
     pytest -D sqlite:/{env:TEMP}/test.sqdb?debug=1
     rm.py -f {env:TEMP}/test.sqdb
 
-[testenv:{py27,py34,py35,py36,py37,py38,py39,py310}-postgres{,-w32}]
+[testenv:py{27,34,35,36,37,38,39,310,311}-postgres{,-w32}]
 commands =
     {[testenv]commands}
     -dropdb --username=runner test
@@ -50,7 +50,7 @@ commands =
     dropdb --username=runner test
 
 # flake8
-[testenv:{py27,py34,py35,py36,py37,py38,py39,py310}-flake8]
+[testenv:py{27,34,35,36,37,38,39,310,311}-flake8]
 deps =
     flake8
     pytest < 7.0
-- 
2.39.5