Revision ffe5e099
Added by Andreas Müller about 5 years ago
cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/database/update/ColumnAdder.java | ||
---|---|---|
62 | 62 |
public static final ColumnAdder NewStringInstance(String stepName, String tableName, String newColumnName, int length, boolean includeAudTable){ |
63 | 63 |
return new ColumnAdder(stepName, tableName, newColumnName, "nvarchar("+length+")", includeAudTable, null, false, null); |
64 | 64 |
} |
65 |
public static final ColumnAdder NewStringInstance(String stepName, String tableName, String newColumnName, int length, String defaultValue, boolean includeAudTable){ |
|
66 |
return new ColumnAdder(stepName, tableName, newColumnName, "nvarchar("+length+")", includeAudTable, defaultValue, false, null); |
|
67 |
} |
|
65 | 68 |
|
66 | 69 |
public static final ColumnAdder NewClobInstance(String stepName, String tableName, String newColumnName, boolean includeAudTable){ |
67 | 70 |
return new ColumnAdder(stepName, tableName, newColumnName, "clob", includeAudTable, null, false, null); |
... | ... | |
103 | 106 |
defaultValueQuery = defaultValueQuery.replace("@tableName", tableName); |
104 | 107 |
defaultValueQuery = defaultValueQuery.replace("@columnName", newColumnName); |
105 | 108 |
datasource.executeUpdate(defaultValueQuery); |
109 |
}else if (defaultValue instanceof String){ |
|
110 |
String defaultValueQuery = "UPDATE @tableName SET @columnName = " + (defaultValue == null ? "NULL" : "'" + defaultValue + "'"); |
|
111 |
defaultValueQuery = defaultValueQuery.replace("@tableName", tableName); |
|
112 |
defaultValueQuery = defaultValueQuery.replace("@columnName", newColumnName); |
|
113 |
datasource.executeUpdate(defaultValueQuery); |
|
106 | 114 |
}else if (defaultValue != null){ |
107 | 115 |
logger.warn("Default Value not implemented for type " + defaultValue.getClass().getName()); |
108 | 116 |
} |
Also available in: Unified diff
ref #6794 add termType to FeatureTree and FeatureNode