Application: gvSIG desktop

import org.gvsig.fmap.geom.Geometry;

    public static String buildCreateTableSQLIfNotExists() {

        return "CREATE TABLE IF NOT EXISTS \"gpkg_geometry_columns\" (\n"

                + "	\"table_name\"	TEXT NOT NULL,\n"

                + "	\"column_name\"	TEXT NOT NULL,\n"

                + "	\"geometry_type_name\"	TEXT NOT NULL,\n"

                + "	\"srs_id\"	INTEGER NOT NULL,\n"

                + "	\"z\"	TINYINT NOT NULL,\n"

                + "	\"m\"	TINYINT NOT NULL,\n"

                + "	CONSTRAINT \"pk_geom_cols\" PRIMARY KEY(\"table_name\",\"column_name\"),\n"

                + "	CONSTRAINT \"fk_gc_tn\" FOREIGN KEY(\"table_name\") REFERENCES \"gpkg_contents\"(\"table_name\"),\n"

                + "	CONSTRAINT \"uk_gc_table_name\" UNIQUE(\"table_name\"),\n"

                + "	CONSTRAINT \"fk_gc_srs\" FOREIGN KEY(\"srs_id\") REFERENCES \"gpkg_spatial_ref_sys\"(\"srs_id\")\n"

                + ")";

    }

    public static String buildInsertSQL(String tableName, String geomName, int geometryType, int geometrySubtype, Object geometrySRSId) {

        String geometryTypeName = "GEOMETRY";

        switch(geometryType){

            case Geometry.TYPES.POINT:

                geometryTypeName = "POINT";

                break;

            case Geometry.TYPES.ARC:

            case Geometry.TYPES.CIRCUMFERENCE:

            case Geometry.TYPES.ELLIPTICARC:

            case Geometry.TYPES.LINE:

            case Geometry.TYPES.PERIELLIPSE:

            case Geometry.TYPES.SPLINE:

                geometryTypeName = "LINESTRING";

                break;

            case Geometry.TYPES.CIRCLE:

            case Geometry.TYPES.ELLIPSE:

            case Geometry.TYPES.FILLEDSPLINE:

            case Geometry.TYPES.POLYGON:

                geometryTypeName = "POLYGON";

                break;

            case Geometry.TYPES.MULTILINE:

                geometryTypeName = "MULTILINESTRING";

                break;

            case Geometry.TYPES.MULTIPOINT:

                geometryTypeName = "MULTIPOINT";

                break;

            case Geometry.TYPES.MULTIPOLYGON:

                geometryTypeName = "MULTIPOLYGON";

                break;

        }

        String s = String.format(

                "INSERT INTO \"main\".\"gpkg_geometry_columns\" (\"table_name\", \"column_name\", \"geometry_type_name\", \"srs_id\", \"z\", \"m\") VALUES ('%s', '%s', '%s', '%s', '%s', '%s')",

                tableName,

                geomName,

                geometryTypeName,

                geometrySRSId.toString(),

                (geometrySubtype==Geometry.SUBTYPES.GEOM3D || geometrySubtype==Geometry.SUBTYPES.GEOM3DM)?1:0,

                (geometrySubtype==Geometry.SUBTYPES.GEOM2DM || geometrySubtype==Geometry.SUBTYPES.GEOM3DM)?1:0

                );

        return s;

    }

    public static String buildDeleteSQL(String tableName, String geomName) {

        String s = String.format(

                "DELETE FROM \"main\".\"gpkg_geometry_columns\" WHERE \"table_name\" = '%s' and \"column_name\" = '%s'",

                tableName,

                geomName

                );

        return s;

    }