.. initialize-extensions:

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

The database is automatically loaded with the necessary tables and attributes for the extension.
In order to be able to use an extension, activate the corresponding app modification :ref:`modification-framework`

.. _empty-extension-model:

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`

* Download the source code
  * https://github.com/TWW/datamodel/releases/latest
  * download`Source Code(zip)`

* if needed, temporarily alter your PGSYSCONFDIR environment variable

* create and run a batch file such as::

    @echo off
    setlocal
    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) "

	REM Set the PYTHONPATH to include the directory containing the app module
	set "PYTHONPATH=%tww_dir%\datamodel;%PYTHONPATH%"

    python -m app.create_app.py --pg_service %myservice% --srid 2056 --drop-schema --extension_names agxx foobar demo

    endlocal
    PAUSE

For official models, an adapted value list sql is provided.

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 :ref:`pg_service-linux` 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