Project

General

Profile

Download (30.6 KB) Statistics
| Branch: | Revision:
1
/**
2
* Copyright (C) 2007 EDIT
3
* European Distributed Institute of Taxonomy
4
* http://www.e-taxonomy.eu
5
*
6
* The contents of this file are subject to the Mozilla Public License Version 1.1
7
* See LICENSE.TXT at the top of this package for the full license terms.
8
*/
9

    
10
package eu.etaxonomy.cdm.app.common;
11

    
12
import java.lang.reflect.Method;
13

    
14
import org.apache.log4j.Logger;
15

    
16
import eu.etaxonomy.cdm.config.AccountStore;
17
import eu.etaxonomy.cdm.database.CdmDataSource;
18
import eu.etaxonomy.cdm.database.DatabaseTypeEnum;
19
import eu.etaxonomy.cdm.database.ICdmDataSource;
20

    
21
public class CdmDestinations {
22

    
23
	@SuppressWarnings("unused")
24
	private static Logger logger = Logger.getLogger(CdmDestinations.class);
25

    
26
	public static ICdmDataSource cdm_local_redlist_animalia(){
27
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
28
		String cdmServer = "localhost";
29
		String cdmDB = "cdm_bfn_imports_animalia";
30
		String cdmUserName = "edit";
31
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
32
	}
33

    
34
    public static ICdmDataSource cdm_redlist_animalia_production(){
35
        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
36
        String cdmServer = "160.45.63.171";
37
        String cdmDB = "cdm_production_rl_animalia";
38
        String cdmUserName = "edit";
39
        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
40
    }
41

    
42
    public static ICdmDataSource cdm_additivity_ontology(){
43
        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
44
        String cdmServer = "160.45.63.171";
45
        String cdmDB = "cdm_production_additivity_ontology";
46
        String cdmUserName = "edit";
47
        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
48
    }
49

    
50
    public static ICdmDataSource cdm_redlist_animalia_production_final(){
51
        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
52
        String cdmServer = "160.45.63.171";
53
        String cdmDB = "cdm_production_rl_animalia_final";
54
        String cdmUserName = "edit";
55
        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
56
    }
57

    
58
	public static ICdmDataSource cdm_local_redlist_plant(){
59
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
60
		String cdmServer = "localhost";
61
		String cdmDB = "cdm_bfn_imports_plants";
62
		String cdmUserName = "edit";
63
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
64
	}
65

    
66
	public static ICdmDataSource cdm_local_testDB(){
67
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
68
		String cdmServer = "localhost";
69
		String cdmDB = "testDB";
70
		String cdmUserName = "root";
71
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
72
	}
73

    
74
    public static ICdmDataSource cdm_local_test_mysql(){
75
        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
76
        String cdmServer = "127.0.0.1";
77
        String cdmDB = "test";
78
        String cdmUserName = "root";
79
        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
80
    }
81

    
82
    public static ICdmDataSource cdm_local_cdmtest_mysql(){
83
        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
84
        String cdmServer = "127.0.0.1";
85
        String cdmDB = "cdm_test";
86
        String cdmUserName = "root";
87
        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
88
    }
89

    
90
	public static ICdmDataSource cdm_local_redlist_gefaesspflanzen(){
91
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
92
		String cdmServer = "127.0.0.1";
93
		String cdmDB = "rl2020_gefaesspflanzen";
94
		String cdmUserName = "root";
95
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
96
	}
97

    
98

    
99
	public static ICdmDataSource cdm_local_test_mysql_moose(){
100
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
101
		String cdmServer = "127.0.0.1";
102
		String cdmDB = "moose";
103
		String cdmUserName = "edit";
104
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
105
	}
106

    
107
	public static ICdmDataSource cdm_local_test_mysql_standardliste(){
108
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
109
		String cdmServer = "127.0.0.1";
110
		String cdmDB = "standardliste";
111
		String cdmUserName = "root";
112
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
113
	}
114

    
115

    
116
	public static ICdmDataSource cdm_local_test_mysql_dwca(){
117
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
118
		String cdmServer = "127.0.0.1";
119
		String cdmDB = "dwca";
120
		String cdmUserName = "edit";
121
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
122
	}
123

    
124

    
125
	public static ICdmDataSource cdm_local_mysql_fdac(){
126
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
127
		String cdmServer = "127.0.0.1";
128
		String cdmDB = "fdac";
129
		String cdmUserName = "edit";
130
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
131
	}
132

    
133
	public static ICdmDataSource cdm_test_local_mysql_test(){
134
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
135
		String cdmServer = "127.0.0.1";
136
		String cdmDB = "test";
137
		String cdmUserName = "edit";     //root on pesiimport2
138
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
139
	}
140

    
141
    public static ICdmDataSource cdm_local_test_bogota(){
142
        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
143
        String cdmServer = "127.0.0.1";
144
        String cdmDB = "cdm_local_flora_bogota";
145
        String cdmUserName = "edit";     //root on pesiimport2
146
        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
147
    }
148

    
149
    public static ICdmDataSource cdm_local_caryo_aizoaceae(){
150
        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
151
        String cdmServer = "127.0.0.1";
152
        String cdmDB = "cdm_caryo_aizoaceae";
153
        String cdmUserName = "edit";     //root on pesiimport2
154
        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
155
    }
156

    
157
    public static ICdmDataSource cdm_local_mysql_pesi_euromed(){
158
        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
159
        String cdmServer = "127.0.0.1";
160
        String cdmDB = "cdm_pesi_euromed";
161
        String cdmUserName = "edit";
162
        int port = 3306;
163
        return CdmDestinations.makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
164
    }
165

    
166
    public static ICdmDataSource cdm_local_mysql_tmpTest(){
167
        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
168
        String cdmServer = "127.0.0.1";
169
        String cdmDB = "tmpTest";
170
        String cdmUserName = "edit";
171
        int port = 3306;
172
        return CdmDestinations.makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
173
    }
174

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

    
183
	public static ICdmDataSource cdm_local_euromed2(){
184
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
185
		String cdmServer = "127.0.0.1";
186
		String cdmDB = "euroMed2";
187
		String cdmUserName = "edit";
188
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
189
	}
190
    public static ICdmDataSource cdm_local_euromed_caucasus(){
191
        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
192
        String cdmServer = "127.0.0.1";
193
        String cdmDB = "euromed_caucasus";
194
        String cdmUserName = "edit";
195
        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
196
    }
197

    
198

    
199

    
200
	public static ICdmDataSource cdm_local_test_euromed3(){
201
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
202
		String cdmServer = "127.0.0.1";
203
		String cdmDB = "euroMed3";
204
		String cdmUserName = "root";
205
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
206
	}
207

    
208
    public static ICdmDataSource cdm_test_col(){
209
        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
210
        String cdmServer = "160.45.63.175";
211
        String cdmDB = "cdm_col";
212
        String cdmUserName = "edit";
213
        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
214
    }
215

    
216
    public static ICdmDataSource cdm_test_col2(){
217
        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
218
        String cdmServer = "160.45.63.175";
219
        String cdmDB = "cdm_col2";
220
        String cdmUserName = "edit";
221
        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
222
    }
223

    
224
    public static ICdmDataSource cdm_local_col(){
225
        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
226
        String cdmServer = "127.0.0.1";
227
        String cdmDB = "col_test";
228
        String cdmUserName = "edit";
229
        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
230
    }
231

    
232
    public static ICdmDataSource cdm_local_col2(){
233
        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
234
        String cdmServer = "127.0.0.1";
235
        String cdmDB = "col_test2";
236
        String cdmUserName = "edit";
237
        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
238
    }
239

    
240

    
241
	public static ICdmDataSource cdm_local_EDITImport(){
242
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
243
		String cdmServer = "127.0.0.1";
244
		String cdmDB = "EDITImport";
245
		String cdmUserName = "edit";     //root on pesiimport2
246
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
247
	}
248

    
249
	public static ICdmDataSource cdm_test_euroMed(){
250
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
251
		String cdmServer = "160.45.63.175";
252
		String cdmDB = "cdm_test_euromed";
253
		String cdmUserName = "edit";
254
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
255
	}
256

    
257
    public static ICdmDataSource cdm_production_euromed(){
258
        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
259
        String cdmServer = "160.45.63.171";
260
        String cdmDB = "cdm_production_euromed";
261
        String cdmUserName = "edit";
262
        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
263
    }
264

    
265
    public static ICdmDataSource cdm_production_euromed_caucasus(){
266
        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
267
        String cdmServer = "160.45.63.171";
268
        String cdmDB = "cdm_production_euromed_caucasus";
269
        String cdmUserName = "edit";
270
        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
271
    }
272

    
273
	public static ICdmDataSource cdm_test_corvidae(){
274
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
275
		String cdmServer = "160.45.63.175";
276
		String cdmDB = "cdm_corvidae";
277
		String cdmUserName = "edit";
278
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
279
	}
280

    
281
   public static ICdmDataSource cdm_test_redlist_mammalia(){
282
        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
283
        String cdmServer = "160.45.63.175";
284
        String cdmDB = "cdm_rl_mammalia";
285
        String cdmUserName = "edit";
286
        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
287
    }
288

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

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

    
305
	public static ICdmDataSource cdm_test_redlist_standardlist(){
306
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
307
		String cdmServer = "160.45.63.175";
308
		String cdmDB = "cdm_mt_standardliste";
309
		String cdmUserName = "edit";
310
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
311
	}
312

    
313
	public static ICdmDataSource cdm_test_redlist_germanSL(){
314
        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
315
        String cdmServer = "160.45.63.175";
316
        String cdmDB = "cdm_rl_german_sl";
317
        String cdmUserName = "edit";
318
        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
319
    }
320

    
321
    public static ICdmDataSource cdm_production_germanSL(){
322
        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
323
        String cdmServer = "160.45.63.171";
324
        String cdmDB = "cdm_production_rl_german_sl";
325
        String cdmUserName = "edit";
326
        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
327
    }
328

    
329

    
330
	public static ICdmDataSource cdm_test_cyprus(){
331
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
332
		String cdmServer = "160.45.63.175";
333
		String cdmDB = "cdm_cyprus";
334
		String cdmUserName = "edit";
335
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
336
	}
337

    
338
    public static ICdmDataSource cdm_test_bupleurum(){
339
        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
340
        String cdmServer = "160.45.63.175";
341
        String cdmDB = "cdm_test_bupleurum";
342
        String cdmUserName = "edit";
343
        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
344
    }
345

    
346
	public static ICdmDataSource cdm_production_cyprus(){
347
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
348
		String cdmServer = "160.45.63.171";
349
		String cdmDB = "cdm_production_cyprus";
350
		String cdmUserName = "edit";
351
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
352
	}
353

    
354
    public static ICdmDataSource cdm_phycobank_production(){
355
        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
356
        String cdmServer = "160.45.63.171";
357
        String cdmDB = "cdm_production_phycobank";
358
        String cdmUserName = "edit";
359
        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
360
    }
361

    
362
    public static ICdmDataSource cdm_production_flora_cuba(){
363
        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
364
        String cdmServer = "160.45.63.171";
365
        String cdmDB = "cdm_production_flora_cuba";
366
        String cdmUserName = "edit";
367
        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
368
    }
369

    
370
    public static ICdmDataSource cdm_production_greece_checklist(){
371
        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
372
        String cdmServer = "160.45.63.171";
373
        String cdmDB = "cdm_production_flora_greece";
374
        String cdmUserName = "edit";
375
        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
376
    }
377

    
378
    public static ICdmDataSource cdm_production_mexico_rubiaceae(){
379
        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
380
        String cdmServer = "160.45.63.171";
381
        String cdmDB = "cdm_production_rubiaceae_mexico";
382
        String cdmUserName = "edit";
383
        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
384
    }
385

    
386
    public static ICdmDataSource cdm_production_bogota(){
387
        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
388
        String cdmServer = "160.45.63.171";
389
        String cdmDB = "cdm_production_flora_bogota";
390
        String cdmUserName = "edit";
391
        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
392
    }
393

    
394
	public static ICdmDataSource cdm_production_tunnel_cyprus(){
395
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
396
		String cdmServer = "127.0.0.1";
397
		int port = 13306;
398
		String cdmDB = "cdm_production_cyprus";
399
		String cdmUserName = "edit";
400
		return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
401
	}
402

    
403
	public static ICdmDataSource cdm_production_campanulaceae(){
404
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
405
		String cdmServer = "160.45.63.171";
406
		String cdmDB = "cdm_production_campanulaceae";
407
		String cdmUserName = "edit";
408
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
409
	}
410

    
411
	public static ICdmDataSource cdm_local_portal_test(){
412
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
413
		String cdmServer = "127.0.0.1";
414
		String cdmDB = "cdm_portal_test";
415
		String cdmUserName = "edit";
416
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
417
	}
418

    
419
	public static ICdmDataSource cdm_local_portal_test2(){
420
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
421
		String cdmServer = "127.0.0.1";
422
		String cdmDB = "cdm_portal_test2";
423
		String cdmUserName = "edit";
424
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
425
	}
426

    
427
	public static ICdmDataSource cdm_local_cichorieae(){
428
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
429
		String cdmServer = "127.0.0.1";
430
		String cdmDB = "cdm_edit_cichorieae";
431
		String cdmUserName = "edit";
432
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
433
	}
434

    
435

    
436

    
437
	public static ICdmDataSource cdm_local_palmae(){
438
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
439
		String cdmServer = "127.0.0.1";
440
		String cdmDB = "cdm_edit_caryo";
441
		String cdmUserName = "edit";
442
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
443
	}
444

    
445
    public static ICdmDataSource cdm_local_cuba(){
446
        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
447
        String cdmServer = "127.0.0.1";
448
        String cdmDB = "cdm_local_flora_cuba";
449
        String cdmUserName = "edit";
450
        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
451
    }
452

    
453
	public static ICdmDataSource cdm_local_caryo(){
454
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
455
		String cdmServer = "127.0.0.1";
456
		String cdmDB = "cdm_local_caryophyllales";
457
		String cdmUserName = "root";
458
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
459
	}
460

    
461
	public static ICdmDataSource cdm_local_algaterranew(){
462
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
463
		String cdmServer = "127.0.0.1";
464
		String cdmDB = "cdm_production_algaterranew";
465
		String cdmUserName = "root";
466
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
467
	}
468

    
469
	public static ICdmDataSource cdm_test_globis(){
470
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
471
		String cdmServer = "160.45.63.175";
472
		String cdmDB = "cdm_edit_globis";
473
		String cdmUserName = "edit";
474
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
475
	}
476

    
477
    public static ICdmDataSource cdm_local_edaphobase(){
478
        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
479
        String cdmServer = "127.0.0.1";
480
        String cdmDB = "edaphobase";
481
        String cdmUserName = "edit";
482
        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
483
    }
484

    
485
    public static ICdmDataSource cdm_postgres_edaphobase(){
486
        DatabaseTypeEnum dbType = DatabaseTypeEnum.PostgreSQL;
487
        String cdmServer = "130.133.70.26";
488
        String cdmDB = "cdm_edaphobase";
489
        String cdmUserName = "edaphobase";
490
        int port = 5433;
491
        return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
492
    }
493

    
494
    public static ICdmDataSource cdm_test_postgres_edaphobase(){
495
        DatabaseTypeEnum dbType = DatabaseTypeEnum.PostgreSQL;
496
        String cdmServer = "160.45.63.175";
497
        String cdmDB = "cdm_edaphobase";
498
        String cdmUserName = "edaphobase";
499
        int port = 5432;
500
        return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
501
    }
502

    
503
    public static ICdmDataSource cdm_test_postgres__ssh_edaphobase(){
504
        DatabaseTypeEnum dbType = DatabaseTypeEnum.PostgreSQL;
505
        String cdmServer = "localhost";
506
        String cdmDB = "cdm_edaphobase";
507
        String cdmUserName = "edaphobase";
508
        int port = 13306;
509
        return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
510
    }
511

    
512
    public static ICdmDataSource cdm_local_caryo_spp(){
513
        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
514
        String cdmServer = "127.0.0.1";
515
        String cdmDB = "cdm_caryo_spp";
516
        String cdmUserName = "edit";
517
        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
518
    }
519

    
520
    public static ICdmDataSource cdm_local_caryo_spp2(){
521
        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
522
        String cdmServer = "127.0.0.1";
523
        String cdmDB = "cdm_caryo_spp2";
524
        String cdmUserName = "edit";
525
        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
526
    }
527

    
528
	public static ICdmDataSource cdm_production_globis(){
529
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
530
		String cdmServer = "160.45.63.171";
531
		String cdmDB = "cdm_production_globis";
532
		String cdmUserName = "edit";
533
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
534
	}
535

    
536
	public static ICdmDataSource cdm_local_globis(){
537
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
538
		String cdmServer = "127.0.0.1";
539
		String cdmDB = "cdm_globis";
540
		String cdmUserName = "edit";
541
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
542
	}
543

    
544
	public static ICdmDataSource cdm_local_postgres_CdmTest(){
545
		DatabaseTypeEnum dbType = DatabaseTypeEnum.PostgreSQL;
546
		String cdmServer = "127.0.0.1";
547
		String cdmDB = "CdmTest";
548
		String cdmUserName = "edit";
549
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
550
	}
551

    
552

    
553
	public static ICdmDataSource localH2(){
554
		return CdmDataSource.NewH2EmbeddedInstance("cdm", "sa", "");
555
	}
556

    
557
	public static ICdmDataSource localH2Edapho(){
558
        return CdmDataSource.NewH2EmbeddedInstance("cdmEdapho", "sa", "");
559
    }
560

    
561
	public static ICdmDataSource localH2Salvador(){
562
		return CdmDataSource.NewH2EmbeddedInstance("salvador", "sa", "");
563
	}
564

    
565
	public static ICdmDataSource localH2Armeria(){
566
		return CdmDataSource.NewH2EmbeddedInstance("armeria", "sa", "");
567
	}
568

    
569
	public static ICdmDataSource localH2Standardliste(){
570
		return CdmDataSource.NewH2EmbeddedInstance("standardliste", "sa", "");
571
	}
572

    
573
	public static ICdmDataSource localH2Cichorieae(){
574
		return CdmDataSource.NewH2EmbeddedInstance("cichorieae", "sa", "");
575
	}
576

    
577
	public static ICdmDataSource localH2Palmae(){
578
		return CdmDataSource.NewH2EmbeddedInstance("palmae", "sa", "");
579
	}
580

    
581
	public static ICdmDataSource localH2EuroMed(){
582
		return CdmDataSource.NewH2EmbeddedInstance("euroMed", "sa", "");
583
	}
584

    
585
	public static ICdmDataSource localH2Erms(){
586
		return CdmDataSource.NewH2EmbeddedInstance("erms", "sa", "");
587
	}
588

    
589

    
590
    public static ICdmDataSource cdm_test_test1(){
591
        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
592
        String cdmServer = "160.45.63.175";
593
        String cdmDB = "cdm_test1";
594
        String cdmUserName = "edit";
595
        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
596
	}
597
    public static ICdmDataSource cdm_test_test2(){
598
        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
599
        String cdmServer = "160.45.63.175";
600
        String cdmDB = "cdm_test2";
601
        String cdmUserName = "edit";
602
        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
603
    }
604
    public static ICdmDataSource cdm_test_test3(){
605
        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
606
        String cdmServer = "160.45.63.175";
607
        String cdmDB = "cdm_test3";
608
        String cdmUserName = "edit";
609
        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
610
    }
611

    
612
    public static ICdmDataSource cdm_test_phycobank(){
613
        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
614
        String cdmServer = "160.45.63.175";
615
        String cdmDB = "cdm_phycobank";
616
        String cdmUserName = "edit";
617
        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
618
    }
619

    
620
	public static ICdmDataSource cdm_test_algaterra(){
621
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
622
		String cdmServer = "160.45.63.175";
623
		String cdmDB = "cdm_edit_algaterra";
624
		String cdmUserName = "edit";
625
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
626
	}
627

    
628
	public static ICdmDataSource cdm_algaterra_production(){
629
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
630
		String cdmServer = "160.45.63.171";
631
		String cdmDB = "cdm_production_algaterra";
632
		String cdmUserName = "edit";
633
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
634
	}
635

    
636
    public static ICdmDataSource cdm_test_salvador(){
637
        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
638
        String cdmServer = "160.45.63.175";
639
        String cdmDB = "cdm_salvador";
640
        String cdmUserName = "edit";
641
        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
642
    }
643

    
644
    public static ICdmDataSource cdm_production_salvador(){
645
        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
646
        String cdmServer = "160.45.63.171";
647
        String cdmDB = "cdm_production_salvador";
648
        String cdmUserName = "edit";
649
        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
650
    }
651

    
652
	public static ICdmDataSource cdm_test_cichorieae(){
653
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
654
		String cdmServer = "160.45.63.175";
655
		String cdmDB = "cdm_edit_cichorieae";
656
		String cdmUserName = "edit";
657
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
658
	}
659

    
660
	public static ICdmDataSource cdm_test_caryo_spp(){
661
        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
662
        String cdmServer = "160.45.63.175";
663
        String cdmDB = "cdm_caryo_spp";
664
        String cdmUserName = "edit";
665
        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
666
    }
667

    
668
	public static ICdmDataSource cdm_production_cichorieae(){
669
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
670
		String cdmServer = "160.45.63.171";
671
		String cdmDB = "cdm_production_cichorieae";
672
		String cdmUserName = "edit";
673
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
674
	}
675

    
676
	public static ICdmDataSource cdm_production_palmae(){
677
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
678
		String cdmServer = "160.45.63.171";
679
		String cdmDB = "cdm_production_palmae";
680
		String cdmUserName = "edit";
681
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
682
	}
683

    
684
	public static ICdmDataSource cdm_production_flora_deutschland(){
685
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
686
		String cdmServer = "160.45.63.171";
687
		String cdmDB = "cdm_production_rl_standardliste";
688
		String cdmUserName = "edit";
689
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
690
	}
691

    
692
	public static ICdmDataSource cdm_production_caryophyllales(){
693
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
694
		String cdmServer = "160.45.63.171";
695
		String cdmDB = "cdm_production_caryophyllales";
696
		String cdmUserName = "edit";
697
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
698
	}
699

    
700
	public static ICdmDataSource cdm_production_caryophyllales_spp(){
701
        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
702
        String cdmServer = "160.45.63.171";
703
        String cdmDB = "cdm_production_caryophyllales_spp";
704
        String cdmUserName = "edit";
705
        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
706
    }
707

    
708
	public static ICdmDataSource cdm_production_caryophyllales_nepenthaceae(){
709
        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
710
        String cdmServer = "160.45.63.171";
711
        String cdmDB = "cdm_production_caryo_nepenthaceae";
712
        String cdmUserName = "edit";
713
        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
714
    }
715

    
716
	public static ICdmDataSource cdm_local_caryophyllales_nepenthaceae(){
717
        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
718
        String cdmServer = "127.0.0.1";
719
        String cdmDB = "cdm_local_caryo_nepenthaceae";
720
        String cdmUserName = "root";
721
        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
722
    }
723

    
724
	public static ICdmDataSource cdm_production_redlist_gefaesspflanzen(){
725
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
726
		String cdmServer = "160.45.63.171";
727
		String cdmDB = "cdm_production_rl_plantae";
728
		String cdmUserName = "edit";
729
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
730
	}
731

    
732
    public static ICdmDataSource cdm_production_edaphobase(){
733
        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
734
        String cdmServer = "160.45.63.171";
735
        String cdmDB = "cdm_production_edaphobase";
736
        String cdmUserName = "edit";
737
        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
738
    }
739

    
740
	public static ICdmDataSource cdm_production_piB(String database){
741
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
742
		String cdmServer = "160.45.63.171";
743
		String cdmDB = "cdm_production_" + database + "_pilot";
744
		String cdmUserName = "edit";
745
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
746
	}
747

    
748
	public static ICdmDataSource cdm_local_piB(String database){
749
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
750
		String cdmServer = "127.0.0.1";
751
		String cdmDB = "piB_" + database;
752
		String cdmUserName = "root";
753
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
754
	}
755

    
756
   public static ICdmDataSource cdm_local_proibiosphere_chenopodium() {
757
        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
758
        String cdmServer = "localhost";
759
        String cdmDB = "cdm_production_proibiosphere_chenopodium_pilot";
760
        String cdmUserName = "root";
761
        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
762
   }
763

    
764
   public static ICdmDataSource cdm_local_proibiosphere_spiders() {
765
       DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
766
       String cdmServer = "localhost";
767
       String cdmDB = "cdm_production_proibiosphere_spiders_pilot";
768
       String cdmUserName = "root";
769
       return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
770
   }
771

    
772
   public static ICdmDataSource cdm_test_pesi_fauna_europaea(){
773
       DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
774
       String cdmServer = "160.45.63.175";
775
       String cdmDB = "cdm_pesi_fauna_europaea";
776
       String cdmUserName = "edit";
777
       return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
778
   }
779

    
780

    
781

    
782
	/**
783
	 * initializes source
784
	 * TODO only supports MySQL and PostgreSQL
785
	 *
786
	 * @param dbType
787
	 * @param cdmServer
788
	 * @param cdmDB
789
	 * @param port
790
	 * @param cdmUserName
791
	 * @param pwd
792
	 * @return
793
	 */
794
	public static ICdmDataSource makeDestination(DatabaseTypeEnum dbType, String cdmServer, String cdmDB, int port, String cdmUserName, String pwd ){
795
		//establish connection
796
		pwd = AccountStore.readOrStorePassword(cdmServer, cdmDB, cdmUserName, pwd);
797
		ICdmDataSource destination;
798
		if(dbType.equals(DatabaseTypeEnum.MySQL)){
799
			destination = CdmDataSource.NewMySqlInstance(cdmServer, cdmDB, port, cdmUserName, pwd);
800
		} else if(dbType.equals(DatabaseTypeEnum.PostgreSQL)){
801
			destination = CdmDataSource.NewPostgreSQLInstance(cdmServer, cdmDB, port, cdmUserName, pwd);
802
		} else {
803
			//TODO others
804
			throw new RuntimeException("Unsupported DatabaseType");
805
		}
806
		return destination;
807

    
808
	}
809

    
810

    
811
	/**
812
	 * Accepts a string array and tries to find a method returning an ICdmDataSource with
813
	 * the name of the given first string in the array
814
	 *
815
	 * @param args
816
	 * @return
817
	 */
818
	public static ICdmDataSource chooseDestination(String[] args) {
819
		if(args == null) {
820
            return null;
821
        }
822

    
823
		if(args.length != 1) {
824
            return null;
825
        }
826

    
827
		String possibleDestination = args[0];
828

    
829
		Method[] methods = CdmDestinations.class.getMethods();
830

    
831
		for (Method method : methods){
832
			if(method.getName().equals(possibleDestination)){
833
				try {
834
					return (ICdmDataSource) method.invoke(null, null);
835
				} catch (Exception e) {
836
					e.printStackTrace();
837
					throw new RuntimeException(e);
838
				}
839
			}
840
		}
841
		return null;
842
	}
843

    
844
}
845

    
(2-2/5)