threedi-schema 0.217.5

The schema of 3Di schematization files

threedi-schema

The schema of 3Di schematisation files.

This project exposes:

• A ThreediDatabase object to interact with schematisation files.

• A ModelSchema object (ThreediDatabase().schema) for adapting schema versions (called “migration”).

• The 3Di schema as SQLAlchemy models and python Enum classes.*

*This package exposes SQLAlchemy models of the schematisation files directly. A minor release of this package may change these models and will be backwards incompatible. If the SQLAlchemy models are used, we strongly advise to fix the minor version as follows: threedi-schema==0.214.*. Otherwise, just fixing the major version is sufficient.

Example

The following code sample shows how you can upgrade a schematisation file:

from threedi_schema import ThreediDatabase

db = ThreediDatabase("<Path to your sqlite file>")
db.schema.upgrade()

The following code sample shows how you can list Channel objects:

from threedi_schema import models
# NB: Ensure that you pin the minor version of threedi-schema
# when using models (or constants).

channels = db.get_session().query(models.Channel).all()

Command-line interface

Migrate to the latest schema version:

threedi_schema -s path/to/model.sqlite migrate

Ensure presence of spatial indexes:

threedi_schema -s path/to/model.sqlite index

Installation

Install with:

$ pip install threedi-schema

Changelog of threedi-schema

0.217.5 (2023-06-15)

• Fixed set_views (spatialite metadata tables wwere not updated).

0.217.4 (2023-06-15)

• Fix SQLAlchemy engine and connection usage.

• Do not pool connections (solving file permission denied issues on Windows).

0.217.3 (2023-06-12)

• Added groundwater 1D2D columns to the views.

0.217.2 (2023-05-24)

• Remove vegetation and groundwater settings from beta features, since they are going to be released.

0.217.1 (2023-05-17)

• Rewrite release workflow to use a supported github action for github release.

• Build the threedi-schema release with the build package instead of setuptools.

0.217.0 (2023-05-08)

• Rename vegetation columns to match raster options.

0.216.4 (2023-04-11)

• Fixed libspatialite 4.3 incompatibility (introduced in 0.216.3).

0.216.3 (2023-04-04)

• Fixed DROP TABLE in migration 214 (tables “v2_connected_pnt”, “v2_calculation_point”, “v2_levee” remained present). The DROP TABLE is emitted again in migration 216.

0.216.2 (2023-03-24)

• Remove groundwater columns from beta columns for 1d boundary conditions.

• Check on vegetation drag settings id in global settings instead of vegetation drag id for beta columns.

0.216.1 (2023-03-23)

• Add beta_features.py to contain a list of spatialite columns and values for columns still in beta status.

0.216.0 (2023-03-15)

• Add v2_vegation_drag table.

• Add 1D2D groundwater attributes to Pipes, Channels and Manholes

0.214.6 (2023-03-13)

• Make timeseries non-nullable for BoundaryCondition1D and BoundaryConditions2D.

0.214.5 (2023-02-16)

• Add SQLAlchemy 2.0 support and drop 1.3 support.

0.214.4 (2023-01-31)

• Properly cleanup geo-tables in migration 214.

0.214.3 (2023-01-19)

• Adapted versioning: prefix existing versions with 0.

• Fixed deprecation warnings of Geoalchemy2 0.13.0

0.214.2 (2023-01-17)

• Fixed packaging (also include migrations).

0.214.1 (2023-01-17)

• Fixed packaging.

0.214.0 (2023-01-17)

• Initial project structure created with cookiecutter and https://github.com/nens/cookiecutter-python-template

• Ported code from threedi-modelchecker, rearranged into ‘domain’, ‘application’, ‘infrastructure’, ‘migrations’.