Project

General

Profile

« Previous | Next » 

Revision a4947270

Added by Andreas Müller over 7 years ago

ref #3658 remove nomenclaturalCode

View differences:

cdm-eflora/src/main/java/eu/etaxonomy/cdm/app/eflora/CdmDestinations.java
1 1
/**
2 2
* Copyright (C) 2007 EDIT
3
* European Distributed Institute of Taxonomy 
3
* European Distributed Institute of Taxonomy
4 4
* http://www.e-taxonomy.eu
5
* 
5
*
6 6
* The contents of this file are subject to the Mozilla Public License Version 1.1
7 7
* See LICENSE.TXT at the top of this package for the full license terms.
8 8
*/
......
22 22
public class CdmDestinations {
23 23
	@SuppressWarnings("unused")
24 24
	private static Logger logger = Logger.getLogger(CdmDestinations.class);
25
	
25

  
26 26
	/**
27 27
	 * Intended to be used for imports
28 28
	 */
......
33 33
		String cdmUserName = "root";
34 34
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
35 35
	}
36
	
36

  
37 37
	public static ICdmDataSource cdm_test_local_mysql(){
38 38
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
39 39
		String cdmServer = "127.0.0.1";
40
		String cdmDB = "cdm_test"; 
40
		String cdmDB = "cdm_test";
41 41
		String cdmUserName = "root";
42 42
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
43 43
	}
......
45 45
	public static ICdmDataSource cdm_test_local_mysql_fdac(){
46 46
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
47 47
		String cdmServer = "127.0.0.1";
48
		String cdmDB = "fdac"; 
48
		String cdmDB = "fdac";
49 49
		String cdmUserName = "edit";
50 50
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
51 51
	}
52
	
52

  
53 53
	public static ICdmDataSource cdm_test_local_mysql_test(){
54 54
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
55 55
		String cdmServer = "127.0.0.1";
56
		String cdmDB = "test"; 
56
		String cdmDB = "test";
57 57
		String cdmUserName = "edit";
58 58
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
59 59
	}
......
61 61
	public static ICdmDataSource cdm_test_local_fdac(){
62 62
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
63 63
		String cdmServer = "127.0.0.1";
64
		String cdmDB = "fdac"; 
64
		String cdmDB = "fdac";
65 65
		String cdmUserName = "root";
66 66
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
67 67
	}
......
74 74
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
75 75
	}
76 76

  
77
	
77

  
78 78
	public static ICdmDataSource cdm_campanulaceae_production(){
79 79
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
80 80
		String cdmServer = "160.45.63.171";
......
82 82
		String cdmUserName = "edit";
83 83
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
84 84
	}
85
	
85

  
86 86
	public static ICdmDataSource cdm_flora_malesiana_preview(){
87 87
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
88 88
		String cdmServer = "160.45.63.175";
......
107 107
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
108 108
	}
109 109

  
110
	
110

  
111 111
	public static ICdmDataSource cdm_flora_guianas_preview(){
112 112
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
113 113
		String cdmServer = "160.45.63.175";
......
123 123
		String cdmUserName = "edit";
124 124
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
125 125
	}
126
	
126

  
127 127
	public static ICdmDataSource cdm_flore_gabon_preview(){
128 128
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
129 129
		String cdmServer = "160.45.63.175";
......
131 131
		String cdmUserName = "edit";
132 132
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
133 133
	}
134
	
134

  
135 135
	public static ICdmDataSource cdm_flore_gabon_production(){
136 136
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
137 137
		String cdmServer = "160.45.63.171";
......
140 140
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
141 141
	}
142 142

  
143
	
143

  
144 144
	public static ICdmDataSource cdm_flora_central_africa_local(){
145 145
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
146 146
		String cdmServer = "localhost";
......
148 148
		String cdmUserName = "edit";
149 149
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
150 150
	}
151
	
151

  
152 152
	public static ICdmDataSource cdm_flora_central_africa_preview(){
153 153
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
154 154
		String cdmServer = "160.45.63.175";
......
156 156
		String cdmUserName = "edit";
157 157
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
158 158
	}
159
	
159

  
160 160
	public static ICdmDataSource cdm_flora_central_africa_production(){
161 161
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
162 162
		String cdmServer = "160.45.63.171";
......
164 164
		String cdmUserName = "edit";
165 165
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
166 166
	}
167
	
167

  
168 168
	public static ICdmDataSource cdm_portal_test_localhost(){
169 169
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
170 170
		String cdmServer = "127.0.0.1";
......
172 172
		String cdmUserName = "edit";
173 173
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
174 174
	}
175
	
175

  
176 176
	public static ICdmDataSource cdm_portal_test_localhost2(){
177 177
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
178 178
		String cdmServer = "127.0.0.1";
......
180 180
		String cdmUserName = "edit";
181 181
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
182 182
	}
183
	
183

  
184 184
	public static ICdmDataSource cdm_local_postgres_CdmTest(){
185 185
		DatabaseTypeEnum dbType = DatabaseTypeEnum.PostgreSQL;
186 186
		String cdmServer = "127.0.0.1";
......
189 189
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
190 190
	}
191 191

  
192
	
193
	
192

  
193

  
194 194
	public static ICdmDataSource NULL(){
195 195
		return null;
196 196
	}
197
	
198
	
197

  
198

  
199 199
	public static ICdmDataSource localH2(){
200 200
		return CdmDataSource.NewH2EmbeddedInstance("cdm", "sa", "");
201 201
	}
202
	
202

  
203 203
	public static ICdmDataSource localH2(String database, String username, String filePath){
204
		return CdmDataSource.NewH2EmbeddedInstance(database, "sa", "", filePath, null);
204
		return CdmDataSource.NewH2EmbeddedInstance(database, "sa", "", filePath);
205 205
	}
206
	
206

  
207 207
	public static ICdmDataSource localH2Salvador(){
208 208
		return CdmDataSource.NewH2EmbeddedInstance("salvador", "sa", "");
209 209
	}
210
	
210

  
211 211
	public static ICdmDataSource localH2Diptera(){
212 212
		return CdmDataSource.NewH2EmbeddedInstance("diptera", "sa", "");
213 213
	}
214
	
215
	
214

  
215

  
216 216
	public static ICdmDataSource localH2Cichorieae(){
217 217
		return CdmDataSource.NewH2EmbeddedInstance("cichorieae", "sa", "");
218 218
	}
219
	
219

  
220 220
	public static ICdmDataSource localH2Palmae(){
221 221
		return CdmDataSource.NewH2EmbeddedInstance("palmae", "sa", "");
222 222
	}
223
	
223

  
224 224
	public static ICdmDataSource localH2EuroMed(){
225 225
		return CdmDataSource.NewH2EmbeddedInstance("euroMed", "sa", "");
226 226
	}
227
	
227

  
228 228
	public static ICdmDataSource localH2Erms(){
229 229
		return CdmDataSource.NewH2EmbeddedInstance("erms", "sa", "");
230 230
	}
231
	
231

  
232 232
	public static ICdmDataSource localH2_viola(){
233 233
		return CdmDataSource.NewH2EmbeddedInstance("testViola", "sa", "");
234 234
	}
235
	
235

  
236 236
	public static ICdmDataSource localH2_LIAS(){
237 237
		return CdmDataSource.NewH2EmbeddedInstance("testLIAS", "sa", "");
238 238
	}
239
	
239

  
240 240
	public static ICdmDataSource localH2_Erythroneura(){
241 241
		return CdmDataSource.NewH2EmbeddedInstance("testErythroneura", "sa", "");
242 242
	}
243
	
243

  
244 244
	public static ICdmDataSource localH2_Cicad(){
245 245
		return CdmDataSource.NewH2EmbeddedInstance("testCicad", "sa", "");
246 246
	}
247
	
247

  
248 248
	public static ICdmDataSource localH2_ValRosandraFRIDAKey(){
249 249
		return CdmDataSource.NewH2EmbeddedInstance("testValRosandraFRIDAKey", "sa", "");
250 250
	}
251
	
251

  
252 252
	public static ICdmDataSource localH2_FreshwaterAquaticInsects(){
253 253
		return CdmDataSource.NewH2EmbeddedInstance("testFreshwaterAquaticInsects", "sa", "");
254 254
	}
255
	
255

  
256 256
	public static ICdmDataSource cdm_portal_test_pollux(){
257 257
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
258 258
		String cdmServer = "192.168.2.11";
......
264 264
	public static ICdmDataSource cdm_algaterra_preview(){
265 265
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
266 266
		String cdmServer = "160.45.63.201";
267
		String cdmDB = "cdm_edit_algaterra"; 
267
		String cdmDB = "cdm_edit_algaterra";
268 268
		String cdmUserName = "edit";
269 269
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
270 270
	}
271
	
271

  
272 272
	public static ICdmDataSource cdm_edit_cichorieae_PG(){
273 273
		DatabaseTypeEnum dbType = DatabaseTypeEnum.PostgreSQL;
274 274
		String cdmServer = "127.0.0.1";
275
		String cdmDB = "cdm_edit_cichorieae_a"; 
275
		String cdmDB = "cdm_edit_cichorieae_a";
276 276
		String cdmUserName = "edit";
277 277
		int port = 15432;
278 278
		return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
......
281 281
	public static ICdmDataSource cdm_cichorieae_preview(){
282 282
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
283 283
		String cdmServer = "160.45.63.201";
284
		String cdmDB = "cdm_edit_cichorieae"; 
284
		String cdmDB = "cdm_edit_cichorieae";
285 285
		String cdmUserName = "edit";
286 286
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
287 287
	}
288
	
288

  
289 289
	public static ICdmDataSource cdm_production_cichorieae(){
290 290
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
291 291
		String cdmServer = "160.45.63.151";
292 292
//		String cdmServer = "127.0.0.1";
293
		String cdmDB = "cdm_production_cichorieae"; 
293
		String cdmDB = "cdm_production_cichorieae";
294 294
		String cdmUserName = "edit";
295 295
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
296 296
	}
297
	
297

  
298 298
	public static ICdmDataSource cdm_production_palmae(){
299 299
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
300 300
		String cdmServer = "160.45.63.151";
301
		String cdmDB = "cdm_production_palmae"; 
301
		String cdmDB = "cdm_production_palmae";
302 302
		String cdmUserName = "edit";
303 303
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
304 304
	}
305
	
306
	
305

  
306

  
307 307
	public static ICdmDataSource cdm_production_diptera(){
308 308
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
309 309
		String cdmServer = "160.45.63.151";
310
		String cdmDB = "cdm_production_diptera"; 
310
		String cdmDB = "cdm_production_diptera";
311 311
		String cdmUserName = "edit";
312 312
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
313 313
	}
314
	
314

  
315 315
	public static ICdmDataSource local_cdm_edit_cichorieae_a(){
316 316
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
317 317
		String cdmServer = "127.0.0.1";
318
		String cdmDB = "cdm_edit_cichorieae_a"; 
318
		String cdmDB = "cdm_edit_cichorieae_a";
319 319
		String cdmUserName = "edit";
320 320
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
321 321
	}
322
	
322

  
323 323
	public static ICdmDataSource local_cdm_edit_cichorieae_b(){
324 324
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
325 325
		String cdmServer = "127.0.0.1";
326
		String cdmDB = "cdm_edit_cichorieae_b"; 
326
		String cdmDB = "cdm_edit_cichorieae_b";
327 327
		String cdmUserName = "edit";
328 328
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
329 329
	}
......
339 339
	public static ICdmDataSource cdm_edit_diptera_preview_B(){
340 340
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
341 341
		String cdmServer = "127.0.0.1";
342
		String cdmDB = "cdm_edit_diptera_b"; 
342
		String cdmDB = "cdm_edit_diptera_b";
343 343
		String cdmUserName = "edit";
344 344
		int port = 13306;
345 345
		return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
346 346
	}
347
	
347

  
348 348
	public static ICdmDataSource cdm_edit_cichorieae_preview(){
349 349
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
350 350
		String cdmServer = "127.0.0.1";
351
		String cdmDB = "cdm_edit_cichorieae"; 
351
		String cdmDB = "cdm_edit_cichorieae";
352 352
		String cdmUserName = "edit";
353 353
		int port = 13306;
354 354
		return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
......
357 357
	public static ICdmDataSource cdm_edit_palmae_preview(){
358 358
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
359 359
		String cdmServer = "127.0.0.1";
360
		String cdmDB = "cdm_edit_palmae"; 
360
		String cdmDB = "cdm_edit_palmae";
361 361
		String cdmUserName = "edit";
362 362
		int port = 13306;
363 363
		return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
364
	}		
365
	
364
	}
365

  
366 366
	public static ICdmDataSource cdm_edit_salvador(){
367 367
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
368 368
		String cdmServer = "192.168.2.10";
369
		String cdmDB = "cdm_edit_salvador"; 
369
		String cdmDB = "cdm_edit_salvador";
370 370
		String cdmUserName = "edit";
371 371
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
372 372
	}
373
	
373

  
374 374
	public static ICdmDataSource cdm_import_salvador() {
375 375
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
376 376
		String cdmServer = "192.168.2.10";
377
		String cdmDB = "cdm_import_salvador"; 
377
		String cdmDB = "cdm_import_salvador";
378 378
		String cdmUserName = "edit";
379 379
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
380 380
	}
381
	
381

  
382 382
	public static ICdmDataSource cdm_salvador_production() {
383 383
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
384 384
		String cdmServer = "192.168.2.10";
385
		String cdmDB = "salvador_cdm"; 
385
		String cdmDB = "salvador_cdm";
386 386
		String cdmUserName = "salvador";
387 387
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
388 388
	}
389
	
390
	
389

  
390

  
391 391
//	public static ICdmDataSource LAPTOP_HP(){
392 392
//		DatabaseTypeEnum dbType = DatabaseTypeEnum.SqlServer2005;
393 393
//		String cdmServer = "LAPTOPHP";
394
//		String cdmDB = "cdmTest"; 
394
//		String cdmDB = "cdmTest";
395 395
//		String cdmUserName = "edit";
396 396
//		return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);
397 397
//	}
398
	
399
	
400 398

  
401
	 
399

  
400

  
401

  
402 402
	/**
403 403
	 * initializes source
404 404
	 * TODO only supports MySQL and PostgreSQL
405
	 * 
405
	 *
406 406
	 * @param dbType
407 407
	 * @param cdmServer
408 408
	 * @param cdmDB
......
416 416
		pwd = AccountStore.readOrStorePassword(cdmServer, cdmDB, cdmUserName, pwd);
417 417
		ICdmDataSource destination;
418 418
		if(dbType.equals(DatabaseTypeEnum.MySQL)){
419
			destination = CdmDataSource.NewMySqlInstance(cdmServer, cdmDB, port, cdmUserName, pwd, null);			
419
			destination = CdmDataSource.NewMySqlInstance(cdmServer, cdmDB, port, cdmUserName, pwd);
420 420
		} else if(dbType.equals(DatabaseTypeEnum.PostgreSQL)){
421
			destination = CdmDataSource.NewPostgreSQLInstance(cdmServer, cdmDB, port, cdmUserName, pwd, null);			
421
			destination = CdmDataSource.NewPostgreSQLInstance(cdmServer, cdmDB, port, cdmUserName, pwd);
422 422
		} else {
423 423
			//TODO others
424 424
			throw new RuntimeException("Unsupported DatabaseType");
......
429 429

  
430 430

  
431 431
	/**
432
	 * Accepts a string array and tries to find a method returning an ICdmDataSource with 
432
	 * Accepts a string array and tries to find a method returning an ICdmDataSource with
433 433
	 * the name of the given first string in the array
434
	 * 
434
	 *
435 435
	 * @param args
436 436
	 * @return
437 437
	 */
438 438
	public static ICdmDataSource chooseDestination(String[] args) {
439
		if(args == null)
440
			return null;
441
		
442
		if(args.length != 1)
443
			return null;
444
		
439
		if(args == null) {
440
            return null;
441
        }
442

  
443
		if(args.length != 1) {
444
            return null;
445
        }
446

  
445 447
		String possibleDestination = args[0];
446
		
448

  
447 449
		Method[] methods = CdmDestinations.class.getMethods();
448
		
450

  
449 451
		for (Method method : methods){
450 452
			if(method.getName().equals(possibleDestination)){
451 453
				try {

Also available in: Unified diff