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);
172 public static ICdmDataSource
cdm_local_EDITImport(){
173 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
174 String cdmServer
= "127.0.0.1";
175 String cdmDB
= "EDITImport";
176 String cdmUserName
= "edit"; //root on pesiimport2
177 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
180 public static ICdmDataSource
cdm_test_euroMed(){
181 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
182 String cdmServer
= "160.45.63.175";
183 String cdmDB
= "cdm_test_euromed";
184 String cdmUserName
= "edit";
185 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
188 public static ICdmDataSource
cdm_pesi_euromed(){
189 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
190 String cdmServer
= "160.45.63.175";
191 String cdmDB
= "cdm_pesi_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_cyprus_dev(){
247 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
248 String cdmServer
= "160.45.63.175";
249 String cdmDB
= "cdm_cyprus";
250 String cdmUserName
= "edit";
251 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
254 public static ICdmDataSource
cdm_cyprus_production(){
255 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
256 String cdmServer
= "160.45.63.171";
257 String cdmDB
= "cdm_production_cyprus";
258 String cdmUserName
= "edit";
259 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
262 public static ICdmDataSource
cdm_cyprus_production_tunnel(){
263 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
264 String cdmServer
= "127.0.0.1";
266 String cdmDB
= "cdm_production_cyprus";
267 String cdmUserName
= "edit";
268 return makeDestination(dbType
, cdmServer
, cdmDB
, port
, cdmUserName
, null);
271 public static ICdmDataSource
cdm_cyprus_dev_tunnel(){
272 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
273 String cdmServer
= "127.0.0.1";
275 String cdmDB
= "cdm_cyprus";
276 String cdmUserName
= "edit";
277 return makeDestination(dbType
, cdmServer
, cdmDB
, port
, cdmUserName
, null);
280 public static ICdmDataSource
cdm_campanulaceae_production(){
281 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
282 String cdmServer
= "160.45.63.171";
283 String cdmDB
= "cdm_production_campanulaceae";
284 String cdmUserName
= "edit";
285 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
288 public static ICdmDataSource
cdm_flora_malesiana_preview(){
289 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
290 String cdmServer
= "160.45.63.175";
291 String cdmDB
= "cdm_edit_flora_malesiana";
292 String cdmUserName
= "edit";
293 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
296 public static ICdmDataSource
cdm_flora_malesiana_production(){
297 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
298 String cdmServer
= "160.45.63.171";
299 String cdmDB
= "cdm_production_flora_malesiana";
300 String cdmUserName
= "edit";
301 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
304 public static ICdmDataSource
cdm_portal_test_localhost(){
305 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
306 String cdmServer
= "127.0.0.1";
307 String cdmDB
= "cdm_portal_test";
308 String cdmUserName
= "edit";
309 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
312 public static ICdmDataSource
cdm_portal_test_localhost2(){
313 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
314 String cdmServer
= "127.0.0.1";
315 String cdmDB
= "cdm_portal_test2";
316 String cdmUserName
= "edit";
317 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
320 public static ICdmDataSource
cdm_local_cichorieae(){
321 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
322 String cdmServer
= "127.0.0.1";
323 String cdmDB
= "cdm_edit_cichorieae";
324 String cdmUserName
= "edit";
325 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
330 public static ICdmDataSource
cdm_local_palmae(){
331 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
332 String cdmServer
= "127.0.0.1";
333 String cdmDB
= "cdm_edit_caryo";
334 String cdmUserName
= "edit";
335 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
338 public static ICdmDataSource
cdm_local_caryo(){
339 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
340 String cdmServer
= "127.0.0.1";
341 String cdmDB
= "cdm_edit_palmae";
342 String cdmUserName
= "edit";
343 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
346 public static ICdmDataSource
cdm_globis_dev(){
347 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
348 String cdmServer
= "160.45.63.175";
349 String cdmDB
= "cdm_edit_globis";
350 String cdmUserName
= "edit";
351 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
354 public static ICdmDataSource
cdm_globis_production(){
355 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
356 String cdmServer
= "160.45.63.171";
357 String cdmDB
= "cdm_production_globis";
358 String cdmUserName
= "edit";
359 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
362 public static ICdmDataSource
cdm_local_globis(){
363 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
364 String cdmServer
= "127.0.0.1";
365 String cdmDB
= "cdm_globis";
366 String cdmUserName
= "edit";
367 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
370 public static ICdmDataSource
cdm_local_postgres_CdmTest(){
371 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.PostgreSQL
;
372 String cdmServer
= "127.0.0.1";
373 String cdmDB
= "CdmTest";
374 String cdmUserName
= "edit";
375 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
378 public static ICdmDataSource
cdm_local_tdwg2010(){
379 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
380 String cdmServer
= "127.0.0.1";
381 String cdmDB
= "cdm_tdwg2010";
382 String cdmUserName
= "edit";
383 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
387 public static ICdmDataSource
NULL(){
392 public static ICdmDataSource
localH2(){
393 return CdmDataSource
.NewH2EmbeddedInstance("cdm", "sa", "");
396 public static ICdmDataSource
localH2(String database
, String username
, String filePath
){
397 return CdmDataSource
.NewH2EmbeddedInstance(database
, "sa", "", filePath
, null);
400 public static ICdmDataSource
localH2Salvador(){
401 return CdmDataSource
.NewH2EmbeddedInstance("salvador", "sa", "");
404 public static ICdmDataSource
localH2Armeria(){
405 return CdmDataSource
.NewH2EmbeddedInstance("armeria", "sa", "");
408 public static ICdmDataSource
localH2Standardliste(){
409 return CdmDataSource
.NewH2EmbeddedInstance("standardliste", "sa", "");
412 public static ICdmDataSource
localH2Cichorieae(){
413 return CdmDataSource
.NewH2EmbeddedInstance("cichorieae", "sa", "");
416 public static ICdmDataSource
localH2Palmae(){
417 return CdmDataSource
.NewH2EmbeddedInstance("palmae", "sa", "");
420 public static ICdmDataSource
localH2EuroMed(){
421 return CdmDataSource
.NewH2EmbeddedInstance("euroMed", "sa", "");
424 public static ICdmDataSource
localH2Erms(){
425 return CdmDataSource
.NewH2EmbeddedInstance("erms", "sa", "");
429 public static ICdmDataSource
cdm_algaterra_preview(){
430 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
431 String cdmServer
= "160.45.63.175";
432 String cdmDB
= "cdm_edit_algaterra";
433 String cdmUserName
= "edit";
434 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
437 public static ICdmDataSource
cdm_algaterra_production(){
438 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
439 String cdmServer
= "160.45.63.171";
440 String cdmDB
= "cdm_production_algaterra";
441 String cdmUserName
= "edit";
442 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
445 public static ICdmDataSource
cdm_edit_cichorieae_local_PG(){
446 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.PostgreSQL
;
447 String cdmServer
= "127.0.0.1";
448 String cdmDB
= "cdm_edit_cichorieae_a";
449 String cdmUserName
= "edit";
451 return makeDestination(dbType
, cdmServer
, cdmDB
, port
, cdmUserName
, null);
454 public static ICdmDataSource
cdm_cichorieae_preview(){
455 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
456 String cdmServer
= "160.45.63.175";
457 String cdmDB
= "cdm_edit_cichorieae";
458 String cdmUserName
= "edit";
459 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
462 public static ICdmDataSource
cdm_production_cichorieae(){
463 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
464 String cdmServer
= "160.45.63.171";
465 // String cdmServer = "127.0.0.1";
466 String cdmDB
= "cdm_production_cichorieae";
467 String cdmUserName
= "edit";
468 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
471 public static ICdmDataSource
cdm_production_palmae(){
472 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
473 String cdmServer
= "160.45.63.171";
474 String cdmDB
= "cdm_production_palmae";
475 String cdmUserName
= "edit";
476 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
479 public static ICdmDataSource
cdm_production_flora_deutschland(){
480 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
481 String cdmServer
= "160.45.63.171";
482 String cdmDB
= "cdm_production_rl_standardliste";
483 String cdmUserName
= "edit";
484 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
487 public static ICdmDataSource
cdm_production_caryophyllales(){
488 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
489 String cdmServer
= "160.45.63.171";
490 String cdmDB
= "cdm_production_caryophyllales";
491 String cdmUserName
= "edit";
492 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
496 public static ICdmDataSource
cdm_production_diptera(){
497 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
498 String cdmServer
= "160.45.63.171";
499 String cdmDB
= "cdm_production_diptera";
500 String cdmUserName
= "edit";
501 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
504 public static ICdmDataSource
cdm_edit_cichorieae_preview(){
505 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
506 String cdmServer
= "127.0.0.1";
507 String cdmDB
= "cdm_edit_cichorieae";
508 String cdmUserName
= "edit";
510 return makeDestination(dbType
, cdmServer
, cdmDB
, port
, cdmUserName
, null);
513 public static ICdmDataSource
cdm_edit_cichorieae_preview_direct(){
514 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
515 String cdmServer
= "160.45.63.175";
516 String cdmDB
= "cdm_edit_cichorieae";
517 String cdmUserName
= "edit";
519 return makeDestination(dbType
, cdmServer
, cdmDB
, port
, cdmUserName
, null);
522 public static ICdmDataSource
cdm_production_piB(String database
){
523 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
524 String cdmServer
= "160.45.63.171";
525 String cdmDB
= "cdm_production_" + database
+ "_pilot";
526 String cdmUserName
= "edit";
527 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
530 public static ICdmDataSource
cdm_local_piB(String database
){
531 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
532 String cdmServer
= "127.0.0.1";
533 String cdmDB
= "piB_" + database
;
534 String cdmUserName
= "root";
535 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
541 public static ICdmDataSource
mon_cdm() {
542 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
543 String cdmServer
= "localhost";
544 String cdmDB
= "cdm_local";
545 String cdmUserName
= "root";
546 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
549 public static ICdmDataSource
proibiosphere_chenopodium_local() {
550 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
551 String cdmServer
= "localhost";
552 String cdmDB
= "cdm_production_proibiosphere_chenopodium_pilot";
553 String cdmUserName
= "root";
554 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
557 public static ICdmDataSource
proibiosphere_ants_local() {
558 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
559 String cdmServer
= "localhost";
560 String cdmDB
= "cdm_production_proibiosphere_ants_pilot";
561 String cdmUserName
= "root";
562 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
565 public static ICdmDataSource
proibiosphere_fungi_local() {
566 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
567 String cdmServer
= "localhost";
568 String cdmDB
= "cdm_production_proibiosphere_fungi_pilot";
569 String cdmUserName
= "root";
570 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
573 public static ICdmDataSource
proibiosphere_campylopus_local() {
574 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
575 String cdmServer
= "localhost";
576 String cdmDB
= "cdm_production_proibiosphere_campylopus_pilot";
577 String cdmUserName
= "root";
578 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
582 public static ICdmDataSource
proibiosphere_eupolybothrus_local() {
583 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
584 String cdmServer
= "localhost";
585 String cdmDB
= "cdm_production_proibiosphere_eupolybothrus_pilot";
586 String cdmUserName
= "root";
587 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
590 public static ICdmDataSource
proibiosphere_spiders_local() {
591 DatabaseTypeEnum dbType
= DatabaseTypeEnum
.MySQL
;
592 String cdmServer
= "localhost";
593 String cdmDB
= "cdm_production_proibiosphere_spiders_pilot";
594 String cdmUserName
= "root";
595 return makeDestination(dbType
, cdmServer
, cdmDB
, -1, cdmUserName
, null);
602 * TODO only supports MySQL and PostgreSQL
612 public static ICdmDataSource
makeDestination(DatabaseTypeEnum dbType
, String cdmServer
, String cdmDB
, int port
, String cdmUserName
, String pwd
){
613 //establish connection
614 pwd
= AccountStore
.readOrStorePassword(cdmServer
, cdmDB
, cdmUserName
, pwd
);
615 ICdmDataSource destination
;
616 if(dbType
.equals(DatabaseTypeEnum
.MySQL
)){
617 destination
= CdmDataSource
.NewMySqlInstance(cdmServer
, cdmDB
, port
, cdmUserName
, pwd
, null);
618 } else if(dbType
.equals(DatabaseTypeEnum
.PostgreSQL
)){
619 destination
= CdmDataSource
.NewPostgreSQLInstance(cdmServer
, cdmDB
, port
, cdmUserName
, pwd
, null);
622 throw new RuntimeException("Unsupported DatabaseType");
630 * Accepts a string array and tries to find a method returning an ICdmDataSource with
631 * the name of the given first string in the array
636 public static ICdmDataSource
chooseDestination(String
[] args
) {
641 if(args
.length
!= 1) {
645 String possibleDestination
= args
[0];
647 Method
[] methods
= CdmDestinations
.class.getMethods();
649 for (Method method
: methods
){
650 if(method
.getName().equals(possibleDestination
)){
652 return (ICdmDataSource
) method
.invoke(null, null);
653 } catch (Exception e
) {
655 throw new RuntimeException(e
);