1. A quick online search shows this tutorial on spatialiate with
sqlalchemy:
https://geoalchemy-2.readthedocs.io/en/latest/spatialite_tutorial.html
the author is using a SqlAlchemy event to load the spatialate extension
into the engine/connection/pool.
2. You are going to have a small problem
Hi,
thanks for the answer. I saw this tutorial many time on my google research,
but I don't know how to integrate this in pyramid and specifically for
Windows.
I probably not clear on that one, but I'm going to have only one database
at the time. The sqlite (spatialite) is used for my local de
Try to find a way to import the dll but it always fails on the
load_extension
def load_spatialite(dbapi_conn, connection_record):
dbapi_conn.enable_load_extension(True)
dbapi_conn.load_extension('C:\\Scripts\\*mod_spatialite*.dll')
Le mardi 9 juillet 2019 17:01:33 UTC-4, Michael Lane a
Even though I put the file in a directory define in %PATH% or try
with/without full path, with/without file extension, with
libspatialite-4.dll or using excute with all combination mentionned
before...
dbapi_conn.execute("SELECT load_extension('mod_spatialite.dll')")
Le mercredi 10 juillet 20