Clone Tools
  • last updated a few seconds ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
OLMIS-6858 Add cron container to reporting stack
OLMIS-6858 Add cron container to reporting stack
Feel free to notify anyone else who should look at this review.

Feel free to notify anyone else who should look at this review.

There are two main connectors for each service (referencedata and requisition), one source (e.g. source-requisition) and one sink (e.g. sink-requisition). The additional sink connectors are for tab...

There are two main connectors for each service (referencedata and requisition), one source (e.g. source-requisition) and one sink (e.g. sink-requisition). The additional sink connectors are for tables that do not have a single id field defined as the primary key.

This is just to match the schema changes in the db.

This is just to match the schema changes in the db.

Script for starting up the stack locally. Not sure if it works in Linux and older versions of macOS.

Script for starting up the stack locally. Not sure if it works in Linux and older versions of macOS.

New settings to define access to the source db and the sink db (for the connectors).

New settings to define access to the source db and the sink db (for the connectors).

This is just for local dev, removing scalyr and logging to syslog, so the logs can be viewed through docker logs.

This is just for local dev, removing scalyr and logging to syslog, so the logs can be viewed through docker logs.

I don't expect we would start up with different versions for Kafka and Zookeeper, so there is just one Confluent version.

I don't expect we would start up with different versions for Kafka and Zookeeper, so there is just one Confluent version.

This is basically the schema in reference data and requisition, minus the foreign keys. Additionally, there is an additional table to define timeliness for each country, and then the materialized v...

This is basically the schema in reference data and requisition, minus the foreign keys. Additionally, there is an additional table to define timeliness for each country, and then the materialized views at the end.

These are here so that the folders exist when mounting the volume to the container.

These are here so that the folders exist when mounting the volume to the container.

OLMIS-6858 Improve the database definition of the reporting database

For Superset. Also add some helper scripts for local development.

  1. … 3 more files in changeset.
OLMIS-6858 Get materialized views to work with new Kafka tables

The new tables in the reporting database are being populated by the streaming architecture, now the materialized views should use them.

    • -422
    • +2069
    ./OlmisCreateTableStatements.sql
  1. … 6 more files in changeset.
Change uuid types to varchar to allow NiFi to process it

    • -76
    • +48
    ./OlmisCreateTableStatements.sql
Change uuid types to varchar to allow NiFi to process it

    • -76
    • +48
    ./OlmisCreateTableStatements.sql
Fix stock consumption mat view

change role and modify stock mv

    • -56
    • +56
    ./OlmisCreateTableStatements.sql
change role and modify stock mv

    • -63
    • +64
    ./OlmisCreateTableStatements.sql
Update stock consumption materialized views

    • -48
    • +18
    ./OlmisCreateTableStatements.sql
Replace join with left join in materialized view

Make the orderable ID not unique since an orderable can have multiple programs

Update materialized view queries

Update materialized view queries

    • -13
    • +13
    ./OlmisCreateTableStatements.sql
Edit materialied view queries to pull data

Add default table and values and materialized views

    • -2
    • +157
    ./OlmisCreateTableStatements.sql
Add a program column to the facility_access table

  1. … 1 more file in changeset.
Edit table name

  1. … 1 more file in changeset.
changes to sql file

- Changed name of sql file from referenceDataCreateTableStatements to OlmisCreateTableStatements

- Added create table statements for sohlineitems, facility_acess and stock_adjustment_reasons

- Added facility_acess to database.yaml

    • -0
    • +525
    ./OlmisCreateTableStatements.sql
  1. … 3 more files in changeset.