Skip to content
This repository has been archived by the owner on Aug 9, 2022. It is now read-only.
/ linz-bde-schema Public archive

LINZ BDE (Landonline) table schema and supporting functions. This repository was merged in to BDE Processor in latest master branch version !

License

Notifications You must be signed in to change notification settings

linz/linz-bde-schema

Repository files navigation

CI Status

LINZ BDE SCHEMAS

Provides the core BDE schemas and functions that are used for storing and accessing raw BDE exports from the Landonline database system.

Refer to LINZ::Bde documentation for further information about raw BDE exports format.

Installation

First install the project into the OS data share directory:

sudo make install

Then you can load the schema into a target database

linz-bde-schema-load $DB_NAME

If you don't want to install the indexes, add --noindexes to the linz-bde-schema-load` invocation:

linz-bde-schema-load --noindexes $DB_NAME

If you would like to revision the table, add --revision to the linz-bde-schema-load invocation:

linz-bde-schema-load --noindexes --revision $DB_NAME

Add --noextension switch if required extensions are not available on the database system.

NOTE: the loader script will expect to find SQL scripts under /usr/share/linz-bde-schema/sql, if you want them found in a different directory you can set the BDESCHEMA_SQLDIR environment variable.

Upgrade

You can upgrade the schema in an existing database by following the install procedure. The linz-bde-schema-load script is able to both install or upgrade databases.

WARNING: upgrades from version 1.0.2 to 1.1.2 will leave database in an inconsistent state due to a broken schema patch found in such release. The patch was absent in previous releases and fixed in later releases so upgrades from them will be ok.

Linting

Prerequisites: Nix

Run nix-shell --pure --run 'pre-commit run --all-files'.

Testing

Testing is done using pg_regress and PgTap. To run the tests run the following command:

make check

Building Debian packaging

Build the debian packages using the following command:

dpkg-buildpackage -us -uc

Dependencies

Requires PostgreSQL and PostGIS on the target database system, dbpatch and optionally table_version.

License

This project is under 3-clause BSD License, except where otherwise specified. See the LICENSE file for more details.

About

LINZ BDE (Landonline) table schema and supporting functions. This repository was merged in to BDE Processor in latest master branch version !

Resources

License

Stars

Watchers

Forks

Packages

No packages published