Merge pull request #2197 from lonvia/use-jinja-for-sql-preprocessing

Use jinja2 for SQL preprocessing

diff --git a/.github/actions/build-nominatim/action.yml b/.github/actions/build-nominatim/action.yml
index 409887bf5b9402b17202c4fe205e083f82bc5b2c..414783d96f26fe19e2bc2a70a67f5502bb953343 100644 (file)
--- a/.github/actions/build-nominatim/action.yml
+++ b/.github/actions/build-nominatim/action.yml
@@ -4,7 +4,7 @@ runs:
     using: "composite"
 
     steps:
-        - name: Install prerequisits
+        - name: Install prerequisites
           run: |
             sudo apt-get install -y -qq libboost-system-dev libboost-filesystem-dev libexpat1-dev zlib1g-dev libbz2-dev libpq-dev libproj-dev python3-psycopg2 python3-pyosmium python3-dotenv python3-psutil python3-jinja2
           shell: bash

diff --git a/nominatim/indexer/indexer.py b/nominatim/indexer/indexer.py
index 93723844d8d63582c982a4f9846058af7b512b8e..06c05e1d5a49e32a7e2c44290339d19c1344b548 100644 (file)
--- a/nominatim/indexer/indexer.py
+++ b/nominatim/indexer/indexer.py
@@ -159,6 +159,7 @@ class Indexer:
             ensure that database statistics are updated.
         """
         conn = psycopg2.connect(self.dsn)
+        conn.autocommit = True
 
         try:
             self.index_by_rank(0, 4)