Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0029800Openbravo ERPA. Platformpublic2015-05-06 12:542016-03-17 10:54
Reporteregoitz 
Assigned ToAugustoMauch 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR16Q2 
Merge Request Status
Review Assigned Toalostale
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket35864
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0029800: Allow excluding sequences from model
DescriptionAdd the possibility to exclude sequences from model:

http://wiki.openbravo.com/wiki/How_to_exclude_Database_Physical_Objects_From_Model [^]

Some tools installed on top of postgresql create sequences that should be excluded from model.

Steps To ReproduceInstall the slony tool and execute an update.database on q1.3 release:

http://www.slony.info/ [^]

You get errors due to sequences and relations.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to design defect 0028143 closed alostale The database sequences are exported to xml files including also the next value 
related to feature request 0031685 closed AugustoMauch Allow using SQL wildcards in the dbsourmanager exclude filter 
related to feature request 0031672 closed AugustoMauch Add tests to check that the exclusion filter works properly in DBSourceManager 
Attached Files? 29800.export (8,205) 2015-12-09 16:59
https://issues.openbravo.com/file_download.php?file_id=8793&type=bug
Issue History
Date ModifiedUsernameFieldChange
2015-05-06 12:54egoitzNew Issue
2015-05-06 12:54egoitzAssigned To => platform
2015-05-06 12:54egoitzOBNetwork customer => Yes
2015-05-06 12:54egoitzModules => Core
2015-05-06 12:54egoitzSupport ticket => 35864
2015-05-06 12:54egoitzTriggers an Emergency Pack => No
2015-05-06 12:56egoitzRelationship addedrelated to 0028143
2015-12-09 16:59AugustoMauchFile Added: 29800.export
2015-12-09 16:59AugustoMauchStatusnew => scheduled
2015-12-10 09:19AugustoMauchRelationship addedrelated to 0031672
2015-12-11 10:12AugustoMauchAssigned Toplatform => AugustoMauch
2015-12-11 10:13AugustoMauchNote Added: 0082674
2016-01-20 11:44AugustoMauchReview Assigned To => alostale
2016-01-20 12:23hgbotCheckin
2016-01-20 12:23hgbotNote Added: 0083441
2016-01-20 12:23hgbotStatusscheduled => resolved
2016-01-20 12:23hgbotResolutionopen => fixed
2016-01-20 12:23hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/9cbd94b17c8829193f42387b92d1d098b018637f [^]
2016-01-20 12:23hgbotCheckin
2016-01-20 12:23hgbotNote Added: 0083445
2016-01-20 12:23hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/9cbd94b17c8829193f42387b92d1d098b018637f [^] => http://code.openbravo.com/erp/devel/dbsm-main/rev/59d5fc9fb9cf719394db9437d53593ca23643bf5 [^]
2016-01-20 12:24hgbotCheckin
2016-01-20 12:24hgbotNote Added: 0083446
2016-01-20 13:30AugustoMauchRelationship addedrelated to 0031685
2016-01-20 15:26alostaleNote Added: 0083464
2016-01-20 15:26alostaleStatusresolved => closed
2016-01-20 15:26alostaleFixed in Version => 3.0PR16Q2
2016-03-17 10:54hudsonbotCheckin
2016-03-17 10:54hudsonbotNote Added: 0085058

Notes
(0082674)
AugustoMauch   
2015-12-11 10:13   
Done, waiting for the PR16Q2 window to be open
(0083441)
hgbot   
2016-01-20 12:23   
Repository: erp/devel/pi
Changeset: 9cbd94b17c8829193f42387b92d1d098b018637f
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Wed Jan 20 12:20:10 2016 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/9cbd94b17c8829193f42387b92d1d098b018637f [^]

Fixes issue 31672, fixes issue 29800, fixes issue 31685: Wildcards in exclusion

Updates the dbsourcemanager jar, now it is allowed to use wildcards in the exclusion filter (see [1]).

[1] http://wiki.openbravo.com/wiki/How_To_Exclude_Database_Physical_Objects_From_Model [^]

---
M src-db/database/lib/dbsourcemanager.jar
---
(0083445)
hgbot   
2016-01-20 12:23   
Repository: erp/devel/dbsm-main
Changeset: 59d5fc9fb9cf719394db9437d53593ca23643bf5
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Wed Dec 09 16:55:15 2015 +0100
URL: http://code.openbravo.com/erp/devel/dbsm-main/rev/59d5fc9fb9cf719394db9437d53593ca23643bf5 [^]

Fixes issue 29800: It is supported to exclude sequences from the database model

It is possible to exclude sequences from the model by declaring the exclusions in the exclude filter like this:

<?xml version="1.0"?>
  <vector>
    <excludedSequence name="EXCLUDED_SEQUENCE"/>
  </vector>

---
M src/mapping.xml
M src/org/apache/ddlutils/platform/ExcludeFilter.java
A src/org/apache/ddlutils/platform/modelexclusion/ExcludedSequence.java
---
(0083446)
hgbot   
2016-01-20 12:24   
Repository: erp/devel/dbsm-main
Changeset: e3b7eb7d542c49ed95afd1635ae94569cfa86749
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Wed Dec 09 16:56:07 2015 +0100
URL: http://code.openbravo.com/erp/devel/dbsm-main/rev/e3b7eb7d542c49ed95afd1635ae94569cfa86749 [^]

Related with issue 29800: Adds tests to check excluded sequences

---
M src-test/src/org/openbravo/dbsm/test/model/CheckExcludeFilter.java
A src-test/model/excludeFilter/BASE_MODEL_WITH_SEQUENCE.xml
A src-test/model/excludeFilter/excludeSequence.xml
---
(0083464)
alostale   
2016-01-20 15:26   
reviewed and tested as part of project http://wiki.openbravo.com/wiki/Projects:Wildcard_Support_In_Exclude_Filter [^]
(0085058)
hudsonbot   
2016-03-17 10:54   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/b22fb0500156 [^]
Maturity status: Test