iframe-proxy | Sunbelt Computer Software

481 lines (421 loc) · 24.8 KB
﻿using System;
using System.Data.SQLite;
using System.IO;
using System.Text;
namespace SharpMap.Data.Providers
    /// <summary>
    /// http://www.geopackage.org/spec/
    /// </summary>
    internal class GpkgUtility
        public static void CheckRequirements(string filename, string password = null)
            if (!File.Exists(filename))
                throw new FileNotFoundException("The geopackage file was not found", filename);
            //Reqirement 1
            //A GeoPackage SHALL be a SQLite database file using version 3 of the SQLite file format.
            //The first 16 bytes of a GeoPackage SHALL contain 'SQLite format 3' in ASCII.
            using (var fs = File.OpenRead(filename))
                var bytes = new byte[16];
                if (fs.Read(bytes, 0, 16) != 16)
                    throw new GeoPackageException("File not long enought to hold valid header");
                var chars = new char[16];
                int bytesUsed, charsUsed;
                bool completed;
                Encoding.ASCII.GetDecoder()
                    .Convert(bytes, 0, 16, chars, 0, 16, true, out bytesUsed, out charsUsed, out completed);
                if (!new string(chars).Contains("SQLite format 3"))
                    throw new GeoPackageException(
                        "Violation of requirement 1:\nThe first 16 bytes of a GeoPackage SHALL contain 'SQLite format 3'");
                //Requirement 2
                //A GeoPackage SHALL contain 0x47503130 ("GP10" in ASCII) in the application id field of the 
                //SQLite database header to indicate a GeoPackage version 1.0 file.
                bytes = new byte[4];
                fs.Seek(68, SeekOrigin.Begin);
                fs.Read(bytes, 0, 4);
                if (BitConverter.ToInt32(bytes, 0) != 808538183) //0x47503130)
                    throw new GeoPackageException(
                        "Violation of requirement 2:\nA GeoPackage SHALL contain 0x47503130 ('GP10' in ASCII) in the application id field of the SQLite database header to indicate a GeoPackage version 1.0 file.");
            //Requirement 2
            //A GeoPackage SHALL contain 0x47503130 ("GP10" in ASCII) in the application id field of the 
            //SQLite database header to indicate a GeoPackage version 1.0 file.
            var connectionString = CreateConnectionString(filename, password);
            using (var cn = new SQLiteConnection(connectionString))
                cn.Open();
                var applicationId = Convert.ToInt32(new SQLiteCommand("PRAGMA application_id;", cn).ExecuteScalar());
                if (applicationId != 1196437808)
                    throw new GeoPackageException(
                        "Violation of requirement 2:\nA GeoPackage SHALL contain 0x47503130 ('GP10' in ASCII) in the application id field of the SQLite database header to indicate a GeoPackage version 1.0 file.");
            //Requirement 3
            //A GeoPackage SHALL have the file extension name '.gpkg'
            //It is RECOMMENDED that Extended GeoPackages use the file extension '.gpkx', but this is NOT a GeoPackage requirement
            var extension = Path.GetExtension(filename);
            if (string.IsNullOrEmpty(extension) || (extension = extension.ToLowerInvariant()) != ".gpkg" && extension != ".gpkx")
                throw new GeoPackageException(
                    "Violation of requirement 3:\nA GeoPackage SHALL have the file extension name '.gpkg'.\nIt is RECOMMENDED that Extended GeoPackages use the file extension '.gpkx', but this is NOT a GeoPackage requirement");
            //TODO check more requirements
        /// <summary>
        /// The size of the connection pool. A value less than 2 disables connection pooling
        /// </summary>
        public static volatile int MaxPoolSize = 0;
        /// <summary>
        /// Function to create a connection string to the GeoPackage database
        /// </summary>
        /// <param name="filename">The filename</param>
        /// <param name="password">The password</param>
        /// <param name="mustExist">A value indicating that the database has to exist</param>
        /// <returns>A SQLite connection string</returns>
        public static string CreateConnectionString(string filename, string password, bool mustExist = true)
            var sb = new StringBuilder(512);
            sb.AppendFormat("DataSource={0};version=3;", filename);
            // the pool size
            var poolSize = MaxPoolSize;
            if (poolSize > 1)
                sb.AppendFormat("Pooling=true;Max Pool Size={0};", poolSize);
            // a password
            if (!String.IsNullOrWhiteSpace(password))
                sb.AppendFormat("Password={0};", password);
            // the database must exist
            if (mustExist)
                sb.AppendFormat("FailIfMissing=True;");
            return sb.ToString();
        public static void CreateGeoPackage(string filename, string password = null)
            using (var cn = new SQLiteConnection(CreateConnectionString(filename, password)))
                cn.Open();
                new SQLiteCommand(CreateSpatialRefSys, cn).ExecuteNonQuery();
                new SQLiteCommand(CreateContents, cn).ExecuteNonQuery();
                new SQLiteCommand(CreateGeometryColumns, cn).ExecuteNonQuery();
                new SQLiteCommand(CreateDataColumns, cn).ExecuteNonQuery();
                new SQLiteCommand(CreateDataColumnConstraints, cn).ExecuteNonQuery();
                new SQLiteCommand(CreateTileMatrixSet, cn).ExecuteNonQuery();
                new SQLiteCommand(CreateTileMatrix, cn).ExecuteNonQuery();
                new SQLiteCommand(CreateTileMatrixZoomLevelInsert, cn).ExecuteNonQuery();
                new SQLiteCommand(CreateTileMatrixZoomLevelUpdate, cn).ExecuteNonQuery();
                new SQLiteCommand(CreateTileMatrixMatrixWidthInsert, cn).ExecuteNonQuery();
                new SQLiteCommand(CreateTileMatrixMatrixWidthUpdate, cn).ExecuteNonQuery();
                new SQLiteCommand(CreateTileMatrixMatrixHeightInsert, cn).ExecuteNonQuery();
                new SQLiteCommand(CreateTileMatrixMatrixHeightUpdate, cn).ExecuteNonQuery();
                new SQLiteCommand(CreateTileMatrixPixelXSizeInsert, cn).ExecuteNonQuery();
                new SQLiteCommand(CreateTileMatrixPixelXSizeUpdate, cn).ExecuteNonQuery();
                new SQLiteCommand(CreateTileMatrixPixelYSizeInsert, cn).ExecuteNonQuery();
                new SQLiteCommand(CreateTileMatrixPixelYSizeUpdate, cn).ExecuteNonQuery();
                new SQLiteCommand(CreateMetadata, cn).ExecuteNonQuery();
                new SQLiteCommand(CreateMetadataMdScopeInsert, cn).ExecuteNonQuery();
                new SQLiteCommand(CreateMetadataMdScopeUpdate, cn).ExecuteNonQuery();
                new SQLiteCommand(CreateMetadataReference, cn).ExecuteNonQuery();
                new SQLiteCommand(CreateMetadataReferenceReferenceScopeInsert, cn).ExecuteNonQuery();
                new SQLiteCommand(CreateMetadataReferenceReferenceScopeUpdate, cn).ExecuteNonQuery();
                new SQLiteCommand(CreateMetadataReferenceColumnNameInsert, cn).ExecuteNonQuery();
                new SQLiteCommand(CreateMetadataReferenceColumnNameUpdate, cn).ExecuteNonQuery();
                new SQLiteCommand(CreateMetadataReferenceRowIDValueInsert, cn).ExecuteNonQuery();
                new SQLiteCommand(CreateMetadataReferenceRowIDValueUpdate, cn).ExecuteNonQuery();
                new SQLiteCommand(CreateMetadataReferenceTimestampInsert, cn).ExecuteNonQuery();
                new SQLiteCommand(CreateMetadataReferenceTimestampUpdate, cn).ExecuteNonQuery();
        private const string CreateSpatialRefSys = 
            @"CREATE TABLE gpkg_spatial_ref_sys (srs_name TEXT NOT NULL, srs_id INTEGER NOT NULL PRIMARY KEY, organization TEXT NOT NULL, organization_coordsys_id INTEGER NOT NULL, definition  TEXT NOT NULL, description TEXT);";
        private const string CreateContents = 
            @"CREATE TABLE 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));";
        private const string CreateGeometryColumns =
            @"CREATE TABLE 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 uk_gc_table_name UNIQUE (table_name), CONSTRAINT fk_gc_tn FOREIGN KEY (table_name) REFERENCES gpkg_contents(table_name), CONSTRAINT fk_gc_srs FOREIGN KEY (srs_id) REFERENCES gpkg_spatial_ref_sys (srs_id));";
        private const string CreateTileMatrixSet =
            @"CREATE TABLE gpkg_tile_matrix_set (table_name TEXT NOT NULL PRIMARY KEY, srs_id INTEGER NOT NULL, min_x DOUBLE NOT NULL, min_y DOUBLE NOT NULL, max_x DOUBLE NOT NULL, max_y DOUBLE NOT NULL, CONSTRAINT fk_gtms_table_name FOREIGN KEY (table_name) REFERENCES gpkg_contents(table_name), CONSTRAINT fk_gtms_srs FOREIGN KEY (srs_id) REFERENCES gpkg_spatial_ref_sys (srs_id));";
        private const string CreateTileMatrix =
            @"CREATE TABLE gpkg_tile_matrix (table_name TEXT NOT NULL, zoom_level INTEGER NOT NULL, matrix_width INTEGER NOT NULL, matrix_height INTEGER NOT NULL, tile_width INTEGER NOT NULL, tile_height INTEGER NOT NULL, pixel_x_size DOUBLE NOT NULL, pixel_y_size DOUBLE NOT NULL, CONSTRAINT pk_ttm PRIMARY KEY (table_name, zoom_level), CONSTRAINT fk_tmm_table_name FOREIGN KEY (table_name) REFERENCES gpkg_contents(table_name));";
        private const string CreateDataColumns =
            @"CREATE TABLE gpkg_data_columns (table_name TEXT NOT NULL, column_name TEXT NOT NULL, name TEXT, title TEXT, description TEXT, mime_type TEXT, constraint_name TEXT, CONSTRAINT pk_gdc PRIMARY KEY (table_name, column_name), CONSTRAINT fk_gdc_tn FOREIGN KEY (table_name) REFERENCES gpkg_contents(table_name));";
        private const string CreateDataColumnConstraints =
            @"CREATE TABLE gpkg_data_column_constraints (constraint_name TEXT NOT NULL, constraint_type TEXT NOT NULL, value TEXT, min NUMERIC, minIsInclusive BOOLEAN, max NUMERIC, maxIsInclusive BOOLEAN, CONSTRAINT gdcc_ntv UNIQUE (constraint_name, constraint_type, value))";
        private const string CreateMetadata =
            @"CREATE TABLE gpkg_metadata (id INTEGER CONSTRAINT m_pk PRIMARY KEY ASC NOT NULL UNIQUE, md_scope TEXT NOT NULL DEFAULT 'dataset', md_standard_uri TEXT NOT NULL, mime_type TEXT NOT NULL DEFAULT 'text/xml', metadata TEXT NOT NULL);";
        private const string CreateMetadataReference =
            @"CREATE TABLE gpkg_metadata_reference (reference_scope TEXT NOT NULL, table_name TEXT, column_name TEXT, row_id_value INTEGER, timestamp DATETIME NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')), md_file_id INTEGER NOT NULL, md_parent_id INTEGER, CONSTRAINT crmr_mfi_fk FOREIGN KEY (md_file_id) REFERENCES gpkg_metadata(id), CONSTRAINT crmr_mpi_fk FOREIGN KEY (md_parent_id) REFERENCES gpkg_metadata(id));";
        #region trigger tiles
        private const string CreateTileMatrixZoomLevelInsert =
            @"CREATE TRIGGER 'gpkg_tile_matrix_zoom_level_insert'
        BEFORE INSERT ON 'gpkg_tile_matrix'
        FOR EACH ROW BEGIN
        SELECT RAISE(ABORT, 'insert on table ''gpkg_tile_matrix'' violates constraint: zoom_level cannot be less than 0')
        WHERE (NEW.zoom_level < 0);
        END;";
        private const string CreateTileMatrixZoomLevelUpdate =
            @"CREATE TRIGGER 'gpkg_tile_matrix_zoom_level_update'
        BEFORE UPDATE of zoom_level ON 'gpkg_tile_matrix'
        FOR EACH ROW BEGIN
        SELECT RAISE(ABORT, 'update on table ''gpkg_tile_matrix'' violates constraint: zoom_level cannot be less than 0')
        WHERE (NEW.zoom_level < 0);
        END;";
        private const string CreateTileMatrixMatrixWidthInsert =
            @"CREATE TRIGGER 'gpkg_tile_matrix_matrix_width_insert'
        BEFORE INSERT ON 'gpkg_tile_matrix'
        FOR EACH ROW BEGIN
        SELECT RAISE(ABORT, 'insert on table ''gpkg_tile_matrix'' violates constraint: matrix_width cannot be less than 1')
        WHERE (NEW.matrix_width < 1);
        END;";
        private const string CreateTileMatrixMatrixWidthUpdate =
            @"CREATE TRIGGER 'gpkg_tile_matrix_matrix_width_update'
        BEFORE UPDATE OF matrix_width ON 'gpkg_tile_matrix'
        FOR EACH ROW BEGIN
        SELECT RAISE(ABORT, 'update on table ''gpkg_tile_matrix'' violates constraint: matrix_width cannot be less than 1')
        WHERE (NEW.matrix_width < 1);
        END";
        private const string CreateTileMatrixMatrixHeightInsert =
            @"CREATE TRIGGER 'gpkg_tile_matrix_matrix_height_insert'
        BEFORE INSERT ON 'gpkg_tile_matrix'
        FOR EACH ROW BEGIN
        SELECT RAISE(ABORT, 'insert on table ''gpkg_tile_matrix'' violates constraint: matrix_height cannot be less than 1')
        WHERE (NEW.matrix_height < 1);
        END;";
        private const string CreateTileMatrixMatrixHeightUpdate =
            @"CREATE TRIGGER 'gpkg_tile_matrix_matrix_height_update'
        BEFORE UPDATE OF matrix_height ON 'gpkg_tile_matrix'
        FOR EACH ROW BEGIN
        SELECT RAISE(ABORT, 'update on table ''gpkg_tile_matrix'' violates constraint: matrix_height cannot be less than 1')
        WHERE (NEW.matrix_height < 1);
        END;";
        private const string CreateTileMatrixPixelXSizeInsert =
            @"CREATE TRIGGER 'gpkg_tile_matrix_pixel_x_size_insert'
        BEFORE INSERT ON 'gpkg_tile_matrix'
        FOR EACH ROW BEGIN
        SELECT RAISE(ABORT, 'insert on table ''gpkg_tile_matrix'' violates constraint: pixel_x_size must be greater than 0')
        WHERE NOT (NEW.pixel_x_size > 0);
        END;";
        private const string CreateTileMatrixPixelXSizeUpdate =
            @"CREATE TRIGGER 'gpkg_tile_matrix_pixel_x_size_update'
        BEFORE UPDATE OF pixel_x_size ON 'gpkg_tile_matrix'
        FOR EACH ROW BEGIN
        SELECT RAISE(ABORT, 'update on table ''gpkg_tile_matrix'' violates constraint: pixel_x_size must be greater than 0')
        WHERE NOT (NEW.pixel_x_size > 0);
        END;";
        private const string CreateTileMatrixPixelYSizeInsert =
            @"CREATE TRIGGER 'gpkg_tile_matrix_pixel_y_size_insert'
        BEFORE INSERT ON 'gpkg_tile_matrix'
        FOR EACH ROW BEGIN
        SELECT RAISE(ABORT, 'insert on table ''gpkg_tile_matrix'' violates constraint: pixel_y_size must be greater than 0')
        WHERE NOT (NEW.pixel_y_size > 0);
        END;";
        private const string CreateTileMatrixPixelYSizeUpdate =
            @"CREATE TRIGGER 'gpkg_tile_matrix_pixel_y_size_update'
        BEFORE UPDATE OF pixel_y_size ON 'gpkg_tile_matrix'
        FOR EACH ROW BEGIN
        SELECT RAISE(ABORT, 'update on table ''gpkg_tile_matrix'' violates constraint: pixel_y_size must be greater than 0')
        WHERE NOT (NEW.pixel_y_size > 0);
        END;";
        #endregion
        #region trigger metadata
        private const string CreateMetadataMdScopeInsert =
            @"CREATE TRIGGER 'gpkg_metadata_md_scope_insert'
BEFORE INSERT ON 'gpkg_metadata'
FOR EACH ROW BEGIN
SELECT RAISE(ABORT, 'insert on table gpkg_metadata violates
constraint: md_scope must be one of undefined | fieldSession |
collectionSession | series | dataset | featureType | feature |
attributeType | attribute | tile | model | catalog | schema |
taxonomy software | service | collectionHardware |
nonGeographicDataset | dimensionGroup')
WHERE NOT(NEW.md_scope IN
('undefined','fieldSession','collectionSession','series','dataset',
'featureType','feature','attributeType','attribute','tile','model',
'catalog','schema','taxonomy','software','service',
'collectionHardware','nonGeographicDataset','dimensionGroup'));
        private const string CreateMetadataMdScopeUpdate =
            @"CREATE TRIGGER 'gpkg_metadata_md_scope_update'
BEFORE UPDATE OF 'md_scope' ON 'gpkg_metadata'
FOR EACH ROW BEGIN
SELECT RAISE(ABORT, 'update on table gpkg_metadata violates
constraint: md_scope must be one of undefined | fieldSession |
collectionSession | series | dataset | featureType | feature |
attributeType | attribute | tile | model | catalog | schema |
taxonomy software | service | collectionHardware |
nonGeographicDataset | dimensionGroup')
WHERE NOT(NEW.md_scope IN
('undefined','fieldSession','collectionSession','series','dataset',
'featureType','feature','attributeType','attribute','tile','model',
'catalog','schema','taxonomy','software','service',
'collectionHardware','nonGeographicDataset','dimensionGroup'));
        #endregion
        private const string CreateMetadataReferenceReferenceScopeInsert =
            @"CREATE TRIGGER 'gpkg_metadata_reference_reference_scope_insert'
BEFORE INSERT ON 'gpkg_metadata_reference'
FOR EACH ROW BEGIN
SELECT RAISE(ABORT, 'insert on table gpkg_metadata_reference
violates constraint: reference_scope must be one of ""geopackage"",
""table"", ""column"", ""row"", ""row/col""')
WHERE NOT NEW.reference_scope IN
('geopackage','table','column','row','row/col');
        private const string CreateMetadataReferenceReferenceScopeUpdate =
            @"CREATE TRIGGER 'gpkg_metadata_reference_reference_scope_update'
BEFORE UPDATE OF 'reference_scope' ON 'gpkg_metadata_reference'
FOR EACH ROW BEGIN
SELECT RAISE(ABORT, 'update on table gpkg_metadata_reference
violates constraint: referrence_scope must be one of ""geopackage"",
""table"", ""column"", ""row"", ""row/col""')
WHERE NOT NEW.reference_scope IN
('geopackage','table','column','row','row/col');
        private const string CreateMetadataReferenceColumnNameInsert =
            @"CREATE TRIGGER 'gpkg_metadata_reference_column_name_insert'
BEFORE INSERT ON 'gpkg_metadata_reference'
FOR EACH ROW BEGIN
SELECT RAISE(ABORT, 'insert on table gpkg_metadata_reference
violates constraint: column name must be NULL when reference_scope
is  ""geopackage"", ""table"" or ""row""')
WHERE (NEW.reference_scope IN ('geopackage','table','row')
AND NEW.column_name IS NOT NULL);
SELECT RAISE(ABORT, 'insert on table gpkg_metadata_reference
violates constraint: column name must be defined for the specified
table when reference_scope is ""column"" or ""row/col""')
WHERE (NEW.reference_scope IN ('column','row/col')
AND NOT NEW.table_name IN (
SELECT name FROM SQLITE_MASTER WHERE type = 'table'
AND name = NEW.table_name
AND sql LIKE ('%' || NEW.column_name || '%')));
        private const string CreateMetadataReferenceColumnNameUpdate =
            @"CREATE TRIGGER 'gpkg_metadata_reference_column_name_update'
BEFORE UPDATE OF column_name ON 'gpkg_metadata_reference'
FOR EACH ROW BEGIN
SELECT RAISE(ABORT, 'update on table gpkg_metadata_reference
violates constraint: column name must be NULL when reference_scope
is  ""geopackage"", ""table"" or ""row""')
WHERE (NEW.reference_scope IN ('geopackage','table','row')
AND NEW.column_nameIS NOT NULL);
SELECT RAISE(ABORT, 'update on table gpkg_metadata_reference
violates constraint: column name must be defined for the specified
table when reference_scope is ""column"" or ""row/col""')
WHERE (NEW.reference_scope IN ('column','row/col')
AND NOT NEW.table_name IN (
SELECT name FROM SQLITE_MASTER WHERE type = 'table'
AND name = NEW.table_name
AND sql LIKE ('%' || NEW.column_name || '%')));
        private const string CreateMetadataReferenceRowIDValueInsert =
            @"CREATE TRIGGER 'gpkg_metadata_reference_row_id_value_insert'
BEFORE INSERT ON 'gpkg_metadata_reference'
FOR EACH ROW BEGIN
SELECT RAISE(ABORT, 'insert on table gpkg_metadata_reference
violates constraint: row_id_value must be NULL when reference_scope
is ""geopackage"", ""table"" or ""column""')
WHERE NEW.reference_scope IN ('geopackage','table','column')
AND NEW.row_id_value IS NOT NULL;
SELECT RAISE(ABORT, 'insert on table gpkg_metadata_reference
violates constraint: row_id_value must exist in specified table when
reference_scope is ""row"" or ""row/col""')
WHERE NEW.reference_scope IN ('row','row/col')
AND NOT EXISTS (SELECT rowid
FROM (SELECT NEW.table_name AS table_name) WHERE rowid =
NEW.row_id_value);
        private const string CreateMetadataReferenceRowIDValueUpdate =
            @"CREATE TRIGGER 'gpkg_metadata_reference_row_id_value_update'
BEFORE UPDATE OF 'row_id_value' ON 'gpkg_metadata_reference'
FOR EACH ROW BEGIN
SELECT RAISE(ABORT, 'update on table gpkg_metadata_reference
violates constraint: row_id_value must be NULL when reference_scope
is ""geopackage"", ""table"" or ""column""')
WHERE NEW.reference_scope IN ('geopackage','table','column')
AND NEW.row_id_value IS NOT NULL;
SELECT RAISE(ABORT, 'update on table gpkg_metadata_reference
violates constraint: row_id_value must exist in specified table when
reference_scope is ""row"" or ""row/col""')
WHERE NEW.reference_scope IN ('row','row/col')
AND NOT EXISTS (SELECT rowid
FROM (SELECT NEW.table_name AS table_name) WHERE rowid =
NEW.row_id_value);
        private const string CreateMetadataReferenceTimestampInsert =
            @"CREATE TRIGGER 'gpkg_metadata_reference_timestamp_insert'
BEFORE INSERT ON 'gpkg_metadata_reference'
FOR EACH ROW BEGIN
SELECT RAISE(ABORT, 'insert on table gpkg_metadata_reference
violates constraint: timestamp must be a valid time in ISO 8601
""yyyy-mm-ddThh-mm-ss.cccZ"" form')
WHERE NOT (NEW.timestamp GLOB
'[1-2][0-9][0-9][0-9]-[0-1][0-9]-[1-3][0-9]T[0-2][0-9]:[0-5][0-
9]:[0-5][0-9].[0-9][0-9][0-9]Z'
AND strftime('%s',NEW.timestamp) NOT NULL);
        private const string CreateMetadataReferenceTimestampUpdate =
            @"CREATE TRIGGER 'gpkg_metadata_reference_timestamp_update'
BEFORE UPDATE OF 'timestamp' ON 'gpkg_metadata_reference'
FOR EACH ROW BEGIN
SELECT RAISE(ABORT, 'update on table gpkg_metadata_reference
violates constraint: timestamp must be a valid time in ISO 8601
""yyyy-mm-ddThh-mm-ss.cccZ"" form')
WHERE NOT (NEW.timestamp GLOB
'[1-2][0-9][0-9][0-9]-[0-1][0-9]-[1-3][0-9]T[0-2][0-9]:[0-5][0-
9]:[0-5][0-9].[0-9][0-9][0-9]Z'
AND strftime('%s',NEW.timestamp) NOT NULL);
        #region metadata reference
        #endregion
        public static Type GetTypeForDataTypeString(string dataTypeString)
            dataTypeString = dataTypeString.ToLowerInvariant();
            switch (dataTypeString)
                case "tinyint":
                    return typeof (byte);
                case "int4":
                case "smallint":
                    return typeof (short);
                case "integer":
                case "int":
                case "mediumint":
                    return typeof(int);
                case "int8":
                case "bigint":
                    return typeof (long);
                case "unsigned big int":
                    return typeof (ulong);
                case "text":
                case "clob":
                    return typeof (string);
                case "blob":
                    return typeof (byte[]);
                case "double":
                case "double precision":
                    return typeof(double);
                case "real":
                case "float":
                    return typeof(float);
                case "date":
                case "datetime":
                    return typeof(DateTime);
                case "numeric":
                    return typeof (decimal);
                case "boolean":
                    return typeof (bool);
                default:
                    if (dataTypeString.StartsWith("character(") ||
                        dataTypeString.StartsWith("varchar(") ||
                        dataTypeString.StartsWith("varying character(") ||
                        dataTypeString.StartsWith("nchar(") ||
                        dataTypeString.StartsWith("native character(") ||
                        dataTypeString.StartsWith("nvarchar(")
                        return typeof (string);
                    if (dataTypeString.StartsWith("decimal("))
                        return typeof (decimal);
                    break;
            throw new GeoPackageException(string.Format("Unknown data type '{0}'", dataTypeString));
Sunbelt Computer Software

PL/B Language Development and Support

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Sunbelt Computer Software

PL/B Language Development and Support

FilesExpand file tree

GpkgUtility.cs

Latest commit

History

GpkgUtility.cs

File metadata and controls
