NBU BCPC Statistics System

This repository contains the source code of the BCPC Statistics system of New Bulgarian University.

Requirements

• PostgreSQL - v12.3 at least
• Temporal Tables - v1.2.0 at least
• Versioner - v1.5.0 at least

Installation

To apply the migration use the versioner schema migration tool, specified in the requirements section. Head over to the tool's page to get more information on how to use it in your environment. The following commands are a brief overview:

• Dropping database:

  versioner -e localhost -p 5432 -d postgres --username admin --password 1234 --sslmode disable database drop -n demo

• Creating database:

  versioner -e localhost -p 5432 -d postgres --username admin --password 1234 --sslmode disable database create -n demo

• Initialization:

  versioner -e localhost -p 5432 -d demo --username admin --password 1234 --sslmode disable migration init

• Applying migrations:

  versioner -e localhost -p 5432 -d demo --username admin --password 1234 --sslmode disable migration apply -c ./configuration.toml

Usage

After initializing and applying the migrations, four main schemas are being created:

• local - Storing the latest state of the data in the tables.
• history - Storing the historical records of the data. ( See temporal tables plugin features ).
• utility - Storing utility functions, used across the schema.
• versioner - Storing the versioner tool necessary data.

To examine the latest schema version click here.

Contacts

Open issue of submit pull request.