[sqlite3] allow clearing the authoriser callback

[erlend-aasland]

BPO	44491
Nosy	@pablogsal, @erlend-aasland
PRs	bpo-44491: Allow clearing the sqlite3 authoriser callback #26863

^{Note: these values reflect the state of the issue at the time it was migrated and might not reflect the current state.}

Show more details

GitHub fields:

assignee = 'https://github.com/erlend-aasland'
closed_at = <Date 2021-06-24.15:24:10.202>
created_at = <Date 2021-06-22.23:30:45.864>
labels = ['extension-modules', 'type-feature', '3.11']
title = '[sqlite3] allow clearing the authoriser callback'
updated_at = <Date 2021-06-24.15:24:10.201>
user = 'https://github.com/erlend-aasland'

bugs.python.org fields:

activity = <Date 2021-06-24.15:24:10.201>
actor = 'pablogsal'
assignee = 'erlendaasland'
closed = True
closed_date = <Date 2021-06-24.15:24:10.202>
closer = 'pablogsal'
components = ['Extension Modules']
creation = <Date 2021-06-22.23:30:45.864>
creator = 'erlendaasland'
dependencies = []
files = []
hgrepos = []
issue_num = 44491
keywords = ['patch']
message_count = 2.0
messages = ['396374', '396491']
nosy_count = 2.0
nosy_names = ['pablogsal', 'erlendaasland']
pr_nums = ['26863']
priority = 'low'
resolution = 'fixed'
stage = 'resolved'
status = 'closed'
superseder = None
type = 'enhancement'
url = 'https://bugs.python.org/issue44491'
versions = ['Python 3.11']

[erlend-aasland]

Currently, it is possible to clear both the sqlite3 trace callback and progress handler by passing 'None' as the callback/handler, however it is not possible to clear the authoriser callback.

Suggesting to allow clearing the authoriser callback with set_authorizer(None).

See also https://sqlite.org/c3ref/set_authorizer.html

[pablogsal]

New changeset b19f455 by Erlend Egeberg Aasland in branch 'main':
bpo-44491: Allow clearing the sqlite3 authoriser callback (GH-26863)
b19f455