Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0029800
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Openbravo ERP] A. Platformmajorhave not tried2015-05-06 12:542016-03-17 10:54
ReporteregoitzView Statuspublic 
Assigned ToAugustoMauch 
PrioritynormalResolutionfixedFixed in Version3.0PR16Q2
StatusclosedFix in branchFixed in SCM revision59d5fc9fb9cf
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Toalostale
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0029800: 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.
TagsNo tags attached.
Attached Files? file icon 29800.export [^] (8,205 bytes) 2015-12-09 16:59

- Relationships Relation Graph ] Dependency Graph ]
related to design defect 0028143 closedalostale The database sequences are exported to xml files including also the next value 
related to feature request 0031685 closedAugustoMauch Allow using SQL wildcards in the dbsourmanager exclude filter 
related to feature request 0031672 closedAugustoMauch Add tests to check that the exclusion filter works properly in DBSourceManager 

-  Notes
(0082674)
AugustoMauch (manager)
2015-12-11 10:13

Done, waiting for the PR16Q2 window to be open
(0083441)
hgbot (developer)
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 (developer)
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 (developer)
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 (manager)
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 (developer)
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

- Issue History
Date Modified Username Field Change
2015-05-06 12:54 egoitz New Issue
2015-05-06 12:54 egoitz Assigned To => platform
2015-05-06 12:54 egoitz Modules => Core
2015-05-06 12:54 egoitz Triggers an Emergency Pack => No
2015-05-06 12:56 egoitz Relationship added related to 0028143
2015-12-09 16:59 AugustoMauch File Added: 29800.export
2015-12-09 16:59 AugustoMauch Status new => scheduled
2015-12-10 09:19 AugustoMauch Relationship added related to 0031672
2015-12-11 10:12 AugustoMauch Assigned To platform => AugustoMauch
2015-12-11 10:13 AugustoMauch Note Added: 0082674
2016-01-20 11:44 AugustoMauch Review Assigned To => alostale
2016-01-20 12:23 hgbot Checkin
2016-01-20 12:23 hgbot Note Added: 0083441
2016-01-20 12:23 hgbot Status scheduled => resolved
2016-01-20 12:23 hgbot Resolution open => fixed
2016-01-20 12:23 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/9cbd94b17c8829193f42387b92d1d098b018637f [^]
2016-01-20 12:23 hgbot Checkin
2016-01-20 12:23 hgbot Note Added: 0083445
2016-01-20 12:23 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/9cbd94b17c8829193f42387b92d1d098b018637f [^] => http://code.openbravo.com/erp/devel/dbsm-main/rev/59d5fc9fb9cf719394db9437d53593ca23643bf5 [^]
2016-01-20 12:24 hgbot Checkin
2016-01-20 12:24 hgbot Note Added: 0083446
2016-01-20 13:30 AugustoMauch Relationship added related to 0031685
2016-01-20 15:26 alostale Note Added: 0083464
2016-01-20 15:26 alostale Status resolved => closed
2016-01-20 15:26 alostale Fixed in Version => 3.0PR16Q2
2016-03-17 10:54 hudsonbot Checkin
2016-03-17 10:54 hudsonbot Note Added: 0085058


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker