--load-extension option for sqlite-utils query

[simonw]

I got this error:

% sqlite-utils calands.db 'create table superunits_with_maps_view_concrete as select * from superunits_with_maps_view'
Traceback (most recent call last):
...
    cursor = db.conn.execute(sql, dict(param))
sqlite3.OperationalError: no such function: AsGeoJSON

A --load-extension=/usr/local/lib/mod_spatialite.dylib option (imitating the same option for Datasette) would help.

[simonw]

Trickiest part of this is how to write a test for it.

I'll do a pytest.skipIf that only executes the test if SpatiaLite is available.

[simonw]

This should get me SpatiaLite in the GitHub Actions Ubuntu:

apt install libsqlite3-mod-spatialite

[simonw]

I think that adds it as /usr/lib/x86_64-linux-gnu/mod_spatialite.so.

[simonw]

Ended up needing two skipIfs:

sqlite-utils/tests/test_cli.py

Lines 888 to 893 in 7e9aad7

	@pytest.mark.skipif(not find_spatialite(), reason="Could not find SpatiaLite extension")
	@pytest.mark.skipif(
	not hasattr(sqlite3.Connection, "enable_load_extension"),
	reason="sqlite3.Connection missing enable_load_extension",
	)
	def test_query_load_extension():