Menu
▾
▴
openutils-svn — developer list with svn commits
You can subscribe to this list here.
| 2006 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(4) |
Nov
(39) |
Dec
(10) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2007 |
Jan
(19) |
Feb
(150) |
Mar
(10) |
Apr
|
May
(8) |
Jun
(11) |
Jul
(27) |
Aug
(52) |
Sep
(35) |
Oct
(30) |
Nov
(18) |
Dec
(4) |
| 2008 |
Jan
(76) |
Feb
(121) |
Mar
(39) |
Apr
(55) |
May
(18) |
Jun
(49) |
Jul
(32) |
Aug
(4) |
Sep
(10) |
Oct
|
Nov
(3) |
Dec
(33) |
| 2009 |
Jan
(19) |
Feb
(87) |
Mar
(69) |
Apr
(38) |
May
(47) |
Jun
(20) |
Jul
(5) |
Aug
(76) |
Sep
(145) |
Oct
(34) |
Nov
(8) |
Dec
(68) |
| 2010 |
Jan
(150) |
Feb
(379) |
Mar
(191) |
Apr
(100) |
May
(525) |
Jun
(269) |
Jul
(127) |
Aug
(190) |
Sep
(190) |
Oct
(29) |
Nov
(147) |
Dec
(83) |
| 2011 |
Jan
(188) |
Feb
(81) |
Mar
(43) |
Apr
(97) |
May
(63) |
Jun
(129) |
Jul
(17) |
Aug
(124) |
Sep
(6) |
Oct
(20) |
Nov
(67) |
Dec
(23) |
| 2012 |
Jan
(6) |
Feb
(14) |
Mar
(181) |
Apr
(64) |
May
(102) |
Jun
(47) |
Jul
(26) |
Aug
(3) |
Sep
(1) |
Oct
(14) |
Nov
(13) |
Dec
(23) |
| 2013 |
Jan
(4) |
Feb
(14) |
Mar
(18) |
Apr
(14) |
May
(27) |
Jun
(27) |
Jul
(5) |
Aug
(2) |
Sep
(74) |
Oct
(79) |
Nov
(21) |
Dec
(97) |
| 2014 |
Jan
(6) |
Feb
(3) |
Mar
(8) |
Apr
|
May
(5) |
Jun
|
Jul
(9) |
Aug
(6) |
Sep
(3) |
Oct
(10) |
Nov
(6) |
Dec
|
| 2015 |
Jan
|
Feb
|
Mar
(1) |
Apr
(25) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2016 |
Jan
|
Feb
|
Mar
|
Apr
(5) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: <fg...@us...> - 2010-11-11 14:13:42
|
Revision: 3130
http://openutils.svn.sourceforge.net/openutils/?rev=3130&view=rev
Author: fgiust
Date: 2010-11-11 14:13:36 +0000 (Thu, 11 Nov 2010)
Log Message:
-----------
[maven-release-plugin] prepare release openutils-dbmigration-2.0.9
Modified Paths:
--------------
trunk/openutils-dbmigration/pom.xml
Modified: trunk/openutils-dbmigration/pom.xml
===================================================================
--- trunk/openutils-dbmigration/pom.xml 2010-11-11 14:11:16 UTC (rev 3129)
+++ trunk/openutils-dbmigration/pom.xml 2010-11-11 14:13:36 UTC (rev 3130)
@@ -14,7 +14,7 @@
With DBMigration you can bundle upgrade scripts in you application. Its purpose
is to manage db updates consistently both for development than for production releases.
]]></description>
- <version>2.0.9-SNAPSHOT</version>
+ <version>2.0.9</version>
<licenses>
<license>
<name>The Apache Software License, Version 2.0</name>
@@ -28,9 +28,9 @@
</issueManagement>
<inceptionYear>2007</inceptionYear>
<scm>
- <connection>scm:svn:https://openutils.svn.sourceforge.net/svnroot/openutils/trunk/openutils-dbmigration</connection>
- <developerConnection>scm:svn:https://openutils.svn.sourceforge.net/svnroot/openutils/trunk/openutils-dbmigration</developerConnection>
- <url>http://openutils.svn.sourceforge.net/viewcvs.cgi/openutils/trunk/openutils-dbmigration</url>
+ <connection>scm:svn:https://openutils.svn.sourceforge.net/svnroot/openutils/tags/openutils-dbmigration-2.0.9</connection>
+ <developerConnection>scm:svn:https://openutils.svn.sourceforge.net/svnroot/openutils/tags/openutils-dbmigration-2.0.9</developerConnection>
+ <url>http://openutils.svn.sourceforge.net/viewcvs.cgi/openutils/tags/openutils-dbmigration-2.0.9</url>
</scm>
<dependencies>
<dependency>
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <fg...@us...> - 2010-11-11 14:11:22
|
Revision: 3129
http://openutils.svn.sourceforge.net/openutils/?rev=3129&view=rev
Author: fgiust
Date: 2010-11-11 14:11:16 +0000 (Thu, 11 Nov 2010)
Log Message:
-----------
postgres specific task for resetting sequences
Added Paths:
-----------
trunk/openutils-dbmigration/src/main/java/it/openutils/migration/postgres/
trunk/openutils-dbmigration/src/main/java/it/openutils/migration/postgres/PostGreSQLSequenceChecker.java
Added: trunk/openutils-dbmigration/src/main/java/it/openutils/migration/postgres/PostGreSQLSequenceChecker.java
===================================================================
--- trunk/openutils-dbmigration/src/main/java/it/openutils/migration/postgres/PostGreSQLSequenceChecker.java (rev 0)
+++ trunk/openutils-dbmigration/src/main/java/it/openutils/migration/postgres/PostGreSQLSequenceChecker.java 2010-11-11 14:11:16 UTC (rev 3129)
@@ -0,0 +1,141 @@
+/**
+ *
+ * openutils db migration (http://www.openmindlab.com/lab/products/dbmigration.html)
+ * Copyright(C) 2007-2010, Openmind S.r.l. http://www.openmindonline.it
+ *
+ * Licensed under the Apache License, Version 2.0 (the "License");
+ * you may not use this file except in compliance with the License.
+ * You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+package it.openutils.migration.postgres;
+
+import it.openutils.migration.task.setup.GenericConditionalTask;
+
+import java.sql.Connection;
+import java.sql.ResultSet;
+import java.sql.SQLException;
+import java.util.ArrayList;
+import java.util.List;
+
+import javax.sql.DataSource;
+
+import org.apache.commons.lang.StringUtils;
+import org.springframework.dao.DataAccessException;
+import org.springframework.jdbc.core.ConnectionCallback;
+import org.springframework.jdbc.core.JdbcTemplate;
+
+
+/**
+ * This is just a patch to move sequences after inserting values from dbMigration. The real solution should be to have
+ * all the database objects generated by dbMigration and not by hibernate. THIS TASK IS NOT CLUSTER SAFE NOR THREAD
+ * SAFE! IT IS JUST A TEMPORARY PATCH.
+ * @author Danilo Ghirardelli
+ */
+public class PostGreSQLSequenceChecker extends GenericConditionalTask
+{
+
+ /**
+ * Enable this task.
+ */
+ private boolean enabled = true;
+
+ private Long offset = 1L;
+
+ /**
+ * @param enabled the enabled to set
+ */
+ public void setEnabled(boolean enabled)
+ {
+ this.enabled = enabled;
+ }
+
+ /**
+ * Sets the offset that will be added to the maximum value of the sequence. In production should be 1, in test may
+ * be big.
+ * @param offset
+ */
+ public void setOffset(Long offset)
+ {
+ this.offset = offset;
+ }
+
+ /**
+ * {@inheritDoc}
+ */
+ @Override
+ @SuppressWarnings("unchecked")
+ public void execute(DataSource dataSource)
+ {
+ if (!enabled)
+ {
+ return;
+ }
+ if (!((Boolean) new JdbcTemplate(dataSource).execute(new ConnectionCallback()
+ {
+
+ public Object doInConnection(Connection con) throws SQLException, DataAccessException
+ {
+ return StringUtils.equalsIgnoreCase(con.getMetaData().getDatabaseProductName(), "PostgreSQL");
+ }
+ })))
+ {
+ log.info("Skipping sequences adjustment, not the right db.");
+ return;
+ }
+ JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
+ List<String> tables = (List<String>) jdbcTemplate.execute(new ConnectionCallback()
+ {
+
+ public Object doInConnection(Connection con) throws SQLException, DataAccessException
+ {
+ List<String> tables = new ArrayList<String>();
+ ResultSet dbTables = con.getMetaData().getTables(null, null, null, new String[]{"TABLE" });
+ while (dbTables.next())
+ {
+ tables.add(dbTables.getString("TABLE_NAME"));
+ }
+ return tables;
+ }
+ });
+ for (String tableName : tables)
+ {
+ if (jdbcTemplate
+ .queryForLong("SELECT COUNT(*) FROM information_schema.sequences WHERE SEQUENCE_NAME ILIKE '"
+ + tableName
+ + "_id_seq'") > 0)
+ {
+ String idColumnName = (String) jdbcTemplate.queryForObject(
+ "SELECT COLUMN_NAME FROM information_schema.columns WHERE TABLE_NAME ILIKE '"
+ + tableName
+ + "' AND COLUMN_DEFAULT ILIKE 'nextval(%"
+ + tableName
+ + "_id_seq%'",
+ String.class);
+ long tableRows = jdbcTemplate.queryForLong("SELECT MAX(" + idColumnName + ") FROM " + tableName);
+ long sequenceVal = jdbcTemplate.queryForLong("SELECT last_value FROM " + tableName + "_id_seq");
+ if ((sequenceVal >= 0) && (tableRows > sequenceVal))
+ {
+ jdbcTemplate.execute("SELECT setval('"
+ + tableName
+ + "_id_seq', "
+ + Long.toString(tableRows + offset)
+ + ")");
+ log.info("Moved sequence \"{}_id_seq\" value from {} to {}.", new Object[]{
+ tableName,
+ sequenceVal,
+ (tableRows + offset) });
+ jdbcTemplate.execute("REINDEX TABLE " + tableName);
+ log.info("Reindexed table: " + tableName);
+ }
+ }
+ }
+ }
+}
\ No newline at end of file
Property changes on: trunk/openutils-dbmigration/src/main/java/it/openutils/migration/postgres/PostGreSQLSequenceChecker.java
___________________________________________________________________
Added: svn:mime-type
+ text/plain
Added: svn:keywords
+ Author Date Id Revision
Added: svn:eol-style
+ native
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <fg...@us...> - 2010-11-11 13:55:39
|
Revision: 3128
http://openutils.svn.sourceforge.net/openutils/?rev=3128&view=rev
Author: fgiust
Date: 2010-11-11 13:55:32 +0000 (Thu, 11 Nov 2010)
Log Message:
-----------
DBMIGRATION-7 ExcelConfigurationTask doesn't deal correctly with PostgreSQL databases and upper case XLS files
Modified Paths:
--------------
trunk/openutils-dbmigration/src/main/java/it/openutils/migration/task/setup/ExcelConfigurationTask.java
Modified: trunk/openutils-dbmigration/src/main/java/it/openutils/migration/task/setup/ExcelConfigurationTask.java
===================================================================
--- trunk/openutils-dbmigration/src/main/java/it/openutils/migration/task/setup/ExcelConfigurationTask.java 2010-11-11 13:44:48 UTC (rev 3127)
+++ trunk/openutils-dbmigration/src/main/java/it/openutils/migration/task/setup/ExcelConfigurationTask.java 2010-11-11 13:55:32 UTC (rev 3128)
@@ -295,8 +295,25 @@
}
else
{
- log.warn("Unable to determine type for column '{}' in table '{}'", column, tableName);
- return false;
+ // DBMIGRATION-7
+ // postgres forces lowercase
+ res.close();
+ res = con.getMetaData().getColumns(
+ null,
+ null,
+ StringUtils.lowerCase(tableName),
+ StringUtils.lowerCase(column));
+
+ if (res.next())
+ {
+ types.add(res.getInt("DATA_TYPE"));
+ }
+ else
+ {
+ log.warn("Unable to determine type for column '{}' in table '{}'", column, tableName);
+ return false;
+ }
+
}
res.close();
}
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <fg...@us...> - 2010-11-11 13:44:55
|
Revision: 3127
http://openutils.svn.sourceforge.net/openutils/?rev=3127&view=rev
Author: fgiust
Date: 2010-11-11 13:44:48 +0000 (Thu, 11 Nov 2010)
Log Message:
-----------
DBMIGRATION-8 New task for checking a column size
Added Paths:
-----------
trunk/openutils-dbmigration/src/main/java/it/openutils/migration/generic/JdbcIfColumnLengthConditionalTask.java
Added: trunk/openutils-dbmigration/src/main/java/it/openutils/migration/generic/JdbcIfColumnLengthConditionalTask.java
===================================================================
--- trunk/openutils-dbmigration/src/main/java/it/openutils/migration/generic/JdbcIfColumnLengthConditionalTask.java (rev 0)
+++ trunk/openutils-dbmigration/src/main/java/it/openutils/migration/generic/JdbcIfColumnLengthConditionalTask.java 2010-11-11 13:44:48 UTC (rev 3127)
@@ -0,0 +1,53 @@
+/**
+ *
+ * openutils db migration (http://www.openmindlab.com/lab/products/dbmigration.html)
+ * Copyright(C) 2007-2010, Openmind S.r.l. http://www.openmindonline.it
+ *
+ * Licensed under the Apache License, Version 2.0 (the "License");
+ * you may not use this file except in compliance with the License.
+ * You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+
+package it.openutils.migration.generic;
+
+import java.util.Map;
+
+
+/**
+ * Task that executes if a given column has a specific length.
+ * @author fgiust
+ * @version $Id$
+ */
+public class JdbcIfColumnLengthConditionalTask extends JdbcColumnBasedConditionalTask
+{
+
+ private int length;
+
+ /**
+ * Sets the length.
+ * @param length the length to set
+ */
+ public void setLength(int length)
+ {
+ this.length = length;
+ }
+
+ /**
+ * {@inheritDoc}
+ */
+ @Override
+ protected boolean checkColumnMetadata(Map<String, Object> metadata)
+ {
+
+ Number columnLength = (Number) metadata.get("COLUMN_SIZE");
+ return length == (columnLength != null ? columnLength.intValue() : 0);
+ }
+}
Property changes on: trunk/openutils-dbmigration/src/main/java/it/openutils/migration/generic/JdbcIfColumnLengthConditionalTask.java
___________________________________________________________________
Added: svn:mime-type
+ text/plain
Added: svn:keywords
+ Author Date Id Revision
Added: svn:eol-style
+ native
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <hu...@op...> - 2010-11-07 14:23:14
|
See <https://hudson.openmindonline.it/job/openutils-mgnlcas/21/> |
|
From: <hu...@op...> - 2010-11-07 14:22:37
|
See <https://hudson.openmindonline.it/job/openutils-elfunctions/net.sourceforge.openutils$openutils-elfunctions/changes> |
|
From: <hu...@op...> - 2010-11-07 14:22:37
|
See <https://hudson.openmindonline.it/job/openutils-elfunctions/31/> |
|
From: <hu...@op...> - 2010-11-07 14:21:42
|
See <https://hudson.openmindonline.it/job/openutils-log4j/24/> |
|
From: <hu...@op...> - 2010-11-07 14:21:01
|
See <https://hudson.openmindonline.it/job/openutils-deployment/19/> |
|
From: <hu...@op...> - 2010-11-07 14:19:38
|
See <https://hudson.openmindonline.it/job/openutils-bshd5/31/> |
|
From: <hu...@op...> - 2010-11-07 14:18:45
|
See <https://hudson.openmindonline.it/job/openutils-mgnlutils/50/> |
|
From: <hu...@op...> - 2010-11-07 14:17:37
|
See <https://hudson.openmindonline.it/job/openutils-mgnltasks/31/> |
|
From: <hu...@op...> - 2010-11-07 14:10:55
|
See <https://hudson.openmindonline.it/job/openutils-mgnlrepoutils/21/> |
|
From: <hu...@op...> - 2010-11-07 14:02:39
|
See <https://hudson.openmindonline.it/job/openutils-mgnlmessages/28/> |
|
From: <hu...@op...> - 2010-11-07 14:01:52
|
See <https://hudson.openmindonline.it/job/openutils-mgnlcriteria/125/> |
|
From: <hu...@op...> - 2010-11-07 14:00:20
|
See <https://hudson.openmindonline.it/job/openutils-mgnlbootstrapsync/22/> |
|
From: <hu...@op...> - 2010-11-07 13:59:35
|
See <https://hudson.openmindonline.it/job/openutils-mgnlcontrols/63/> |
|
From: <hu...@op...> - 2010-11-07 13:33:16
|
See <https://hudson.openmindonline.it/job/openutils-mgnlmedia/306/> |
|
From: <hu...@op...> - 2010-11-07 13:32:42
|
See <https://hudson.openmindonline.it/job/openutils-mgnlgroovy/58/> |
|
From: <hu...@op...> - 2010-11-07 13:13:24
|
See <https://hudson.openmindonline.it/job/openutils-testing4dwr/19/> |
|
From: <hu...@op...> - 2010-11-05 16:51:32
|
See <https://hudson.openmindonline.it/job/openutils-dbmigration/23/> |
|
From: <df...@us...> - 2010-11-05 16:25:16
|
Revision: 3126
http://openutils.svn.sourceforge.net/openutils/?rev=3126&view=rev
Author: dfghi
Date: 2010-11-05 16:25:09 +0000 (Fri, 05 Nov 2010)
Log Message:
-----------
DBMIGRATION-6 Added the "splitChar" property so the user can set different split chars for statements.
Modified Paths:
--------------
trunk/openutils-dbmigration/src/main/java/it/openutils/migration/task/setup/BaseConditionalTask.java
Modified: trunk/openutils-dbmigration/src/main/java/it/openutils/migration/task/setup/BaseConditionalTask.java
===================================================================
--- trunk/openutils-dbmigration/src/main/java/it/openutils/migration/task/setup/BaseConditionalTask.java 2010-10-28 07:59:38 UTC (rev 3125)
+++ trunk/openutils-dbmigration/src/main/java/it/openutils/migration/task/setup/BaseConditionalTask.java 2010-11-05 16:25:09 UTC (rev 3126)
@@ -52,6 +52,12 @@
*/
protected String ddl;
+ /**
+ * Character used to split ddl statement, default is ";" char.
+ * Null or empty value disable split.
+ */
+ protected String splitChar = ";";
+
/**
* If <code>true</code> executes only if check returned <code>false</code>
*/
@@ -83,6 +89,14 @@
{
this.ddl = ddls;
}
+
+ /**
+ * {@inheritDoc}
+ */
+ public final void setSplitChar(String splitChar)
+ {
+ this.splitChar = splitChar;
+ }
/**
* Sets the not.
@@ -229,7 +243,15 @@
*/
protected void executeSingle(SimpleJdbcTemplate jdbcTemplate, String scriptContent)
{
- String[] ddls = StringUtils.split(performSubstitution(scriptContent), ';');
+ String[] ddls;
+ if (StringUtils.isNotEmpty(splitChar))
+ {
+ ddls = StringUtils.split(performSubstitution(scriptContent), splitChar);
+ }
+ else
+ {
+ ddls = new String[]{performSubstitution(scriptContent)};
+ }
for (String statement : ddls)
{
if (StringUtils.isNotBlank(statement))
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
|
From: <hu...@op...> - 2010-11-05 14:07:32
|
See <https://hudson.openmindonline.it/job/openutils-testing-testng/27/> |
|
From: <hu...@op...> - 2010-11-05 14:07:08
|
See <https://hudson.openmindonline.it/job/openutils-mgnlstruts11/24/> |
|
From: <hu...@op...> - 2010-11-05 14:06:32
|
See <https://hudson.openmindonline.it/job/openutils-mgnlspring/20/> |
