René's URL Explorer Experiment


Title: gh-79009: sqlite3.iterdump now correctly handles tables with autoincrement by itssme · Pull Request #9621 · python/cpython · GitHub

Open Graph Title: gh-79009: sqlite3.iterdump now correctly handles tables with autoincrement by itssme · Pull Request #9621 · python/cpython

X Title: gh-79009: sqlite3.iterdump now correctly handles tables with autoincrement by itssme · Pull Request #9621 · python/cpython

Description: The iterdump command in Lib/sqlite3/dump.py assumed that the table "sqlite_sequence" already exists. When this was not the case and exception was thrown. Changes: Sqlite3 iterdump now deletes and recreates the "sqlite_sequence" table at the end of the transaction (Just like the sqlite3 command ".dump" does) Added two new test for the iterdump command Resolves gh-79009

Open Graph Description: The iterdump command in Lib/sqlite3/dump.py assumed that the table "sqlite_sequence" already exists. When this was not the case and exception was thrown. Changes: Sqlite3 iterdump now de...

X Description: The iterdump command in Lib/sqlite3/dump.py assumed that the table "sqlite_sequence" already exists. When this was not the case and exception was thrown. Changes: Sqlite3 iterdum...

Opengraph URL: https://github.com/python/cpython/pull/9621

X: @github

direct link

Domain: github.com

route-pattern/:user_id/:repository/pull/:id/files(.:format)
route-controllerpull_requests
route-actionfiles
fetch-noncev2:0497f046-8f39-6f43-80a1-400e3b6e3edd
current-catalog-service-hashae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b
request-idC2AE:4BD90:11C4D06:18D7EFE:696A3924
html-safe-nonce5661adf43bc4bac5bf456889ab80309d372d94cb56b3315a9396ca32a97b029c
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJDMkFFOjRCRDkwOjExQzREMDY6MThEN0VGRTo2OTZBMzkyNCIsInZpc2l0b3JfaWQiOiI2NjEzMjU0NzU5OTc0MDU4Mjc2IiwicmVnaW9uX2VkZ2UiOiJpYWQiLCJyZWdpb25fcmVuZGVyIjoiaWFkIn0=
visitor-hmac1c2c7c225f0a707bd91cafa3f3fe9bd0421ddcb314fc8fffd2d7f44bebc42efc
hovercard-subject-tagpull_request:218961325
github-keyboard-shortcutsrepository,pull-request-list,pull-request-conversation,pull-request-files-changed,copilot
google-site-verificationApib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-urlhttps://collector.github.com/github/collect
analytics-location///pull_requests/show/files
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/python/cpython/pull/9621/files
twitter:imagehttps://avatars.githubusercontent.com/u/23434503?s=400&v=4
twitter:cardsummary_large_image
og:imagehttps://avatars.githubusercontent.com/u/23434503?s=400&v=4
og:image:altThe iterdump command in Lib/sqlite3/dump.py assumed that the table "sqlite_sequence" already exists. When this was not the case and exception was thrown. Changes: Sqlite3 iterdump now de...
og:site_nameGitHub
og:typeobject
hostnamegithub.com
expected-hostnamegithub.com
None321736bfdb3f591415ae895a0459bec204b26a76caf47ba5c980634cfacc4538
turbo-cache-controlno-preview
diff-viewunified
go-importgithub.com/python/cpython git https://github.com/python/cpython.git
octolytics-dimension-user_id1525981
octolytics-dimension-user_loginpython
octolytics-dimension-repository_id81598961
octolytics-dimension-repository_nwopython/cpython
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id81598961
octolytics-dimension-repository_network_root_nwopython/cpython
turbo-body-classeslogged-out env-production page-responsive full-width
disable-turbotrue
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
release7a9163cefd1ea4bd06f8eb7c082f43e4e53f626f
ui-targetfull
theme-color#1e2327
color-schemelight dark

Links:

Skip to contenthttps://github.com/python/cpython/pull/9621/files#start-of-content
https://github.com/
Sign in https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fpython%2Fcpython%2Fpull%2F9621%2Ffiles
GitHub CopilotWrite better code with AIhttps://github.com/features/copilot
GitHub SparkBuild and deploy intelligent appshttps://github.com/features/spark
GitHub ModelsManage and compare promptshttps://github.com/features/models
MCP RegistryNewIntegrate external toolshttps://github.com/mcp
ActionsAutomate any workflowhttps://github.com/features/actions
CodespacesInstant dev environmentshttps://github.com/features/codespaces
IssuesPlan and track workhttps://github.com/features/issues
Code ReviewManage code changeshttps://github.com/features/code-review
GitHub Advanced SecurityFind and fix vulnerabilitieshttps://github.com/security/advanced-security
Code securitySecure your code as you buildhttps://github.com/security/advanced-security/code-security
Secret protectionStop leaks before they starthttps://github.com/security/advanced-security/secret-protection
Why GitHubhttps://github.com/why-github
Documentationhttps://docs.github.com
Bloghttps://github.blog
Changeloghttps://github.blog/changelog
Marketplacehttps://github.com/marketplace
View all featureshttps://github.com/features
Enterpriseshttps://github.com/enterprise
Small and medium teamshttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
App Modernizationhttps://github.com/solutions/use-case/app-modernization
DevSecOpshttps://github.com/solutions/use-case/devsecops
DevOpshttps://github.com/solutions/use-case/devops
CI/CDhttps://github.com/solutions/use-case/ci-cd
View all use caseshttps://github.com/solutions/use-case
Healthcarehttps://github.com/solutions/industry/healthcare
Financial serviceshttps://github.com/solutions/industry/financial-services
Manufacturinghttps://github.com/solutions/industry/manufacturing
Governmenthttps://github.com/solutions/industry/government
View all industrieshttps://github.com/solutions/industry
View all solutionshttps://github.com/solutions
AIhttps://github.com/resources/articles?topic=ai
Software Developmenthttps://github.com/resources/articles?topic=software-development
DevOpshttps://github.com/resources/articles?topic=devops
Securityhttps://github.com/resources/articles?topic=security
View all topicshttps://github.com/resources/articles
Customer storieshttps://github.com/customer-stories
Events & webinarshttps://github.com/resources/events
Ebooks & reportshttps://github.com/resources/whitepapers
Business insightshttps://github.com/solutions/executive-insights
GitHub Skillshttps://skills.github.com
Documentationhttps://docs.github.com
Customer supporthttps://support.github.com
Community forumhttps://github.com/orgs/community/discussions
Trust centerhttps://github.com/trust-center
Partnershttps://github.com/partners
GitHub SponsorsFund open source developershttps://github.com/sponsors
Security Labhttps://securitylab.github.com
Maintainer Communityhttps://maintainers.github.com
Acceleratorhttps://github.com/accelerator
Archive Programhttps://archiveprogram.github.com
Topicshttps://github.com/topics
Trendinghttps://github.com/trending
Collectionshttps://github.com/collections
Enterprise platformAI-powered developer platformhttps://github.com/enterprise
GitHub Advanced SecurityEnterprise-grade security featureshttps://github.com/security/advanced-security
Copilot for BusinessEnterprise-grade AI featureshttps://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 supporthttps://github.com/premium-support
Pricinghttps://github.com/pricing
Search syntax tipshttps://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
documentationhttps://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
Sign in https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fpython%2Fcpython%2Fpull%2F9621%2Ffiles
Sign up https://github.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E%2Fpull_requests%2Fshow%2Ffiles&source=header-repo&source_repo=python%2Fcpython
Reloadhttps://github.com/python/cpython/pull/9621/files
Reloadhttps://github.com/python/cpython/pull/9621/files
Reloadhttps://github.com/python/cpython/pull/9621/files
python https://github.com/python
cpythonhttps://github.com/python/cpython
Please reload this pagehttps://github.com/python/cpython/pull/9621/files
Notifications https://github.com/login?return_to=%2Fpython%2Fcpython
Fork 33.9k https://github.com/login?return_to=%2Fpython%2Fcpython
Star 71.1k https://github.com/login?return_to=%2Fpython%2Fcpython
Code https://github.com/python/cpython
Issues 5k+ https://github.com/python/cpython/issues
Pull requests 2.1k https://github.com/python/cpython/pulls
Actions https://github.com/python/cpython/actions
Projects 31 https://github.com/python/cpython/projects
Security Uh oh! There was an error while loading. Please reload this page. https://github.com/python/cpython/security
Please reload this pagehttps://github.com/python/cpython/pull/9621/files
Insights https://github.com/python/cpython/pulse
Code https://github.com/python/cpython
Issues https://github.com/python/cpython/issues
Pull requests https://github.com/python/cpython/pulls
Actions https://github.com/python/cpython/actions
Projects https://github.com/python/cpython/projects
Security https://github.com/python/cpython/security
Insights https://github.com/python/cpython/pulse
Sign up for GitHub https://github.com/signup?return_to=%2Fpython%2Fcpython%2Fissues%2Fnew%2Fchoose
terms of servicehttps://docs.github.com/terms
privacy statementhttps://docs.github.com/privacy
Sign inhttps://github.com/login?return_to=%2Fpython%2Fcpython%2Fissues%2Fnew%2Fchoose
erlend-aaslandhttps://github.com/erlend-aasland
python:mainhttps://github.com/python/cpython/tree/main
itssme:fix-issue-34828https://github.com/itssme/cpython/tree/fix-issue-34828
Conversation 35 https://github.com/python/cpython/pull/9621
Commits 15 https://github.com/python/cpython/pull/9621/commits
Checks 0 https://github.com/python/cpython/pull/9621/checks
Files changed https://github.com/python/cpython/pull/9621/files
Please reload this pagehttps://github.com/python/cpython/pull/9621/files
gh-79009: sqlite3.iterdump now correctly handles tables with autoincrement https://github.com/python/cpython/pull/9621/files#top
Show all changes 15 commits https://github.com/python/cpython/pull/9621/files
9bf9eb7 bpo-34828 sqlite3.iterdump now correctly handles tables with autoincr… itssme Sep 28, 2018 https://github.com/python/cpython/pull/9621/commits/9bf9eb7b5b2a9f174da7073826c9ca98d6c21b50
5d7b0ae bpo-34828: added entry in NEWS.d/next/Library and in ACKS itssme Sep 28, 2018 https://github.com/python/cpython/pull/9621/commits/5d7b0aede8fe635f6e1782f1cefde08cde303278
1ac20b0 Merge remote-tracking branch 'origin/master' into fix-issue-34828 itssme Jul 3, 2021 https://github.com/python/cpython/pull/9621/commits/1ac20b0825f256706bff5b48e86e80ed0621e3e4
365a2f1 bpo-34828 Removed redundant code and made some small formatting chang… itssme Jul 3, 2021 https://github.com/python/cpython/pull/9621/commits/365a2f1a683aaf0dce16a951e75506bd1f5cde1d
7c5901b Merge branch 'main' into fix-issue-34828 itssme Oct 15, 2021 https://github.com/python/cpython/pull/9621/commits/7c5901b6d45b823899981922cdae13354160f43b
b259219 bpo-34828 formatting changes as well as readability improvements in s… itssme Oct 15, 2021 https://github.com/python/cpython/pull/9621/commits/b2592197a23fe0c47faa4811eafe397401cb52e2
3812bf6 Merge branch 'main' into fix-issue-34828 itssme May 22, 2022 https://github.com/python/cpython/pull/9621/commits/3812bf6e01e2dc6083a94d02c065ae800d872e06
daed6e5 bpo-34828: reformatted some tests in test_sqlite3/test.dump.py as wel… itssme May 22, 2022 https://github.com/python/cpython/pull/9621/commits/daed6e50fc65ef27a64d1be6fc3440e1ec884bfb
d5daa91 Merge branch 'main' into fix-issue-34828 erlend-aasland Jun 9, 2022 https://github.com/python/cpython/pull/9621/commits/d5daa91959e351e2cde7c1503970d97818d48e34
4e573e9 bpo-34828: minified test case for some sqlite3 dump command tests, fi… itssme Jun 17, 2022 https://github.com/python/cpython/pull/9621/commits/4e573e9c12c32cedbe64a2be5cfdc9a4d1e97a36
64f4101 Merge branch 'main' into fix-issue-34828 erlend-aasland Jun 19, 2022 https://github.com/python/cpython/pull/9621/commits/64f410179f31922a49c99b94419f81cf2985d260
1abc7d0 Clean up dump.py erlend-aasland Jun 19, 2022 https://github.com/python/cpython/pull/9621/commits/1abc7d05b7a605224611a09eaa74e50ef1cc38e1
6bfac7e Cleanup: don't use abbreviated link in NEWS entry erlend-aasland Jun 19, 2022 https://github.com/python/cpython/pull/9621/commits/6bfac7e03aee3104c49c0c45e32933ad042faf30
103c50f Cleanup: tests erlend-aasland Jun 19, 2022 https://github.com/python/cpython/pull/9621/commits/103c50ffdcfe454a89fed09586524244cde68bdd
53076e9 Fix 1abc7d05b7a605224611a09eaa74e50ef1cc38e1 erlend-aasland Jun 19, 2022 https://github.com/python/cpython/pull/9621/commits/53076e91daee6639c9d6400741c2ee581997d677
Clear filters https://github.com/python/cpython/pull/9621/files
Please reload this pagehttps://github.com/python/cpython/pull/9621/files
Please reload this pagehttps://github.com/python/cpython/pull/9621/files
dump.py https://github.com/python/cpython/pull/9621/files#diff-445686d2c16ed3989d2adeac33729d1b06765dcf315f117fe8668be101b1e269
test_dump.py https://github.com/python/cpython/pull/9621/files#diff-4a893d9d2b972b194d731d3119eacb880e7eac1f3d25822b07a4dd8e04fd2b7c
ACKS https://github.com/python/cpython/pull/9621/files#diff-d1243956feb505c5459fc05387e194609efb5c350cee202942be47ed30d7d7d0
2018-09-28-22-18-03.bpo-34828.5Zyi_S.rst https://github.com/python/cpython/pull/9621/files#diff-1323ff4ef95685c6ad437d928546c8af6a755b84e4e94fc7faffdaa384f2ae48
https://github.com/python/cpython/blob/main/.github/CODEOWNERS#L578
Lib/sqlite3/dump.pyhttps://github.com/python/cpython/pull/9621/files#diff-445686d2c16ed3989d2adeac33729d1b06765dcf315f117fe8668be101b1e269
View file https://github.com/itssme/cpython/blob/53076e91daee6639c9d6400741c2ee581997d677/Lib/sqlite3/dump.py
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/python/cpython/pull/9621/{{ revealButtonHref }}
https://github.com/python/cpython/pull/9621/files#diff-445686d2c16ed3989d2adeac33729d1b06765dcf315f117fe8668be101b1e269
https://github.com/python/cpython/pull/9621/files#diff-445686d2c16ed3989d2adeac33729d1b06765dcf315f117fe8668be101b1e269
https://github.com/python/cpython/pull/9621/files#diff-445686d2c16ed3989d2adeac33729d1b06765dcf315f117fe8668be101b1e269
https://github.com/python/cpython/blob/main/.github/CODEOWNERS#L579
Lib/test/test_sqlite3/test_dump.pyhttps://github.com/python/cpython/pull/9621/files#diff-4a893d9d2b972b194d731d3119eacb880e7eac1f3d25822b07a4dd8e04fd2b7c
View file https://github.com/itssme/cpython/blob/53076e91daee6639c9d6400741c2ee581997d677/Lib/test/test_sqlite3/test_dump.py
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/python/cpython/pull/9621/{{ revealButtonHref }}
https://github.com/python/cpython/pull/9621/files#diff-4a893d9d2b972b194d731d3119eacb880e7eac1f3d25822b07a4dd8e04fd2b7c
https://github.com/python/cpython/pull/9621/files#diff-4a893d9d2b972b194d731d3119eacb880e7eac1f3d25822b07a4dd8e04fd2b7c
https://github.com/python/cpython/pull/9621/files#diff-4a893d9d2b972b194d731d3119eacb880e7eac1f3d25822b07a4dd8e04fd2b7c
https://github.com/python/cpython/pull/9621/files#diff-4a893d9d2b972b194d731d3119eacb880e7eac1f3d25822b07a4dd8e04fd2b7c
Misc/ACKShttps://github.com/python/cpython/pull/9621/files#diff-d1243956feb505c5459fc05387e194609efb5c350cee202942be47ed30d7d7d0
View file https://github.com/itssme/cpython/blob/53076e91daee6639c9d6400741c2ee581997d677/Misc/ACKS
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/python/cpython/pull/9621/{{ revealButtonHref }}
https://github.com/python/cpython/pull/9621/files#diff-d1243956feb505c5459fc05387e194609efb5c350cee202942be47ed30d7d7d0
https://github.com/python/cpython/pull/9621/files#diff-d1243956feb505c5459fc05387e194609efb5c350cee202942be47ed30d7d7d0
Misc/NEWS.d/next/Library/2018-09-28-22-18-03.bpo-34828.5Zyi_S.rsthttps://github.com/python/cpython/pull/9621/files#diff-1323ff4ef95685c6ad437d928546c8af6a755b84e4e94fc7faffdaa384f2ae48
View file https://github.com/itssme/cpython/blob/53076e91daee6639c9d6400741c2ee581997d677/Misc/NEWS.d/next/Library/2018-09-28-22-18-03.bpo-34828.5Zyi_S.rst
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/python/cpython/pull/9621/{{ revealButtonHref }}
https://github.com
Termshttps://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacyhttps://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Securityhttps://github.com/security
Statushttps://www.githubstatus.com/
Communityhttps://github.community/
Docshttps://docs.github.com/
Contacthttps://support.github.com?tags=dotcom-footer

Viewport: width=device-width


URLs of crawlers that visited me.