Application: gvSIG desktop

SELECT "test"."ID", 

       "test"."Byte", 

       "test"."Bool1", 

       "test"."Long", 

       "test"."Timestamp", 

       "test"."Date", 

       "test"."Time", 

       "test"."Bool2", 

       "test"."String", 

       "test"."Bool3", 

       "test"."Double", 

       "test"."Bool4", 

       "test"."Float", 

       "test"."Bool5", 

       "test"."Decimal", 

       "test"."Geometry" 

FROM "test" 

WHERE ( ("test"."ID") = (?) ) 

-- Calculate envelope SQL

    IIF(ST_ExtentAggregate("test"."Geometry") IS NULL,NULL, 

    ST_AsBinary(ST_ExtentAggregate("test"."Geometry"))) 

FROM "test" 

WHERE ( ("test"."Geometry") IS NOT NULL );

SELECT "ARENA2_CONDUCTORES"."LID_CONDUCTOR", "ARENA2_CONDUCTORES"."ID_ACCIDENTE", 

"ARENA2_CONDUCTORES"."LID_VEHICULO", "ARENA2_CONDUCTORES"."ID_VEHICULO", 

"ARENA2_CONDUCTORES"."POSIBLE_RESPONSABLE", "ARENA2_CONDUCTORES"."FECHA_NACIMIENTO", 

"ARENA2_CONDUCTORES"."SEXO", "ARENA2_CONDUCTORES"."NACIONALIDAD", 

"ARENA2_CONDUCTORES"."PAIS_RESIDENCIA", "ARENA2_CONDUCTORES"."PROVINCIA_RESIDENCIA", 

"ARENA2_CONDUCTORES"."MUNICIPIO_RESIDENCIA", "ARENA2_CONDUCTORES"."ASISTENCIA_SANITARIA", 

"ARENA2_CONDUCTORES"."INFLU_FACT_ATENCION", "ARENA2_CONDUCTORES"."FACTORES_ATENCION", 

"ARENA2_CONDUCTORES"."INFLU_PRES_ERROR", "ARENA2_CONDUCTORES"."PRESUNTOS_ERRORES", 

"ARENA2_CONDUCTORES"."CARACT_PERMISO", "ARENA2_CONDUCTORES"."CLASE_PERMISO", 

"ARENA2_CONDUCTORES"."FECHA_PERMISO", "ARENA2_CONDUCTORES"."MOTIVO_DESPLAZAMIENTO", 

"ARENA2_CONDUCTORES"."DESPLAZAMIENTO_PREVISTO", "ARENA2_CONDUCTORES"."ACC_SEG_CINTURON", 

"ARENA2_CONDUCTORES"."ACC_SEG_CASCO", "ARENA2_CONDUCTORES"."ACC_SEG_BRAZOS", 

"ARENA2_CONDUCTORES"."ACC_SEG_ESPALDA", "ARENA2_CONDUCTORES"."ACC_SEG_TORSO", 

"ARENA2_CONDUCTORES"."ACC_SEG_MANOS", "ARENA2_CONDUCTORES"."ACC_SEG_PIERNAS", 

"ARENA2_CONDUCTORES"."ACC_SEG_PIES", "ARENA2_CONDUCTORES"."ACC_SEG_PRENDA_REF", 

"ARENA2_CONDUCTORES"."INFLU_ALCOHOL", "ARENA2_CONDUCTORES"."PRUEBA_ALCOHOLEMIA", 

"ARENA2_CONDUCTORES"."TASA_ALCOHOLEMIA1", "ARENA2_CONDUCTORES"."TASA_ALCOHOLEMIA2", 

"ARENA2_CONDUCTORES"."PRUEBA_ALC_SANGRE", "ARENA2_CONDUCTORES"."SIGNOS_INFLU_ALCOHOL", 

"ARENA2_CONDUCTORES"."INFLU_DROGAS", "ARENA2_CONDUCTORES"."PRUEBA_DROGAS", 

"ARENA2_CONDUCTORES"."AMP", "ARENA2_CONDUCTORES"."CONFIRMADO_AMP", 

"ARENA2_CONDUCTORES"."BDZ", "ARENA2_CONDUCTORES"."CONFIRMADO_BDZ", 

"ARENA2_CONDUCTORES"."COC", "ARENA2_CONDUCTORES"."CONFIRMADO_COC", "ARENA2_CONDUCTORES"."THC", 

"ARENA2_CONDUCTORES"."CONFIRMADO_THC", "ARENA2_CONDUCTORES"."METH", 

"ARENA2_CONDUCTORES"."CONFIRMADO_METH", "ARENA2_CONDUCTORES"."OPI", "ARENA2_CONDUCTORES"."CONFIRMADO_OPI", 

"ARENA2_CONDUCTORES"."OTRAS", "ARENA2_CONDUCTORES"."CONFIRMADO_OTRAS", 

"ARENA2_CONDUCTORES"."SIGNOS_INFLU_DROGAS", "ARENA2_CONDUCTORES"."INFLU_PRES_INFRAC_COND", 

"ARENA2_CONDUCTORES"."PRES_INFRAC_COND", "ARENA2_CONDUCTORES"."PRES_INFRAC_SIN_LUCES", 

"ARENA2_CONDUCTORES"."PRES_INFRAC_SIN_TRIANGULO", "ARENA2_CONDUCTORES"."INFLU_PRES_INFRAC_VEL", 

"ARENA2_CONDUCTORES"."PRES_INFRAC_VEL_COND", "ARENA2_CONDUCTORES"."INFLU_OTRA_INFRAC", 

"ARENA2_CONDUCTORES"."OTRA_INFRAC_COND", "ARENA2_CONDUCTORES"."EXTRA", 

"ARENA2_ACCIDENTES"."KM" AS "AccKm0", 

("ARENA2_ACCIDENTES"."KM" * 100) AS "AccKm1", 

("ARENA2_ACCIDENTES"."KM" * 222) AS "AccKm2", 

"ARENA2_ACCIDENTES"."KM" 

FROM "ARENA2_CONDUCTORES" 

LEFT JOIN "ARENA2_ACCIDENTES" ON ( ("ARENA2_CONDUCTORES"."ID_ACCIDENTE") = ("ARENA2_ACCIDENTES"."ID_ACCIDENTE") ) 

SELECT COUNT(*) FROM "ARENA2_CONDUCTORES";

-- testSTDistanceWithoutSpatialIndex

    "test"."ID", "test"."Byte", "test"."Bool1", "test"."Long", 

    "test"."Timestamp", "test"."Date", "test"."Time", "test"."Bool2", 

    "test"."String", "test"."Bool3", "test"."Double", "test"."Bool4", 

    "test"."Float", "test"."Bool5", "test"."Decimal", "test"."Geometry" 

FROM "test" 

WHERE ST_Intersects((ST_GeomFromWKB((X'000000000300000001000000213ff000000000000040440000000000003fef6297cff75cb04043e70747c3965a3fed906bcf328d464043cf043ab2a2ad3fea9b66290ea1a34043b8e31319465d3fe6a09e667f3bcd4043a57d866603113fe1c73b39ae68c940439592675bc5793fd87de2a6aea964404389be50c335cb3fc8f8b83c69a60d40438275a0c0228d3c91a62633145c074043800000000000bfc8f8b83c69a60840438275a0c0228dbfd87de2a6aea962404389be50c335cbbfe1c73b39ae68c640439592675bc579bfe6a09e667f3bcc4043a57d86660311bfea9b66290ea1a44043b8e31319465dbfed906bcf328d474043cf043ab2a2adbfef6297cff75cb14043e70747c3965abff00000000000004044000000000000bfef6297cff75cae404418f8b83c69a6bfed906bcf328d42404430fbc54d5d53bfea9b66290ea19c4044471cece6b9a3bfe6a09e667f3bc240445a827999fcefbfe1c73b39ae68bb40446a6d98a43a87bfd87de2a6aea94140447641af3cca35bfc8f8b83c69a5bb40447d8a5f3fdd733ce6586c6b36175f40448000000000003fc8f8b83c69a66a40447d8a5f3fdd733fd87de2a6aea99340447641af3cca353fe1c73b39ae68e040446a6d98a43a863fe6a09e667f3be240445a827999fcef3fea9b66290ea1b54044471cece6b9a33fed906bcf328d53404430fbc54d5d523fef6297cff75cb7404418f8b83c69a53ff00000000000004044000000000000'), 4326)),("test"."Geometry")) 

ORDER BY ST_Distance(ST_GeomFromWKB((X'000000000300000001000000213ff000000000000040440000000000003fef6297cff75cb04043e70747c3965a3fed906bcf328d464043cf043ab2a2ad3fea9b66290ea1a34043b8e31319465d3fe6a09e667f3bcd4043a57d866603113fe1c73b39ae68c940439592675bc5793fd87de2a6aea964404389be50c335cb3fc8f8b83c69a60d40438275a0c0228d3c91a62633145c074043800000000000bfc8f8b83c69a60840438275a0c0228dbfd87de2a6aea962404389be50c335cbbfe1c73b39ae68c640439592675bc579bfe6a09e667f3bcc4043a57d86660311bfea9b66290ea1a44043b8e31319465dbfed906bcf328d474043cf043ab2a2adbfef6297cff75cb14043e70747c3965abff00000000000004044000000000000bfef6297cff75cae404418f8b83c69a6bfed906bcf328d42404430fbc54d5d53bfea9b66290ea19c4044471cece6b9a3bfe6a09e667f3bc240445a827999fcefbfe1c73b39ae68bb40446a6d98a43a87bfd87de2a6aea94140447641af3cca35bfc8f8b83c69a5bb40447d8a5f3fdd733ce6586c6b36175f40448000000000003fc8f8b83c69a66a40447d8a5f3fdd733fd87de2a6aea99340447641af3cca353fe1c73b39ae68e040446a6d98a43a863fe6a09e667f3be240445a827999fcef3fea9b66290ea1b54044471cece6b9a33fed906bcf328d53404430fbc54d5d523fef6297cff75cb7404418f8b83c69a53ff00000000000004044000000000000'), 4326), "Geometry") ASC NULLS LAST, 

    "test"."ID" ASC LIMIT 1;

-- testSTDistanceWithSpatialIndex

SELECT 

    "test"."ID", "test"."Byte", "test"."Bool1", "test"."Long", 

    "test"."Timestamp", "test"."Date", "test"."Time", "test"."Bool2", 

    "test"."String", "test"."Bool3", "test"."Double", "test"."Bool4", 

    "test"."Float", "test"."Bool5", "test"."Decimal", "test"."Geometry" FROM "test" WHERE ( (("ID" IN (SELECT "rtree_test_Geometry"."id" 

FROM "rtree_test_Geometry" 

WHERE "rtree_test_Geometry"."minx" <= (1.0) AND 

    "rtree_test_Geometry"."miny" <= (41.0) AND 

    "rtree_test_Geometry"."maxx" >= (-1.0) AND 

    "rtree_test_Geometry"."maxy" >= (39.0)))) AND 

    ST_Intersects((ST_GeomFromWKB((X'000000000300000001000000213ff000000000000040440000000000003fef6297cff75cb04043e70747c3965a3fed906bcf328d464043cf043ab2a2ad3fea9b66290ea1a34043b8e31319465d3fe6a09e667f3bcd4043a57d866603113fe1c73b39ae68c940439592675bc5793fd87de2a6aea964404389be50c335cb3fc8f8b83c69a60d40438275a0c0228d3c91a62633145c074043800000000000bfc8f8b83c69a60840438275a0c0228dbfd87de2a6aea962404389be50c335cbbfe1c73b39ae68c640439592675bc579bfe6a09e667f3bcc4043a57d86660311bfea9b66290ea1a44043b8e31319465dbfed906bcf328d474043cf043ab2a2adbfef6297cff75cb14043e70747c3965abff00000000000004044000000000000bfef6297cff75cae404418f8b83c69a6bfed906bcf328d42404430fbc54d5d53bfea9b66290ea19c4044471cece6b9a3bfe6a09e667f3bc240445a827999fcefbfe1c73b39ae68bb40446a6d98a43a87bfd87de2a6aea94140447641af3cca35bfc8f8b83c69a5bb40447d8a5f3fdd733ce6586c6b36175f40448000000000003fc8f8b83c69a66a40447d8a5f3fdd733fd87de2a6aea99340447641af3cca353fe1c73b39ae68e040446a6d98a43a863fe6a09e667f3be240445a827999fcef3fea9b66290ea1b54044471cece6b9a33fed906bcf328d53404430fbc54d5d523fef6297cff75cb7404418f8b83c69a53ff00000000000004044000000000000'), 4326)),("test"."Geometry") )) 

ORDER BY ST_Distance(ST_GeomFromWKB((X'000000000300000001000000213ff000000000000040440000000000003fef6297cff75cb04043e70747c3965a3fed906bcf328d464043cf043ab2a2ad3fea9b66290ea1a34043b8e31319465d3fe6a09e667f3bcd4043a57d866603113fe1c73b39ae68c940439592675bc5793fd87de2a6aea964404389be50c335cb3fc8f8b83c69a60d40438275a0c0228d3c91a62633145c074043800000000000bfc8f8b83c69a60840438275a0c0228dbfd87de2a6aea962404389be50c335cbbfe1c73b39ae68c640439592675bc579bfe6a09e667f3bcc4043a57d86660311bfea9b66290ea1a44043b8e31319465dbfed906bcf328d474043cf043ab2a2adbfef6297cff75cb14043e70747c3965abff00000000000004044000000000000bfef6297cff75cae404418f8b83c69a6bfed906bcf328d42404430fbc54d5d53bfea9b66290ea19c4044471cece6b9a3bfe6a09e667f3bc240445a827999fcefbfe1c73b39ae68bb40446a6d98a43a87bfd87de2a6aea94140447641af3cca35bfc8f8b83c69a5bb40447d8a5f3fdd733ce6586c6b36175f40448000000000003fc8f8b83c69a66a40447d8a5f3fdd733fd87de2a6aea99340447641af3cca353fe1c73b39ae68e040446a6d98a43a863fe6a09e667f3be240445a827999fcef3fea9b66290ea1b54044471cece6b9a33fed906bcf328d53404430fbc54d5d523fef6297cff75cb7404418f8b83c69a53ff00000000000004044000000000000'), 4326), "Geometry") ASC NULLS LAST, 

    "test"."ID" ASC 

LIMIT 1;

SELECT 1 FROM "test" LIMIT 1;

INSERT INTO "test" ( 

     ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? 

DELETE FROM "test" WHERE ( ("ID") = (?) );

UPDATE "test" 

    "Geometry" = ? 

ALTER TABLE "test" ADD COLUMN "Byte" TINYINT DEFAULT NULL NULL;

ALTER TABLE "test" ADD COLUMN "Bool1" BOOLEAN DEFAULT NULL NULL;

ALTER TABLE "test" ADD COLUMN "Long" BIGINT DEFAULT NULL NULL;

ALTER TABLE "test" ADD COLUMN "Timestamp" DATETIME DEFAULT NULL NULL;

ALTER TABLE "test" ADD COLUMN "Date" DATE DEFAULT NULL NULL;

ALTER TABLE "test" ADD COLUMN "Time" TIME DEFAULT NULL NULL;

ALTER TABLE "test" ADD COLUMN "Bool2" BOOLEAN DEFAULT NULL NULL;

ALTER TABLE "test" ADD COLUMN "String" VARCHAR(30) DEFAULT NULL NULL;

ALTER TABLE "test" ADD COLUMN "Bool3" BOOLEAN DEFAULT NULL NULL;

ALTER TABLE "test" ADD COLUMN "Double" DOUBLE PRECISION DEFAULT NULL NULL;

ALTER TABLE "test" ADD COLUMN "Bool4" BOOLEAN DEFAULT NULL NULL;

ALTER TABLE "test" ADD COLUMN "Float" FLOAT DEFAULT NULL NULL;

ALTER TABLE "test" ADD COLUMN "Bool5" BOOLEAN DEFAULT NULL NULL;

ALTER TABLE "test" ADD COLUMN "Decimal" DECIMAL(6,3) DEFAULT NULL NULL;

ALTER TABLE "test" ADD COLUMN "Geometry" BLOB DEFAULT NULL NULL;

--ALTER TABLE "test" ADD CONSTRAINT 

--  IF NOT EXISTS "test_GEOM_Geometry" 

--  CHECK NVL2(

--    "Geometry", 

--    ST_GeometryTypeCode("Geometry") = 1 AND 

--      ST_CoordDim("Geometry") = 2 AND 

--      ST_SRID("Geometry") = 4326, 

--    TRUE

--  )

SELECT "test"."ID", "test"."Byte", "test"."Bool1", "test"."Long", "test"."Timestamp", "test"."Date", "test"."Time", "test"."Bool2", "test"."String", "test"."Bool3", "test"."Double", "test"."Bool4", "test"."Float", "test"."Bool5", "test"."Decimal", NVL2("test"."Geometry",ST_AsBinary("test"."Geometry"),NULL), JSON_VALUE("test"."String", '$.acc_cit') AS "JsonValue1" FROM "test" WHERE (JSON_VALUE("test"."String", '$.acc_cit') = 1) ORDER BY "test"."ID" ASC;

INSERT INTO "test" ( 

     ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? 

  );

SELECT * FROM "test" LIMIT 0;

SELECT 

    "COLUMN_NAME", "CONSTRAINT_TYPE" 

FROM INFORMATION_SCHEMA.table_constraints t_cons inner join INFORMATION_SCHEMA.key_column_usage c on c.constraint_catalog = t_cons.constraint_catalog and c.table_schema = t_cons.table_schema and c.table_name = t_cons.table_name and c.constraint_name = t_cons.constraint_name  

WHERE (( (c.TABLE_NAME) LIKE ('test') ) AND ( ("CONSTRAINT_TYPE") = ('PRIMARY KEY') ));

--CREATE TABLE "test" (

--  "ID" INTEGER PRIMARY KEY NOT NULL, 

--  "Byte" TINYINT DEFAULT NULL, 

--  "Bool1" BOOLEAN DEFAULT NULL, 

--  "Long" BIGINT DEFAULT NULL, 

--  "Timestamp" TIMESTAMP DEFAULT NULL, 

--  "Date" DATE DEFAULT NULL, 

--  "Time" TIME DEFAULT NULL, 

--  "Bool2" BOOLEAN DEFAULT NULL, 

--  "String" VARCHAR(30) DEFAULT NULL, 

--  "Bool3" BOOLEAN DEFAULT NULL, 

--  "Double" DOUBLE DEFAULT NULL, 

--  "Bool4" BOOLEAN DEFAULT NULL, 

--  "Float" REAL DEFAULT NULL, 

--  "Bool5" BOOLEAN DEFAULT NULL, 

--  "Decimal" DECIMAL(6,3) DEFAULT NULL, 

--  "Geometry" GEOMETRY(1) CHECK NVL2("Geometry", ST_GeometryTypeCode("Geometry") = 1 AND ST_CoordDim("Geometry") = 2 AND ST_SRID("Geometry") = 4326, TRUE) 

--);

CREATE TABLE IF NOT EXISTS gpkg_contents (table_name TEXT NOT NULL PRIMARY KEY,data_type TEXT NOT NULL,identifier TEXT UNIQUE,description TEXT DEFAULT '',last_change DATETIME NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')),min_x DOUBLE, min_y DOUBLE,max_x DOUBLE, max_y DOUBLE,srs_id INTEGER,CONSTRAINT fk_gc_r_srs_id FOREIGN KEY (srs_id) REFERENCES gpkg_spatial_ref_sys(srs_id));

CREATE TABLE IF NOT EXISTS gpkg_extensions (

    table_name TEXT, 

    column_name TEXT, 

    extension_name TEXT NOT NULL, 

    definition TEXT NOT NULL, 

    scope TEXT NOT NULL, 

    CONSTRAINT ge_tce UNIQUE (table_name, column_name, extension_name) );

CREATE TABLE IF NOT EXISTS "gpkg_geometry_columns" (

	"table_name"	TEXT NOT NULL,

	"column_name"	TEXT NOT NULL,

	"geometry_type_name"	TEXT NOT NULL,

	"srs_id"	INTEGER NOT NULL,

	"z"	TINYINT NOT NULL,

	"m"	TINYINT NOT NULL,

	CONSTRAINT "pk_geom_cols" PRIMARY KEY("table_name","column_name"),

	CONSTRAINT "fk_gc_tn" FOREIGN KEY("table_name") REFERENCES "gpkg_contents"("table_name"),

	CONSTRAINT "uk_gc_table_name" UNIQUE("table_name"),

	CONSTRAINT "fk_gc_srs" FOREIGN KEY("srs_id") REFERENCES "gpkg_spatial_ref_sys"("srs_id")

INSERT INTO "main"."gpkg_contents" ("table_name", "data_type", "identifier", "description", "last_change", "min_x", "min_y", "max_x", "max_y", "srs_id") VALUES ('test', 'features', 'test', '', '2023-10-31 10:41:12.628', NULL, NULL, NULL, NULL, NULL);

CREATE TABLE "test" ("ID" MEDIUMINT PRIMARY KEY NOT NULL, "Byte" TINYINT DEFAULT NULL, "Bool1" BOOLEAN DEFAULT NULL, "Long" BIGINT DEFAULT NULL, "Timestamp" DATETIME DEFAULT NULL, "Date" DATE DEFAULT NULL, "Time" TIME DEFAULT NULL, "Bool2" BOOLEAN DEFAULT NULL, "String" VARCHAR(30) DEFAULT NULL, "Bool3" BOOLEAN DEFAULT NULL, "Double" DOUBLE PRECISION DEFAULT NULL, "Bool4" BOOLEAN DEFAULT NULL, "Float" FLOAT DEFAULT NULL, "Bool5" BOOLEAN DEFAULT NULL, "Decimal" DECIMAL(6,3) DEFAULT NULL, "Geometry" BLOB DEFAULT NULL );

INSERT INTO "main"."gpkg_geometry_columns" ("table_name", "column_name", "geometry_type_name", "srs_id", "z", "m") VALUES ('test', 'Geometry', 'POINT', '4326', '0', '0');

CREATE TABLE IF NOT EXISTS gpkg_extensions (

    table_name TEXT, 

    column_name TEXT, 

    extension_name TEXT NOT NULL, 

    definition TEXT NOT NULL, 

    scope TEXT NOT NULL, 

    CONSTRAINT ge_tce UNIQUE (table_name, column_name, extension_name) );

CREATE VIRTUAL TABLE "rtree_test_Geometry" USING rtree(id, minx, maxx, miny, maxy);

CREATE TRIGGER "rtree_test_Geometry_delete" AFTER DELETE ON "test"

  WHEN old."Geometry" NOT NULL

BEGIN

  DELETE FROM "rtree_test_Geometry" WHERE ID = OLD."ID";

END;

CREATE TRIGGER "rtree_test_Geometry_insert" AFTER INSERT ON "test"

  WHEN (new."Geometry" NOT NULL AND NOT ST_IsEmpty(NEW."Geometry"))

BEGIN

  INSERT OR REPLACE INTO "rtree_test_Geometry" VALUES (

    NEW."ID",

    ST_MinX(NEW."Geometry"), ST_MaxX(NEW."Geometry"),

    ST_MinY(NEW."Geometry"), ST_MaxY(NEW."Geometry")

  );

END;

CREATE TRIGGER "rtree_test_Geometry_update1" AFTER UPDATE OF "Geometry" ON "test"

  WHEN OLD."ID" = NEW."ID" AND

       (NEW."Geometry" NOTNULL AND NOT ST_IsEmpty(NEW."Geometry"))

BEGIN

  INSERT OR REPLACE INTO "rtree_test_Geometry" VALUES (

    NEW."ID",

    ST_MinX(NEW."Geometry"), ST_MaxX(NEW."Geometry"),

    ST_MinY(NEW."Geometry"), ST_MaxY(NEW."Geometry")

  );

END;

CREATE TRIGGER "rtree_test_Geometry_update2" AFTER UPDATE OF "Geometry" ON "test"

  WHEN OLD."ID" = NEW."ID" AND

       (NEW."Geometry" ISNULL OR ST_IsEmpty(NEW."Geometry"))

BEGIN

  DELETE FROM "rtree_test_Geometry" WHERE ID = OLD."ID";

END;

CREATE TRIGGER "rtree_test_Geometry_update3" AFTER UPDATE ON "test"

  WHEN OLD."ID" != NEW."ID" AND

       (NEW."Geometry" NOTNULL AND NOT ST_IsEmpty(NEW."Geometry"))

BEGIN

  DELETE FROM "rtree_test_Geometry" WHERE ID = OLD."ID";

  INSERT OR REPLACE INTO "rtree_test_Geometry" VALUES (

    NEW."ID",

    ST_MinX(NEW."Geometry"), ST_MaxX(NEW."Geometry"),

    ST_MinY(NEW."Geometry"), ST_MaxY(NEW."Geometry")

  );

END;

CREATE TRIGGER "rtree_test_Geometry_update4" AFTER UPDATE ON "test"

  WHEN OLD."ID" != NEW."ID" AND

       (NEW."Geometry" ISNULL OR ST_IsEmpty(NEW."Geometry"))

BEGIN

  DELETE FROM "rtree_test_Geometry" WHERE ID IN (OLD."ID", NEW."ID");

END;

INSERT INTO "gpkg_extensions" (

    "table_name", 

    "column_name", 

    "extension_name", 

    "definition", 

    "scope"

) VALUES (

    'test', 

    'Geometry', 

    'gpkg_rtree_index', 

    'http://www.geopackage.org/spec/#extension_rtree', 

    'read-write'

);

DELETE FROM gpkg_geometry_columns WHERE table_name = "test";

DELETE FROM "main"."gpkg_contents" WHERE "identifier" = 'test';

DELETE FROM "main"."gpkg_extensions" WHERE "table_name" = 'test';

DROP TABLE "test";

    "test"."ID", "test"."Byte", "test"."Bool1", "test"."Long", 

    "test"."Timestamp", "test"."Date", "test"."Time", "test"."Bool2", 

    "test"."String", "test"."Bool3", "test"."Double", "test"."Bool4", 

    "test"."Float", "test"."Bool5", "test"."Decimal", "test"."Geometry" 

FROM "test" 

    ((("test"."Time" > ('01:02:03')) AND ("test"."Time" < ('20:52:55'))) OR 

    (("test"."Date" > ('2019-02-17')) AND ("test"."Date" < ('2020-02-23')))) 

ORDER BY "test"."ID" ASC;

SELECT "test"."ID",

       "test"."Byte",

       "test"."Bool1",

       "test"."Long",

       "test"."Timestamp",

       "test"."Date",

       "test"."Time",

       "test"."Bool2",

       "test"."String",

       "test"."Bool3",

       "test"."Double",

       "test"."Bool4",

       "test"."Float",

       "test"."Bool5",

       "test"."Decimal",

       "test"."Geometry"

FROM "test"

ORDER BY "test"."ID" ASC

SELECT MIN("test"."ID") AS "ID",

       MAX("test"."Byte") AS "Byte",

       "test"."Long",

       SUM("test"."Double") AS "Double",

FROM "test"

GROUP BY "test"."Long"

ORDER BY "test"."Long" ASC NULLS LAST

SELECT "test"."ID",

       "test"."Byte",

       "test"."Bool1",

       "test"."Long",

       "test"."Timestamp",

       "test"."Date",

       "test"."Time",

       "test"."Bool2",

       "test"."String",

       "test"."Bool3",

       "test"."Double",

       "test"."Bool4",

       "test"."Float",

       "test"."Bool5",

       "test"."Decimal",

       "test"."Geometry",

       NVL2(COALESCE(( SELECT "countries"."ISO_A2" FROM "countries" WHERE (("test"."STRING" = "countries"."CONTINENT") AND ("countries"."LASTCENSUS" < 0)) LIMIT 1 )),TRUE,FALSE) AS "EXISTS62a964cd7bc24f409b97c03b9170408d"

FROM "test"

                    WHERE (("test"."STRING" = "countries"."CONTINENT") AND ("countries"."LASTCENSUS" < 0))

ORDER BY "test"."ID" ASC

SELECT "test"."ID",

       "test"."Byte",

       "test"."Bool1",

       "test"."Long",

       "test"."Timestamp",

       "test"."Date",

       "test"."Time",

       "test"."Bool2",

       "test"."String",

       "test"."Bool3",

       "test"."Double",

       "test"."Bool4",

       "test"."Float",

       "test"."Bool5",

       "test"."Decimal",

       "test"."Geometry",

       NVL2(COALESCE(( SELECT "test"."Long" FROM "countries" WHERE (("test"."STRING" = "countries"."CONTINENT") AND ("countries"."LASTCENSUS" < 0)) LIMIT 1 )),TRUE,FALSE) AS "EXISTS62a964cd7bc24f409b97c03b9170408d"

FROM "test"

WHERE NVL2(COALESCE(( SELECT "test"."Long"

                    WHERE (("test"."STRING" = "countries"."CONTINENT") AND ("countries"."LASTCENSUS" < 0))

ORDER BY "test"."ID" ASC

SELECT MIN("test"."ID") AS "ID",

       MAX("test"."Byte") AS "Byte",

       "test"."Long",

       SUM("test"."Double") AS "Double",

FROM "test"

                    WHERE (("test"."STRING" = "countries"."CONTINENT") AND ("countries"."LASTCENSUS" < 0))

GROUP BY "test"."Long"

ORDER BY "test"."Long" ASC NULLS LAST

SELECT "test"."ID",

        "test"."Byte",

       "test"."Bool1",

       "test"."Long",

       "test"."Timestamp",

       "test"."Date",

       "test"."Time",

       "test"."Bool2",

       "test"."String",

       "test"."Bool3",

       "test"."Double",

       "test"."Bool4",

       "test"."Float",

       "test"."Bool5",

       "test"."Decimal",

       "test"."Geometry"

FROM "test"

ORDER BY "test"."ID" ASC

SELECT "test"."ID",

       "test"."Byte",

       "test"."Bool1",

       "test"."Long",

       "test"."Timestamp",

       "test"."Date",

       "test"."Time",

       "test"."Bool2",

       "test"."String",

       "test"."Bool3",

       "test"."Double",

       "test"."Bool4",

       "test"."Float",

       "test"."Bool5",

       "test"."Decimal",

       "test"."Geometry",

       ("test"."ID" * 2) AS "Compu1"

FROM "test"

ORDER BY "test"."ID" ASC

SELECT "test"."ID",

       "test"."Byte",

       "test"."Bool1",

       "test"."Long",

       "test"."Timestamp",

       "test"."Date",

       "test"."Time",

       "test"."Bool2",

       "test"."String",

       "test"."Bool3",

       "test"."Double",

       "test"."Bool4",

       "test"."Float",

       "test"."Bool5",

       "test"."Decimal",

       "test"."Geometry",

       ("test"."ID" * 2) AS "Compu1",

       (("test"."Long" + 10) + ("test"."ID" * 2)) AS "Compu2"

FROM "test"

ORDER BY "test"."ID" ASC

SELECT "test"."ID",

       "test"."Byte",

       "test"."Bool1",

       "test"."Long",

       "test"."Timestamp",

       "test"."Date",

       "test"."Time",

       "test"."Bool2",

       "test"."String",

       "test"."Bool3",

       "test"."Double",

       "test"."Bool4",

       "test"."Float",

       "test"."Bool5",

       "test"."Decimal",

       "test"."Geometry",

       ("test"."ID" * 2) AS "Compu1",

       (("test"."Long" + 10) + ("test"."ID" * 2)) AS "Extra1"

FROM "test"

ORDER BY "test"."ID" ASC

SELECT "test"."ID",

       "test"."Byte",

       "test"."Bool1",

       "test"."Long",

       "test"."Timestamp",

       "test"."Date",

       "test"."Time",

       "test"."Bool2",

       "test"."String",

       "test"."Bool3",

       "test"."Double",

       "test"."Bool4",

       "test"."Float",

       "test"."Bool5",

       "test"."Decimal",

       "test"."Geometry",

       ("test"."ID" * 2) AS "Extra1",

       (("test"."Long" + 10) + ("test"."ID" * 2)) AS "Extra2"

FROM "test"

ORDER BY "test"."ID" ASC

SELECT "test"."ID",

       "test"."Byte",

       "test"."Bool1",

       "test"."Long",

       "test"."Timestamp",

       "test"."Date",

       "test"."Time",

       "test"."Bool2",

       "test"."String",

       "test"."Bool3",

       "test"."Double",

       "test"."Bool4",

       "test"."Float",

       "test"."Bool5",

       "test"."Decimal",

       "test"."Geometry",

       ("test"."ID" * 2) AS "Compu1",

       (("test"."Long" + 10) + ("test"."ID" * 2)) AS "Extra1"

FROM "test"

WHERE ((("test"."Long" + 10) + ("test"."ID" * 2)) > 10)

         "test"."ID" ASC

SELECT MIN("test"."ID") AS "ID",

       MAX("test"."Byte") AS "Byte",

       "test"."Long",

       SUM("test"."Double") AS "Double",

       ("test"."ID" * 2) AS "Compu1",

       SUM(("test"."Long" + 300)) AS "Compu2",

       (("test"."Long" + 10) + ("test"."ID" * 2)) AS "Extra1",

       SUM(((20 + "test"."Byte") + ("test"."ID" * 2))) AS "Extra2"

FROM "test"

GROUP BY "test"."Long",

         (("test"."Long" + 10) + ("test"."ID" * 2)),

         ("test"."ID" * 2)

ORDER BY "test"."Long" ASC NULLS LAST,

         (("test"."Long" + 10) + ("test"."ID" * 2)) ASC NULLS LAST,

         ("test"."ID" * 2) ASC NULLS LAST

SELECT MIN("test"."ID") AS "ID",

       MAX("test"."Byte") AS "Byte",

       "test"."Long",

       SUM("test"."Double") AS "Double",

       ("test"."ID" * 2) AS "Compu1",

       SUM(("test"."Long" + 300)) AS "Compu2",

       (("test"."Long" + 10) + ("test"."ID" * 2)) AS "Extra1",

       SUM(((20 + "test"."Byte") + ("test"."ID" * 2))) AS "Extra2",

FROM "test"

GROUP BY "test"."Long",

         (("test"."Long" + 10) + ("test"."ID" * 2)),

         ("test"."ID" * 2)

SELECT MIN("test"."ID") AS "ID",

       MAX("test"."Byte") AS "Byte",

       SUM("test"."Double") AS "Double",

       SUM(("test"."Long" + 10)) AS "Extra1",

FROM "test"

ORDER BY MIN("test"."ID") ASC,

SELECT COUNT(*) FROM "test"

FROM ( SELECT MAX("test"."Byte") AS "Byte", 

             MIN("test"."ID") AS "ID", 

             SUM("test"."Double") AS "Double" 

      FROM "test" 

      GROUP BY "test"."Long") AS _subquery_alias_ 

FROM ( SELECT "test"."Long" 

      FROM "test" 

      GROUP BY "test"."Long") AS _subquery_alias_ 

FROM ( SELECT MAX("test"."Byte") AS "Byte", 

             MIN("test"."ID") AS "ID", 

             SUM("test"."Double") AS "Double" 

      FROM "test") AS _subquery_alias_ 

package org.gvsig.sqlite.dal;

import java.io.File;

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.ResultSetMetaData;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.ArrayList;

import java.util.List;

import java.util.Objects;

import org.apache.commons.io.FilenameUtils;

import org.apache.commons.lang3.StringUtils;

import static org.gvsig.fmap.dal.DatabaseWorkspaceManager.FIELD_CONFIGURATION_NAME;

import static org.gvsig.fmap.dal.DatabaseWorkspaceManager.FIELD_CONFIGURATION_VALUE;

import static org.gvsig.fmap.dal.DatabaseWorkspaceManager.FIELD_RESOURCES_NAME;

import static org.gvsig.fmap.dal.DatabaseWorkspaceManager.FIELD_RESOURCES_RESOURCE;

import static org.gvsig.fmap.dal.DatabaseWorkspaceManager.TABLE_CONFIGURATION_NAME;

import static org.gvsig.fmap.dal.DatabaseWorkspaceManager.TABLE_RESOURCES_NAME;

import org.gvsig.fmap.dal.store.jdbc.exception.JDBCDriverClassNotFoundException;

import org.gvsig.fmap.dal.store.jdbc2.JDBCUtils;

import org.gvsig.sqlite.dal.functions.Functions;

import org.gvsig.sqlite.dal.geopackage.GeopackageUtils;

import org.gvsig.tools.library.impl.DefaultLibrariesInitializer;

import org.slf4j.Logger;

import org.slf4j.LoggerFactory;

import org.sqlite.SQLiteConfig;

import org.sqlite.SQLiteConnection;

import org.sqlite.SQLiteOpenMode;

public class RunSQL {

    private static final Logger LOGGER = LoggerFactory.getLogger(RunSQL.class);

    public static final String DBNAME = "testCreate";

    public static void main(String[] args) throws Exception {

        new DefaultLibrariesInitializer().fullInitialize();

        //Modificar estas tres l?neas para cada test

        //Test date

//        String sql = "SELECT \"test\".\"ID\", \"test\".\"Byte\", \"test\".\"Bool1\", \"test\".\"Long\", \"test\".\"Timestamp\", \"test\".\"Date\", \"test\".\"Time\", \"test\".\"Bool2\", \"test\".\"String\", \"test\".\"Bool3\", \"test\".\"Double\", \"test\".\"Bool4\", \"test\".\"Float\", \"test\".\"Bool5\", \"test\".\"Decimal\", \"test\".\"Geometry\" FROM \"test\" WHERE (((\"test\".\"Time\" > ('01:02:03')) AND (\"test\".\"Time\" < ('20:52:55'))) OR ((\"test\".\"Date\" > ('2019-08-01')) AND (\"test\".\"Date\" < ('2020-02-23')))) ORDER BY \"test\".\"ID\" ASC";

        //Test drop table (Sin ejecutar)

//        String sql = "DELETE FROM gpkg_geometry_columns WHERE table_name = \"test\"";

//        String sql = "DELETE FROM \"main\".\"gpkg_contents\" WHERE \"identifier\" = 'test'";

//        String sql = "DELETE FROM \"main\".\"gpkg_extensions\" WHERE \"table_name\" = 'test'";

//        String sql = "DROP TABLE \"test\"";

        //Test fetch feature type by reference

//        String sql = "SELECT \"test\".\"ID\", \"test\".\"Byte\", \"test\".\"Bool1\", \"test\".\"Long\", \"test\".\"Timestamp\", \"test\".\"Date\", \"test\".\"Time\", \"test\".\"Bool2\", \"test\".\"String\", \"test\".\"Bool3\", \"test\".\"Double\", \"test\".\"Bool4\", \"test\".\"Float\", \"test\".\"Bool5\", \"test\".\"Decimal\", \"test\".\"Geometry\" FROM \"test\" WHERE ( (\"test\".\"ID\") = (4) ) LIMIT 1";

        //FetchFeatureType first row SQL

//        String sql = "SELECT * FROM \"test\" LIMIT 0";

        //Test fetch feature type (CHUNGO REVISAR)

//        String sql = "SELECT \n" +

//            "    \"COLUMN_NAME\", \"CONSTRAINT_TYPE\" \n" +

//            "FROM INFORMATION_SCHEMA.table_constraints t_cons inner join INFORMATION_SCHEMA.key_column_usage c on c.constraint_catalog = t_cons.constraint_catalog and c.table_schema = t_cons.table_schema and c.table_name = t_cons.table_name and c.constraint_name = t_cons.constraint_name  \n" +

//            "WHERE (( (c.TABLE_NAME) LIKE ('test') ) AND ( (\"CONSTRAINT_TYPE\") = ('PRIMARY KEY') ))";

        //Test Subselect (CHUNGO REVISAR)

//        String sql = "SELECT \"test\".\"ID\", \"test\".\"Byte\", \"test\".\"Bool1\", \"test\".\"Long\", "

//                + "\"test\".\"Timestamp\", \"test\".\"Date\", \"test\".\"Time\", \"test\".\"Bool2\", "

//                + "\"test\".\"String\", \"test\".\"Bool3\", \"test\".\"Double\", \"test\".\"Bool4\", "

//                + "\"test\".\"Float\", \"test\".\"Bool5\", \"test\".\"Decimal\", \"test\".\"Geometry\", "

//                + "EXISTS(( SELECT \"countries\".\"ISO_A2\" "

//                + "FROM \"countries\" "

//                + "WHERE ((\"test\".\"STRING\" = \"countries\".\"CONTINENT\") AND (\"countries\".\"LASTCENSUS\" < 0)) LIMIT 1 )) AS \"EXISTS62a964cd7bc24f409b97c03b9170408d\" "

//                + "FROM \"test\" "

//                + "WHERE EXISTS(( SELECT \"countries\".\"ISO_A2\" "

//                    + "FROM \"countries\" "

//                    + "WHERE ((\"test\".\"STRING\" = \"countries\".\"CONTINENT\") AND (\"countries\".\"LASTCENSUS\" < 0)) LIMIT 1 )) "

//                + "ORDER BY \"test\".\"ID\" ASC";

        //Test STDistance (He a?adido la funcion ST_DISTANCE)

//        String sql = "SELECT \"test\".\"ID\", \"test\".\"Byte\", \"test\".\"Bool1\", \"test\".\"Long\", \"test\".\"Timestamp\", \"test\".\"Date\", \"test\".\"Time\", \"test\".\"Bool2\", \"test\".\"String\", \"test\".\"Bool3\", \"test\".\"Double\", \"test\".\"Bool4\", \"test\".\"Float\", \"test\".\"Bool5\", \"test\".\"Decimal\", \"test\".\"Geometry\" FROM \"test\" WHERE ( ((\"ID\" IN (SELECT \"rtree_test_Geometry\".\"id\" FROM \"rtree_test_Geometry\" WHERE \"rtree_test_Geometry\".\"minx\" <= (1.0) AND \"rtree_test_Geometry\".\"miny\" <= (41.0) AND \"rtree_test_Geometry\".\"maxx\" >= (-1.0) AND \"rtree_test_Geometry\".\"maxy\" >= (39.0)))) AND ST_Intersects((ST_GeomFromWKB((X'000000000300000001000000213ff000000000000040440000000000003fef6297cff75cb04043e70747c3965a3fed906bcf328d464043cf043ab2a2ad3fea9b66290ea1a34043b8e31319465d3fe6a09e667f3bcd4043a57d866603113fe1c73b39ae68c940439592675bc5793fd87de2a6aea964404389be50c335cb3fc8f8b83c69a60d40438275a0c0228d3c91a62633145c074043800000000000bfc8f8b83c69a60840438275a0c0228dbfd87de2a6aea962404389be50c335cbbfe1c73b39ae68c640439592675bc579bfe6a09e667f3bcc4043a57d86660311bfea9b66290ea1a44043b8e31319465dbfed906bcf328d474043cf043ab2a2adbfef6297cff75cb14043e70747c3965abff00000000000004044000000000000bfef6297cff75cae404418f8b83c69a6bfed906bcf328d42404430fbc54d5d53bfea9b66290ea19c4044471cece6b9a3bfe6a09e667f3bc240445a827999fcefbfe1c73b39ae68bb40446a6d98a43a87bfd87de2a6aea94140447641af3cca35bfc8f8b83c69a5bb40447d8a5f3fdd733ce6586c6b36175f40448000000000003fc8f8b83c69a66a40447d8a5f3fdd733fd87de2a6aea99340447641af3cca353fe1c73b39ae68e040446a6d98a43a863fe6a09e667f3be240445a827999fcef3fea9b66290ea1b54044471cece6b9a33fed906bcf328d53404430fbc54d5d523fef6297cff75cb7404418f8b83c69a53ff00000000000004044000000000000'), 4326)),(\"test\".\"Geometry\") )) ORDER BY ST_Distance(ST_GeomFromWKB((X'000000000300000001000000213ff000000000000040440000000000003fef6297cff75cb04043e70747c3965a3fed906bcf328d464043cf043ab2a2ad3fea9b66290ea1a34043b8e31319465d3fe6a09e667f3bcd4043a57d866603113fe1c73b39ae68c940439592675bc5793fd87de2a6aea964404389be50c335cb3fc8f8b83c69a60d40438275a0c0228d3c91a62633145c074043800000000000bfc8f8b83c69a60840438275a0c0228dbfd87de2a6aea962404389be50c335cbbfe1c73b39ae68c640439592675bc579bfe6a09e667f3bcc4043a57d86660311bfea9b66290ea1a44043b8e31319465dbfed906bcf328d474043cf043ab2a2adbfef6297cff75cb14043e70747c3965abff00000000000004044000000000000bfef6297cff75cae404418f8b83c69a6bfed906bcf328d42404430fbc54d5d53bfea9b66290ea19c4044471cece6b9a3bfe6a09e667f3bc240445a827999fcefbfe1c73b39ae68bb40446a6d98a43a87bfd87de2a6aea94140447641af3cca35bfc8f8b83c69a5bb40447d8a5f3fdd733ce6586c6b36175f40448000000000003fc8f8b83c69a66a40447d8a5f3fdd733fd87de2a6aea99340447641af3cca353fe1c73b39ae68e040446a6d98a43a863fe6a09e667f3be240445a827999fcef3fea9b66290ea1b54044471cece6b9a33fed906bcf328d53404430fbc54d5d523fef6297cff75cb7404418f8b83c69a53ff00000000000004044000000000000'), 4326), \"Geometry\") ASC NULLS LAST, \"test\".\"ID\" ASC LIMIT 1";

//        String sql = "SELECT \"test\".\"ID\", \"test\".\"Byte\", \"test\".\"Bool1\", \"test\".\"Long\", \"test\".\"Timestamp\", \"test\".\"Date\", \"test\".\"Time\", \"test\".\"Bool2\", \"test\".\"String\", \"test\".\"Bool3\", \"test\".\"Double\", \"test\".\"Bool4\", \"test\".\"Float\", \"test\".\"Bool5\", \"test\".\"Decimal\", \"test\".\"Geometry\" FROM \"test\" WHERE ST_Intersects((ST_GeomFromWKB((X'000000000300000001000000213ff000000000000040440000000000003fef6297cff75cb04043e70747c3965a3fed906bcf328d464043cf043ab2a2ad3fea9b66290ea1a34043b8e31319465d3fe6a09e667f3bcd4043a57d866603113fe1c73b39ae68c940439592675bc5793fd87de2a6aea964404389be50c335cb3fc8f8b83c69a60d40438275a0c0228d3c91a62633145c074043800000000000bfc8f8b83c69a60840438275a0c0228dbfd87de2a6aea962404389be50c335cbbfe1c73b39ae68c640439592675bc579bfe6a09e667f3bcc4043a57d86660311bfea9b66290ea1a44043b8e31319465dbfed906bcf328d474043cf043ab2a2adbfef6297cff75cb14043e70747c3965abff00000000000004044000000000000bfef6297cff75cae404418f8b83c69a6bfed906bcf328d42404430fbc54d5d53bfea9b66290ea19c4044471cece6b9a3bfe6a09e667f3bc240445a827999fcefbfe1c73b39ae68bb40446a6d98a43a87bfd87de2a6aea94140447641af3cca35bfc8f8b83c69a5bb40447d8a5f3fdd733ce6586c6b36175f40448000000000003fc8f8b83c69a66a40447d8a5f3fdd733fd87de2a6aea99340447641af3cca353fe1c73b39ae68e040446a6d98a43a863fe6a09e667f3be240445a827999fcef3fea9b66290ea1b54044471cece6b9a33fed906bcf328d53404430fbc54d5d523fef6297cff75cb7404418f8b83c69a53ff00000000000004044000000000000'), 4326)),(\"test\".\"Geometry\")) ORDER BY ST_Distance(ST_GeomFromWKB((X'000000000300000001000000213ff000000000000040440000000000003fef6297cff75cb04043e70747c3965a3fed906bcf328d464043cf043ab2a2ad3fea9b66290ea1a34043b8e31319465d3fe6a09e667f3bcd4043a57d866603113fe1c73b39ae68c940439592675bc5793fd87de2a6aea964404389be50c335cb3fc8f8b83c69a60d40438275a0c0228d3c91a62633145c074043800000000000bfc8f8b83c69a60840438275a0c0228dbfd87de2a6aea962404389be50c335cbbfe1c73b39ae68c640439592675bc579bfe6a09e667f3bcc4043a57d86660311bfea9b66290ea1a44043b8e31319465dbfed906bcf328d474043cf043ab2a2adbfef6297cff75cb14043e70747c3965abff00000000000004044000000000000bfef6297cff75cae404418f8b83c69a6bfed906bcf328d42404430fbc54d5d53bfea9b66290ea19c4044471cece6b9a3bfe6a09e667f3bc240445a827999fcefbfe1c73b39ae68bb40446a6d98a43a87bfd87de2a6aea94140447641af3cca35bfc8f8b83c69a5bb40447d8a5f3fdd733ce6586c6b36175f40448000000000003fc8f8b83c69a66a40447d8a5f3fdd733fd87de2a6aea99340447641af3cca353fe1c73b39ae68e040446a6d98a43a863fe6a09e667f3be240445a827999fcef3fea9b66290ea1b54044471cece6b9a33fed906bcf328d53404430fbc54d5d523fef6297cff75cb7404418f8b83c69a53ff00000000000004044000000000000'), 4326), \"Geometry\") ASC NULLS LAST, \"test\".\"ID\" ASC LIMIT 1";

        //Test Perform changes

//        List<String> sqls = new ArrayList();

        //###### SQL[insert]:

//        sqls.add("INSERT INTO \"test\" ( \"ID\", \"Byte\", \"Bool1\", \"Long\", \"Timestamp\", \"Date\", \"Time\", \"Bool2\", \"String\", \"Bool3\", \"Double\", \"Bool4\", \"Float\", \"Bool5\", \"Decimal\", \"Geometry\" ) VALUES ( 30, 30, TRUE, 30000, CURRENT_TIMESTAMP, CURRENT_DATE, CURRENT_TIME, TRUE, 'Treinta', FALSE, 30.3030, TRUE, 30.3030, TRUE, 30.303, ST_GeomFromWKB((X'000000000300000001000000213ff000000000000040440000000000003fef6297cff75cb04043e70747c3965a3fed906bcf328d464043cf043ab2a2ad3fea9b66290ea1a34043b8e31319465d3fe6a09e667f3bcd4043a57d866603113fe1c73b39ae68c940439592675bc5793fd87de2a6aea964404389be50c335cb3fc8f8b83c69a60d40438275a0c0228d3c91a62633145c074043800000000000bfc8f8b83c69a60840438275a0c0228dbfd87de2a6aea962404389be50c335cbbfe1c73b39ae68c640439592675bc579bfe6a09e667f3bcc4043a57d86660311bfea9b66290ea1a44043b8e31319465dbfed906bcf328d474043cf043ab2a2adbfef6297cff75cb14043e70747c3965abff00000000000004044000000000000bfef6297cff75cae404418f8b83c69a6bfed906bcf328d42404430fbc54d5d53bfea9b66290ea19c4044471cece6b9a3bfe6a09e667f3bc240445a827999fcefbfe1c73b39ae68bb40446a6d98a43a87bfd87de2a6aea94140447641af3cca35bfc8f8b83c69a5bb40447d8a5f3fdd733ce6586c6b36175f40448000000000003fc8f8b83c69a66a40447d8a5f3fdd733fd87de2a6aea99340447641af3cca353fe1c73b39ae68e040446a6d98a43a863fe6a09e667f3be240445a827999fcef3fea9b66290ea1b54044471cece6b9a33fed906bcf328d53404430fbc54d5d523fef6297cff75cb7404418f8b83c69a53ff00000000000004044000000000000'), 4326) )");

        //###### SQL[delete]:

//        sqls.add("DELETE FROM \"test\" WHERE ( (\"ID\") = (30) )");

        //###### SQL[update]:

//        sqls.add("UPDATE \"test\" SET \"Byte\" = 31, \"Bool1\" = FALSE, \"Long\" = 313131, \"Timestamp\" = CURRENT_TIMESTAMP, \"Date\" = CURRENT_DATE, \"Time\" = CURRENT_TIME, \"Bool2\" = FALSE, \"String\" = 'Treinta y uno', \"Bool3\" = FALSE, \"Double\" = 31.3131, \"Bool4\" = FALSE, \"Float\" = 31.3131, \"Bool5\" = FALSE, \"Decimal\" = 31.313, \"Geometry\" = ST_GeomFromWKB((X'000000000300000001000000213ff000000000000040440000000000003fef6297cff75cb04043e70747c3965a3fed906bcf328d464043cf043ab2a2ad3fea9b66290ea1a34043b8e31319465d3fe6a09e667f3bcd4043a57d866603113fe1c73b39ae68c940439592675bc5793fd87de2a6aea964404389be50c335cb3fc8f8b83c69a60d40438275a0c0228d3c91a62633145c074043800000000000bfc8f8b83c69a60840438275a0c0228dbfd87de2a6aea962404389be50c335cbbfe1c73b39ae68c640439592675bc579bfe6a09e667f3bcc4043a57d86660311bfea9b66290ea1a44043b8e31319465dbfed906bcf328d474043cf043ab2a2adbfef6297cff75cb14043e70747c3965abff00000000000004044000000000000bfef6297cff75cae404418f8b83c69a6bfed906bcf328d42404430fbc54d5d53bfea9b66290ea19c4044471cece6b9a3bfe6a09e667f3bc240445a827999fcefbfe1c73b39ae68bb40446a6d98a43a87bfd87de2a6aea94140447641af3cca35bfc8f8b83c69a5bb40447d8a5f3fdd733ce6586c6b36175f40448000000000003fc8f8b83c69a66a40447d8a5f3fdd733fd87de2a6aea99340447641af3cca353fe1c73b39ae68e040446a6d98a43a863fe6a09e667f3be240445a827999fcef3fea9b66290ea1b54044471cece6b9a33fed906bcf328d53404430fbc54d5d523fef6297cff75cb7404418f8b83c69a53ff00000000000004044000000000000'), 4326) WHERE ( (\"ID\") = (30) )");

        //###### SQL[updatetable 0]:

//        sqls.add("ALTER TABLE \"test\" ADD COLUMN \"Byte10\" TINYINT DEFAULT NULL NULL");

//        //###### SQL[updatetable 1]:

//        sqls.add("ALTER TABLE \"test\" ADD COLUMN \"Bool101\" BOOLEAN DEFAULT NULL NULL");

//        //###### SQL[updatetable 2]:

//        sqls.add("ALTER TABLE \"test\" ADD COLUMN \"Long10\" BIGINT DEFAULT NULL NULL");

//        //###### SQL[updatetable 3]:

//        sqls.add("ALTER TABLE \"test\" ADD COLUMN \"Timestamp10\" DATETIME DEFAULT NULL NULL");

//        //###### SQL[updatetable 4]:

//        sqls.add("ALTER TABLE \"test\" ADD COLUMN \"Date10\" DATE DEFAULT NULL NULL");

//        //###### SQL[updatetable 5]:

//        sqls.add("ALTER TABLE \"test\" ADD COLUMN \"Time10\" TIME DEFAULT NULL NULL");

//        //###### SQL[updatetable 6]:

//        sqls.add("ALTER TABLE \"test\" ADD COLUMN \"Bool102\" BOOLEAN DEFAULT NULL NULL");

//        //###### SQL[updatetable 7]:

//        sqls.add("ALTER TABLE \"test\" ADD COLUMN \"String10\" VARCHAR(30) DEFAULT NULL NULL");

//        //###### SQL[updatetable 8]:

//        sqls.add("ALTER TABLE \"test\" ADD COLUMN \"Bool103\" BOOLEAN DEFAULT NULL NULL");

//        //###### SQL[updatetable 9]:

//        sqls.add("ALTER TABLE \"test\" ADD COLUMN \"Double10\" DOUBLE PRECISION DEFAULT NULL NULL");

//        //###### SQL[updatetable 10]:

//        sqls.add("ALTER TABLE \"test\" ADD COLUMN \"Bool104\" BOOLEAN DEFAULT NULL NULL");

//        //###### SQL[updatetable 11]:

//        sqls.add("ALTER TABLE \"test\" ADD COLUMN \"Float10\" FLOAT DEFAULT NULL NULL");

//        //###### SQL[updatetable 12]:

//        sqls.add("ALTER TABLE \"test\" ADD COLUMN \"Bool105\" BOOLEAN DEFAULT NULL NULL");

//        //###### SQL[updatetable 13]:

//        sqls.add("ALTER TABLE \"test\" ADD COLUMN \"Decimal10\" DECIMAL(6,3) DEFAULT NULL NULL");

//        //###### SQL[updatetable 14]:

//        sqls.add("ALTER TABLE \"test\" ADD COLUMN \"Geometry10\" BLOB DEFAULT NULL NULL");

//        

//        sqls.add("ALTER TABLE \"test\" DROP COLUMN \"Byte10\"");

//        //###### SQL[updatetable 1]:

//        sqls.add("ALTER TABLE \"test\" DROP COLUMN \"Bool101\"");

//        //###### SQL[updatetable 2]:

//        sqls.add("ALTER TABLE \"test\" DROP COLUMN \"Long10\"");

//        //###### SQL[updatetable 3]:

//        sqls.add("ALTER TABLE \"test\" DROP COLUMN \"Timestamp10\"");

//        //###### SQL[updatetable 4]:

//        sqls.add("ALTER TABLE \"test\" DROP COLUMN \"Date10\"");

//        //###### SQL[updatetable 5]:

//        sqls.add("ALTER TABLE \"test\" DROP COLUMN \"Time10\"");

//        //###### SQL[updatetable 6]:

//        sqls.add("ALTER TABLE \"test\" DROP COLUMN \"Bool102\"");

//        //###### SQL[updatetable 7]:

//        sqls.add("ALTER TABLE \"test\" DROP COLUMN \"String10\"");

//        //###### SQL[updatetable 8]:

//        sqls.add("ALTER TABLE \"test\" DROP COLUMN \"Bool103\"");

//        //###### SQL[updatetable 9]:

//        sqls.add("ALTER TABLE \"test\" DROP COLUMN \"Double10\"");

//        //###### SQL[updatetable 10]:

//        sqls.add("ALTER TABLE \"test\" DROP COLUMN \"Bool104\"");

//        //###### SQL[updatetable 11]:

//        sqls.add("ALTER TABLE \"test\" DROP COLUMN \"Float10\"");

//        //###### SQL[updatetable 12]:

//        sqls.add("ALTER TABLE \"test\" DROP COLUMN \"Bool105\"");

//        //###### SQL[updatetable 13]:

//        sqls.add("ALTER TABLE \"test\" DROP COLUMN \"Decimal10\"");

//        //###### SQL[updatetable 14]:

//        sqls.add("ALTER TABLE \"test\" DROP COLUMN \"Geometry10\"");

        //ResultSetForSetProvider

//        String sql = "SELECT \"test\".\"ID\", \"test\".\"Byte\", \"test\".\"Bool1\", \"test\".\"Long\", \"test\".\"Timestamp\", \"test\".\"Date\", \"test\".\"Time\", \"test\".\"Bool2\", \"test\".\"String\", \"test\".\"Bool3\", \"test\".\"Double\", \"test\".\"Bool4\", \"test\".\"Float\", \"test\".\"Bool5\", \"test\".\"Decimal\", \"test\".\"Geometry\" FROM \"test\" ORDER BY \"test\".\"ID\" ASC";

//        String sql = "SELECT \"test\".\"ID\", \"test\".\"Byte\", \"test\".\"Bool1\", \"test\".\"Long\", \"test\".\"Timestamp\", \"test\".\"Date\", \"test\".\"Time\", \"test\".\"Bool2\", \"test\".\"String\", \"test\".\"Bool3\", \"test\".\"Double\", \"test\".\"Bool4\", \"test\".\"Float\", \"test\".\"Bool5\", \"test\".\"Decimal\", \"test\".\"Geometry\", (\"test\".\"ID\" * 2) AS \"Compu1\" FROM \"test\" ORDER BY \"test\".\"ID\" ASC";

//        String sql = "SELECT \"test\".\"ID\", \"test\".\"Byte\", \"test\".\"Bool1\", \"test\".\"Long\", \"test\".\"Timestamp\", \"test\".\"Date\", \"test\".\"Time\", \"test\".\"Bool2\", \"test\".\"String\", \"test\".\"Bool3\", \"test\".\"Double\", \"test\".\"Bool4\", \"test\".\"Float\", \"test\".\"Bool5\", \"test\".\"Decimal\", \"test\".\"Geometry\", (\"test\".\"ID\" * 2) AS \"Compu1\", ((\"test\".\"Long\" + 10) + (\"test\".\"ID\" * 2)) AS \"Compu2\" FROM \"test\" ORDER BY \"test\".\"ID\" ASC";

//        String sql = "SELECT \"test\".\"ID\", \"test\".\"Byte\", \"test\".\"Bool1\", \"test\".\"Long\", \"test\".\"Timestamp\", \"test\".\"Date\", \"test\".\"Time\", \"test\".\"Bool2\", \"test\".\"String\", \"test\".\"Bool3\", \"test\".\"Double\", \"test\".\"Bool4\", \"test\".\"Float\", \"test\".\"Bool5\", \"test\".\"Decimal\", \"test\".\"Geometry\", (\"test\".\"ID\" * 2) AS \"Compu1\", ((\"test\".\"Long\" + 10) + (\"test\".\"ID\" * 2)) AS \"Extra1\" FROM \"test\" ORDER BY \"test\".\"ID\" ASC";

//        String sql = "SELECT \"test\".\"ID\", \"test\".\"Byte\", \"test\".\"Bool1\", \"test\".\"Long\", \"test\".\"Timestamp\", \"test\".\"Date\", \"test\".\"Time\", \"test\".\"Bool2\", \"test\".\"String\", \"test\".\"Bool3\", \"test\".\"Double\", \"test\".\"Bool4\", \"test\".\"Float\", \"test\".\"Bool5\", \"test\".\"Decimal\", \"test\".\"Geometry\", (\"test\".\"ID\" * 2) AS \"Extra1\", ((\"test\".\"Long\" + 10) + (\"test\".\"ID\" * 2)) AS \"Extra2\" FROM \"test\" ORDER BY \"test\".\"ID\" ASC";

//        String sql = "SELECT \"test\".\"ID\", \"test\".\"Byte\", \"test\".\"Bool1\", \"test\".\"Long\", \"test\".\"Timestamp\", \"test\".\"Date\", \"test\".\"Time\", \"test\".\"Bool2\", \"test\".\"String\", \"test\".\"Bool3\", \"test\".\"Double\", \"test\".\"Bool4\", \"test\".\"Float\", \"test\".\"Bool5\", \"test\".\"Decimal\", \"test\".\"Geometry\", (\"test\".\"ID\" * 2) AS \"Extra1\", ((\"test\".\"Long\" + 10) + (\"test\".\"ID\" * 2)) AS \"Extra2\" FROM \"test\" ORDER BY \"test\".\"ID\" ASC";

//        String sql = "SELECT MIN(\"test\".\"ID\") AS \"ID\", MAX(\"test\".\"Byte\") AS \"Byte\", NULL AS \"Bool1\", \"test\".\"Long\", NULL AS \"Timestamp\", NULL AS \"Date\", NULL AS \"Time\", NULL AS \"Bool2\", NULL AS \"String\", NULL AS \"Bool3\", SUM(\"test\".\"Double\") AS \"Double\", NULL AS \"Bool4\", NULL AS \"Float\", NULL AS \"Bool5\", NULL AS \"Decimal\", NULL AS \"Geometry\" FROM \"test\" GROUP BY \"test\".\"Long\" ORDER BY \"test\".\"Long\" ASC NULLS LAST";

//        String sql = "SELECT MIN(\"test\".\"ID\") AS \"ID\", MAX(\"test\".\"Byte\") AS \"Byte\", NULL AS \"Bool1\", NULL AS \"Long\", NULL AS \"Timestamp\", NULL AS \"Date\", NULL AS \"Time\", NULL AS \"Bool2\", NULL AS \"String\", NULL AS \"Bool3\", SUM(\"test\".\"Double\") AS \"Double\", NULL AS \"Bool4\", NULL AS \"Float\", NULL AS \"Bool5\", NULL AS \"Decimal\", NULL AS \"Geometry\", SUM((\"test\".\"Long\" + 10)) AS \"Extra1\", NULL AS \"Extra2\" FROM \"test\" ORDER BY MIN(\"test\".\"ID\") ASC, SUM((\"Long\" + 10)) ASC NULLS LAST";

//        String sql = "SELECT MIN(\"test\".\"ID\") AS \"ID\", MAX(\"test\".\"Byte\") AS \"Byte\", NULL AS \"Bool1\", \"test\".\"Long\", NULL AS \"Timestamp\", NULL AS \"Date\", NULL AS \"Time\", NULL AS \"Bool2\", NULL AS \"String\", NULL AS \"Bool3\", SUM(\"test\".\"Double\") AS \"Double\", NULL AS \"Bool4\", NULL AS \"Float\", NULL AS \"Bool5\", NULL AS \"Decimal\", NULL AS \"Geometry\", (\"test\".\"ID\" * 2) AS \"Compu1\", SUM((\"test\".\"Long\" + 300)) AS \"Compu2\", SUM(1) AS \"Compu3\", ((\"test\".\"Long\" + 10) + (\"test\".\"ID\" * 2)) AS \"Extra1\", SUM(((20 + \"test\".\"Byte\") + (\"test\".\"ID\" * 2))) AS \"Extra2\" FROM \"test\" GROUP BY \"test\".\"Long\", ((\"test\".\"Long\" + 10) + (\"test\".\"ID\" * 2)), (\"test\".\"ID\" * 2) ORDER BY \"test\".\"Long\" ASC NULLS LAST, ((\"test\".\"Long\" + 10) + (\"test\".\"ID\" * 2)) ASC NULLS LAST, (\"test\".\"ID\" * 2) ASC NULLS LAST";

//        String sql = "SELECT MIN(\"test\".\"ID\") AS \"ID\", MAX(\"test\".\"Byte\") AS \"Byte\", NULL AS \"Bool1\", \"test\".\"Long\", NULL AS \"Timestamp\", NULL AS \"Date\", NULL AS \"Time\", NULL AS \"Bool2\", NULL AS \"String\", NULL AS \"Bool3\", SUM(\"test\".\"Double\") AS \"Double\", NULL AS \"Bool4\", NULL AS \"Float\", NULL AS \"Bool5\", NULL AS \"Decimal\", NULL AS \"Geometry\", (\"test\".\"ID\" * 2) AS \"Compu1\", SUM((\"test\".\"Long\" + 300)) AS \"Compu2\", SUM(1) AS \"Compu3\", ((\"test\".\"Long\" + 10) + (\"test\".\"ID\" * 2)) AS \"Extra1\", SUM(((20 + \"test\".\"Byte\") + (\"test\".\"ID\" * 2))) AS \"Extra2\", NULL AS \"Extra3\" FROM \"test\" GROUP BY \"test\".\"Long\", ((\"test\".\"Long\" + 10) + (\"test\".\"ID\" * 2)), (\"test\".\"ID\" * 2) ORDER BY ((\"Long\" + 10) + (\"ID\" * 2)) ASC NULLS LAST, SUM(((20 + \"Byte\") + (\"ID\" * 2))) ASC NULLS LAST";

//        String sql = "SELECT \"test\".\"ID\", \"test\".\"Byte\", \"test\".\"Bool1\", \"test\".\"Long\", \"test\".\"Timestamp\", \"test\".\"Date\", \"test\".\"Time\", \"test\".\"Bool2\", \"test\".\"String\", \"test\".\"Bool3\", \"test\".\"Double\", \"test\".\"Bool4\", \"test\".\"Float\", \"test\".\"Bool5\", \"test\".\"Decimal\", \"test\".\"Geometry\", EXISTS(( SELECT \"countries\".\"ISO_A2\" FROM \"countries\" WHERE ((\"test\".\"STRING\" = \"countries\".\"CONTINENT\") AND (\"countries\".\"LASTCENSUS\" < 0)) LIMIT 1 )) AS \"EXISTS62a964cd7bc24f409b97c03b9170408d\" FROM \"test\" WHERE EXISTS(( SELECT \"countries\".\"ISO_A2\" FROM \"countries\" WHERE ((\"test\".\"STRING\" = \"countries\".\"CONTINENT\") AND (\"countries\".\"LASTCENSUS\" < 0)) LIMIT 1 )) ORDER BY \"test\".\"ID\" ASC"; //*

//        String sql = "SELECT \"test\".\"ID\", \"test\".\"Byte\", \"test\".\"Bool1\", \"test\".\"Long\", \"test\".\"Timestamp\", \"test\".\"Date\", \"test\".\"Time\", \"test\".\"Bool2\", \"test\".\"String\", \"test\".\"Bool3\", \"test\".\"Double\", \"test\".\"Bool4\", \"test\".\"Float\", \"test\".\"Bool5\", \"test\".\"Decimal\", \"test\".\"Geometry\", EXISTS(( SELECT \"test\".\"Long\" FROM \"countries\" WHERE ((\"test\".\"STRING\" = \"countries\".\"CONTINENT\") AND (\"countries\".\"LASTCENSUS\" < 0)) LIMIT 1 )) AS \"EXISTS62a964cd7bc24f409b97c03b9170408d\" FROM \"test\" WHERE EXISTS(( SELECT \"test\".\"Long\" FROM \"countries\" WHERE ((\"test\".\"STRING\" = \"countries\".\"CONTINENT\") AND (\"countries\".\"LASTCENSUS\" < 0)) LIMIT 1 )) ORDER BY \"test\".\"ID\" ASC"; //*

//        String sql = "SELECT MIN(\"test\".\"ID\") AS \"ID\", MAX(\"test\".\"Byte\") AS \"Byte\", NULL AS \"Bool1\", \"test\".\"Long\", NULL AS \"Timestamp\", NULL AS \"Date\", NULL AS \"Time\", NULL AS \"Bool2\", NULL AS \"String\", NULL AS \"Bool3\", SUM(\"test\".\"Double\") AS \"Double\", NULL AS \"Bool4\", NULL AS \"Float\", NULL AS \"Bool5\", NULL AS \"Decimal\", NULL AS \"Geometry\" FROM \"test\" WHERE EXISTS(( SELECT \"countries\".\"ISO_A2\" FROM \"countries\" WHERE ((\"test\".\"STRING\" = \"countries\".\"CONTINENT\") AND (\"countries\".\"LASTCENSUS\" < 0)) LIMIT 1 )) GROUP BY \"test\".\"Long\" ORDER BY \"test\".\"Long\" ASC NULLS LAST"; //*

//        String sql = "SELECT \"test\".\"ID\", \"test\".\"Byte\", \"test\".\"Bool1\", \"test\".\"Long\", \"test\".\"Timestamp\", \"test\".\"Date\", \"test\".\"Time\", \"test\".\"Bool2\", \"test\".\"String\", \"test\".\"Bool3\", \"test\".\"Double\", \"test\".\"Bool4\", \"test\".\"Float\", \"test\".\"Bool5\", \"test\".\"Decimal\", \"test\".\"Geometry\" FROM \"test\" ORDER BY \"test\".\"ID\" ASC";

        String sql = "";

        String dbPath = "/home/fdiaz/projects/gvSIG/org.gvsig.desktop/org.gvsig.desktop.plugin/org.gvsig.sqlite/org.gvsig.sqlite.provider/target/test-dbs/";

        String dbName = "testCreate-1699008328746-001.gpkg";

        System.out.println(dbPath+dbName);

//        for (String sql : sqls) {

        String table = "testCreateTarget1";

        sql = sql.replaceAll("_test_", "_"+table+"_");

        sql = sql.replaceAll("\"test\"", "\""+table+"\"");

        System.out.println("SQL " + sql);

        Connection conn = getConnection(dbPath + dbName);

        Statement stmt = conn.createStatement();

        stmt.execute(sql);

        ResultSet rs3 = stmt.executeQuery(sql);

        ResultSetMetaData rsMetadata = rs3.getMetaData();

        int columnCount = rsMetadata.getColumnCount();

        int[] colsizes = new int[columnCount + 1];

        int recordsCount = 0;

        for (int i = 1; i <= columnCount; i++) {

            colsizes[i] = rsMetadata.getColumnName(i).length() + 1;

        }

        while (rs3.next()) {

            for (int i = 1; i <= columnCount; i++) {

                int l = Objects.toString(rs3.getObject(i)).length() + 1;

                if (l > colsizes[i]) {

                    colsizes[i] = l;

                }

            }

            recordsCount++;

        }

        rs3.close();

        System.out.println("Records " + recordsCount);

        ResultSet rs = stmt.executeQuery(sql);

        rsMetadata = rs.getMetaData();

        for (int i = 1; i <= columnCount; i++) {

            System.out.print(StringUtils.rightPad(rsMetadata.getColumnName(i), colsizes[i]));

        }

        System.out.println();

        for (int i = 1; i <= columnCount; i++) {

            System.out.print(StringUtils.repeat("-", colsizes[i] - 1) + " ");

        }

        System.out.println();

        while (rs.next()) {

            for (int i = 1; i <= columnCount; i++) {

                System.out.print(StringUtils.rightPad(Objects.toString(rs.getObject(i)), colsizes[i]));

            }

            System.out.println();

        }

        rs.close();

        System.out.println();

        JDBCUtils.close(conn);

//        }

    }

    public static Connection getConnection(String fName) throws SQLException {

        registerDriver();

        File f = new File(fName);

        boolean newdb = f != null && !f.exists();

        SQLiteConfig config = new SQLiteConfig();

        config.setSharedCache(true);

        config.enableLoadExtension(true);

        config.setTransactionMode(SQLiteConfig.TransactionMode.IMMEDIATE);

        config.setOpenMode(SQLiteOpenMode.NOMUTEX);

//            config.setJournalMode(SQLiteConfig.JournalMode.WAL);

//            config.setTransactionMode(SQLiteConfig.TransactionMode.DEFERRED);

//            config.setSynchronous(SQLiteConfig.SynchronousMode.OFF);

//            config.setOpenMode(SQLiteOpenMode.FULLMUTEX);

        config.setPragma(SQLiteConfig.Pragma.CASE_SENSITIVE_LIKE, "true");

        SQLiteConnection conn;

        try {

            conn = org.sqlite.JDBC.createConnection(getConnectionURL(f), config.toProperties());

        } catch (Throwable th) {

            throw th;

        }

        Functions.register_all(conn);

        if (newdb) {

            String[] sqls2 = new String[]{

                "CREATE TABLE IF NOT EXISTS \"" + TABLE_RESOURCES_NAME + "\"(\"" + FIELD_RESOURCES_NAME + "\" VARCHAR(150) NOT NULL, \"" + FIELD_RESOURCES_RESOURCE + "\" BLOB DEFAULT NULL , PRIMARY KEY(\"" + FIELD_RESOURCES_NAME + "\"))",

                "CREATE TABLE IF NOT EXISTS \"" + TABLE_CONFIGURATION_NAME + "\"(\"" + FIELD_CONFIGURATION_NAME + "\" VARCHAR(200) NOT NULL, \"" + FIELD_CONFIGURATION_VALUE + "\" CLOB DEFAULT NULL, PRIMARY KEY(\"" + FIELD_CONFIGURATION_NAME + "\"))"

            };

            for (String sql : sqls2) {

                try {

                    conn.createStatement().execute(sql);

                } catch (SQLException ex) {

                    LOGGER.debug("Can't configure gvsig tables.", ex);

                    LOGGER.warn("Can't configure gvsig tables. " + sql);

                    // Ignore this error.

                }

            }

        }

        return conn;

    }

    public static String getConnectionURL(File dbFile) {

        String fname = dbFile.getAbsolutePath().replace("\\", "/");

        if (StringUtils.isBlank(FilenameUtils.getExtension(fname))) {

            if (fname.endsWith(".")) {

                fname = fname + GeopackageUtils.EXTENSION;

            } else {

                fname = fname + "." + GeopackageUtils.EXTENSION;

            }

        }

        String connectionURL = "jdbc:sqlite:" + fname;

        return connectionURL;

    }

    private static void registerDriver() throws SQLException {

        String className = "org.sqlite.JDBC";

        if (className == null) {

            return;

        }

        try {

            Class theClass = Class.forName(className);

            if (theClass == null) {

                throw new JDBCDriverClassNotFoundException(SQLiteLibrary.NAME, className);

            }

        } catch (Exception e) {

            throw new SQLException("Can't register JDBC driver '" + className + "'.", e);

        }

    }

}

        return SQLiteLibrary.NAME;