v2.2.0rc1

Important changes

v2.2.0 uses pkg-config instead of mysql_config. You need to install pkg-config to build. You can configure cflags and ldflags manually by setting MYSQLCLIENT_CFLAGS and MYSQLCLIENT_LDFLAGS too.

Cursor.mogrify() is added.

Cursor.executemany implementation now uses mogrify(). Sequencee of scalar value (e.g. executemany("INSERT INTO t (data) VALUES (%s)", [1, 2, 3]) is no more valid args. You need to use sequence of tuple (e.g. [(1,), (2,), (3,)]) instead.

What's Changed

• Actions: Drop Python 3.6 and add 3.11-dev by @methane in #542
• docs: fix simple typo, portible -> portable by @timgates42 in #547
• Update python_requires to match supported python versions by @gopackgo90 in #543
• Raise ProgrammingError on -inf by @methane in #557
• Swap 3.11-dev for 3.11 in CI by @joshuadavidthomas in #561
• Add CodeQL workflow for GitHub code scanning by @lgtm-com in #565
• ER_BAD_NULL should be IntegrityError. by @methane in #579
• Update windows build workflow by @methane in #585
• Use pkg-config instead of mysql_config by @methane in #586
• Remove uneeded code. by @methane in #512
• Add collation option by @vsalvino in #564
• Start 2.2.0 development by @methane in #587
• Action: Use Ruff by @methane in #588
• Run pyupgrade --py38-plus by @methane in #590
• Update workflows by @methane in #593
• Update Django test workflow by @methane in #594
• CI: Update codeql build. by @methane in #595
• Improved exception handling when importing the module by @piglei in #596
• CI: Fix django workflow by @methane in #597
• Use pyproject.toml by @methane in #598
• Add Cursor.mogrify(). by @steveteahan in #477
• Add ability to customize ssl mode settings by @thereisnosun in #475
• Use src-layout. by @methane in #600
• Discard results without converting them into Python objects. by @methane in #601
• Fix sphinx warnings by @methane in #602
• Release GIL during result.discard() by @methane in #604
• Fix executemany with binary prefix by @methane in #605
• CI: Fix Django test by @methane in #606
• Fix Connection.escape() with Unicode input by @methane in #608
• fix: fix sslmode typo by @mschoettle in #609
• CI: Update Django test workflow by @methane in #610
• Release v2.2.0rc1 by @methane in #607

New Contributors

• @gopackgo90 made their first contribution in #543
• @joshuadavidthomas made their first contribution in #561
• @lgtm-com made their first contribution in #565
• @vsalvino made their first contribution in #564
• @piglei made their first contribution in #596
• @steveteahan made their first contribution in #477
• @thereisnosun made their first contribution in #475
• @mschoettle made their first contribution in #609

Full Changelog: v2.1.1...v2.2.0rc1