RL2_SQL_SCRIPT_WINDOWS - geopaparazzi/Spatialite-Tasks-with-Sql-Scripts GitHub Wiki

Calling a Sql-Script

• setting SPATIALITE_SECURITY=relaxed
  • I have no idea if this will work correctly
    • Windows Batch Scripting
      • Windows NT, Windows XP, Windows Vista, Windows 7 and later

--> 'List of Sql-Commands'

<-- 'Index Page for RasterLite2 - Commands'

<-- 'Index Page for RasterLite2 - Database Creation'

---

@echo off
set SPATIALITE_SECURITY=relaxed
rem < filename : Redirect standard input to read from the named file.
sqlite3 1890.berlin_stadt_postgrenzen.db < build_1890.berlin_stadt_postgrenzen_db.sql
rem wmslite -db 1890.berlin_stadt_postgrenzen.db &
rem ======================================================
rem               WmsLite server startup
rem ======================================================
rem          SQLite version: 3.7.17
rem      SpatiaLite version: 4.2.0-devel
rem     RasterLite2 version: 0.8
rem ======================================================
rem Publishing layer "berlin_stadtteilgrenzen.1880"
rem Publishing layer "berlin_postgrenzen.1890"
rem ======================================================
rem     HTTP micro-server listening on port: 8080
rem ======================================================
rem LibreWMS &
rem To unset a variable, set it to empty string, such as "set myvar=".
rem unset SPATIALITE_SECURITY
set SPATIALITE_SECURITY=
exit /b

---

2014-05-12: Mark Johnson, Berlin Germany

---