Skip to content

Try x86 instead

Try x86 instead #14

Workflow file for this run

name: Python Setup with Datasette and Spatialite
on:
push:
branches: [ main ]
pull_request:
branches: [ main ]
jobs:
setup:
runs-on: windows-latest
steps:
- uses: actions/checkout@v4
- name: Set up Python 3.12
uses: actions/setup-python@v5
with:
python-version: '3.12'
- name: Install Datasette
run: |
# python -m pip install pysqlite3-binary
# pip install datasette
- name: Download mod_spatialite
run: Invoke-WebRequest -outfile spatialite.7z http://www.gaia-gis.it/gaia-sins/windows-bin-x86/mod_spatialite-5.1.0-win-x86.7z
- name: Unpack the archive
run: 7z.exe x spatialite.7z
- name: Show all files
run: |
# $folderPath = "$PWD\spatialite-loadable-modules-5.0.0-win-amd64"
$folderPath = "$PWD"
Get-ChildItem -Path $folderPath -Recurse | ForEach-Object { $_.FullName }
- name: Show path
run: echo $PWD\spatialite-loadable-modules-5.0.0-win-amd64
- name: Verify installation
run: |
python -c @"
import sqlite3, os
spatialite_path = os.path.join(os.environ['GITHUB_WORKSPACE'], 'spatialite-loadable-modules-5.0.0-win-amd64', 'mod_spatialite.dll')
print(f'Checking path: {spatialite_path}')
assert os.path.exists(spatialite_path), f'SpatiaLite module not found at: {spatialite_path}'
db = sqlite3.Connection(':memory:')
db.enable_load_extension(True)
db.load_extension(spatialite_path)
print(db.execute('select spatialite_version()').fetchall())
"@
# datasette --version