1
|
/**
|
2
|
*
|
3
|
*/
|
4
|
package eu.etaxonomy.cdm.database.update;
|
5
|
|
6
|
import org.apache.log4j.Logger;
|
7
|
|
8
|
import eu.etaxonomy.cdm.api.application.CdmApplicationController;
|
9
|
import eu.etaxonomy.cdm.common.AccountStore;
|
10
|
import eu.etaxonomy.cdm.common.monitor.DefaultProgressMonitor;
|
11
|
import eu.etaxonomy.cdm.database.CdmDataSource;
|
12
|
import eu.etaxonomy.cdm.database.DbSchemaValidation;
|
13
|
import eu.etaxonomy.cdm.database.ICdmDataSource;
|
14
|
import eu.etaxonomy.cdm.io.api.application.CdmIoApplicationController;
|
15
|
import eu.etaxonomy.cdm.model.taxon.Classification;
|
16
|
|
17
|
/**
|
18
|
* @author a.mueller
|
19
|
*
|
20
|
*/
|
21
|
public class BgbmInstancesUpdater {
|
22
|
private static final Logger logger = Logger.getLogger(BgbmInstancesUpdater.class);
|
23
|
|
24
|
private static String integrationServer = "160.45.63.201";
|
25
|
private static String productionServer = "160.45.63.171";
|
26
|
// private static String testServer = "160.45.63.175";
|
27
|
private static String testServer = "edit-test.bgbm.fu-berlin.de"; //preliminary
|
28
|
|
29
|
private static String[] integrationDatabases = new String[]{/**/"cdm_integration_cichorieae",
|
30
|
"cdm_integration_cyprus", "cdm_integration_diptera", "cdm_integration_flora_malesiana",
|
31
|
"cdm_integration_palmae"};
|
32
|
|
33
|
private static String[] testDatabases = new String[]{"cdm_bgbm_edit_usergroup","cdm_campanulaceae",
|
34
|
"cdm_campanulaceae_082014","cdm_caryo", "cdm_col","cdm_corvidae","cdm_cyprus","cdm_demo1","cdm_demo2",
|
35
|
"cdm_demo3", "cdm_edit_algaterra","cdm_edit_cichorieae","cdm_edit_ildis","cdm_edit_flora_central_africa",
|
36
|
"cdm_flora_guianas","cdm_flore_gabon","cdm_edit_flora_malesiana","cdm_edit_globis","cdm_edit_palmae",
|
37
|
"cdm_ipni_Caryophyllaceae","cdm_mt_moose","cdm_mt_standardliste",
|
38
|
"cdm_pesi_euromed", "cdm_pesi_erms","cdm_pesi_fauna_europaea",
|
39
|
"cdm_proibiosphere_chenopodium_pilot","cdm_rl_mammalia","cdm_rl_animals","cdm_test_eckhard","cdm_test_euromed","cdm_test_gabi",
|
40
|
"cdm_test_norbert","cdm_test_sabine","cdm_vibrant_index"};
|
41
|
|
42
|
private static String[] testDatabasesOthers = new String[]{"cdm_caryo_amaranthaceae",
|
43
|
"cdm_caryo_caryophyllales","cdm_flora_malesiana_prospective","cdm_pesi_all","cdm_salvador",
|
44
|
};
|
45
|
|
46
|
private static String[] productionDatabases = new String[]{
|
47
|
"cdm_col", "cdm_production_acantholimon","cdm_production_algaterra",
|
48
|
"cdm_production_amaranthaceae","cdm_production_cactaceae",
|
49
|
"cdm_production_campanulaceae","cdm_production_caryophyllales",
|
50
|
"cdm_production_chenopodiaceae","cdm_production_cichorieae",
|
51
|
"cdm_production_corvidae","cdm_production_cyprus",
|
52
|
"cdm_production_dianthus","cdm_production_diptera",
|
53
|
"cdm_production_flora_central_africa","cdm_production_flora_guianas",
|
54
|
"cdm_production_flora_malesiana","cdm_production_flora_malesiana_prospective",
|
55
|
"cdm_production_flore_gabon",
|
56
|
"cdm_production_globis","cdm_production_nyctaginaceae",
|
57
|
"cdm_production_palmae","cdm_production_piB_campylopus_pilot",
|
58
|
"cdm_production_piB_eupolybothrus_pilot","cdm_production_piB_lactarius_pilot",
|
59
|
"cdm_production_piB_loranthaceae","cdm_production_piB_nephrolepis_pilot",
|
60
|
"cdm_production_piB_spiders_pilot","cdm_production_polygonaceae",
|
61
|
"cdm_production_proibiosphere_ants_pilot","cdm_production_proibiosphere_chenopodium_pilot",
|
62
|
"cdm_production_rl_armeria_demo","cdm_production_rl_lumbricidae",
|
63
|
"cdm_production_rl_odonata_demo","cdm_production_rl_standardliste",
|
64
|
"cdm_production_tamaricaceae","cdm_production_vibrant_index"};
|
65
|
|
66
|
static BgbmServer bgbmServer = BgbmServer.TEST;
|
67
|
|
68
|
|
69
|
|
70
|
static String username = "edit";
|
71
|
|
72
|
|
73
|
|
74
|
/**
|
75
|
* @param args
|
76
|
*/
|
77
|
public static void main(String[] args) {
|
78
|
DbSchemaValidation schema = DbSchemaValidation.VALIDATE;
|
79
|
String server = bgbmServer.server;
|
80
|
for (String database : bgbmServer.databases){
|
81
|
boolean result = true;
|
82
|
logger.warn("Update: " + database + " ... ");
|
83
|
ICdmDataSource dataSource = CdmDataSource.NewMySqlInstance(server, database, username, AccountStore.readOrStorePassword(server, database, username, null));
|
84
|
try {
|
85
|
CdmUpdater updater = new CdmUpdater();
|
86
|
result = updater.updateToCurrentVersion(dataSource, DefaultProgressMonitor.NewInstance());
|
87
|
CdmApplicationController appCtr = CdmIoApplicationController.NewInstance(dataSource,schema);
|
88
|
System.out.println(appCtr.getClassificationService().count(Classification.class));
|
89
|
} catch (Exception e) {
|
90
|
result = false;
|
91
|
e.printStackTrace();
|
92
|
}
|
93
|
if(!result ){
|
94
|
logger.warn("Problem");
|
95
|
break;
|
96
|
}
|
97
|
|
98
|
logger.warn("Update: " + database + " ... DONE ");
|
99
|
}
|
100
|
|
101
|
|
102
|
}
|
103
|
|
104
|
private enum BgbmServer{
|
105
|
INTEGRATION (integrationServer, integrationDatabases),
|
106
|
TEST(testServer,testDatabases),
|
107
|
PRODUCTION(productionServer,productionDatabases);
|
108
|
private String server;
|
109
|
private String[] databases;
|
110
|
private BgbmServer(String server, String[] databases){
|
111
|
this.server = server;
|
112
|
this.databases = databases;
|
113
|
}
|
114
|
|
115
|
|
116
|
|
117
|
}
|
118
|
}
|