Bump pymysql from 0.9.3 to 1.1.1 in /src #1

Open
opened 2025-10-14 17:23:58 -06:00 by navan · 0 comments
Owner

Originally created by @dependabot[bot] on 5/21/2024

Bumps pymysql from 0.9.3 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

New Contributors

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

v1.1.0

What's Changed

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

v1.0.2

... (truncated)

Commits

Dependabot compatibility score

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.
*Originally created by @dependabot[bot] on 5/21/2024* Bumps [pymysql](https://github.com/PyMySQL/PyMySQL) from 0.9.3 to 1.1.1. <details> <summary>Release notes</summary> <p><em>Sourced from <a href="https://github.com/PyMySQL/PyMySQL/releases">pymysql's releases</a>.</em></p> <blockquote> <h2>v1.1.1</h2> <blockquote> <p>[!WARNING] This release fixes a vulnerability (CVE-2024-36039). All users are recommended to update to this version.</p> <p>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.</p> </blockquote> <h2>What's Changed</h2> <ul> <li>Prohibit dict parameter for <code>Cursor.execute()</code>. It didn't produce valid SQL and might cause SQL injection. (CVE-2024-36039)</li> <li>Added ssl_key_password param by <a href="https://github.com/svaskov"><code>@​svaskov</code></a> in <a href="https://redirect.github.com/PyMySQL/PyMySQL/pull/1145">PyMySQL/PyMySQL#1145</a></li> </ul> <h2>Merged PRs</h2> <ul> <li>Add support for Python 3.12 by <a href="https://github.com/hugovk"><code>@​hugovk</code></a> in <a href="https://redirect.github.com/PyMySQL/PyMySQL/pull/1134">PyMySQL/PyMySQL#1134</a></li> <li>chore(deps): update actions/checkout action to v4 by <a href="https://github.com/renovate"><code>@​renovate</code></a> in <a href="https://redirect.github.com/PyMySQL/PyMySQL/pull/1136">PyMySQL/PyMySQL#1136</a></li> <li>Update codecov/codecov-action action to v4 by <a href="https://github.com/renovate"><code>@​renovate</code></a> in <a href="https://redirect.github.com/PyMySQL/PyMySQL/pull/1137">PyMySQL/PyMySQL#1137</a></li> <li>ci: use codecov@v3 by <a href="https://github.com/methane"><code>@​methane</code></a> in <a href="https://redirect.github.com/PyMySQL/PyMySQL/pull/1142">PyMySQL/PyMySQL#1142</a></li> <li>chore(deps): update dessant/lock-threads action to v5 by <a href="https://github.com/renovate"><code>@​renovate</code></a> in <a href="https://redirect.github.com/PyMySQL/PyMySQL/pull/1141">PyMySQL/PyMySQL#1141</a></li> <li>doc: use rtd theme by <a href="https://github.com/methane"><code>@​methane</code></a> in <a href="https://redirect.github.com/PyMySQL/PyMySQL/pull/1143">PyMySQL/PyMySQL#1143</a></li> <li>use Ruff as formatter by <a href="https://github.com/methane"><code>@​methane</code></a> in <a href="https://redirect.github.com/PyMySQL/PyMySQL/pull/1144">PyMySQL/PyMySQL#1144</a></li> <li>chore(deps): update dependency sphinx-rtd-theme to v2 by <a href="https://github.com/renovate"><code>@​renovate</code></a> in <a href="https://redirect.github.com/PyMySQL/PyMySQL/pull/1147">PyMySQL/PyMySQL#1147</a></li> <li>chore(deps): update actions/setup-python action to v5 by <a href="https://github.com/renovate"><code>@​renovate</code></a> in <a href="https://redirect.github.com/PyMySQL/PyMySQL/pull/1152">PyMySQL/PyMySQL#1152</a></li> <li>chore(deps): update github/codeql-action action to v3 by <a href="https://github.com/renovate"><code>@​renovate</code></a> in <a href="https://redirect.github.com/PyMySQL/PyMySQL/pull/1154">PyMySQL/PyMySQL#1154</a></li> <li>chore(deps): update codecov/codecov-action action to v4 by <a href="https://github.com/renovate"><code>@​renovate</code></a> in <a href="https://redirect.github.com/PyMySQL/PyMySQL/pull/1158">PyMySQL/PyMySQL#1158</a></li> <li>Support error packet without sqlstate by <a href="https://github.com/methane"><code>@​methane</code></a> in <a href="https://redirect.github.com/PyMySQL/PyMySQL/pull/1160">PyMySQL/PyMySQL#1160</a></li> <li>test json - mariadb without JSON type by <a href="https://github.com/grooverdan"><code>@​grooverdan</code></a> in <a href="https://redirect.github.com/PyMySQL/PyMySQL/pull/1165">PyMySQL/PyMySQL#1165</a></li> </ul> <h2>New Contributors</h2> <ul> <li><a href="https://github.com/hugovk"><code>@​hugovk</code></a> made their first contribution in <a href="https://redirect.github.com/PyMySQL/PyMySQL/pull/1134">PyMySQL/PyMySQL#1134</a></li> <li><a href="https://github.com/svaskov"><code>@​svaskov</code></a> made their first contribution in <a href="https://redirect.github.com/PyMySQL/PyMySQL/pull/1145">PyMySQL/PyMySQL#1145</a></li> </ul> <p><strong>Full Changelog</strong>: <a href="https://github.com/PyMySQL/PyMySQL/compare/v1.1.0...v1.1.1">https://github.com/PyMySQL/PyMySQL/compare/v1.1.0...v1.1.1</a></p> <h2>v1.1.0</h2> <h2>What's Changed</h2> <ul> <li>Remove redundant wheel dep from pyproject.toml by <a href="https://github.com/mgorny"><code>@​mgorny</code></a> in <a href="https://redirect.github.com/PyMySQL/PyMySQL/pull/1099">PyMySQL/PyMySQL#1099</a></li> <li>ci: Fix black options by <a href="https://github.com/methane"><code>@​methane</code></a> in <a href="https://redirect.github.com/PyMySQL/PyMySQL/pull/1109">PyMySQL/PyMySQL#1109</a></li> <li>Remove unused function by <a href="https://github.com/methane"><code>@​methane</code></a> in <a href="https://redirect.github.com/PyMySQL/PyMySQL/pull/1108">PyMySQL/PyMySQL#1108</a></li> <li>Expose <code>Cursor.warning_count</code> by <a href="https://github.com/Nothing4You"><code>@​Nothing4You</code></a> in <a href="https://redirect.github.com/PyMySQL/PyMySQL/pull/1056">PyMySQL/PyMySQL#1056</a></li> <li>Add constants and tests related to query timeouts by <a href="https://github.com/Nothing4You"><code>@​Nothing4You</code></a> in <a href="https://redirect.github.com/PyMySQL/PyMySQL/pull/1033">PyMySQL/PyMySQL#1033</a></li> <li>Fix SSCursor raising query timeout error on wrong query on MySQL DB by <a href="https://github.com/Nothing4You"><code>@​Nothing4You</code></a> in <a href="https://redirect.github.com/PyMySQL/PyMySQL/pull/1035">PyMySQL/PyMySQL#1035</a></li> <li>Make Cursor an iterator by <a href="https://github.com/sanchezg"><code>@​sanchezg</code></a> in <a href="https://redirect.github.com/PyMySQL/PyMySQL/pull/995">PyMySQL/PyMySQL#995</a></li> <li>ci: Update CodeQL workflow by <a href="https://github.com/methane"><code>@​methane</code></a> in <a href="https://redirect.github.com/PyMySQL/PyMySQL/pull/1110">PyMySQL/PyMySQL#1110</a></li> <li>Use Ruff instead of flake8 by <a href="https://github.com/methane"><code>@​methane</code></a> in <a href="https://redirect.github.com/PyMySQL/PyMySQL/pull/1112">PyMySQL/PyMySQL#1112</a></li> <li>Use Codecov instead of coveralls. by <a href="https://github.com/methane"><code>@​methane</code></a> in <a href="https://redirect.github.com/PyMySQL/PyMySQL/pull/1113">PyMySQL/PyMySQL#1113</a></li> <li>optionfile: Replace <code>_</code> with <code>-</code> by <a href="https://github.com/methane"><code>@​methane</code></a> in <a href="https://redirect.github.com/PyMySQL/PyMySQL/pull/1114">PyMySQL/PyMySQL#1114</a></li> <li>Cursor.fetchall() always return list. by <a href="https://github.com/methane"><code>@​methane</code></a> in <a href="https://redirect.github.com/PyMySQL/PyMySQL/pull/1115">PyMySQL/PyMySQL#1115</a></li> </ul> <!-- raw HTML omitted --> </blockquote> <p>... (truncated)</p> </details> <details> <summary>Changelog</summary> <p><em>Sourced from <a href="https://github.com/PyMySQL/PyMySQL/blob/main/CHANGELOG.md">pymysql's changelog</a>.</em></p> <blockquote> <h2>v1.1.1</h2> <p>Release date: 2024-05-21</p> <blockquote> <p>[!WARNING] This release fixes a vulnerability (CVE-2024-36039). All users are recommended to update to this version.</p> <p>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.</p> </blockquote> <ul> <li>Prohibit dict parameter for <code>Cursor.execute()</code>. It didn't produce valid SQL and might cause SQL injection. (CVE-2024-36039)</li> <li>Added ssl_key_password param. <a href="https://redirect.github.com/PyMySQL/PyMySQL/issues/1145">#1145</a></li> </ul> <h2>v1.1.0</h2> <p>Release date: 2023-06-26</p> <ul> <li>Fixed SSCursor raising OperationalError for query timeouts on wrong statement (<a href="https://redirect.github.com/PyMySQL/PyMySQL/issues/1032">#1032</a>)</li> <li>Exposed <code>Cursor.warning_count</code> to check for warnings without additional query (<a href="https://redirect.github.com/PyMySQL/PyMySQL/issues/1056">#1056</a>)</li> <li>Make Cursor iterator (<a href="https://redirect.github.com/PyMySQL/PyMySQL/issues/995">#995</a>)</li> <li>Support '_' in key name in my.cnf (<a href="https://redirect.github.com/PyMySQL/PyMySQL/issues/1114">#1114</a>)</li> <li><code>Cursor.fetchall()</code> returns empty list instead of tuple (<a href="https://redirect.github.com/PyMySQL/PyMySQL/issues/1115">#1115</a>). Note that <code>Cursor.fetchmany()</code> still return empty tuple after reading all rows for compatibility with Django.</li> <li>Deprecate Error classes in Cursor class (<a href="https://redirect.github.com/PyMySQL/PyMySQL/issues/1117">#1117</a>)</li> <li>Add <code>Connection.set_character_set(charset, collation=None)</code>. This method is compatible with mysqlclient. (<a href="https://redirect.github.com/PyMySQL/PyMySQL/issues/1119">#1119</a>)</li> <li>Deprecate <code>Connection.set_charset(charset)</code> (<a href="https://redirect.github.com/PyMySQL/PyMySQL/issues/1119">#1119</a>)</li> <li>New connection always send &quot;SET NAMES charset [COLLATE collation]&quot; query. (<a href="https://redirect.github.com/PyMySQL/PyMySQL/issues/1119">#1119</a>) Since collation table is vary on MySQL server versions, collation in handshake is fragile.</li> <li>Support <code>charset=&quot;utf8mb3&quot;</code> option (<a href="https://redirect.github.com/PyMySQL/PyMySQL/issues/1127">#1127</a>)</li> </ul> <h2>v1.0.3</h2> <p>Release date: 2023-03-28</p> <ul> <li>Dropped support of end of life MySQL version 5.6</li> <li>Dropped support of end of life MariaDB versions below 10.3</li> <li>Dropped support of end of life Python version 3.6</li> <li>Removed <code>_last_executed</code> because of duplication with <code>_executed</code> by <a href="https://github.com/rajat315315"><code>@​rajat315315</code></a> in <a href="https://redirect.github.com/PyMySQL/PyMySQL/pull/948">PyMySQL/PyMySQL#948</a></li> <li>Fix generating authentication response with long strings by <a href="https://github.com/netch80"><code>@​netch80</code></a> in <a href="https://redirect.github.com/PyMySQL/PyMySQL/pull/988">PyMySQL/PyMySQL#988</a></li> <li>update pymysql.constants.CR by <a href="https://github.com/Nothing4You"><code>@​Nothing4You</code></a> in <a href="https://redirect.github.com/PyMySQL/PyMySQL/pull/1029">PyMySQL/PyMySQL#1029</a></li> <li>Document that the ssl connection parameter can be an SSLContext by <a href="https://github.com/cakemanny"><code>@​cakemanny</code></a> in <a href="https://redirect.github.com/PyMySQL/PyMySQL/pull/1045">PyMySQL/PyMySQL#1045</a></li> <li>Raise ProgrammingError on -np.inf in addition to np.inf by <a href="https://github.com/cdcadman"><code>@​cdcadman</code></a> in <a href="https://redirect.github.com/PyMySQL/PyMySQL/pull/1067">PyMySQL/PyMySQL#1067</a></li> <li>Use Python 3.11 release instead of -dev in tests by <a href="https://github.com/Nothing4You"><code>@​Nothing4You</code></a> in <a href="https://redirect.github.com/PyMySQL/PyMySQL/pull/1076">PyMySQL/PyMySQL#1076</a></li> </ul> <h2>v1.0.2</h2> <!-- raw HTML omitted --> </blockquote> <p>... (truncated)</p> </details> <details> <summary>Commits</summary> <ul> <li><a href="https://github.com/PyMySQL/PyMySQL/commit/2cab9ecc641e962565c6254a5091f90c47f59b35"><code>2cab9ec</code></a> v1.1.1</li> <li><a href="https://github.com/PyMySQL/PyMySQL/commit/521e40050cb386a499f68f483fefd144c493053c"><code>521e400</code></a> forbid dict parameter</li> <li><a href="https://github.com/PyMySQL/PyMySQL/commit/7f032a699d55340f05101deb4d7d4f63db4adc11"><code>7f032a6</code></a> remove coveralls from requirements</li> <li><a href="https://github.com/PyMySQL/PyMySQL/commit/69f6c7439bee14784e0ea70ae107af6446cc0c67"><code>69f6c74</code></a> ruff format</li> <li><a href="https://github.com/PyMySQL/PyMySQL/commit/b4ed6884a1105df0a27f948f52b3e81d5585634f"><code>b4ed688</code></a> test json - mariadb without JSON type (<a href="https://redirect.github.com/PyMySQL/PyMySQL/issues/1165">#1165</a>)</li> <li><a href="https://github.com/PyMySQL/PyMySQL/commit/bbd049f40db9c696574ce6f31669880042c56d79"><code>bbd049f</code></a> Support error packet without sqlstate (<a href="https://redirect.github.com/PyMySQL/PyMySQL/issues/1160">#1160</a>)</li> <li><a href="https://github.com/PyMySQL/PyMySQL/commit/9694747ae619e88b792a8e0b4c08036572452584"><code>9694747</code></a> pyupgrade</li> <li><a href="https://github.com/PyMySQL/PyMySQL/commit/1f0b7856de4008e7e4c1e8c1b215d5d4dfaecd1a"><code>1f0b785</code></a> chore(deps): update codecov/codecov-action action to v4 (<a href="https://redirect.github.com/PyMySQL/PyMySQL/issues/1158">#1158</a>)</li> <li><a href="https://github.com/PyMySQL/PyMySQL/commit/1e28be81c24dde66f8acbf4c5e24f60d6b5e72e7"><code>1e28be8</code></a> chore(deps): update github/codeql-action action to v3 (<a href="https://redirect.github.com/PyMySQL/PyMySQL/issues/1154">#1154</a>)</li> <li><a href="https://github.com/PyMySQL/PyMySQL/commit/f13f054abcc18b39855a760a84be0a517f0da658"><code>f13f054</code></a> chore(deps): update actions/setup-python action to v5 (<a href="https://redirect.github.com/PyMySQL/PyMySQL/issues/1152">#1152</a>)</li> <li>Additional commits viewable in <a href="https://github.com/PyMySQL/PyMySQL/compare/v0.9.3...v1.1.1">compare view</a></li> </ul> </details> <br /> [![Dependabot compatibility score](https://dependabot-badges.githubapp.com/badges/compatibility_score?dependency-name=pymysql&package-manager=pip&previous-version=0.9.3&new-version=1.1.1)](https://docs.github.com/en/github/managing-security-vulnerabilities/about-dependabot-security-updates#about-compatibility-scores) 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-automerge-start) [//]: # (dependabot-automerge-end) --- <details> <summary>Dependabot commands and options</summary> <br /> 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](https://github.com/keiffster/program-y/network/alerts). </details>
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference: github/program-y#1
No description provided.