Bump pymysql from 0.9.2 to 1.1.1 in /webapp/python_sanic

[dependabot[bot]]

Bumps pymysql from 0.9.2 to 1.1.1.

Release notes

Sourced from pymysql's releases.

v1.1.1

[!WARNING] This release fixes a vulnerability (CVE-2024-36039). All users are recommended to update to this version.

If you can not update soon, check the input value from untrusted source has an expected type. Only dict input from untrusted source can be an attack vector.

What's Changed

• Prohibit dict parameter for Cursor.execute(). It didn't produce valid SQL and might cause SQL injection. (CVE-2024-36039)
• Added ssl_key_password param by @​svaskov in PyMySQL/PyMySQL#1145

Merged PRs

• Add support for Python 3.12 by @​hugovk in PyMySQL/PyMySQL#1134
• chore(deps): update actions/checkout action to v4 by @​renovate in PyMySQL/PyMySQL#1136
• Update codecov/codecov-action action to v4 by @​renovate in PyMySQL/PyMySQL#1137
• ci: use codecov@v3 by @​methane in PyMySQL/PyMySQL#1142
• chore(deps): update dessant/lock-threads action to v5 by @​renovate in PyMySQL/PyMySQL#1141
• doc: use rtd theme by @​methane in PyMySQL/PyMySQL#1143
• use Ruff as formatter by @​methane in PyMySQL/PyMySQL#1144
• chore(deps): update dependency sphinx-rtd-theme to v2 by @​renovate in PyMySQL/PyMySQL#1147
• chore(deps): update actions/setup-python action to v5 by @​renovate in PyMySQL/PyMySQL#1152
• chore(deps): update github/codeql-action action to v3 by @​renovate in PyMySQL/PyMySQL#1154
• chore(deps): update codecov/codecov-action action to v4 by @​renovate in PyMySQL/PyMySQL#1158
• Support error packet without sqlstate by @​methane in PyMySQL/PyMySQL#1160
• test json - mariadb without JSON type by @​grooverdan in PyMySQL/PyMySQL#1165

New Contributors

• @​hugovk made their first contribution in PyMySQL/PyMySQL#1134
• @​svaskov made their first contribution in PyMySQL/PyMySQL#1145

Full Changelog: https://github.com/PyMySQL/PyMySQL/compare/v1.1.0...v1.1.1

v1.1.0

What's Changed

• Remove redundant wheel dep from pyproject.toml by @​mgorny in PyMySQL/PyMySQL#1099
• ci: Fix black options by @​methane in PyMySQL/PyMySQL#1109
• Remove unused function by @​methane in PyMySQL/PyMySQL#1108
• Expose Cursor.warning_count by @​Nothing4You in PyMySQL/PyMySQL#1056
• Add constants and tests related to query timeouts by @​Nothing4You in PyMySQL/PyMySQL#1033
• Fix SSCursor raising query timeout error on wrong query on MySQL DB by @​Nothing4You in PyMySQL/PyMySQL#1035
• Make Cursor an iterator by @​sanchezg in PyMySQL/PyMySQL#995
• ci: Update CodeQL workflow by @​methane in PyMySQL/PyMySQL#1110
• Use Ruff instead of flake8 by @​methane in PyMySQL/PyMySQL#1112
• Use Codecov instead of coveralls. by @​methane in PyMySQL/PyMySQL#1113
• optionfile: Replace _ with - by @​methane in PyMySQL/PyMySQL#1114
• Cursor.fetchall() always return list. by @​methane in PyMySQL/PyMySQL#1115

... (truncated)

Changelog

Sourced from pymysql's changelog.

v1.1.1

Release date: 2024-05-21

[!WARNING] This release fixes a vulnerability (CVE-2024-36039). All users are recommended to update to this version.

If you can not update soon, check the input value from untrusted source has an expected type. Only dict input from untrusted source can be an attack vector.

• Prohibit dict parameter for Cursor.execute(). It didn't produce valid SQL and might cause SQL injection. (CVE-2024-36039)
• Added ssl_key_password param. #1145

v1.1.0

Release date: 2023-06-26

• Fixed SSCursor raising OperationalError for query timeouts on wrong statement (#1032)
• Exposed Cursor.warning_count to check for warnings without additional query (#1056)
• Make Cursor iterator (#995)
• Support '_' in key name in my.cnf (#1114)
• Cursor.fetchall() returns empty list instead of tuple (#1115). Note that Cursor.fetchmany() still return empty tuple after reading all rows for compatibility with Django.
• Deprecate Error classes in Cursor class (#1117)
• Add Connection.set_character_set(charset, collation=None). This method is compatible with mysqlclient. (#1119)
• Deprecate Connection.set_charset(charset) (#1119)
• New connection always send "SET NAMES charset [COLLATE collation]" query. (#1119) Since collation table is vary on MySQL server versions, collation in handshake is fragile.
• Support charset="utf8mb3" option (#1127)

v1.0.3

Release date: 2023-03-28

• Dropped support of end of life MySQL version 5.6
• Dropped support of end of life MariaDB versions below 10.3
• Dropped support of end of life Python version 3.6
• Removed _last_executed because of duplication with _executed by @​rajat315315 in PyMySQL/PyMySQL#948
• Fix generating authentication response with long strings by @​netch80 in PyMySQL/PyMySQL#988
• update pymysql.constants.CR by @​Nothing4You in PyMySQL/PyMySQL#1029
• Document that the ssl connection parameter can be an SSLContext by @​cakemanny in PyMySQL/PyMySQL#1045
• Raise ProgrammingError on -np.inf in addition to np.inf by @​cdcadman in PyMySQL/PyMySQL#1067
• Use Python 3.11 release instead of -dev in tests by @​Nothing4You in PyMySQL/PyMySQL#1076

v1.0.2

... (truncated)

Commits

• 2cab9ec v1.1.1
• 521e400 forbid dict parameter
• 7f032a6 remove coveralls from requirements
• 69f6c74 ruff format
• b4ed688 test json - mariadb without JSON type (#1165)
• bbd049f Support error packet without sqlstate (#1160)
• 9694747 pyupgrade
• 1f0b785 chore(deps): update codecov/codecov-action action to v4 (#1158)
• 1e28be8 chore(deps): update github/codeql-action action to v3 (#1154)
• f13f054 chore(deps): update actions/setup-python action to v5 (#1152)
• Additional commits viewable in compare view

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.

---

Dependabot commands and options

You can trigger Dependabot actions by commenting on this PR:

• @dependabot rebase will rebase this PR
• @dependabot recreate will recreate this PR, overwriting any edits that have been made to it
• @dependabot merge will merge this PR after your CI passes on it
• @dependabot squash and merge will squash and merge this PR after your CI passes on it
• @dependabot cancel merge will cancel a previously requested merge and block automerging
• @dependabot reopen will reopen this PR if it is closed
• @dependabot close will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually
• @dependabot show <dependency name> ignore conditions will show all of the ignore conditions of the specified dependency
• @dependabot ignore this major version will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)
• @dependabot ignore this minor version will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)
• @dependabot ignore this dependency will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself) You can disable automated security fix PRs for this repo from the Security Alerts page.