2 * Copyright (C) 2007 EDIT
3 * European Distributed Institute of Taxonomy
4 * http://www.e-taxonomy.eu
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.
10 package eu
.etaxonomy
.cdm
.app
.common
;
12 import java
.lang
.reflect
.Method
;
14 import org
.apache
.log4j
.Logger
;
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
;
21 public class CdmDestinations
{
23 @SuppressWarnings("unused")
24 private static Logger logger
= Logger
.getLogger(CdmDestinations
.class);
26 public static ICdmDataSource
cdm_pesi2019_final(){
27 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
28 String cdmServer
= "127.0.0.1";
29 String cdmDB
= "cdm_pesi_2019final";
30 String cdmUserName
= "edit";
32 return CdmDestinations
.makeDestination(dbType
, cdmServer
, cdmDB
, port
, cdmUserName
, null);
35 public static ICdmDataSource
cdm_local_redlist_animalia(){
36 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
37 String cdmServer
= "localhost";
38 String cdmDB
= "cdm_bfn_imports_animalia";
39 String cdmUserName
= "edit";
40 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
43 public static ICdmDataSource
cdm_redlist_animalia_production(){
44 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
45 String cdmServer
= "160.45.63.171";
46 String cdmDB
= "cdm_production_rl_animalia";
47 String cdmUserName
= "edit";
48 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
51 public static ICdmDataSource
cdm_additivity_ontology(){
52 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
53 String cdmServer
= "160.45.63.171";
54 String cdmDB
= "cdm_production_additivity_ontology";
55 String cdmUserName
= "edit";
56 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
59 public static ICdmDataSource
cdm_redlist_animalia_production_final(){
60 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
61 String cdmServer
= "160.45.63.171";
62 String cdmDB
= "cdm_production_rl_animalia_final";
63 String cdmUserName
= "edit";
64 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
67 public static ICdmDataSource
cdm_local_redlist_plant(){
68 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
69 String cdmServer
= "localhost";
70 String cdmDB
= "cdm_bfn_imports_plants";
71 String cdmUserName
= "edit";
72 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
75 public static ICdmDataSource
cdm_local_testDB(){
76 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
77 String cdmServer
= "localhost";
78 String cdmDB
= "testDB";
79 String cdmUserName
= "root";
80 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
83 public static ICdmDataSource
cdm_local_test_mysql(){
84 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
85 String cdmServer
= "127.0.0.1";
86 String cdmDB
= "test";
87 String cdmUserName
= "root";
88 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
91 public static ICdmDataSource
cdm_local_cdmtest_mysql(){
92 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
93 String cdmServer
= "127.0.0.1";
94 String cdmDB
= "cdm_test";
95 String cdmUserName
= "root";
96 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
99 public static ICdmDataSource
cdm_local_uzbekistan(){
100 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
101 String cdmServer
= "127.0.0.1";
102 String cdmDB
= "cdm_uzbekistan";
103 String cdmUserName
= "edit";
104 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
107 public static ICdmDataSource
cdm_local_redlist_gefaesspflanzen(){
108 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
109 String cdmServer
= "127.0.0.1";
110 String cdmDB
= "rl2020_gefaesspflanzen";
111 String cdmUserName
= "root";
112 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
116 public static ICdmDataSource
cdm_local_test_mysql_moose(){
117 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
118 String cdmServer
= "127.0.0.1";
119 String cdmDB
= "moose";
120 String cdmUserName
= "edit";
121 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
124 public static ICdmDataSource
cdm_local_test_mysql_standardliste(){
125 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
126 String cdmServer
= "127.0.0.1";
127 String cdmDB
= "standardliste";
128 String cdmUserName
= "root";
129 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
133 public static ICdmDataSource
cdm_local_test_mysql_dwca(){
134 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
135 String cdmServer
= "127.0.0.1";
136 String cdmDB
= "dwca";
137 String cdmUserName
= "edit";
138 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
142 public static ICdmDataSource
cdm_local_mysql_fdac(){
143 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
144 String cdmServer
= "127.0.0.1";
145 String cdmDB
= "fdac";
146 String cdmUserName
= "edit";
147 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
150 public static ICdmDataSource
cdm_test_local_mysql_test(){
151 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
152 String cdmServer
= "127.0.0.1";
153 String cdmDB
= "test";
154 String cdmUserName
= "edit"; //root on pesiimport2
155 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
158 public static ICdmDataSource
cdm_local_greece(){
159 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
160 String cdmServer
= "127.0.0.1";
161 String cdmDB
= "cdm_test_greece";
162 String cdmUserName
= "edit";
163 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
166 public static ICdmDataSource
cdm_local_test_bogota(){
167 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
168 String cdmServer
= "127.0.0.1";
169 String cdmDB
= "cdm_local_flora_bogota";
170 String cdmUserName
= "edit"; //root on pesiimport2
171 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
174 public static ICdmDataSource
cdm_local_casearia(){
175 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
176 String cdmServer
= "127.0.0.1";
177 String cdmDB
= "cdm_casearia";
178 String cdmUserName
= "edit"; //root on pesiimport2
179 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
182 public static ICdmDataSource
cdm_local_mysql_pesi_euromed(){
183 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
184 String cdmServer
= "127.0.0.1";
185 String cdmDB
= "cdm_pesi_euromed";
186 String cdmUserName
= "edit";
188 return CdmDestinations
.makeDestination(dbType
, cdmServer
, cdmDB
, port
, cdmUserName
, null);
191 public static ICdmDataSource
cdm_local_euromed(){
192 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
193 String cdmServer
= "127.0.0.1";
194 String cdmDB
= "cdm_euromed";
195 String cdmUserName
= "edit";
197 return CdmDestinations
.makeDestination(dbType
, cdmServer
, cdmDB
, port
, cdmUserName
, null);
200 public static ICdmDataSource
cdm_local_mysql_tmpTest(){
201 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
202 String cdmServer
= "127.0.0.1";
203 String cdmDB
= "tmpTest";
204 String cdmUserName
= "edit";
206 return CdmDestinations
.makeDestination(dbType
, cdmServer
, cdmDB
, port
, cdmUserName
, null);
209 public static ICdmDataSource
cdm_local_euromed2(){
210 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
211 String cdmServer
= "127.0.0.1";
212 String cdmDB
= "euroMed2";
213 String cdmUserName
= "edit";
214 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
216 public static ICdmDataSource
cdm_local_euromed_caucasus(){
217 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
218 String cdmServer
= "127.0.0.1";
219 String cdmDB
= "euromed_caucasus";
220 String cdmUserName
= "edit";
221 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
226 public static ICdmDataSource
cdm_local_test_euromed3(){
227 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
228 String cdmServer
= "127.0.0.1";
229 String cdmDB
= "euroMed3";
230 String cdmUserName
= "root";
231 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
234 public static ICdmDataSource
cdm_test_col(){
235 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
236 String cdmServer
= "160.45.63.175";
237 String cdmDB
= "cdm_col";
238 String cdmUserName
= "edit";
239 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
242 public static ICdmDataSource
cdm_test_col2(){
243 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
244 String cdmServer
= "160.45.63.175";
245 String cdmDB
= "cdm_col2";
246 String cdmUserName
= "edit";
247 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
250 public static ICdmDataSource
cdm_local_col(){
251 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
252 String cdmServer
= "127.0.0.1";
253 String cdmDB
= "col_test";
254 String cdmUserName
= "edit";
255 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
258 public static ICdmDataSource
cdm_local_col2(){
259 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
260 String cdmServer
= "127.0.0.1";
261 String cdmDB
= "col_test2";
262 String cdmUserName
= "edit";
263 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
267 public static ICdmDataSource
cdm_local_EDITImport(){
268 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
269 String cdmServer
= "127.0.0.1";
270 String cdmDB
= "EDITImport";
271 String cdmUserName
= "edit"; //root on pesiimport2
272 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
275 public static ICdmDataSource
cdm_test_euroMed(){
276 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
277 String cdmServer
= "160.45.63.175";
278 String cdmDB
= "cdm_test_euromed";
279 String cdmUserName
= "edit";
280 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
283 public static ICdmDataSource
cdm_production_euromed(){
284 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
285 String cdmServer
= "160.45.63.171";
286 String cdmDB
= "cdm_production_euromed";
287 String cdmUserName
= "edit";
288 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
291 public static ICdmDataSource
cdm_production_euromed_caucasus(){
292 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
293 String cdmServer
= "160.45.63.171";
294 String cdmDB
= "cdm_production_euromed_caucasus";
295 String cdmUserName
= "edit";
296 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
299 public static ICdmDataSource
cdm_test_corvidae(){
300 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
301 String cdmServer
= "160.45.63.175";
302 String cdmDB
= "cdm_corvidae";
303 String cdmUserName
= "edit";
304 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
307 public static ICdmDataSource
cdm_test_redlist_mammalia(){
308 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
309 String cdmServer
= "160.45.63.175";
310 String cdmDB
= "cdm_rl_mammalia";
311 String cdmUserName
= "edit";
312 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
315 public static ICdmDataSource
cdm_test_redlist_moose(){
316 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
317 String cdmServer
= "160.45.63.175";
318 String cdmDB
= "cdm_mt_moose";
319 String cdmUserName
= "edit";
320 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
323 public static ICdmDataSource
cdm_redlist_moose_production(){
324 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
325 String cdmServer
= "160.45.63.171";
326 String cdmDB
= "cdm_production_rl_moose";
327 String cdmUserName
= "edit";
328 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
331 public static ICdmDataSource
cdm_test_redlist_standardlist(){
332 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
333 String cdmServer
= "160.45.63.175";
334 String cdmDB
= "cdm_mt_standardliste";
335 String cdmUserName
= "edit";
336 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
339 public static ICdmDataSource
cdm_test_redlist_germanSL(){
340 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
341 String cdmServer
= "160.45.63.175";
342 String cdmDB
= "cdm_rl_german_sl";
343 String cdmUserName
= "edit";
344 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
347 public static ICdmDataSource
cdm_production_germanSL(){
348 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
349 String cdmServer
= "160.45.63.171";
350 String cdmDB
= "cdm_production_rl_german_sl";
351 String cdmUserName
= "edit";
352 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
355 public static ICdmDataSource
local_cyprus(){
356 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
357 String cdmServer
= "localhost";
358 String cdmDB
= "cdm_cyprus";
359 String cdmUserName
= "edit";
360 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
363 public static ICdmDataSource
cdm_test_cyprus(){
364 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
365 String cdmServer
= "160.45.63.175";
366 String cdmDB
= "cdm_cyprus";
367 String cdmUserName
= "edit";
368 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
371 public static ICdmDataSource
cdm_test_bupleurum(){
372 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
373 String cdmServer
= "160.45.63.175";
374 String cdmDB
= "cdm_test_bupleurum";
375 String cdmUserName
= "edit";
376 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
379 public static ICdmDataSource
cdm_production_cyprus(){
380 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
381 String cdmServer
= "160.45.63.171";
382 String cdmDB
= "cdm_production_cyprus";
383 String cdmUserName
= "edit";
384 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
387 public static ICdmDataSource
cdm_production_casearia(){
388 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
389 String cdmServer
= "160.45.63.171";
390 String cdmDB
= "cdm_production_casearia";
391 String cdmUserName
= "edit";
392 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
395 public static ICdmDataSource
cdm_production_uzbekistan(){
396 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
397 String cdmServer
= "160.45.63.171";
398 String cdmDB
= "cdm_production_flora_uzbekistan";
399 String cdmUserName
= "edit";
400 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
403 public static ICdmDataSource
cdm_phycobank_production(){
404 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
405 String cdmServer
= "160.45.63.171";
406 String cdmDB
= "cdm_production_phycobank";
407 String cdmUserName
= "edit";
408 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
411 public static ICdmDataSource
cdm_production_flora_cuba(){
412 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
413 String cdmServer
= "160.45.63.171";
414 String cdmDB
= "cdm_production_flora_cuba";
415 String cdmUserName
= "edit";
416 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
419 public static ICdmDataSource
cdm_production_greece_checklist(){
420 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
421 String cdmServer
= "160.45.63.171";
422 String cdmDB
= "cdm_production_flora_greece";
423 String cdmUserName
= "edit";
424 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
427 public static ICdmDataSource
cdm_production_lichenes(){
428 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
429 String cdmServer
= "160.45.63.171";
430 String cdmDB
= "cdm_production_lichenes";
431 String cdmUserName
= "edit";
432 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
435 public static ICdmDataSource
cdm_production_mexico_rubiaceae(){
436 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
437 String cdmServer
= "160.45.63.171";
438 String cdmDB
= "cdm_production_rubiaceae_mexico";
439 String cdmUserName
= "edit";
440 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
443 public static ICdmDataSource
cdm_production_bogota(){
444 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
445 String cdmServer
= "160.45.63.171";
446 String cdmDB
= "cdm_production_flora_bogota";
447 String cdmUserName
= "edit";
448 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
451 public static ICdmDataSource
cdm_production_tunnel_cyprus(){
452 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
453 String cdmServer
= "127.0.0.1";
455 String cdmDB
= "cdm_production_cyprus";
456 String cdmUserName
= "edit";
457 return makeDestination(dbType
, cdmServer
, cdmDB
, port
, cdmUserName
, null);
460 public static ICdmDataSource
cdm_production_campanulaceae(){
461 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
462 String cdmServer
= "160.45.63.171";
463 String cdmDB
= "cdm_production_campanulaceae";
464 String cdmUserName
= "edit";
465 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
468 public static ICdmDataSource
cdm_local_portal_test(){
469 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
470 String cdmServer
= "127.0.0.1";
471 String cdmDB
= "cdm_portal_test";
472 String cdmUserName
= "edit";
473 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
476 public static ICdmDataSource
cdm_local_portal_test2(){
477 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
478 String cdmServer
= "127.0.0.1";
479 String cdmDB
= "cdm_portal_test2";
480 String cdmUserName
= "edit";
481 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
484 public static ICdmDataSource
cdm_local_cichorieae(){
485 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
486 String cdmServer
= "127.0.0.1";
487 String cdmDB
= "cdm_edit_cichorieae";
488 String cdmUserName
= "edit";
489 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
492 public static ICdmDataSource
cdm_local_cyprus(){
493 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
494 String cdmServer
= "127.0.0.1";
495 String cdmDB
= "cdm_cyprus";
496 String cdmUserName
= "edit";
497 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
500 public static ICdmDataSource
cdm_local_mexico(){
501 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
502 String cdmServer
= "127.0.0.1";
503 String cdmDB
= "cdm_mexico";
504 String cdmUserName
= "edit";
505 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
507 public static ICdmDataSource
cdm_local_mexico2(){
508 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
509 String cdmServer
= "127.0.0.1";
510 String cdmDB
= "cdm_mexico2";
511 String cdmUserName
= "edit";
512 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
515 public static ICdmDataSource
cdm_local_palmae(){
516 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
517 String cdmServer
= "127.0.0.1";
518 String cdmDB
= "cdm_edit_caryo";
519 String cdmUserName
= "edit";
520 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
523 public static ICdmDataSource
cdm_local_cuba(){
524 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
525 String cdmServer
= "127.0.0.1";
526 String cdmDB
= "cdm_flora_cuba";
527 String cdmUserName
= "edit";
528 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
531 public static ICdmDataSource
cdm_local_caryo(){
532 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
533 String cdmServer
= "127.0.0.1";
534 String cdmDB
= "cdm_caryo_spp";
535 String cdmUserName
= "edit";
536 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
539 public static ICdmDataSource
cdm_local_algaterranew(){
540 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
541 String cdmServer
= "127.0.0.1";
542 String cdmDB
= "cdm_production_algaterranew";
543 String cdmUserName
= "root";
544 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
547 public static ICdmDataSource
cdm_test_globis(){
548 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
549 String cdmServer
= "160.45.63.175";
550 String cdmDB
= "cdm_edit_globis";
551 String cdmUserName
= "edit";
552 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
555 public static ICdmDataSource
cdm_local_edaphobase(){
556 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
557 String cdmServer
= "127.0.0.1";
558 String cdmDB
= "edaphobase";
559 String cdmUserName
= "edit";
560 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
563 public static ICdmDataSource
cdm_postgres_edaphobase(){
564 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.PostgreSQL
;
565 String cdmServer
= "130.133.70.26";
566 String cdmDB
= "cdm_edaphobase";
567 String cdmUserName
= "edaphobase";
569 return makeDestination(dbType
, cdmServer
, cdmDB
, port
, cdmUserName
, null);
572 public static ICdmDataSource
cdm_test_postgres_edaphobase(){
573 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.PostgreSQL
;
574 String cdmServer
= "160.45.63.175";
575 String cdmDB
= "cdm_edaphobase";
576 String cdmUserName
= "edaphobase";
578 return makeDestination(dbType
, cdmServer
, cdmDB
, port
, cdmUserName
, null);
581 public static ICdmDataSource
cdm_test_postgres__ssh_edaphobase(){
582 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.PostgreSQL
;
583 String cdmServer
= "localhost";
584 String cdmDB
= "cdm_edaphobase";
585 String cdmUserName
= "edaphobase";
587 return makeDestination(dbType
, cdmServer
, cdmDB
, port
, cdmUserName
, null);
590 public static ICdmDataSource
cdm_local_caryo_spp(){
591 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
592 String cdmServer
= "127.0.0.1";
593 String cdmDB
= "cdm_local_caryophyllales_spp";
594 String cdmUserName
= "edit";
595 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
598 public static ICdmDataSource
cdm_local_caryo_spp2(){
599 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
600 String cdmServer
= "127.0.0.1";
601 String cdmDB
= "cdm_caryo_spp2";
602 String cdmUserName
= "edit";
603 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
606 public static ICdmDataSource
cdm_production_globis(){
607 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
608 String cdmServer
= "160.45.63.171";
609 String cdmDB
= "cdm_production_globis";
610 String cdmUserName
= "edit";
611 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
614 public static ICdmDataSource
cdm_local_globis(){
615 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
616 String cdmServer
= "127.0.0.1";
617 String cdmDB
= "cdm_globis";
618 String cdmUserName
= "edit";
619 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
622 public static ICdmDataSource
cdm_local_postgres_CdmTest(){
623 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.PostgreSQL
;
624 String cdmServer
= "127.0.0.1";
625 String cdmDB
= "CdmTest";
626 String cdmUserName
= "edit";
627 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
629 public static ICdmDataSource
cdm_mexico_flora(){
630 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
631 String cdmServer
= "132.248.13.83";
632 String cdmDB
= "cdm_flora_mexico";
633 String cdmUserName
= "bgbm-developer";
634 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
638 public static ICdmDataSource
localH2(){
639 return CdmDataSource
.NewH2EmbeddedInstance("cdm", "sa", "");
642 public static ICdmDataSource
localH2Edapho(){
643 return CdmDataSource
.NewH2EmbeddedInstance("cdmEdapho", "sa", "");
646 public static ICdmDataSource
localH2Salvador(){
647 return CdmDataSource
.NewH2EmbeddedInstance("salvador", "sa", "");
650 public static ICdmDataSource
localH2Armeria(){
651 return CdmDataSource
.NewH2EmbeddedInstance("armeria", "sa", "");
654 public static ICdmDataSource
localH2Standardliste(){
655 return CdmDataSource
.NewH2EmbeddedInstance("standardliste", "sa", "");
658 public static ICdmDataSource
localH2Cichorieae(){
659 return CdmDataSource
.NewH2EmbeddedInstance("cichorieae", "sa", "");
662 public static ICdmDataSource
localH2Palmae(){
663 return CdmDataSource
.NewH2EmbeddedInstance("palmae", "sa", "");
666 public static ICdmDataSource
localH2EuroMed(){
667 return CdmDataSource
.NewH2EmbeddedInstance("euroMed", "sa", "");
670 public static ICdmDataSource
localH2Erms(){
671 return CdmDataSource
.NewH2EmbeddedInstance("erms", "sa", "");
675 public static ICdmDataSource
cdm_test_test1(){
676 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
677 String cdmServer
= "160.45.63.175";
678 String cdmDB
= "cdm_test1";
679 String cdmUserName
= "edit";
680 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
682 public static ICdmDataSource
cdm_test_test2(){
683 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
684 String cdmServer
= "160.45.63.175";
685 String cdmDB
= "cdm_test2";
686 String cdmUserName
= "edit";
687 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
689 public static ICdmDataSource
cdm_test_test3(){
690 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
691 String cdmServer
= "160.45.63.175";
692 String cdmDB
= "cdm_test3";
693 String cdmUserName
= "edit";
694 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
697 public static ICdmDataSource
cdm_test_phycobank(){
698 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
699 String cdmServer
= "160.45.63.175";
700 String cdmDB
= "cdm_phycobank";
701 String cdmUserName
= "edit";
702 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
705 public static ICdmDataSource
cdm_test_algaterra(){
706 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
707 String cdmServer
= "160.45.63.175";
708 String cdmDB
= "cdm_edit_algaterra";
709 String cdmUserName
= "edit";
710 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
713 public static ICdmDataSource
cdm_algaterra_production(){
714 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
715 String cdmServer
= "160.45.63.171";
716 String cdmDB
= "cdm_production_algaterra";
717 String cdmUserName
= "edit";
718 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
721 public static ICdmDataSource
cdm_test_salvador(){
722 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
723 String cdmServer
= "160.45.63.175";
724 String cdmDB
= "cdm_salvador";
725 String cdmUserName
= "edit";
726 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
729 public static ICdmDataSource
cdm_production_salvador(){
730 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
731 String cdmServer
= "160.45.63.171";
732 String cdmDB
= "cdm_production_salvador";
733 String cdmUserName
= "edit";
734 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
737 public static ICdmDataSource
cdm_test_cichorieae(){
738 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
739 String cdmServer
= "160.45.63.175";
740 String cdmDB
= "cdm_edit_cichorieae";
741 String cdmUserName
= "edit";
742 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
745 public static ICdmDataSource
cdm_int_flora_malesiana(){
746 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
747 String cdmServer
= "160.45.63.201";
748 String cdmDB
= "cdm_integration_flora_malesiana";
749 String cdmUserName
= "edit";
750 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
753 public static ICdmDataSource
cdm_test_caryo_spp(){
754 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
755 String cdmServer
= "160.45.63.175";
756 String cdmDB
= "cdm_caryo_spp";
757 String cdmUserName
= "edit";
758 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
761 public static ICdmDataSource
cdm_production_cichorieae(){
762 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
763 String cdmServer
= "160.45.63.171";
764 String cdmDB
= "cdm_production_cichorieae";
765 String cdmUserName
= "edit";
766 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
769 public static ICdmDataSource
cdm_production_palmae(){
770 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
771 String cdmServer
= "160.45.63.171";
772 String cdmDB
= "cdm_production_palmae";
773 String cdmUserName
= "edit";
774 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
777 public static ICdmDataSource
cdm_production_flora_deutschland(){
778 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
779 String cdmServer
= "160.45.63.171";
780 String cdmDB
= "cdm_production_rl_standardliste";
781 String cdmUserName
= "edit";
782 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
785 public static ICdmDataSource
cdm_production_caryophyllales_genus(){
786 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
787 String cdmServer
= "160.45.63.171";
788 String cdmDB
= "cdm_production_caryophyllales";
789 String cdmUserName
= "edit";
790 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
793 public static ICdmDataSource
cdm_production_caryophyllales_spp(){
794 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
795 String cdmServer
= "160.45.63.171";
796 String cdmDB
= "cdm_production_caryophyllales_spp";
797 String cdmUserName
= "edit";
798 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
801 public static ICdmDataSource
cdm_production_caryophyllales_nepenthaceae(){
802 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
803 String cdmServer
= "160.45.63.171";
804 String cdmDB
= "cdm_production_caryo_nepenthaceae";
805 String cdmUserName
= "edit";
806 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
809 public static ICdmDataSource
cdm_local_caryophyllales_nepenthaceae(){
810 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
811 String cdmServer
= "127.0.0.1";
812 String cdmDB
= "cdm_local_caryo_nepenthaceae";
813 String cdmUserName
= "root";
814 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
817 public static ICdmDataSource
cdm_production_redlist_gefaesspflanzen(){
818 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
819 String cdmServer
= "160.45.63.171";
820 String cdmDB
= "cdm_production_rl_plantae";
821 String cdmUserName
= "edit";
822 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
825 public static ICdmDataSource
cdm_production_edaphobase(){
826 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
827 String cdmServer
= "160.45.63.171";
828 String cdmDB
= "cdm_production_edaphobase";
829 String cdmUserName
= "edit";
830 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
833 public static ICdmDataSource
cdm_production_piB(String database
){
834 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
835 String cdmServer
= "160.45.63.171";
836 String cdmDB
= "cdm_production_" + database
+ "_pilot";
837 String cdmUserName
= "edit";
838 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
841 public static ICdmDataSource
cdm_local_piB(String database
){
842 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
843 String cdmServer
= "127.0.0.1";
844 String cdmDB
= "piB_" + database
;
845 String cdmUserName
= "root";
846 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
849 public static ICdmDataSource
cdm_local_proibiosphere_chenopodium() {
850 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
851 String cdmServer
= "localhost";
852 String cdmDB
= "cdm_production_proibiosphere_chenopodium_pilot";
853 String cdmUserName
= "root";
854 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
857 public static ICdmDataSource
cdm_local_proibiosphere_spiders() {
858 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
859 String cdmServer
= "localhost";
860 String cdmDB
= "cdm_production_proibiosphere_spiders_pilot";
861 String cdmUserName
= "root";
862 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
865 public static ICdmDataSource
cdm_test_pesi_fauna_europaea(){
866 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
867 String cdmServer
= "160.45.63.175";
868 String cdmDB
= "cdm_pesi_fauna_europaea";
869 String cdmUserName
= "edit";
870 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
877 * TODO only supports MySQL and PostgreSQL
887 public static ICdmDataSource
makeDestination(DatabaseTypeEnum dbType
, String cdmServer
, String cdmDB
, int port
, String cdmUserName
, String pwd
){
888 //establish connection
889 pwd
= AccountStore
.readOrStorePassword(cdmServer
, cdmDB
, cdmUserName
, pwd
);
890 ICdmDataSource destination
;
891 if(dbType
.equals(DatabaseTypeEnum
.MySQL
)){
892 destination
= CdmDataSource
.NewMySqlInstance(cdmServer
, cdmDB
, port
, cdmUserName
, pwd
);
893 } else if(dbType
.equals(DatabaseTypeEnum
.PostgreSQL
)){
894 destination
= CdmDataSource
.NewPostgreSQLInstance(cdmServer
, cdmDB
, port
, cdmUserName
, pwd
);
897 throw new RuntimeException("Unsupported DatabaseType");
905 * Accepts a string array and tries to find a method returning an ICdmDataSource with
906 * the name of the given first string in the array
911 public static ICdmDataSource
chooseDestination(String
[] args
) {
916 if(args
.length
!= 1) {
920 String possibleDestination
= args
[0];
922 Method
[] methods
= CdmDestinations
.class.getMethods();
924 for (Method method
: methods
){
925 if(method
.getName().equals(possibleDestination
)){
927 return (ICdmDataSource
) method
.invoke(null, null);
928 } catch (Exception e
) {
930 throw new RuntimeException(e
);