package com.onemap.overlap.utils;

import org.sqlite.SQLiteConfig;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;

public class SpatialiteUtils {
    public static Connection getSpatialiteConnection(String dbFile) throws Exception {
        Class.forName("org.sqlite.JDBC");
        Connection conn = null;
//        System.out.println(org.sqlite.SQLiteJDBCLoader.getVersion());
        SQLiteConfig config = new SQLiteConfig();
        config.enableLoadExtension(true);
        conn = config.createConnection("jdbc:sqlite:" + dbFile);
        Statement stmt = conn.createStatement();
        stmt.setQueryTimeout(30000000);
        stmt.execute("SELECT load_extension('mod_spatialite')");
        return conn;
    }
}