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
.common
.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
{
22 @SuppressWarnings("unused")
23 private static Logger logger
= Logger
.getLogger(CdmDestinations
.class);
25 public static ICdmDataSource
cdm_redlist_animalia_localhost(){
26 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
27 String cdmServer
= "localhost";
28 String cdmDB
= "cdm_bfn_imports_animalia";
29 String cdmUserName
= "edit";
30 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
33 public static ICdmDataSource
cdm_redlist_animalia_production(){
34 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
35 String cdmServer
= "160.45.63.171";
36 String cdmDB
= "cdm_production_rl_animals";
37 String cdmUserName
= "edit";
38 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
41 public static ICdmDataSource
cdm_redlist_plant_localhost(){
42 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
43 String cdmServer
= "localhost";
44 String cdmDB
= "cdm_bfn_imports_plants";
45 String cdmUserName
= "edit";
46 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
49 public static ICdmDataSource
cdm_redlist_lumbricidae(){
50 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
51 String cdmServer
= "160.45.63.171";
52 String cdmDB
= "cdm_production_rl_lumbricidae";
53 String cdmUserName
= "edit";
54 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
57 public static ICdmDataSource
cdm_testDB_localhost(){
58 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
59 String cdmServer
= "localhost";
60 String cdmDB
= "testDB";
61 String cdmUserName
= "root";
62 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
65 public static ICdmDataSource
cdm_test_useSummary(){
66 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
67 String cdmServer
= "localhost";
68 String cdmDB
= "palmae_2011_07_17";
69 String cdmUserName
= "root";
70 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
73 public static ICdmDataSource
cdm_test_local_mysql(){
74 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
75 String cdmServer
= "127.0.0.1";
76 String cdmDB
= "cdm_test";
77 String cdmUserName
= "root";
78 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
82 public static ICdmDataSource
cdm_test_local_mysql_moose(){
83 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
84 String cdmServer
= "127.0.0.1";
85 String cdmDB
= "moose";
86 String cdmUserName
= "edit";
87 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
90 public static ICdmDataSource
cdm_test_local_mysql_standardliste(){
91 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
92 String cdmServer
= "127.0.0.1";
93 String cdmDB
= "standardliste";
94 String cdmUserName
= "root";
95 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
99 public static ICdmDataSource
cdm_test_local_mysql_dwca(){
100 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
101 String cdmServer
= "127.0.0.1";
102 String cdmDB
= "dwca";
103 String cdmUserName
= "edit";
104 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
108 public static ICdmDataSource
cdm_test_local_mysql_fdac(){
109 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
110 String cdmServer
= "127.0.0.1";
111 String cdmDB
= "fdac";
112 String cdmUserName
= "edit";
113 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
116 public static ICdmDataSource
cdm_test_local_mysql_test(){
117 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
118 String cdmServer
= "127.0.0.1";
119 String cdmDB
= "test";
120 String cdmUserName
= "edit"; //root on pesiimport2
121 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
124 public static ICdmDataSource
cdm_test_local_euromed(){
125 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
126 String cdmServer
= "127.0.0.1";
127 String cdmDB
= "euroMed";
128 String cdmUserName
= "root";
129 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
132 public static ICdmDataSource
cdm_test_local_euromed2(){
133 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
134 String cdmServer
= "127.0.0.1";
135 String cdmDB
= "euroMed2";
136 String cdmUserName
= "root";
137 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
139 public static ICdmDataSource
cdm_test_local_euromed3(){
140 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
141 String cdmServer
= "127.0.0.1";
142 String cdmDB
= "euroMed3";
143 String cdmUserName
= "root";
144 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
147 public static ICdmDataSource
cdm_test_col(){
148 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
149 String cdmServer
= "160.45.63.175";
150 String cdmDB
= "cdm_col";
151 String cdmUserName
= "edit";
152 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
155 public static ICdmDataSource
cdm_test_col2(){
156 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
157 String cdmServer
= "160.45.63.175";
158 String cdmDB
= "cdm_col2";
159 String cdmUserName
= "edit";
160 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
163 public static ICdmDataSource
cdm_col_local(){
164 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
165 String cdmServer
= "127.0.0.1";
166 String cdmDB
= "col_test";
167 String cdmUserName
= "edit";
168 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
171 public static ICdmDataSource
cdm_col2_local(){
172 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
173 String cdmServer
= "127.0.0.1";
174 String cdmDB
= "col_test2";
175 String cdmUserName
= "edit";
176 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
180 public static ICdmDataSource
cdm_local_EDITImport(){
181 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
182 String cdmServer
= "127.0.0.1";
183 String cdmDB
= "EDITImport";
184 String cdmUserName
= "edit"; //root on pesiimport2
185 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
188 public static ICdmDataSource
cdm_test_euroMed(){
189 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
190 String cdmServer
= "160.45.63.175";
191 String cdmDB
= "cdm_test_euromed";
192 String cdmUserName
= "edit";
193 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
196 public static ICdmDataSource
cdm_corvidae_dev(){
197 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
198 String cdmServer
= "160.45.63.175";
199 String cdmDB
= "cdm_corvidae";
200 String cdmUserName
= "edit";
201 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
204 public static ICdmDataSource
cdm_ildis_dev(){
205 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
206 String cdmServer
= "160.45.63.175";
207 String cdmDB
= "cdm_edit_ildis";
208 String cdmUserName
= "edit";
209 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
213 // public static ICdmDataSource cdm_ildis_production(){
214 // DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
215 // String cdmServer = "160.45.63.171";
216 // String cdmDB = "cdm_edit_ildis";
217 // String cdmUserName = "edit";
218 // return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
222 public static ICdmDataSource
cdm_redlist_moose_dev(){
223 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
224 String cdmServer
= "160.45.63.175";
225 String cdmDB
= "cdm_mt_moose";
226 String cdmUserName
= "edit";
227 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
230 public static ICdmDataSource
cdm_redlist_moose_production(){
231 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
232 String cdmServer
= "160.45.63.171";
233 String cdmDB
= "cdm_production_rl_moose";
234 String cdmUserName
= "edit";
235 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
238 public static ICdmDataSource
cdm_redlist_standardlist_dev(){
239 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
240 String cdmServer
= "160.45.63.175";
241 String cdmDB
= "cdm_mt_standardliste";
242 String cdmUserName
= "edit";
243 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
246 public static ICdmDataSource
cdm_redlist_germanSL_preview(){
247 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
248 String cdmServer
= "160.45.63.175";
249 String cdmDB
= "cdm_rl_german_sl";
250 String cdmUserName
= "edit";
251 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
254 public static ICdmDataSource
cdm_germanSL_production(){
255 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
256 String cdmServer
= "160.45.63.171";
257 String cdmDB
= "cdm_production_rl_german_sl";
258 String cdmUserName
= "edit";
259 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
263 public static ICdmDataSource
cdm_cyprus_dev(){
264 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
265 String cdmServer
= "160.45.63.175";
266 String cdmDB
= "cdm_cyprus";
267 String cdmUserName
= "edit";
268 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
271 public static ICdmDataSource
cdm_cyprus_production(){
272 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
273 String cdmServer
= "160.45.63.171";
274 String cdmDB
= "cdm_production_cyprus";
275 String cdmUserName
= "edit";
276 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
279 public static ICdmDataSource
cdm_cuba_production(){
280 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
281 String cdmServer
= "160.45.63.171";
282 String cdmDB
= "cdm_production_flora_cuba";
283 String cdmUserName
= "edit";
284 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
287 public static ICdmDataSource
cdm_mexico_rubiaceae_production(){
288 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
289 String cdmServer
= "160.45.63.171";
290 String cdmDB
= "cdm_production_rubiaceae_mexico";
291 String cdmUserName
= "edit";
292 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
295 public static ICdmDataSource
cdm_cyprus_production_tunnel(){
296 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
297 String cdmServer
= "127.0.0.1";
299 String cdmDB
= "cdm_production_cyprus";
300 String cdmUserName
= "edit";
301 return makeDestination(dbType
, cdmServer
, cdmDB
, port
, cdmUserName
, null);
304 public static ICdmDataSource
cdm_cyprus_dev_tunnel(){
305 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
306 String cdmServer
= "127.0.0.1";
308 String cdmDB
= "cdm_cyprus";
309 String cdmUserName
= "edit";
310 return makeDestination(dbType
, cdmServer
, cdmDB
, port
, cdmUserName
, null);
313 public static ICdmDataSource
cdm_campanulaceae_production(){
314 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
315 String cdmServer
= "160.45.63.171";
316 String cdmDB
= "cdm_production_campanulaceae";
317 String cdmUserName
= "edit";
318 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
321 public static ICdmDataSource
cdm_portal_test_localhost(){
322 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
323 String cdmServer
= "127.0.0.1";
324 String cdmDB
= "cdm_portal_test";
325 String cdmUserName
= "edit";
326 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
329 public static ICdmDataSource
cdm_portal_test_localhost2(){
330 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
331 String cdmServer
= "127.0.0.1";
332 String cdmDB
= "cdm_portal_test2";
333 String cdmUserName
= "edit";
334 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
337 public static ICdmDataSource
cdm_local_cichorieae(){
338 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
339 String cdmServer
= "127.0.0.1";
340 String cdmDB
= "cdm_edit_cichorieae";
341 String cdmUserName
= "edit";
342 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
347 public static ICdmDataSource
cdm_local_palmae(){
348 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
349 String cdmServer
= "127.0.0.1";
350 String cdmDB
= "cdm_edit_caryo";
351 String cdmUserName
= "edit";
352 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
355 public static ICdmDataSource
cdm_local_caryo(){
356 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
357 String cdmServer
= "127.0.0.1";
358 String cdmDB
= "cdm_local_caryophyllales";
359 String cdmUserName
= "root";
360 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
363 public static ICdmDataSource
cdm_globis_dev(){
364 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
365 String cdmServer
= "160.45.63.175";
366 String cdmDB
= "cdm_edit_globis";
367 String cdmUserName
= "edit";
368 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
371 public static ICdmDataSource
cdm_local_edaphobase(){
372 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
373 String cdmServer
= "127.0.0.1";
374 String cdmDB
= "edaphobase";
375 String cdmUserName
= "edit";
376 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
379 public static ICdmDataSource
cdm_globis_production(){
380 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
381 String cdmServer
= "160.45.63.171";
382 String cdmDB
= "cdm_production_globis";
383 String cdmUserName
= "edit";
384 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
387 public static ICdmDataSource
cdm_local_globis(){
388 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
389 String cdmServer
= "127.0.0.1";
390 String cdmDB
= "cdm_globis";
391 String cdmUserName
= "edit";
392 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
395 public static ICdmDataSource
cdm_local_postgres_CdmTest(){
396 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.PostgreSQL
;
397 String cdmServer
= "127.0.0.1";
398 String cdmDB
= "CdmTest";
399 String cdmUserName
= "edit";
400 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
404 public static ICdmDataSource
NULL(){
409 public static ICdmDataSource
localH2(){
410 return CdmDataSource
.NewH2EmbeddedInstance("cdm", "sa", "");
413 public static ICdmDataSource
localH2Edapho(){
414 return CdmDataSource
.NewH2EmbeddedInstance("cdmEdapho", "sa", "");
417 public static ICdmDataSource
localH2Salvador(){
418 return CdmDataSource
.NewH2EmbeddedInstance("salvador", "sa", "");
421 public static ICdmDataSource
localH2Armeria(){
422 return CdmDataSource
.NewH2EmbeddedInstance("armeria", "sa", "");
425 public static ICdmDataSource
localH2Standardliste(){
426 return CdmDataSource
.NewH2EmbeddedInstance("standardliste", "sa", "");
429 public static ICdmDataSource
localH2Cichorieae(){
430 return CdmDataSource
.NewH2EmbeddedInstance("cichorieae", "sa", "");
433 public static ICdmDataSource
localH2Palmae(){
434 return CdmDataSource
.NewH2EmbeddedInstance("palmae", "sa", "");
437 public static ICdmDataSource
localH2EuroMed(){
438 return CdmDataSource
.NewH2EmbeddedInstance("euroMed", "sa", "");
441 public static ICdmDataSource
localH2Erms(){
442 return CdmDataSource
.NewH2EmbeddedInstance("erms", "sa", "");
446 public static ICdmDataSource
cdm_algaterra_preview(){
447 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
448 String cdmServer
= "160.45.63.175";
449 String cdmDB
= "cdm_edit_algaterra";
450 String cdmUserName
= "edit";
451 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
454 public static ICdmDataSource
cdm_algaterra_production(){
455 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
456 String cdmServer
= "160.45.63.171";
457 String cdmDB
= "cdm_production_algaterra";
458 String cdmUserName
= "edit";
459 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
462 public static ICdmDataSource
cdm_salvador_preview(){
463 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
464 String cdmServer
= "160.45.63.175";
465 String cdmDB
= "cdm_salvador";
466 String cdmUserName
= "edit";
467 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
470 public static ICdmDataSource
cdm_salvador_production(){
471 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
472 String cdmServer
= "160.45.63.171";
473 String cdmDB
= "cdm_production_salvador";
474 String cdmUserName
= "edit";
475 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
478 public static ICdmDataSource
cdm_edit_cichorieae_local_PG(){
479 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.PostgreSQL
;
480 String cdmServer
= "127.0.0.1";
481 String cdmDB
= "cdm_edit_cichorieae_a";
482 String cdmUserName
= "edit";
484 return makeDestination(dbType
, cdmServer
, cdmDB
, port
, cdmUserName
, null);
487 public static ICdmDataSource
cdm_cichorieae_preview(){
488 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
489 String cdmServer
= "160.45.63.175";
490 String cdmDB
= "cdm_edit_cichorieae";
491 String cdmUserName
= "edit";
492 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
495 public static ICdmDataSource
cdm_production_cichorieae(){
496 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
497 String cdmServer
= "160.45.63.171";
498 // String cdmServer = "127.0.0.1";
499 String cdmDB
= "cdm_production_cichorieae";
500 String cdmUserName
= "edit";
501 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
504 public static ICdmDataSource
cdm_production_palmae(){
505 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
506 String cdmServer
= "160.45.63.171";
507 String cdmDB
= "cdm_production_palmae";
508 String cdmUserName
= "edit";
509 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
512 public static ICdmDataSource
cdm_production_flora_deutschland(){
513 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
514 String cdmServer
= "160.45.63.171";
515 String cdmDB
= "cdm_production_rl_standardliste";
516 String cdmUserName
= "edit";
517 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
520 public static ICdmDataSource
cdm_production_caryophyllales(){
521 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
522 String cdmServer
= "160.45.63.171";
523 String cdmDB
= "cdm_production_caryophyllales";
524 String cdmUserName
= "edit";
525 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
528 public static ICdmDataSource
cdm_production_redlist_gefaesspflanzen(){
529 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
530 String cdmServer
= "160.45.63.171";
531 String cdmDB
= "cdm_production_rl_plantae";
532 String cdmUserName
= "edit";
533 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
536 public static ICdmDataSource
cdm_production_edaphobase(){
537 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
538 String cdmServer
= "160.45.63.171";
539 String cdmDB
= "cdm_production_edaphobase";
540 String cdmUserName
= "edit";
541 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
545 public static ICdmDataSource
cdm_production_diptera(){
546 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
547 String cdmServer
= "160.45.63.171";
548 String cdmDB
= "cdm_production_diptera";
549 String cdmUserName
= "edit";
550 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
553 public static ICdmDataSource
cdm_edit_cichorieae_preview(){
554 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
555 String cdmServer
= "127.0.0.1";
556 String cdmDB
= "cdm_edit_cichorieae";
557 String cdmUserName
= "edit";
559 return makeDestination(dbType
, cdmServer
, cdmDB
, port
, cdmUserName
, null);
562 public static ICdmDataSource
cdm_edit_cichorieae_preview_direct(){
563 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
564 String cdmServer
= "160.45.63.175";
565 String cdmDB
= "cdm_edit_cichorieae";
566 String cdmUserName
= "edit";
568 return makeDestination(dbType
, cdmServer
, cdmDB
, port
, cdmUserName
, null);
571 public static ICdmDataSource
cdm_production_piB(String database
){
572 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
573 String cdmServer
= "160.45.63.171";
574 String cdmDB
= "cdm_production_" + database
+ "_pilot";
575 String cdmUserName
= "edit";
576 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
579 public static ICdmDataSource
cdm_local_piB(String database
){
580 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
581 String cdmServer
= "127.0.0.1";
582 String cdmDB
= "piB_" + database
;
583 String cdmUserName
= "root";
584 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
590 public static ICdmDataSource
mon_cdm() {
591 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
592 String cdmServer
= "localhost";
593 String cdmDB
= "cdm_local";
594 String cdmUserName
= "root";
595 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
598 public static ICdmDataSource
proibiosphere_chenopodium_local() {
599 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
600 String cdmServer
= "localhost";
601 String cdmDB
= "cdm_production_proibiosphere_chenopodium_pilot";
602 String cdmUserName
= "root";
603 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
606 public static ICdmDataSource
proibiosphere_ants_local() {
607 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
608 String cdmServer
= "localhost";
609 String cdmDB
= "cdm_production_proibiosphere_ants_pilot";
610 String cdmUserName
= "root";
611 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
614 public static ICdmDataSource
proibiosphere_fungi_local() {
615 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
616 String cdmServer
= "localhost";
617 String cdmDB
= "cdm_production_proibiosphere_fungi_pilot";
618 String cdmUserName
= "root";
619 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
622 public static ICdmDataSource
proibiosphere_campylopus_local() {
623 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
624 String cdmServer
= "localhost";
625 String cdmDB
= "cdm_production_proibiosphere_campylopus_pilot";
626 String cdmUserName
= "root";
627 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
631 public static ICdmDataSource
proibiosphere_eupolybothrus_local() {
632 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
633 String cdmServer
= "localhost";
634 String cdmDB
= "cdm_production_proibiosphere_eupolybothrus_pilot";
635 String cdmUserName
= "root";
636 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
639 public static ICdmDataSource
proibiosphere_spiders_local() {
640 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
641 String cdmServer
= "localhost";
642 String cdmDB
= "cdm_production_proibiosphere_spiders_pilot";
643 String cdmUserName
= "root";
644 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
651 * TODO only supports MySQL and PostgreSQL
661 public static ICdmDataSource
makeDestination(DatabaseTypeEnum dbType
, String cdmServer
, String cdmDB
, int port
, String cdmUserName
, String pwd
){
662 //establish connection
663 pwd
= AccountStore
.readOrStorePassword(cdmServer
, cdmDB
, cdmUserName
, pwd
);
664 ICdmDataSource destination
;
665 if(dbType
.equals(DatabaseTypeEnum
.MySQL
)){
666 destination
= CdmDataSource
.NewMySqlInstance(cdmServer
, cdmDB
, port
, cdmUserName
, pwd
);
667 } else if(dbType
.equals(DatabaseTypeEnum
.PostgreSQL
)){
668 destination
= CdmDataSource
.NewPostgreSQLInstance(cdmServer
, cdmDB
, port
, cdmUserName
, pwd
);
671 throw new RuntimeException("Unsupported DatabaseType");
679 * Accepts a string array and tries to find a method returning an ICdmDataSource with
680 * the name of the given first string in the array
685 public static ICdmDataSource
chooseDestination(String
[] args
) {
690 if(args
.length
!= 1) {
694 String possibleDestination
= args
[0];
696 Method
[] methods
= CdmDestinations
.class.getMethods();
698 for (Method method
: methods
){
699 if(method
.getName().equals(possibleDestination
)){
701 return (ICdmDataSource
) method
.invoke(null, null);
702 } catch (Exception e
) {
704 throw new RuntimeException(e
);