Skip to content

json1 SQLite extension is not correctly detected in versions.json #2326

New issue
New issue
Closed
#2327
Closed
json1 SQLite extension is not correctly detected in versions.json#2326
#2327
@sebbacon

Description

@sebbacon
sebbacon
opened on Apr 18, 2024

Due to hasversion always being False for json1, it is never detected in this code path:

datasette/datasette/app.py

Lines 1106 to 1115 in 7d6d471

for extension, testsql, hasversion in (
("json1", "SELECT json('{}')", False),
("spatialite", "SELECT spatialite_version()", True),
):
try:
result = conn.execute(testsql)
if hasversion:
sqlite_extensions[extension] = result.fetchone()[0]
else:
sqlite_extensions[extension] = None

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions