Sometimes we need to manipulate batches of data stored in the db. Since we're storing documents in JSONB blobs, our options are:
use SQL with obscurish Postgres JSONB manipulation syntax
write data manipulation code in Clojure
This does the latter. Tasks are defined in lipas.maintenance namespace and running happens by simply executing:
docker-compose run backend-maintenance :my-maintenance-task
Let's see how this works for us in the long run.
Several small changes to swimming pool form content
Removed unnecessary filtering methods and added one new
Removed tautological and obscure main construction materials
Changed 'outdoor pool' from pool type to a boolean property for all pool types
Added "readings contain other buildings" checkbox to energy consumption form
Sometimes energy consumption readings contain also other buildings or spaces, such as "gym" or "sports hall". These falsify real readings and makes comparing similar swimming pools / ice stadiums less accurate. Therefore we added a checkbox so we can filter these entries.
Live
https://lipas-dev.cc.jyu.fi/
Functionality for running data maintenance tasks
Sometimes we need to manipulate batches of data stored in the db. Since we're storing documents in JSONB blobs, our options are:
This does the latter. Tasks are defined in
lipas.maintenancenamespace and running happens by simply executing:docker-compose run backend-maintenance :my-maintenance-taskLet's see how this works for us in the long run.
Several small changes to swimming pool form content
Added "readings contain other buildings" checkbox to energy consumption form
Sometimes energy consumption readings contain also other buildings or spaces, such as "gym" or "sports hall". These falsify real readings and makes comparing similar swimming pools / ice stadiums less accurate. Therefore we added a checkbox so we can filter these entries.
Updated MUI 1.2.1 -> 1.4.0
See commit messages for further details.