Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

WS/UD gw_fct_sector_update #58

Closed
vicente-medina opened this issue May 26, 2016 · 1 comment
Closed

WS/UD gw_fct_sector_update #58

vicente-medina opened this issue May 26, 2016 · 1 comment
Assignees
@vicente-medina
Labels
enhancement feature

Comments

@vicente-medina
Copy link
Member

Customer's request on 24/05/2016.

When sector is updated, sector_id of node, arc, connec & gully must be updated automaticlly if it's needed.

Overlap control between polygon it's needed (TODO check "sector" topology).
@vicente-medina vicente-medina self-assigned this May 26, 2016
vicente-medina pushed a commit that referenced this issue May 26, 2016
#58 First version of the "sector" trigger.
6b669ae 
It acts on INSERT, UPDATE, DELETE and as a consequence shots the "arc" and "node" triggers. To reduce the impacts both triggers are modified to bypass in case of no geometry update.

Signed-off-by: Vicente Medina <vicente.medina@gits.ws>
@vicente-medina vicente-medina mentioned this issue May 26, 2016
Closed
vicente-medina pushed a commit that referenced this issue May 26, 2016
#59 First version of "dma" trigger.
738cd49 
Commits done to the branch #58 because he modification of the the "arc" and "node" triggers done in #58 is mandatory.

Signed-off-by: Vicente Medina <vicente.medina@gits.ws>
@daviderill
Copy link
Member

@vicente-medina
It would be nice to parametrize both functions in the same way that we have in gw_trg_edit_inp_arc.sql
Calling trigger with params and retrieving them with TG_ARGV[i]

daviderill added a commit that referenced this issue May 27, 2016
@daviderill
#58 #59 Format code
bc9da95
@daviderill daviderill mentioned this issue May 27, 2016
Merged
daviderill added a commit that referenced this issue May 27, 2016
@daviderill
Merge 'issue-58' into dev (#60)
ab65c77 
* #58 First version of the "sector" trigger.

It acts on INSERT, UPDATE, DELETE and as a consequence shots the "arc" and "node" triggers. To reduce the impacts both triggers are modified to bypass in case of no geometry update.

Signed-off-by: Vicente Medina <vicente.medina@gits.ws>

* #59 First version of "dma" trigger.

Commits done to the branch #58 because he modification of the the "arc" and "node" triggers done in #58 is mandatory.

Signed-off-by: Vicente Medina <vicente.medina@gits.ws>

* #58 #59 Format code
daviderill added a commit that referenced this issue Jun 3, 2016
@daviderill
Merge 'dev' into 'master' (#73)
b83ec20 
* Merge branch 'master' into 'dev'

* #12 wip in Tab 'Add. info'
Refactor: lowercase and comments

* #12 Add superclass to manage common config in 'arc' & 'node'
Add 'arc' custom init form
Update widget names in 'arc' form

* #12 Parametrize 'field_id'
Update widget names

* #12 Custom form and init function for 'connec'

* #17 Add map tool to manage action
Rename name of management functions
Add parameter 'show help'

* #17 First beta version of the function "gw_fct_node2arc"

Signed-off-by: Vicente Medina <vicente.medina@gits.ws>

* #12 Morph from QDateTime to QDate in connec form
Minor bug fix

* wip #17

* #12 Tab 'Add. info': Perform an Insert if any record updated

* Merege 'issue-19' into 'dev' (#24)

Merge 'issue-19' into 'dev' (commits squashed)

* #12 Morph from QDateTime to QDate and other minor changes

* Merge 'issue-16' into 'dev' (#25)

* #16 Import SQL's from giswater main repository

* #16 WiP

* Issue #16 WiP

* #16 Add function 'connect to network'
Bug fix: check null variables
Format source code

* #26 Add and update icons

* #26 Add and update messages (i18n)

* #26 Toolbar and configuration management
Rename 'edit' to 'manage'
Add new one called 'edit'

* #12 Rename QTableWidgets to 'tbl_*'

* Modify "gw_fct_node2arc.sql" to work properly with curved geometries and to insert node within the line.

Signed-off-by: Vicente Medina <vicente.medina@gits.ws>

* Improved "gw_fct_connect_to_network.sql" keeping low computational cost.

Signed-off-by: Vicente Medina <vicente.medina@gits.ws>

* #28 Beta version of the "gw_fct_mincut.sql".

Signed-off-by: Vicente Medina <vicente.medina@gits.ws>

* #28 Format source code

* #26 Update order and tooltips in management bar

* #28 Add parameters 'table_arc' and 'table_node'
Enable action when 'arc' or 'node' layers are selected

* #28 Return integer with code results instead of arrays
Plugin will get id's to select from the corresponding temporal tables

* #28 Implement action 'mg_fow_trace'
Set signal 'projectRead'. It's triggered when user opens a QGS project

* #19 Update "gw_fct_connect_to_network" to include "userdefined_pos" as constrain and to autofill "serctor_id". The column "connec_id" is assumed to not exist anymore in "vnode" table.

Signed-off-by: Vicente Medina <vicente.medina@gits.ws>

* #28 Update "gw_fct_mincut.sql" to include concave polygon.

Signed-off-by: Vicente Medina <vicente.medina@gits.ws>

* Modify "gw_fct_node2arc.sql" to work properly with curved geometries and to insert node within the line.

Signed-off-by: Vicente Medina <vicente.medina@gits.ws>
(cherry picked from commit be898b9)

* Issue 29 (#35)

* Modify "gw_fct_node2arc.sql" to work properly with curved geometries and to insert node within the line.

* Improved "gw_fct_connect_to_network.sql" keeping low computational cost.

* #29 Beta version of the "gw_fct_delete_node" function.

* #29 Format source code
Set corresponding toolbar function

* #29 Bug fix

* #28 Replace "test_ws" to "SCHEMA_NAME"

* #28 #36 Attempt to solve bug found in "gw_fct_mincut.sql". Clear temporal tables before running.

Signed-off-by: Vicente Medina <vicente.medina@gits.ws>

* #40 Merge 'issue-40' into 'dev'

* #41  'ws_gw_trg_arc_orphannode_delete'. New trigger for "arc" table, covering AFTER DELETE. The final version of "arc" will contain three different triggers, for BEFORE INSERT, UPDATE and AFTER DELETE.

Signed-off-by: Vicente Medina <vicente.medina@gits.ws>

* close #41

* Merge 'staging' into 'dev' (#46)

* #48 Format code

* Merge 'issue-47' into 'dev' (#50)

* #47 Merge some SQL's from ancient branch 'issue-16'

* #47 Update ui form

* #47 Update custom form workflow
Add new parameters in config file

* #47 Update trigger to avoid exception when inserting node

* #47 Update 'epa_type' default values
Fill node.node_type in sample SQL

* Merge 'issue-58' into dev (#60)

* #58 First version of the "sector" trigger.

It acts on INSERT, UPDATE, DELETE and as a consequence shots the "arc" and "node" triggers. To reduce the impacts both triggers are modified to bypass in case of no geometry update.

Signed-off-by: Vicente Medina <vicente.medina@gits.ws>

* #59 First version of "dma" trigger.

Commits done to the branch #58 because he modification of the the "arc" and "node" triggers done in #58 is mandatory.

Signed-off-by: Vicente Medina <vicente.medina@gits.ws>

* #58 #59 Format code

* Hide plugin menu entries
Improve error catching and messaging

* Update sector_id & dma_id when the_geom of node, arc & connec is modified (#66)

* #56 First version

* Merge SQL files (#68)

* Reorganize SQL files (new file of starting definition (000), new files of external data (00), and new files of analysis structure (6x)

* Update WS sample project with scada & hydrometer data

* Update Scada & hydrometer tables & views

* Change streetaxis by ext_streetaxis on connec view

* Delete inp_value_opti_unb table

* Add ws_71_custom.sql file

* Move gw_fct_mincut.sql from utils to ws

* Update analysis views file

* Update minor changes on analysis views

* Add headers & change config from UTF8 to UTF without boom, bug fix on doc sequences &

* #64 Bug fix doc sequences & add doc sample data

* #64 Bug fix on ws_gw_trg_sector function trigger

* #64 WS - Create views of event data to use on ui

* #64 WS - Create views of doc data to use on ui

* #64 Move v_valve to editting view v_edit_valve

* Rename ws_32_doc_views.sql  to ws_33_doc_views.sql #64

* Update gw_fct_connect_to_network #64

* Add views: element_x_node & element_x_connec #64

* Update WS SQL sample: vnode and link values #64

* Add field nodetype_change_enabled field #64
In config table to configure change system node type

* #64 WS - RTC tables, views & value domain

* #64 Reordering value default of selector's

* #64 Add on sample project UPDATE node SET node_type

* #49 Audit tables (#51)

* Update sector_id & dma_id when the_geom of node, arc & connec is modified (#69)

* #56 Enhance usability

* #56 Load style through QML file

* #56 Get SRID from config file

* Merge 'issue-45' into 'dev' (#71)

* #45 Minor changes in ws connec ui

* #45 Enable widget 'epa_type'

* #45 Hide some tabs 'node' & 'connec'
Remove unused files

* #45 Hide some tabs 'arc'
Remove unused file

* #45 Update query combo 'node_type'

* Update metadata contents: version 0.5

* Bug fix in v0.5
xtorret pushed a commit that referenced this issue Apr 23, 2019
@albertbofill
bug fix (function name) and new icon #58
33375e9
xtorret pushed a commit that referenced this issue Apr 23, 2019
@albertbofill
New icon #58
9ed77d8
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@vicente-medina vicente-medina

Labels
enhancement feature
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@vicente-medina @daviderill