Class GeoPackageTableCreator

TableCreator provides methods for creating the various standard tables in a GeoPackage database.

Hierarchy

GeoPackageTableCreator
- GeometryIndexTableCreator

Constructors

constructor

new GeoPackageTableCreator(geoPackage: GeoPackage): GeoPackageTableCreator
Constructor
Parameters
- geoPackage: GeoPackage
Returns GeoPackageTableCreator
- Defined in lib/db/geoPackageTableCreator.ts:41

Properties

connection

connection: GeoPackageConnection

geoPackage

geoPackage: GeoPackage

`Static` `Readonly` sqlScripts

sqlScripts: {
    contents: string[];
    contents_id: string[];
    data_column_constraints: string[];
    data_columns: string[];
    extended_relations: string[];
    extensions: string[];
    feature_tile_link: string[];
    geometry_columns: string[];
    geometry_index: string[];
    geometry_index_index: string[];
    geometry_index_unindex: string[];
    metadata: string[];
    metadata_reference: string[];
    spatial_reference_system: string[];
    table_index: string[];
    tile_matrix: string[];
    tile_matrix_set: string[];
    tile_scaling: string[];
} = ...

Type declaration

contents: string[]
contents_id: string[]
data_column_constraints: string[]
data_columns: string[]
extended_relations: string[]
extensions: string[]
feature_tile_link: string[]
geometry_columns: string[]
geometry_index: string[]
geometry_index_index: string[]
geometry_index_unindex: string[]
metadata: string[]
metadata_reference: string[]
spatial_reference_system: string[]
table_index: string[]
tile_matrix: string[]
tile_matrix_set: string[]
tile_scaling: string[]

Methods

createContents

createContents(): boolean
Creates the contents tables

Returns

Returns boolean
- Defined in lib/db/geoPackageTableCreator.ts:72

createContentsId

createContentsId(): boolean
Creates the contentsId tables

Returns

Returns boolean
- Defined in lib/db/geoPackageTableCreator.ts:163

createDataColumnConstraints

createDataColumnConstraints(): boolean
Creates the data column constraints tables

Returns

Returns boolean
- Defined in lib/db/geoPackageTableCreator.ts:107

createDataColumns

createDataColumns(): boolean
Creates the data columns tables

Returns

Returns boolean
- Defined in lib/db/geoPackageTableCreator.ts:100

createExtendedRelations

createExtendedRelations(): boolean
Creates the extended relations tables

Returns

Returns boolean
- Defined in lib/db/geoPackageTableCreator.ts:156

createExtensions

createExtensions(): boolean
Creates the extensions tables

Returns

Returns boolean
- Defined in lib/db/geoPackageTableCreator.ts:128

createFeatureTileLink

createFeatureTileLink(): boolean
Creates the feature tile link tables

Returns

Returns boolean
- Defined in lib/db/geoPackageTableCreator.ts:149

createGeometryColumns

createGeometryColumns(): boolean
Creates the geometry columns tables

Returns

Returns boolean
- Defined in lib/db/geoPackageTableCreator.ts:79

createGeometryIndex

createGeometryIndex(): boolean
Creates the geometry index tables

Returns

Returns boolean
- Defined in lib/db/geoPackageTableCreator.ts:142

createMetadata

createMetadata(): boolean
Creates the metadata tables

Returns

Returns boolean
- Defined in lib/db/geoPackageTableCreator.ts:114

createMetadataReference

createMetadataReference(): boolean
Creates the metadata reference tables

Returns

Returns boolean
- Defined in lib/db/geoPackageTableCreator.ts:121

createRequired

createRequired(): boolean
Creates all required tables and Spatial Reference Systems, in addition to EPSG:3857

Returns

Returns boolean
- Defined in lib/db/geoPackageTableCreator.ts:49

createSpatialReferenceSystem

createSpatialReferenceSystem(): boolean
Creates the spatial reference system tables

Returns

Returns boolean
- Defined in lib/db/geoPackageTableCreator.ts:65

createTableIndex

createTableIndex(): boolean
Creates the table index tables

Returns

Returns boolean
- Defined in lib/db/geoPackageTableCreator.ts:135

createTileMatrix

createTileMatrix(): boolean
Creates the tile matrix tables

Returns

Returns boolean
- Defined in lib/db/geoPackageTableCreator.ts:93

createTileMatrixSet

createTileMatrixSet(): boolean
Creates the tile matrix set tables

Returns

Returns boolean
- Defined in lib/db/geoPackageTableCreator.ts:86

createTileScaling

createTileScaling(): boolean
Creates the tileScaling tables

Returns

Returns boolean
- Defined in lib/db/geoPackageTableCreator.ts:170

createUserTable

createUserTable(userTable: UserTable<UserColumn>): {
changes: number;
lastInsertRowid: number;
}
Create the given user table.

Returns
the result of run

Throws
if the table already exists
Parameters
- userTable: UserTable<UserColumn>
  
  user table to create
Returns {
changes: number;
lastInsertRowid: number;
}
- changes: number
- lastInsertRowid: number
- Defined in lib/db/geoPackageTableCreator.ts:200

dropTable

dropTable(table: string): void
Drop the table if it exists
Parameters
- table: string
  
  table name
Returns void
- Defined in lib/db/geoPackageTableCreator.ts:216

dropView

dropView(view: string): void
Drop the view if it exists
Parameters
- view: string
  
  view name
Returns void
- Defined in lib/db/geoPackageTableCreator.ts:224

execScript

execScript(creationScriptName: SqlScripts): boolean
Creates all tables necessary for the specified table creation script name in the GeoPackage

Returns
Parameters
- creationScriptName: SqlScripts
  
  creation scripts to run
Returns boolean
- Defined in lib/db/geoPackageTableCreator.ts:178

Class GeoPackageTableCreator

Hierarchy

Index

Constructors

Properties

Methods

Constructors

constructor

Parameters

geoPackage: GeoPackage

Returns GeoPackageTableCreator

Properties

connection

geoPackage

Static Readonly sqlScripts

Type declaration

contents: string[]

contents_id: string[]

data_column_constraints: string[]

data_columns: string[]

extended_relations: string[]

extensions: string[]

feature_tile_link: string[]

geometry_columns: string[]

geometry_index: string[]

geometry_index_index: string[]

geometry_index_unindex: string[]

metadata: string[]

metadata_reference: string[]

spatial_reference_system: string[]

table_index: string[]

tile_matrix: string[]

tile_matrix_set: string[]

tile_scaling: string[]

Methods

createContents

Returns

Returns boolean

createContentsId

Returns

Returns boolean

createDataColumnConstraints

Returns

Returns boolean

createDataColumns

Returns

Returns boolean

createExtendedRelations

Returns

Returns boolean

createExtensions

Returns

Returns boolean

createFeatureTileLink

Returns

Returns boolean

createGeometryColumns

Returns

Returns boolean

createGeometryIndex

Returns

Returns boolean

createMetadata

Returns

Returns boolean

createMetadataReference

Returns

Returns boolean

createRequired

Returns

Returns boolean

createSpatialReferenceSystem

Returns

Returns boolean

createTableIndex

Returns

Returns boolean

createTileMatrix

Returns

Returns boolean

`Static` `Readonly` sqlScripts

Returns {
changes: number;
lastInsertRowid: number;
}