Revision 870bdcfa
Added by Andreas Müller almost 6 years ago
| cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/database/update/v47_50/SchemaUpdater_47_50.java | ||
|---|---|---|
| 15 | 15 |
|
| 16 | 16 |
import org.apache.log4j.Logger; |
| 17 | 17 |
|
| 18 |
import eu.etaxonomy.cdm.database.DatabaseTypeEnum; |
|
| 18 | 19 |
import eu.etaxonomy.cdm.database.update.ClassBaseTypeUpdater; |
| 19 | 20 |
import eu.etaxonomy.cdm.database.update.ColumnAdder; |
| 20 | 21 |
import eu.etaxonomy.cdm.database.update.ColumnNameChanger; |
| ... | ... | |
| 317 | 318 |
|
| 318 | 319 |
//move data |
| 319 | 320 |
stepName = "Copy mediaCreated to new columns"; |
| 320 |
String query = "UPDATE @@Media@@ " |
|
| 321 |
+ " SET mediaCreated_start = Left(Replace(Replace(Replace(mediaCreatedOld, '-', ''), ':', ''), ' ', '_'), 13)"
|
|
| 321 |
String queryTemplate = "UPDATE @@Media@@ "
|
|
| 322 |
+ " SET mediaCreated_start = %s "
|
|
| 322 | 323 |
+ " WHERE mediaCreatedOld IS NOT NULL "; |
| 323 |
step = SimpleSchemaUpdaterStep.NewAuditedInstance(stepName, query, tableName, -99); |
|
| 324 |
String queryDefault = String.format(queryTemplate, "Left(Replace(Replace(Replace(mediaCreatedOld, '-', ''), ':', ''), ' ', '_'), 13)"); |
|
| 325 |
String queryPostgres = String.format(queryTemplate, "to_char(mediaCreatedOld,'YYYYMMDD HH24MI')"); |
|
| 326 |
step = SimpleSchemaUpdaterStep.NewAuditedInstance(stepName, queryDefault, tableName, -99) |
|
| 327 |
.put(DatabaseTypeEnum.PostgreSQL, queryPostgres) |
|
| 328 |
.putAudited(DatabaseTypeEnum.PostgreSQL, queryPostgres); |
|
| 324 | 329 |
stepList.add(step); |
| 325 | 330 |
|
| 326 | 331 |
//delete old column |
Also available in: Unified diff
fix #7468 fix update script for mediaCreated in PostGreSQL