Project

General

Profile

« Previous | Next » 

Revision f04abc2f

Added by Andreas Müller about 8 years ago

Adapt table and column names to hibernate 5 naming strategy #5369

... and some other changes to table/attribute names

View differences:

cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/database/update/v36_40/SchemaUpdater_36_40.java
22 22
import eu.etaxonomy.cdm.database.update.ISchemaUpdaterStep;
23 23
import eu.etaxonomy.cdm.database.update.SchemaUpdaterBase;
24 24
import eu.etaxonomy.cdm.database.update.SimpleSchemaUpdaterStep;
25
import eu.etaxonomy.cdm.database.update.TableNameChanger;
25 26
import eu.etaxonomy.cdm.database.update.v35_36.SchemaUpdater_35_36;
26 27

  
27 28
/**
......
107 108
        step = ColumnRemover.NewInstance(stepName, tableName, newColumnName, ! INCLUDE_AUDIT);
108 109
        stepList.add(step);
109 110

  
111
        ///#5369
112
        renameColumnsAccordingToHibernate5(stepList);
110 113

  
111 114

  
112 115
        return stepList;
113 116
	}
114 117

  
115 118

  
116
	@Override
119
	//#5369
120
    private void renameColumnsAccordingToHibernate5(List<ISchemaUpdaterStep> stepList) {
121

  
122
        //AgenBase_AgentBase.AgentBase_ID  -> Team_ID
123
        String stepName = "Rename columns according to hibernate5";
124
        String tableName = "AgentBase_AgentBase";
125
        String oldColumnName = "agentbase_id";
126
        String newColumnName = "team_id";
127
        ISchemaUpdaterStep step = ColumnNameChanger.NewIntegerInstance(stepName, tableName, oldColumnName, newColumnName, INCLUDE_AUDIT);
128
        stepList.add(step);
129

  
130
        //DescriptionElementBase_LanguageString.DescriptionElementBase_ID -> TextData_ID
131
        stepName = "Rename DescriptionElementBase_LanguageString.DescriptionElementBase_ID";
132
        tableName = "DescriptionElementBase_LanguageString";
133
        oldColumnName = "descriptionElementBase_id";
134
        newColumnName = "textdata_id";
135
        step = ColumnNameChanger.NewIntegerInstance(stepName, tableName, oldColumnName, newColumnName, INCLUDE_AUDIT);
136
        stepList.add(step);
137

  
138
        //AgentBase_DefinedTermBase.AgentBase_ID -> Institution_id
139
        stepName = "Rename AgentBase_DefinedTermBase.AgentBase_ID -> Institution_id";
140
        tableName = "AgentBase_DefinedTermBase";
141
        oldColumnName = "agentbase_id";
142
        newColumnName = "institution_id";
143
        step = ColumnNameChanger.NewIntegerInstance(stepName, tableName, oldColumnName, newColumnName, INCLUDE_AUDIT);
144
        stepList.add(step);
145

  
146
        //PermissionGroup_GrantedAuthorityImpl.PermsiionsGroup_id -> Group_id
147
        stepName = "PermissionGroup_GrantedAuthorityImpl.PermsiionsGroup_id -> Group_id ";
148
        tableName = "PermissionGroup_GrantedAuthorityImpl";
149
        oldColumnName = "Permissiongroup_id";
150
        newColumnName = "group_id";
151
        step = ColumnNameChanger.NewIntegerInstance(stepName, tableName, oldColumnName, newColumnName, ! INCLUDE_AUDIT);
152
        stepList.add(step);
153

  
154
        //UserAccount_GrantedAuthorityImpl.UserAccount_id -> User_id
155
        stepName = "UserAccount_GrantedAuthorityImpl.UserAccount_id -> User_id ";
156
        tableName = "UserAccount_GrantedAuthorityImpl";
157
        oldColumnName = "useraccount_id";
158
        newColumnName = "user_id";
159
        step = ColumnNameChanger.NewIntegerInstance(stepName, tableName, oldColumnName, newColumnName, ! INCLUDE_AUDIT);
160
        stepList.add(step);
161

  
162
        //DefinedTermBase_RecommendedModifierEnumeration.DefinedTermBase_id -> Feature_id
163
        stepName = "DefinedTermBase_RecommendedModifierEnumeration.DefinedTermBase_id -> Feature_id";
164
        tableName = "DefinedTermBase_RecommendedModifierEnumeration";
165
        oldColumnName = "definedtermbase_id";
166
        newColumnName = "feature_id";
167
        step = ColumnNameChanger.NewIntegerInstance(stepName, tableName, oldColumnName, newColumnName, INCLUDE_AUDIT);
168
        stepList.add(step);
169

  
170
        //DefinedTermBase_StatisticalMeasure.DefinedTermBase_id -> Feature_id
171
        stepName = "DefinedTermBase_StatisticalMeasure.DefinedTermBase_id -> Feature_id";
172
        tableName = "DefinedTermBase_StatisticalMeasure";
173
        oldColumnName = "definedtermbase_id";
174
        newColumnName = "feature_id";
175
        step = ColumnNameChanger.NewIntegerInstance(stepName, tableName, oldColumnName, newColumnName, INCLUDE_AUDIT);
176
        stepList.add(step);
177

  
178
        //DefinedTermBase_SupportedCategoricalEnumeration.DefinedTermBase_id -> Feature_id
179
        stepName = "DefinedTermBase_SupportedCategoricalEnumeration.DefinedTermBase_id -> Feature_id";
180
        tableName = "DefinedTermBase_SupportedCategoricalEnumeration";
181
        oldColumnName = "definedtermbase_id";
182
        newColumnName = "feature_id";
183
        step = ColumnNameChanger.NewIntegerInstance(stepName, tableName, oldColumnName, newColumnName, INCLUDE_AUDIT);
184
        stepList.add(step);
185

  
186
        //DefinedTermBase_MeasurementUnit.DefinedTermBase_id -> Feature_id
187
        stepName = "DefinedTermBase_MeasurementUnit.DefinedTermBase_id -> Feature_id";
188
        tableName = "DefinedTermBase_MeasurementUnit";
189
        oldColumnName = "definedtermbase_id";
190
        newColumnName = "feature_id";
191
        step = ColumnNameChanger.NewIntegerInstance(stepName, tableName, oldColumnName, newColumnName, INCLUDE_AUDIT);
192
        stepList.add(step);
193

  
194
        //Media_TaxonBase.Media_id -> MediaKey_id
195
        stepName = "DefinedTermBase_MeasurementUnit.DefinedTermBase_id -> Feature_id";
196
        tableName = "Media_TaxonBase";
197
        oldColumnName = "media_id";
198
        newColumnName = "mediakey_id";
199
        step = ColumnNameChanger.NewIntegerInstance(stepName, tableName, oldColumnName, newColumnName, INCLUDE_AUDIT);
200
        stepList.add(step);
201

  
202
        //Rename Media_TaxonBase -> MediaKey_CoveredTaxon
203
        stepName = "Rename Media_TaxonBase -> MediaKey_CoveredTaxon";
204
        String oldTableName = "Media_TaxonBase";
205
        String newTableName = "MediaKey_CoveredTaxon";
206
        step = TableNameChanger.NewInstance(stepName, oldTableName, newTableName, INCLUDE_AUDIT);
207
        stepList.add(step);
208

  
209
        //MediaKey_NamedArea.Media_id -> MediaKey_id
210
        stepName = "MediaKey_NamedArea.Media_id -> MediaKey_id";
211
        tableName = "MediaKey_NamedArea";
212
        oldColumnName = "media_id";
213
        newColumnName = "mediakey_id";
214
        step = ColumnNameChanger.NewIntegerInstance(stepName, tableName, oldColumnName, newColumnName, INCLUDE_AUDIT);
215
        stepList.add(step);
216

  
217
        //MediaKey_Scope.Media_id -> MediaKey_id
218
        stepName = "MediaKey_Scope.Media_id -> MediaKey_id";
219
        tableName = "MediaKey_Scope";
220
        oldColumnName = "media_id";
221
        newColumnName = "mediakey_id";
222
        step = ColumnNameChanger.NewIntegerInstance(stepName, tableName, oldColumnName, newColumnName, INCLUDE_AUDIT);
223
        stepList.add(step);
224

  
225
        //Rename MediaKey_Taxon -> MediaKey_TaxonScope
226
        stepName = "Rename MediaKey_Taxon -> MediaKey_TaxonScope";
227
        oldTableName = "MediaKey_Taxon";
228
        newTableName = "MediaKey_TaxonScope";
229
        step = TableNameChanger.NewInstance(stepName, oldTableName, newTableName, INCLUDE_AUDIT);
230
        stepList.add(step);
231

  
232
        //MediaKey_TaxonScope.taxon_id -> taxonomicScope_id
233
        stepName = "MediaKey_TaxonScope.taxon_id -> taxonomicScope_id";
234
        tableName = "MediaKey_TaxonScope";
235
        oldColumnName = "taxon_id";
236
        newColumnName = "taxonomicScope_id";
237
        step = ColumnNameChanger.NewIntegerInstance(stepName, tableName, oldColumnName, newColumnName, INCLUDE_AUDIT);
238
        stepList.add(step);
239

  
240
        //Rename WorkingSet_TaxonBase -> MultiAccessKey_CoveredTaxon
241
        stepName = "Rename WorkingSet_TaxonBase -> MultiAccessKey_CoveredTaxon";
242
        oldTableName = "WorkingSet_TaxonBase";
243
        newTableName = "MultiAccessKey_CoveredTaxon";
244
        step = TableNameChanger.NewInstance(stepName, oldTableName, newTableName, INCLUDE_AUDIT);
245
        stepList.add(step);
246

  
247
        //MultiAccessKey_CoveredTaxon.WorkingSet_id -> MultiAccessKey_id
248
        stepName = "MultiAccessKey_CoveredTaxon.WorkingSet_id -> MultiAccessKey_id";
249
        tableName = "MultiAccessKey_CoveredTaxon";
250
        oldColumnName = "workingset_id";
251
        newColumnName = "multiaccesskey_id";
252
        step = ColumnNameChanger.NewIntegerInstance(stepName, tableName, oldColumnName, newColumnName, INCLUDE_AUDIT);
253
        stepList.add(step);
254
//         (also rename table)
255

  
256
        //MultiAccessKey_NamedArea.WorkingSet_id -> MultiAccessKey_id
257
        stepName = "MultiAccessKey_NamedArea.WorkingSet_id -> MultiAccessKey_id";
258
        tableName = "MultiAccessKey_NamedArea";
259
        oldColumnName = "workingset_id";
260
        newColumnName = "multiaccesskey_id";
261
        step = ColumnNameChanger.NewIntegerInstance(stepName, tableName, oldColumnName, newColumnName, INCLUDE_AUDIT);
262
        stepList.add(step);
263

  
264
        //MultiAccessKey_Scope.WorkingSet_id -> MultiAccessKey_id
265
        stepName = "MultiAccessKey_Scope.WorkingSet_id -> MultiAccessKey_id ";
266
        tableName = "MultiAccessKey_Scope";
267
        oldColumnName = "workingset_id";
268
        newColumnName = "multiaccesskey_id";
269
        step = ColumnNameChanger.NewIntegerInstance(stepName, tableName, oldColumnName, newColumnName, INCLUDE_AUDIT);
270
        stepList.add(step);
271

  
272
        //Rename MultiAccessKey_Taxon -> MultiAccessKey_TaxonScope
273
        stepName = "Rename MultiAccessKey_Taxon -> MultiAccessKey_TaxonScope";
274
        oldTableName = "MultiAccessKey_Taxon";
275
        newTableName = "MultiAccessKey_TaxonScope";
276
        step = TableNameChanger.NewInstance(stepName, oldTableName, newTableName, INCLUDE_AUDIT);
277
        stepList.add(step);
278

  
279
        //MultiAccessKey_TaxonScope.taxon_id -> taxonomicScope_id
280
        stepName = "MultiAccessKey_TaxonScope.taxon_id -> taxonomicScope_id";
281
        tableName = "MultiAccessKey_TaxonScope";
282
        oldColumnName = "taxon_id";
283
        newColumnName = "taxonomicScope_id";
284
        step = ColumnNameChanger.NewIntegerInstance(stepName, tableName, oldColumnName, newColumnName, INCLUDE_AUDIT);
285
        stepList.add(step);
286

  
287
        //DescriptionBase_Scope.DescriptionBase_id -> TaxonDescription_id
288
        stepName = "DescriptionBase_Scope.DescriptionBase_id -> TaxonDescription_id";
289
        tableName = "DescriptionBase_Scope";
290
        oldColumnName = "descriptionbase_id";
291
        newColumnName = "taxondescription_id";
292
        step = ColumnNameChanger.NewIntegerInstance(stepName, tableName, oldColumnName, newColumnName, INCLUDE_AUDIT);
293
        stepList.add(step);
294

  
295
        //DescriptionBase_GeoScope.DescriptionBase_id -> TaxonDescription_id
296
        stepName = "DescriptionBase_GeoScope.DescriptionBase_id -> TaxonDescription_id";
297
        tableName = "DescriptionBase_GeoScope";
298
        oldColumnName = "descriptionbase_id";
299
        newColumnName = "taxondescription_id";
300
        step = ColumnNameChanger.NewIntegerInstance(stepName, tableName, oldColumnName, newColumnName, INCLUDE_AUDIT);
301
        stepList.add(step);
302

  
303
        //DefinedTermBase_Continent.DefinedTermBase_id -> Country_id
304
        stepName = "DefinedTermBase_Continent.DefinedTermBase_id -> Country_id";
305
        tableName = "DefinedTermBase_Continent";
306
        oldColumnName = "definedtermbase_id";
307
        newColumnName = "country_id";
308
        step = ColumnNameChanger.NewIntegerInstance(stepName, tableName, oldColumnName, newColumnName, INCLUDE_AUDIT);
309
        stepList.add(step);
310

  
311
        //DefinedTermBase_Country.DefinedTermBase_id -> NamedArea_id
312
        stepName = "DefinedTermBase_Country.DefinedTermBase_id -> NamedArea_id";
313
        tableName = "DefinedTermBase_Country";
314
        oldColumnName = "definedtermbase_id";
315
        newColumnName = "namedarea_id";
316
        step = ColumnNameChanger.NewIntegerInstance(stepName, tableName, oldColumnName, newColumnName, INCLUDE_AUDIT);
317
        stepList.add(step);
318

  
319
        //Media_Sequence.Media_id -> PhylogeneticTree_id
320
        stepName = "Media_Sequence.Media_id -> PhylogeneticTree_id";
321
        tableName = "Media_Sequence";
322
        oldColumnName = "media_id";
323
        newColumnName = "phylogenetictree_id";
324
        step = ColumnNameChanger.NewIntegerInstance(stepName, tableName, oldColumnName, newColumnName, INCLUDE_AUDIT);
325
        stepList.add(step);
326

  
327

  
328
        //RelationshipTermBase_inverseRepresentation.DefinedTermBase_id ->RelationshipTermBase_id
329
        stepName = "RelationshipTermBase_inverseRepresentation.DefinedTermBase_id ->RelationshipTermBase_id";
330
        tableName = "RelationshipTermBase_inverseRepresentation";
331
        oldColumnName = "definedtermbase_id";
332
        newColumnName = "relationshiptermbase_id";
333
        step = ColumnNameChanger.NewIntegerInstance(stepName, tableName, oldColumnName, newColumnName, INCLUDE_AUDIT);
334
        stepList.add(step);
335

  
336
        //TaxonInteraction_LanguageString.DescriptionElementBase_id -> TaxonInteraction_id
337
        stepName = "TaxonInteraction_LanguageString.DescriptionElementBase_id -> TaxonInteraction_id";
338
        tableName = "TaxonInteraction_LanguageString";
339
        oldColumnName = "descriptionelementbase_id";
340
        newColumnName = "taxoninteraction_id";
341
        step = ColumnNameChanger.NewIntegerInstance(stepName, tableName, oldColumnName, newColumnName, INCLUDE_AUDIT);
342
        stepList.add(step);
343

  
344
        //IndividualAssociation_LanguageString.DescriptionElementBase_id -> IndividualsAssociation_id
345
        stepName = "IndividualAssociation_LanguageString.DescriptionElementBase_id -> IndividualsAssociation_id";
346
        tableName = "IndividualAssociation_LanguageString";
347
        oldColumnName = "descriptionelementbase_id";
348
        newColumnName = "individualsassociation_id";
349
        step = ColumnNameChanger.NewIntegerInstance(stepName, tableName, oldColumnName, newColumnName, INCLUDE_AUDIT);
350
        stepList.add(step);
351

  
352
        //Media_Representation.Media_id -> MediaKey_id
353
        stepName = "Media_Representation.Media_id -> MediaKey_id";
354
        tableName = "Media_Representation";
355
        oldColumnName = "media_id";
356
        newColumnName = "mediakey_id";
357
        step = ColumnNameChanger.NewIntegerInstance(stepName, tableName, oldColumnName, newColumnName, INCLUDE_AUDIT);
358
        stepList.add(step);
359

  
360
        //RightsInfo_Annotation. RightsInfo_id->Rights_id (see AssociationOverrides on class level)
361
        stepName = "RightsInfo_Annotation. RightsInfo_id->Rights_id";
362
        tableName = "RightsInfo_Annotation";
363
        oldColumnName = "rightsinfo_id";
364
        newColumnName = "rights_id";
365
        step = ColumnNameChanger.NewIntegerInstance(stepName, tableName, oldColumnName, newColumnName, INCLUDE_AUDIT);
366
        stepList.add(step);
367

  
368
        // RightsInfo_Marker. RightsInfo_id->Rights_id (see AssociationOverrides on class level)
369
        stepName = "RightsInfo_Marker. RightsInfo_id->Rights_id";
370
        tableName = "RightsInfo_Marker";
371
        oldColumnName = "rightsinfo_id";
372
        newColumnName = "rights_id";
373
        step = ColumnNameChanger.NewIntegerInstance(stepName, tableName, oldColumnName, newColumnName, INCLUDE_AUDIT);
374
        stepList.add(step);
375

  
376
        // WorkingSet_DescriptionBase.workingSet_id->workingSets_id
377
        stepName = "WorkingSet_DescriptionBase.workingSet_id->workingSets_id";
378
        tableName = "WorkingSet_DescriptionBase";
379
        oldColumnName = "workingSet_id";
380
        newColumnName = "workingSets_id";
381
        step = ColumnNameChanger.NewIntegerInstance(stepName, tableName, oldColumnName, newColumnName, INCLUDE_AUDIT);
382
        stepList.add(step);
383

  
384
        // IndividualAssociation_LanguageString -> IndividualsAssociation_LanguageString
385
        stepName = "IndividualAssociation_LanguageString -> IndividualsAssociation_LanguageString";
386
        oldTableName = "IndividualAssociation_LanguageString";
387
        newTableName = "IndividualsAssociation_LanguageString";
388
        step = TableNameChanger.NewInstance(stepName, oldTableName, newTableName, INCLUDE_AUDIT);
389
        stepList.add(step);
390

  
391
        //Contact tables
392
        // AgentBase_contact_emailaddresses-> AgentBase_contact_emailAddresses
393
        //in 2 steps to avoid "table already exists" on non sensitive systems
394
        stepName = "AgentBase_contact_emailaddresses-> AgentBase_contact_emailAddresses(I)";
395
        oldTableName = "AgentBase_contact_emailaddresses";
396
        newTableName = "AgentBase_contact_emailaddresses2";
397
        step = TableNameChanger.NewInstance(stepName, oldTableName, newTableName, INCLUDE_AUDIT);
398
        stepList.add(step);
399
        stepName = "AgentBase_contact_emailaddresses-> AgentBase_contact_emailAddresses(II)";
400
        oldTableName = "AgentBase_contact_emailaddresses2";
401
        newTableName = "AgentBase_contact_emailAddresses";
402
        step = TableNameChanger.NewInstance(stepName, oldTableName, newTableName, INCLUDE_AUDIT);
403
        stepList.add(step);
404

  
405
        // AgentBase_contact_faxnumbers-> AgentBase_contact_faxNumbers
406
        stepName = "AgentBase_contact_faxnumbers-> AgentBase_contact_faxNumbers(I)";
407
        oldTableName = "AgentBase_contact_faxnumbers";
408
        newTableName = "AgentBase_contact_faxnumbers2";
409
        step = TableNameChanger.NewInstance(stepName, oldTableName, newTableName, INCLUDE_AUDIT);
410
        stepList.add(step);
411
        stepName = "AgentBase_contact_faxnumbers-> AgentBase_contact_faxNumbers(II)";
412
        oldTableName = "AgentBase_contact_faxnumbers2";
413
        newTableName = "AgentBase_contact_faxNumbers";
414
        step = TableNameChanger.NewInstance(stepName, oldTableName, newTableName, INCLUDE_AUDIT);
415
        stepList.add(step);
416

  
417
        // AgentBase_contact_phoneNumbers-> AgentBase_contact_phoneNumbers
418
        stepName = "AgentBase_contact_phonenumbers-> AgentBase_contact_phoneNumbers(I)";
419
        oldTableName = "AgentBase_contact_phonenumbers";
420
        newTableName = "AgentBase_contact_phonenumbers2";
421
        step = TableNameChanger.NewInstance(stepName, oldTableName, newTableName, INCLUDE_AUDIT);
422
        stepList.add(step);
423
        stepName = "AgentBase_contact_phonenumbers-> AgentBase_contact_phoneNumbers(II)";
424
        oldTableName = "AgentBase_contact_phonenumbers2";
425
        newTableName = "AgentBase_contact_phoneNumbers";
426
        step = TableNameChanger.NewInstance(stepName, oldTableName, newTableName, INCLUDE_AUDIT);
427
        stepList.add(step);
428
    }
429

  
430
    @Override
117 431
	public ISchemaUpdater getNextUpdater() {
118 432
		return null;
119 433
	}

Also available in: Unified diff