details: https://code.openbravo.com/erp/devel/pi/rev/2fbca6442d49
changeset: 20227:2fbca6442d49
user: Javier Etxarri <javier.echarri <at> openbravo.com>
date: Mon Apr 29 14:17:57 2013 +0200
summary: fix int-inc
diffstat:
src-util/buildvalidation/build/classes/org/openbravo/buildvalidation/DuplicatedPriceListVersion.class
| 0
src-util/buildvalidation/src/org/openbravo/buildvalidation/DuplicatedPriceListVersion.java
| 52 ----------
src-util/buildvalidation/src/org/openbravo/buildvalidation/DuplicatedPriceListVersion_data.xsql
| 31 -----
3 files changed, 0 insertions(+), 83 deletions(-)
diffs (94 lines):
diff -r 9b5623c3aaf6 -r 2fbca6442d49
src-util/buildvalidation/build/classes/org/openbravo/buildvalidation/DuplicatedPriceListVersion.class
Binary file
src-util/buildvalidation/build/classes/org/openbravo/buildvalidation/DuplicatedPriceListVersion.class
has changed
diff -r 9b5623c3aaf6 -r 2fbca6442d49
src-util/buildvalidation/src/org/openbravo/buildvalidation/DuplicatedPriceListVersion.java
---
a/src-util/buildvalidation/src/org/openbravo/buildvalidation/DuplicatedPriceListVersion.java
Mon Apr 29 14:05:40 2013 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,52 +0,0 @@
-/*
- *************************************************************************
- * The contents of this file are subject to the Openbravo Public License
- * Version 1.1 (the "License"), being the Mozilla Public License
- * Version 1.1 with a permitted attribution clause; you may not use this
- * file except in compliance with the License. You may obtain a copy of
- * the License at http://www.openbravo.com/legal/license.html
- * Software distributed under the License is distributed on an "AS IS"
- * basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
- * License for the specific language governing rights and limitations
- * under the License.
- * The Original Code is Openbravo ERP.
- * The Initial Developer of the Original Code is Openbravo SLU
- * All portions are Copyright (C) 2010 Openbravo SLU
- * All Rights Reserved.
- * Contributor(s): ______________________________________.
- ************************************************************************
- */
-package org.openbravo.buildvalidation;
-
-import java.util.ArrayList;
-import java.util.List;
-
-import org.openbravo.database.ConnectionProvider;
-
-/**
- * This validation is related to this issue: 23164: It is possible to create a
- * two price list versions with same name and same valid from date
- */
-public class DuplicatedPriceListVersion extends BuildValidation {
-
- @Override
- public List<String> execute() {
- ConnectionProvider cp = getConnectionProvider();
- ArrayList<String> errors = new ArrayList<String>();
- try {
- if (DuplicatedPriceListVersionData.existsDuplicatedPriceListVersion(cp))
{
- errors
- .add("Due to a database constraint modification, is no longer
allowed " +
- "to create two price list versions with same name and
same valid from date" +
- "to one price list. " +
- "There exists data in your database that do not fit
this new constraint. " +
- "Please fix it in M_PRICELIST_VERSION table as
M_PRICELIST_ID, NAME AND " +
- "VALIDFROM columns have not got duplicated values");
- }
- } catch (Exception e) {
- return handleError(e);
- }
- return errors;
- }
-
-}
diff -r 9b5623c3aaf6 -r 2fbca6442d49
src-util/buildvalidation/src/org/openbravo/buildvalidation/DuplicatedPriceListVersion_data.xsql
---
a/src-util/buildvalidation/src/org/openbravo/buildvalidation/DuplicatedPriceListVersion_data.xsql
Mon Apr 29 14:05:40 2013 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,32 +0,0 @@
-<?xml version="1.0" encoding="UTF-8" ?>
-<!--
- *************************************************************************
- * The contents of this file are subject to the Openbravo Public License
- * Version 1.1 (the "License"), being the Mozilla Public License
- * Version 1.1 with a permitted attribution clause; you may not use this
- * file except in compliance with the License. You may obtain a copy of
- * the License at http://www.openbravo.com/legal/license.html
- * Software distributed under the License is distributed on an "AS IS"
- * basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
- * License for the specific language governing rights and limitations
- * under the License.
- * The Original Code is Openbravo ERP.
- * The Initial Developer of the Original Code is Openbravo SLU
- * All portions are Copyright (C) 2013 Openbravo SLU
- * All Rights Reserved.
- * Contributor(s): ______________________________________.
- ************************************************************************
--->
-
-<SqlClass name="DuplicatedPriceListVersionData"
package="org.openbravo.buildvalidation">
- <SqlMethod name="existsDuplicatedPriceListVersion" type="preparedStatement"
return="boolean">
- <SqlMethodComment></SqlMethodComment>
- <Sql><![CDATA[
- SELECT count(*) AS EXISTING
- FROM m_pricelist_version
- GROUP BY m_pricelist_id, name, validfrom
- HAVING count(*)>1
- ]]>
- </Sql>
- </SqlMethod>
-</SqlClass>
------------------------------------------------------------------------------
Try New Relic Now & We'll Send You this Cool Shirt
New Relic is the only SaaS-based application performance monitoring service
that delivers powerful full stack analytics. Optimize and monitor your
browser, app, & servers with just a few lines of code. Try New Relic
and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_apr
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
