[3.10] Docs: Escape lone stars in sqlite3 docs (GH-96081). (#96085)

(cherry picked from commit 91afe66707237558d808aeca4683d0822aa0511e)

Co-authored-by: Erlend E. Aasland <erlend.aasland@protonmail.com>

gh-95271: Rework sqlite3 tutorial (GH-95749)

Co-authored-by: C.A.M. Gerlach <CAM.Gerlach@Gerlach.CAM>
Co-authored-by: Ezio Melotti <ezio.melotti@gmail.com>
(cherry picked from commit c87ea10fc91f040822ab3eed2d08b073861360f6)

Co-authored-by: Erlend E. Aasland <erlend.aasland@protonmail.com>

gh-78143: IDLE - fix settings dialog page label. (GH-96009)

'/Tab' should have been removed from the font page label
when the tab-spaces setting was moved to the Windows page.
(cherry picked from commit f6b811059ac945a283bb59bf37efac162c3bbab6)

Co-authored-by: Terry Jan Reedy <tjreedy@udel.edu>

gh-94439: typing docs: Add minimum version to `__required_keys__` and `__optional_keys__` (GH-95373)

(cherry picked from commit f235178beccf5eb5b47e770240f32d9ba24b26fd)

Co-authored-by: Howie Zhao <howiezhaohr@hotmail.com>

Fix typo in internal/pycore_atomic.h (GH-95939)

(cherry picked from commit 8281cbddc6f0fbc94f0c21cacfac79a2d4057a4b)

Co-authored-by: fluesvamp <105884371+fluesvamp@users.noreply.github.com>

[3.10] gh-94996: Disallow lambda pos only params with feature_version < (3, 8) (GH-95934) (GH-95938)

(cherry picked from commit a965db37f27ffb232312bc13d9a509f0d93fcd20)

Co-authored-by: Shantanu <12621235+hauntsaninja@users.noreply.github.com>
Automerge-Triggered-By: GH:lysnikolaou

[3.10] gh-94996: Disallow parsing pos only params with feature_version < (3, 8) (GH-95935)

(cherry picked from commit https://github.com/python/cpython/commit/b5e3ea286289fcad12be78480daf3756e350f69f)

Co-authored-by: Shantanu <12621235+hauntsaninja@users.noreply.github.com>
Automerge-Triggered-By: GH:lysnikolaou

gh-82180: Document support for non-integer arg removed from grp.getgrgid in 3.10 (GH-95346) (GH-95930)

(cherry picked from commit 50bf5fafcceacf8d7460fd8f9fb4297ac74d3eac)

Co-authored-by: Hugo van Kemenade <hugovk@users.noreply.github.com>

gh-92412: Clarify the documentation on library/syslog (GH-92587) (GH-95266)

(cherry picked from commit b7ce4625fe2a8a4d6c1db6b39b52c7f97d384caa)

Co-authored-by: Nicolas Haller <nicolas@haller.im>

[3.10] gh-95789: update documentation RFC base URL (GH-95800)

* pythongh-95789: update documentation RFC base URL

* 📜🤖 Added by blurb_it.

Co-authored-by: blurb-it[bot] <43283697+blurb-it[bot]@users.noreply.github.com>

[3.10] gh-95273: Improve sqlite3.complete_statement docs (GH-95840) (#95918)

Co-authored-by: Ezio Melotti <ezio.melotti@gmail.com>
Co-authored-by: CAM Gerlach <CAM.Gerlach@Gerlach.CAM>.
(cherry picked from commit e6623e7083ce08a247e5df169bcc749f99327823)

Co-authored-by: Erlend E. Aasland <erlend.aasland@protonmail.com>

gh-95841: IDLE - Revise Windows local doc url (GH-95845)

GH-91242 replaced the Windows chm help file with a copy
of the html docs.  This PR replaces the IDLE code that
fetches the Windows local help url passed to os.startfile.
Co-authored-by: Steve Dower
(cherry picked from commit bdb2cf8e913c041f26e8976abe58414819b3e8ff)

Co-authored-by: Terry Jan Reedy <tjreedy@udel.edu>

gh-84910: Change 'IDLE Help' to 'IDLE Doc' (GH-95873)

'IDLE Help' was a plain text file.  It was superceded years ago
by a copy of the much more complete html doc.  .
(cherry picked from commit 05a0f37029f8ef917ed7ddbf7871856fc73aaca1)

Co-authored-by: Terry Jan Reedy <tjreedy@udel.edu>

[3.10] gh-95876: Fix format string in pegen error location code (GH-95877 (GH-95901)

(cherry picked from commit b4c857d0fd74abb1ede6fe083c4fa3ca728b2b83)

Co-authored-by: Christian Heimes <christian@python.org>

gh-95878: Fix format char in datetime CAPI tests (GH-95879)

(cherry picked from commit 8b34e914bba2ccd6ae39609410db49d0beb19cb1)

Co-authored-by: Christian Heimes <christian@python.org>

gh-75510: Edit idlelib entry in doc (GH-95869)

Make section instead of subsection and revise sentence.
(cherry picked from commit 9af4aed73af0accffd26176c09aa263b68c8ca5d)

Co-authored-by: Terry Jan Reedy <tjreedy@udel.edu>

gh-84910: Tweak IDLE Glossary entry (GH-95866)

Link "IDLE" to its doc and add 'and Learning' to its expansion,
as in the doc.
(cherry picked from commit 3646f6cd880f8f91e189a2fe44a687798aa1fef1)

Co-authored-by: Terry Jan Reedy <tjreedy@udel.edu>

gh-95349: Hide a Distutils Warning Filter for test_check_c_globals (GH-95837)

Under certain build conditions, test_check_c_globals fails.  This fix takes the same approach as we took for gh-84236 (via gh-20095).  We'll be removing use of distutils in the c-analyzer at some point.  Until then we'll hide the warning filter.
(cherry picked from commit 3ff6d9affb351292ad8530802e7c06f651520706)

Co-authored-by: Eric Snow <ericsnowcurrently@gmail.com>

gh-95605: Fix `float(s)` error message when `s` contains only whitespace (GH-95665) (GH-95859)

This PR fixes the error message from float(s) in the case where s contains only whitespace.
(cherry picked from commit 97e9cfa75a80b54a0630b7371f35e368a12749d1)

Co-authored-by: Mark Dickinson <dickinsm@gmail.com>

Fix documentation typo for functools.cmp_to_key (GH-95766) (#95777)

gh-75500: Add idlelib section to IDLE doc (GH-95832)

This enables accessing IDLE as 'idlelib' in the Doc Module listing.
(cherry picked from commit 70fc9641b56144854777aef29c145cd10789e3df)

Co-authored-by: Terry Jan Reedy <tjreedy@udel.edu>

[3.11] gh-88878: IDLE - replace type('') with str (GH-95792)

Change in idlelib.browser, line 54
cherrypicked from 3680ebed7f3e529d01996dd0318601f9f0d02b4b
(cherry picked from commit 1a22ec5d69c2cbe51afdaff2cc3bc25a9514dd4f)

Co-authored-by: Terry Jan Reedy <tjreedy@udel.edu>

gh-95767: Fix grammatical error in asyncio loop.create_task docs (GH-95768)

(cherry picked from commit 141f2517fc36cc7a0caf177f270edb6d39cf3d23)

Co-authored-by: Andrzej Bartosiński <6197476+Neob91@users.noreply.github.com>

[3.10] gh-95273: Reorganize sqlite3 doc module level funcs and vars (GH-95626) (#95803)

Co-authored-by: Ezio Melotti <ezio.melotti@gmail.com>
Co-authored-by: CAM Gerlach <CAM.Gerlach@Gerlach.CAM>.
(cherry picked from commit 41c939cb35cda395388a775156c367676efffebe)

Co-authored-by: Erlend E. Aasland <erlend.aasland@protonmail.com>

[3.10] gh-91838: Resolve more HTTP links which redirect to HTTPS (GH-95650). (GH-95786)

(cherry picked from commit cc9160a29bc3356ced92348bcd8e6668c67167c9)

Co-authored-by: Serhiy Storchaka <storchaka@gmail.com>

gh-95491: Mention IDLE Issue project in Readme (GH-95750)

(cherry picked from commit 63140b445e4a303df430b3d60c1cd4ef34f27c03)

Co-authored-by: Terry Jan Reedy <tjreedy@udel.edu>

gh-94635: Fixup sqlite3 'Introduction' seealso note (GH-95751)

In gh-95269, the seealso note incorrectly ended up in
the 'Tutorial' section.
(cherry picked from commit 56af5a200d60e86a8ac450264729d693053275e3)

Co-authored-by: Erlend E. Aasland <erlend.aasland@protonmail.com>

gh-95376: Add test for names containing null (GH-GH-5394) (GH-95747)

Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@protonmail.com>
(cherry picked from commit a17cd47b614f8bc660788647a009a25e121221d7)

Co-authored-by: Sion Kang <31057849+Yaminyam@users.noreply.github.com>

gh-95395: Add argument type error test (GH-95412) (GH-95745)

(cherry picked from commit 4703c158116bd157e20938bbf5356b79422470bb)

Co-authored-by: Sion Kang <31057849+Yaminyam@users.noreply.github.com>

gh-95155: Update "Using Python on a Mac" documentation (GH-95284) (GH-95743)

Co-authored-by: Łukasz Langa <lukasz@langa.pl>
(cherry picked from commit d25ff1f61387edd65a91b3930b12bcf4d734e8a1)

Co-authored-by: Howie Zhao <howiezhaohr@hotmail.com>

Fix typo in test_dataclasses.py (gh-95735)

`dataclass` was called as a function when it was almost certainly intended to be a decorator.
(cherry picked from commit 59e09efe888affe549e9249f188797c1325edecc)

Co-authored-by: da-woods <dw-git@d-woods.co.uk>

gh-95251: IDLE - Add What's New section to README (GH-95688)

Document what I (TJR) currently do for 3.10/3.11.

Co-authored-by: Erlend E. Aasland <erlend.aasland@protonmail.com>
(cherry picked from commit a302a274892f2dad4e1fa492c4886d55e4df0a80)

Co-authored-by: Terry Jan Reedy <tjreedy@udel.edu>

gh-89362: Doc IDLE menu and search (GH-95697)

Update menu item position and capitalization.
Add paragraph about search.
For help.html, include save-as addition.
(cherry picked from commit 834064c19a110dad425dc290c91c0545eaa24471)

Co-authored-by: Terry Jan Reedy <tjreedy@udel.edu>

gh-91271: Document which parts of structs are in limited API/stable ABI (GH-32196) (GH-95711)

Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@innova.no>

bpo-42037: Corrected request dependencies in CookieJar functions (GH-23112) (GH-95515)

(cherry picked from commit d29e279de38e7bc3b7deda573ba23d65831d9351)

Co-authored-by: markus-sus <73822103+markus-sus@users.noreply.github.com>

GH-95685: Fix rendering of the string documentation (GH-95686) (GH-95701)

There's an extra underlines that messed the rest of the documentation rendering.

Closes #95685
(cherry picked from commit a525f2ada407d6677bf8ca708f104694de0525e4)

Co-authored-by: Mariatta Wijaya <Mariatta@users.noreply.github.com>

gh-65802: IDLE - explain SaveAs and extensions (GH-95690)

File name extensions may or may not be shown for the current name
and are added in an OS-dependent manner if not given for the new
name.
(cherry picked from commit 9890f86ae2001d19e7a18fee5b13aa0dd6069aef)

Co-authored-by: Terry Jan Reedy <tjreedy@udel.edu>

[3.10] Docs: sqlite3 docs fixup (GH-95681) (#95684)

- Disable links to the module itself
- Consistent ref markup

(cherry picked from commit 44f1f63ad5cf00b6f50cef0cc1a62c42632138be)

Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@protonmail.com>

[3.10] gh-95271: Extract placeholders howto from sqlite3 tutorial (GH-95522) (#95678)

Co-authored-by: CAM Gerlach <CAM.Gerlach@Gerlach.CAM>
Co-authored-by: Ezio Melotti <ezio.melotti@gmail.com>
(cherry picked from commit b24e8b28a7dc585ba367a959be83393f2352d21d)

Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@protonmail.com>

[3.10] gh-95273: Improve documented return values and exceptions raised for sqlite3 class methods (GH-95530) (#95674)

Co-authored-by: Ezio Melotti <ezio.melotti@gmail.com>
Co-authored-by: Alex Waygood <Alex.Waygood@Gmail.com>.
(cherry picked from commit 12d92c733cfc00ee630b30e4e0250da400c83395)

Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@protonmail.com>

Docs: fix two typos in the sqlite3 docs (GH-95661)

- statment => statement
- transaciton => transaction
(cherry picked from commit 962acd446839c7e10caf301931760133644ce8ca)

Co-authored-by: ceh <emil@hessman.se>

gh-91838: Resolve HTTP links which redirect to HTTPS (GH-95642)

It updates links which redirect to HTTPS with different authority or
path.
(cherry picked from commit d0d0154443cafb2f0a2cdfb6a1267d80cce8388e)

Co-authored-by: Serhiy Storchaka <storchaka@gmail.com>

[3.10] gh-91838: Use HTTPS links in docs for resources which redirect to HTTPS (GH-95527) (GH-95644)

If an HTTP link is redirected to a same looking HTTPS link, the latter can
be used directly without changes in readability and behavior.
It protects from a men-in-the-middle attack.

This change does not affect Python examples..
(cherry picked from commit f79547a429d5c90af83a0da821e082cba20d4712)

Co-authored-by: Serhiy Storchaka <storchaka@gmail.com>

gh-95638: Update idlelib README file and menu lists (GH-95639)

(cherry picked from commit 621b33ce258f3eaf154322c1edf0ead1e4892e36)

Co-authored-by: Terry Jan Reedy <tjreedy@udel.edu>

gh-95191: IDLE Prompts entry for What's New 3.10 (GH-95633)

(cherry picked from commit bcc74d509a3bd7e4fdc658179ae6d77614d1fd36)

Co-authored-by: Terry Jan Reedy <tjreedy@udel.edu>

[3.10] gh-91423: Remove bugs.python.org from bugs.rst (GH-91425) (#95615)

* Remove bugs.python.org from bugs.rst

* Update bugs.rst to the github issue tracker

* reflow

* Fix a typo and rephrase a sentence.

Co-authored-by: Inada Naoki <songofacandy@gmail.com>
Co-authored-by: Ezio Melotti <ezio.melotti@gmail.com>
(cherry picked from commit df81d2892eed3a256eb61ce59304f2173fb0c945)

Co-authored-by: roy reznik <royreznik@gmail.com>
Co-authored-by: roy reznik <royreznik@gmail.com>

gh-95423: Update winreg.DeleteKeyEx documentation and remove dynamic function load (GH-95521)

Co-authored-by: Derek Kim <ddkim1024@gmail.com>

gh-95597: Fix typo in Lib directory files (GH-95599)

(cherry picked from commit b53aed76d26419fc7449c358c6035c9afe055e16)

Co-authored-by: Jo, Yunjin <black33jo@gmail.com>

[3.10] gh-95273: Align sqlite3 const doc refs with the devguide recommendations (GH-95525). (#95618)

(cherry picked from commit 4d02572f8c39b16c83c0883917db4e31efc1048e)

Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@protonmail.com>

gh-95609: update bundled pip to 22.2.2 (gh-95610)

(cherry picked from commit 3d9d45b22cb1e90bca2901eade4b3125aeadb8c9)

Co-authored-by: Stéphane Bidoul <stephane.bidoul@gmail.com>

gh-91207: Override stylesheet fingerprinting when building for HTML Help (GH-95556)

gh-95233: Correct grp.getgrgid parameter name in documentation (gid -> id) (gh-95232)

(cherry picked from commit df7c8b95372169fb9d23140d35f91970ba32189d)

Co-authored-by: Adam Dangoor <adamdangoor@gmail.com>

gh-92219: Clarify that some options to the installer may break the install (GH-95548) (#95550)

(cherry picked from commit d2c1a9c76c001b18c14e50779b0ee41ea4ccf0b3)

Co-authored-by: Steve Dower <steve.dower@python.org>

gh-95516: Add param types and clarify param descriptions of LogRecord (GH-95517) (#95565)

(cherry picked from commit 75a6441718dcbc65d993c9544e67e25bef120e82)

Co-authored-by: CAM Gerlach <CAM.Gerlach@Gerlach.CAM>

gh-95191: IDLE: Include prompts when saving Shell GH-95554 (#95558)

(cherry picked from commit b85411fc5e9e223a6bd44f89f674ee3b2e29b99e)

Co-authored-by: Terry Jan Reedy <tjreedy@udel.edu>

gh-83270: Update IDLE's credits (GH-95528) (#95560)

Co-authored-by: Terry Jan Reedy <tjreedy@udel.edu>
(cherry picked from commit 698fa8bf6075c1594966ef6da8501a6f81db50f2)

Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@protonmail.com>

Post 3.10.6

Python 3.10.6

gh-95511: IDLE - fix Shell context menu copy-with-prompts bug (GH-95512)

If one selects whole lines, as the sidebar makes easy, do not
add an extra line.  Only move the end of a selection to the
beginning of the next line when not already at the beginning
of a line.  (Also improve the surrounding code.)
(cherry picked from commit fc31a13dc1799b8d972c1f4ea49f27090aed7f48)

Co-authored-by: Terry Jan Reedy <tjreedy@udel.edu>

IDLE: Fix docs URL in the About window (GH-28417)

(cherry picked from commit 0f17a754d925345d67beff18897d86780436c506)

Co-authored-by: Serhiy Storchaka <storchaka@gmail.com>

[3.10] bpo-46053: Fix OSS audio support on NetBSD (GH-30065). (GH-95477)

(cherry picked from commit 2e7e3c4c109928870c1e33d8af36b78e92895594)

Co-authored-by: Thomas Klausner <tk@giga.or.at>

[3.10] gh-94635: Add Reference, How-to, and Explanation headings to sqlite3 docs (GH-94636) (#95483)

Co-authored-by: CAM Gerlach <CAM.Gerlach@Gerlach.CAM>.
(cherry picked from commit 6c439b978bf55b29f21c595e9375202d63c8208d)

Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@protonmail.com>
* Fix refs

gh-95471: IDLE - Tweak Edit menu (GH-95481)

Move `Select All` above  `Cut` as it is used with `Cut` and `Copy` but not `Paste`.  Add a separator between `Replace` and `Go to Line` to separate items that belong to the 'Edit-find' (above) and 'Edit-show' (below) IDLE github project topics.
(cherry picked from commit 53357b3ee53d767c2da5cd77f9c47117903e9a44)

Co-authored-by: Terry Jan Reedy <tjreedy@udel.edu>

[3.10] gh-90654: IDLE - Insert blank line in NEWS.txt (#95479)

Needed for backports.

Cherrypicked from 9ec6abf6dc6ab622efda83a28d83d25ba129bbe2

gh-94938: Fix test (GH-95396)

(cherry picked from commit 0956b6d9c44f66cc152c6afe22a3793e5b157cfd)

Co-authored-by: Serhiy Storchaka <storchaka@gmail.com>

gh-95411: IDLE - Enable using the module browser with .pyw files (GH-95397)

Co-authored-by: Terry Jan Reedy <tjreedy@udel.edu>
(cherry picked from commit 7e19e417b5df765dabab8d6550ec0e9d897c573e)

Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@protonmail.com>

gh-95273: Relocate sqlite3 enable load extension note (GH-95430)

(cherry picked from commit d92b19e1b500247f9a62b12b9da889b99fe333f6)

Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@protonmail.com>

gh-95432: Fixup sqlite3 tutorial example (GH-95431)

- the insert statement should have five placeholders, not four
- missing ... in the multiline row list
(cherry picked from commit 2fbee85931296bbeddae6358583e400ce5321f89)

Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@protonmail.com>

[3.10] gh-95166: cancel map waited on future on timeout (GH-95169) (GH-95375)

Co-authored-by: Thomas Grainger <tagrain@gmail.com>
Co-authored-by: Kumar Aditya <59607654+kumaraditya303@users.noreply.github.com>

gh-95273: Improve sqlite3 class descriptions (GH-95379)

Co-authored-by: CAM Gerlach <CAM.Gerlach@Gerlach.CAM>
(cherry picked from commit e003b64f40fa28954ec967024fa811adff6cffe7)

Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@innova.no>

gh-95273: Condense sqlite3 executescript example (GH-95383) (#95419)

(cherry picked from commit e9c8de669d40d993489981be2973d1ea5bd10d0c)

Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@innova.no>

gh-95273: Move sqlite3 executemany examples from reference to tutorial (GH-95351)

(cherry picked from commit f0bf7956e60b452208f279146f928d71eb0aa11b)

Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@innova.no>

Improve documentation for adding datetime and timedelta (gh-95403) (gh-95409)

(cherry picked from commit 6e44bf9558dbcaffd78b7c4fc7f6b474388b4a9a)

Co-authored-by: BenjaminHelyer <91896754+BenjaminHelyer@users.noreply.github.com>
Co-authored-by: BenjaminHelyer <91896754+BenjaminHelyer@users.noreply.github.com>

gh-89610: Add .pyi as a recognised extension for IDLE on macOS (GH-95393)

This allows opening stub files by double clicking on them in the Finder.

Co-authored-by: Terry Jan Reedy <tjreedy@udel.edu>
(cherry picked from commit 06fc249135e5b98a74fc0213e157e80412354659)

Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@protonmail.com>

gh-86128: Add warning to ThreadPoolExecutor docs about atexit behaviour (GH-94008)

(cherry picked from commit 7df2f4d78714707cfb30d83ca99ce84ef9934892)

Co-authored-by: [object Object] <lucas.wiman@gmail.com>

gh-95355: Check tokens[0] after allocating memory (GH-95356)

GH-95355

Automerge-Triggered-By: GH:pablogsal
(cherry picked from commit b946f529efb4a623ac4ad968d8091edb81ebdcdb)

Co-authored-by: Honglin Zhu <zhuhonglin.zhl@alibaba-inc.com>

Docs: Fix refs & tweak wording in sqlite3 'Using shortcut methods' (#95358)

Co-authored-by: CAM Gerlach <CAM.Gerlach@Gerlach.CAM>
(cherry picked from commit ea269b9a380a52828d4e401fa695737bcd699398)

Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@protonmail.com>

[3.10] GH-93899: fix checks for eventfd flags  (GH-95170). (#95345)

(cherry picked from commit 4dd099bafff14639ef5d2185965016d8f253353f)

Co-authored-by: Kumar Aditya <59607654+kumaraditya303@users.noreply.github.com>

[3.10] gh-94938: Fix errror detection of unexpected keyword arguments (GH-94999) (GH-95354)

When keyword argument name is an instance of a str subclass with
overloaded methods __eq__ and __hash__, the former code could not find
the name of an extraneous keyword argument to report an error, and
_PyArg_UnpackKeywords() returned success without setting the
corresponding cell in the linearized arguments array. But since the number
of expected initialized cells is determined as the total number of passed
arguments, this lead to reading NULL as a keyword parameter value, that
caused SystemError or crash or other undesired behavior..
(cherry picked from commit ebad53a4dc1bb591820724a22cef9b8459185b5f)

Co-authored-by: Serhiy Storchaka <storchaka@gmail.com>

gh-95339: update bundled pip to 22.2.1 (gh-95340)

(cherry picked from commit 226d02bb109d08601fbccd645e9d67aee2e5bcdc)

Co-authored-by: Stéphane Bidoul <stephane.bidoul@gmail.com>

[3.10] gh-95273: Normalise sqlite3 reference wording (GH-95274) (#95330)

Co-authored-by: Alex Waygood <Alex.Waygood@Gmail.com>
Co-authored-by: CAM Gerlach <CAM.Gerlach@Gerlach.CAM>.
(cherry picked from commit 2361908a9d5553102f2b2294af44852a76d2ab03)

Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@innova.no>

gh-94630: Fixup sqlite3 argument spec docs for connection execute* methods (GH-95319)

(cherry picked from commit 2b37395612ece0a8c37439801087ba9e2c56702f)

Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@protonmail.com>

GH-95045: gc untrack _lsprof.Profiler before deallocating it (GH-95315)

Automerge-Triggered-By: GH:pablogsal
(cherry picked from commit deacf391d7a1b3ab49bffa16088b3500fdb4c435)

Co-authored-by: Kumar Aditya <59607654+kumaraditya303@users.noreply.github.com>

gh-95280: Fix test_get_ciphers on systems without RSA key exchange (GH-95282)

(cherry picked from commit 565403038b75eb64ea483b2757ba30769246d853)

Co-authored-by: Christian Heimes <christian@python.org>

gh-94635: Add sqlite3 'Introduction' and 'Tutorial' doc headings (GH-95269)

(cherry picked from commit 2e35a13e46663acf665da06267c54e66c7ecf18d)

Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@protonmail.com>

gh-95291: Use import helper to improve sqlite3 audit tests (GH-95292)

Now the tests are correctly reported as skipped if sqlite3 is not available.
(cherry picked from commit 152eb90311fdf294510b5d077332580ba18c0ee4)

Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@protonmail.com>

gh-95041: Fail syslog.syslog in case inner call to syslog.openlog fails (GH-95264)

(cherry picked from commit b1f648efc56ff17e18ec2b7402d59a771b305004)

Co-authored-by: Noam Cohen <noam@noam.me>

[3.10] gh-95235: Add explicit parameter list to some sqlite3 methods (GH-95240) (#95268)

Co-authored-by: CAM Gerlach <CAM.Gerlach@Gerlach.CAM>.
(cherry picked from commit 5012bedc7ca7d78b5a42bf60eef55bac263f4060)

Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@protonmail.com>

gh-95041: Fix several minor issues in syslog.openlog() (GH-95058)

* syslog_get_argv() swallows exceptions, but not in all cases.
* if ident is non UTF-8 encodable, syslog.openlog() fails after setting the
  global reference to ident. Now the C string saved internally in the previous
  call to openlog() points to the freed memory.
* PySys_Audit() can crash if ident is NULL.
* There may be a race condition with syslog.syslog(), because the global
  reference to ident is decrefed before setting the new value.
* Possible use of freed memory if syslog.openlog() is called while
  the GIL is released in syslog.syslog().
(cherry picked from commit 68c555a50a2b74731b0db0f4dcbf51b2c11d4853)

Co-authored-by: Serhiy Storchaka <storchaka@gmail.com>

gh-95235: Document undocumented parameters in sqlite3 functions and methods (GH-95236)

Co-authored-by: CAM Gerlach <CAM.Gerlach@Gerlach.CAM>
(cherry picked from commit ac6a94c669cba8c8384a61b4304c87cc83728335)

Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@protonmail.com>

gh-95087: Fix IndexError in parsing invalid date in the email module (GH-95201)

Co-authored-by: wouter bolsterlee <wouter@bolsterl.ee>
(cherry picked from commit ea5ed0ba51c10cfdde7651a475438551964dfdfc)

Co-authored-by: Serhiy Storchaka <storchaka@gmail.com>

gh-95212: make multiprocessing test case parallel-safe (GH-95213)

(cherry picked from commit 5956de16cd00e7e1cf5cbf3d7b4a930eaa928321)

Co-authored-by: Christian Heimes <christian@python.org>

gh-95199: upgrade bundled setuptools to 63.2.0 (gh-95200)

(cherry picked from commit 3c94d3395edbcd299cbdacd09660ed88e654eeef)

Co-authored-by: Stéphane Bidoul <stephane.bidoul@gmail.com>

gh-95194: upgrade bundled pip to 22.2 (gh-95195)

upgrade bundled pip to 22.2
(cherry picked from commit 068ffafa5465e9388a940692d1720266a1b37257)

Co-authored-by: Stéphane Bidoul <stephane.bidoul@gmail.com>

gh-93157: Fix fileinput didn't support `errors` in `inplace` mode (GH-95128)

(cherry picked from commit 5c7f3bcdafedd60a385e8ca5403bc6b0b7a862b3)

Co-authored-by: Inada Naoki <songofacandy@gmail.com>

Doc: Add omitted secondary prompt in inputoutput tutorial (GH-30317) (#95159)

For the continuation lines, "..." should present as secondary prompt
(cherry picked from commit de28ee8f755760fda13b481a34b1f326984d293a)

Co-authored-by: Chenwei Xiao <chanvinxiao@163.com>
Co-authored-by: Chenwei Xiao <chanvinxiao@163.com>

Fix copy-friendliness of tutorial example (GH-93424)

(cherry picked from commit 34d11f1b0c0e1936a37581e0fb0daec637afca47)

Co-authored-by: Chenwei Xiao <chanvinxiao@163.com>

Fix async method reference links in `compound_stmts` docs (GH-94935)

(cherry picked from commit 79d2f549adcbbefd4f2c0a0c9dd572bbbf252c62)

Co-authored-by: July Tikhonov <july.tikh@gmail.com>

Closes gh-95133: docs, fix indentation level in TestCase.assertLogs example (GH-95134)

(cherry picked from commit 2a9c227ac11f7d8fc6d756542dd3410be0a6b6b0)

Co-authored-by: Alexandru Mărășteanu <alexei@users.noreply.github.com>

gh-81040: Improve sqlite3.Cursor.rowcount docs (GH-94940)

(cherry picked from commit f9b3706df65c4962646587b437a4eb39289dfd4c)

Co-authored-by: Erlend Egeberg Aasland <erlend.aasland@protonmail.com>