qwat-data-model icon indicating copy to clipboard operation
qwat-data-model copied to clipboard

TEKSI Water module (project QWAT) - PostgreSQL / postgis Datamodel

Results 76 qwat-data-model issues
Sort by recently updated
recently updated
newest added

This PR aims to set some attributes to nodes regarding connected pipes. This concerns only `node` table. There are several attributes to inherit from connected pipes : - [ ]...

Enhancement
2 - Work started <= 5
Data model

This pull request aims to add some features for the user to simulate network incidents : * network leakage * network interruption * network pollution

Enhancement

## Description When user wants to connect an element part to a pipe, orientation of the element is wrong, fixing angle to 0 or some wrong value. ### Before ![qwat](https://user-images.githubusercontent.com/8960009/146891790-01262d0c-d8a3-48eb-bce9-85790a0cb394.gif)...

Bug
Data model

- [ ] Run tests against multiple postgres versions - [ ] Dockerise some of it.

Enhancement
Datamodel
Infrastructure

- [ ] Add Roles management in continuous integration

Enhancement
Datamodel

Hi, I'm initializing a 1.3.3 structure with the init scripts and then I restore the data only dump. It fails because the dump contains tables of the sigip module, which...

Bug
Question
4 - Done
Data model
QWAT

Add german translations for QWAT Work in progress, do not merge

Enhancement

For new users - [ ] SET QWAT in 2056 as default - [ ] Reframe demo data - [ ] Check demo project .qgs - [ ] Check doc...

Datamodel

Error when restore QWAT 1.3.6 https://gist.github.com/ponceta/7a053cd9212e12f23faeaadc228789bc Using pgAdmin 6.8 - [ ] View vw_pipe_child_parent ``` pg_restore: creating VIEW "qwat_od.vw_pipe_child_parent" pg_restore: while PROCESSING TOC: pg_restore: from TOC entry 345; 1259 53664...

Bug
Data model

Tables in sys schemas used for versioning with PUM should be generalized between QGEP and QWAT. Right now: - for QGEP : `qgep_sys.pum_info` - for QWAT : `qwat_sys.info` & `qwat_sys.upgrades`