5.1. Initialising Database extensions

TEKSI Wastewater maintains database extensions to serve the following models:

AG-64 Abwasserkataster Version 2.1.0
AG-96 Genereller_Entwaesserungsplan_AG Version 2.0.0

5.1.1. create an empty datamodel with an extension

In order to use a database extension, we need to load them from the source code:

Load a standard TWW Database * https://github.com/TWW/datamodel/releases/latest * download tww_{version}_structure_with_value_lists.sql

In the future, an adapted value list sql will be provided. For now, we will have to rely on the source code

Download the source code * https://github.com/TWW/datamodel/releases/latest * download`Source Code(zip)`
install pirogue if necessary: pip install pirogue
if needed, temporarily alter your PGSYSCONFDIR environment variable

create and run a batch file such as:

@echo off

set /p tww_dir="Set the directory your downloaded teksi wastewater to"

if not exist %tww_dir% (
   echo "Path %tww_dir% does not exist. Please download the latest datamodel from https://github.com/TWW/datamodel/releases (structure_with_value_lists.sql) and adjust path in this batch file."
   PAUSE
   exit -1
)

pip install pirogue

set /p myservice="Please enter the service name? (e.g. tww_community) "

    python %tww_dir%\extensions\extension_manager.py --pg_service %myservice% --extension_name "agxx"
    python %tww_dir%\app\create_app.py --pg_service %myservice% --srid 2056


PAUSE

Important notes:

Do not use the –drop_schema flag on create_app.py, as all the extension views are to be stored in the app schema

5.1.2. Generate the data model under Linux

You can also generate the data model extension under Linux.

Download the data model:

git clone https://github.com/TWW/datamodel
cd datamodel

Setup the pg_service.conf file and add the pg_tww service as in the Linux/macOS pg_service section.

Create the database:

psql -U postgres -c 'CREATE DATABASE tww;'

Set the environment variables for the generation script:
```
./scripts/db_setup.sh
```
Run the generation script:
```
./scripts/db_setup.sh
```