Description

The project includes the following parts:

1. Become familiar with the existing openIMIS implementation in general and the openIMIS database in particular.

2. Create the openIMIS database structure in PostgreSQL: tables, views, user-defined types.

3. Migrate Stored Procedures and Functions to PostgreSQL. Analyse and propose optimisation during the migration of Stored Procedures. This can also include the replacement of stored procedures by application-level code.

4. Migrate in-line SQL scripts in all openIMIS related components: Web Application (legacy and modular), REST API, Web Services, Windows Services. Optional: construct SQL scripts using framework's ORM (Entity Framework or Django ORM) to become DBMS independent.

5. Develop a tool for the transfer of data from the MSSQL database to the PostgreSQL database.

6. Start the migration of SP from the database level to Python code in the modular backend using Django ORM (DBMS independent).

Discussions

Use of Python code in the SP: https://www.postgresql.org/docs/10/plpython.html