Project

General

Profile

Download (20.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.InvocationTargetException;
13
import java.lang.reflect.Method;
14

    
15
import org.apache.log4j.Logger;
16

    
17
import eu.etaxonomy.cdm.common.AccountStore;
18
import eu.etaxonomy.cdm.database.CdmDataSource;
19
import eu.etaxonomy.cdm.database.DatabaseTypeEnum;
20
import eu.etaxonomy.cdm.database.ICdmDataSource;
21

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

    
26
	/**
27
	 * Intended to be used for imports
28
	 */
29
	public static ICdmDataSource import_a(){
30
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
31
		String cdmServer = "localhost";
32
		String cdmDB = "import_a";
33
		String cdmUserName = "root";
34
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
35
	}
36

    
37
	public static ICdmDataSource cdm_test_useSummary(){
38
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
39
		String cdmServer = "localhost";
40
		String cdmDB = "palmae_2011_07_17";
41
		String cdmUserName = "root";
42
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
43
	}
44

    
45
	public static ICdmDataSource cdm_test_local_mysql(){
46
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
47
		String cdmServer = "127.0.0.1";
48
		String cdmDB = "cdm_test";
49
		String cdmUserName = "root";
50
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
51
	}
52

    
53

    
54
	public static ICdmDataSource cdm_test_local_mysql_moose(){
55
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
56
		String cdmServer = "127.0.0.1";
57
		String cdmDB = "moose";
58
		String cdmUserName = "root";
59
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
60
	}
61

    
62
	public static ICdmDataSource cdm_test_local_mysql_standardliste(){
63
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
64
		String cdmServer = "127.0.0.1";
65
		String cdmDB = "standardliste";
66
		String cdmUserName = "root";
67
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
68
	}
69
	public static ICdmDataSource cdm_test_local_mysql_standardliste2(){
70
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
71
		String cdmServer = "127.0.0.1";
72
		String cdmDB = "standardliste2"; 
73
		String cdmUserName = "root";
74
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
75
	}
76

    
77

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

    
86

    
87
	public static ICdmDataSource cdm_test_local_mysql_fdac(){
88
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
89
		String cdmServer = "127.0.0.1";
90
		String cdmDB = "fdac";
91
		String cdmUserName = "edit";
92
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
93
	}
94

    
95
	public static ICdmDataSource cdm_test_local_mysql_test(){
96
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
97
		String cdmServer = "127.0.0.1";
98
		String cdmDB = "test";
99
		String cdmUserName = "edit";     //root on pesiimport2
100
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
101
	}
102
	
103
	public static ICdmDataSource cdm_local_EDITImport(){
104
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
105
		String cdmServer = "127.0.0.1";
106
		String cdmDB = "EDITImport";
107
		String cdmUserName = "edit";     //root on pesiimport2
108
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
109
	}
110

    
111
	public static ICdmDataSource cdm_corvidae_dev(){
112
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
113
		String cdmServer = "160.45.63.175";
114
		String cdmDB = "cdm_corvidae";
115
		String cdmUserName = "edit";
116
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
117
	}
118

    
119
	public static ICdmDataSource cdm_ildis_dev(){
120
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
121
		String cdmServer = "160.45.63.175";
122
		String cdmDB = "cdm_edit_ildis";
123
		String cdmUserName = "edit";
124
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
125
	}
126

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

    
136

    
137
	public static ICdmDataSource cdm_redlist_moose_dev(){
138
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
139
		String cdmServer = "160.45.63.175";
140
		String cdmDB = "cdm_mt_moose";
141
		String cdmUserName = "edit";
142
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
143
	}
144

    
145
	public static ICdmDataSource cdm_redlist_standardlist_dev(){
146
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
147
		String cdmServer = "160.45.63.175";
148
		String cdmDB = "cdm_mt_standardliste";
149
		String cdmUserName = "edit";
150
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
151
	}
152

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

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

    
169
	public static ICdmDataSource cdm_cyprus_production_tunnel(){
170
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
171
		String cdmServer = "127.0.0.1";
172
		int port = 13306;
173
		String cdmDB = "cdm_production_cyprus";
174
		String cdmUserName = "edit";
175
		return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
176
	}
177

    
178
	public static ICdmDataSource cdm_cyprus_dev_tunnel(){
179
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
180
		String cdmServer = "127.0.0.1";
181
		int port = 13306;
182
		String cdmDB = "cdm_cyprus";
183
		String cdmUserName = "edit";
184
		return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
185
	}
186

    
187
	public static ICdmDataSource cdm_campanulaceae_production(){
188
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
189
		String cdmServer = "160.45.63.171";
190
		String cdmDB = "cdm_production_campanulaceae";
191
		String cdmUserName = "edit";
192
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
193
	}
194

    
195
	public static ICdmDataSource cdm_flora_malesiana_preview(){
196
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
197
		String cdmServer = "160.45.63.175";
198
		String cdmDB = "cdm_edit_flora_malesiana";
199
		String cdmUserName = "edit";
200
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
201
	}
202

    
203
	public static ICdmDataSource cdm_flora_malesiana_production(){
204
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
205
		String cdmServer = "160.45.63.171";
206
		String cdmDB = "cdm_production_flora_malesiana";
207
		String cdmUserName = "edit";
208
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
209
	}
210

    
211
	public static ICdmDataSource cdm_portal_test_localhost(){
212
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
213
		String cdmServer = "127.0.0.1";
214
		String cdmDB = "cdm_portal_test";
215
		String cdmUserName = "edit";
216
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
217
	}
218

    
219
	public static ICdmDataSource cdm_portal_test_localhost2(){
220
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
221
		String cdmServer = "127.0.0.1";
222
		String cdmDB = "cdm_portal_test2";
223
		String cdmUserName = "edit";
224
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
225
	}
226

    
227
	public static ICdmDataSource cdm_local_cichorieae(){
228
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
229
		String cdmServer = "127.0.0.1";
230
		String cdmDB = "cdm_edit_cichorieae";
231
		String cdmUserName = "edit";
232
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
233
	}
234

    
235
	public static ICdmDataSource cdm_local_dipera(){
236
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
237
		String cdmServer = "127.0.0.1";
238
		String cdmDB = "cdm_edit_diptera";
239
		String cdmUserName = "edit";
240
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
241
	}
242

    
243
	public static ICdmDataSource cdm_local_palmae(){
244
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
245
		String cdmServer = "127.0.0.1";
246
		String cdmDB = "cdm_edit_palmae";
247
		String cdmUserName = "edit";
248
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
249
	}
250

    
251
	public static ICdmDataSource cdm_globis_dev(){
252
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
253
		String cdmServer = "160.45.63.175";
254
		String cdmDB = "cdm_edit_globis";
255
		String cdmUserName = "edit";
256
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
257
	}
258
	
259
	public static ICdmDataSource cdm_globis_production(){
260
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
261
		String cdmServer = "160.45.63.171";
262
		String cdmDB = "cdm_production_globis";
263
		String cdmUserName = "edit";
264
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
265
	}
266

    
267
	public static ICdmDataSource cdm_local_globis(){
268
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
269
		String cdmServer = "127.0.0.1";
270
		String cdmDB = "cdm_globis";
271
		String cdmUserName = "edit";
272
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
273
	}
274

    
275
	public static ICdmDataSource cdm_local_postgres_CdmTest(){
276
		DatabaseTypeEnum dbType = DatabaseTypeEnum.PostgreSQL;
277
		String cdmServer = "127.0.0.1";
278
		String cdmDB = "CdmTest";
279
		String cdmUserName = "edit";
280
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
281
	}
282

    
283
	public static ICdmDataSource cdm_local_tdwg2010(){
284
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
285
		String cdmServer = "127.0.0.1";
286
		String cdmDB = "cdm_tdwg2010";
287
		String cdmUserName = "edit";
288
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
289
	}
290

    
291

    
292
	public static ICdmDataSource NULL(){
293
		return null;
294
	}
295

    
296

    
297
	public static ICdmDataSource localH2(){
298
		return CdmDataSource.NewH2EmbeddedInstance("cdm", "sa", "");
299
	}
300

    
301
	public static ICdmDataSource localH2(String database, String username, String filePath){
302
		return CdmDataSource.NewH2EmbeddedInstance(database, "sa", "", filePath, null);
303
	}
304

    
305
	public static ICdmDataSource localH2Salvador(){
306
		return CdmDataSource.NewH2EmbeddedInstance("salvador", "sa", "");
307
	}
308

    
309
	public static ICdmDataSource localH2Diptera(){
310
		return CdmDataSource.NewH2EmbeddedInstance("diptera", "sa", "");
311
	}
312

    
313

    
314
	public static ICdmDataSource localH2Cichorieae(){
315
		return CdmDataSource.NewH2EmbeddedInstance("cichorieae", "sa", "");
316
	}
317

    
318
	public static ICdmDataSource localH2Palmae(){
319
		return CdmDataSource.NewH2EmbeddedInstance("palmae", "sa", "");
320
	}
321

    
322
	public static ICdmDataSource localH2EuroMed(){
323
		return CdmDataSource.NewH2EmbeddedInstance("euroMed", "sa", "");
324
	}
325

    
326
	public static ICdmDataSource localH2Erms(){
327
		return CdmDataSource.NewH2EmbeddedInstance("erms", "sa", "");
328
	}
329

    
330

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

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

    
347
	public static ICdmDataSource cdm_edit_cichorieae_local_PG(){
348
		DatabaseTypeEnum dbType = DatabaseTypeEnum.PostgreSQL;
349
		String cdmServer = "127.0.0.1";
350
		String cdmDB = "cdm_edit_cichorieae_a";
351
		String cdmUserName = "edit";
352
		int port = 15432;
353
		return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
354
	}
355

    
356
	public static ICdmDataSource cdm_cichorieae_preview(){
357
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
358
		String cdmServer = "160.45.63.175";
359
		String cdmDB = "cdm_edit_cichorieae";
360
		String cdmUserName = "edit";
361
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
362
	}
363

    
364
	public static ICdmDataSource cdm_production_cichorieae(){
365
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
366
		String cdmServer = "160.45.63.171";
367
//		String cdmServer = "127.0.0.1";
368
		String cdmDB = "cdm_production_cichorieae";
369
		String cdmUserName = "edit";
370
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
371
	}
372

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

    
381

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

    
390
	public static ICdmDataSource local_cdm_edit_cichorieae_a(){
391
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
392
		String cdmServer = "127.0.0.1";
393
		String cdmDB = "cdm_edit_cichorieae_a";
394
		String cdmUserName = "edit";
395
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
396
	}
397

    
398
	public static ICdmDataSource cdm_edit_palmae_a(){
399
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
400
		String cdmServer = "192.168.2.10";
401
		String cdmDB = "cdm_edit_palmae_a";
402
		String cdmUserName = "edit";
403
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
404
	}
405

    
406
	public static ICdmDataSource cdm_edit_cichorieae_preview(){
407
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
408
		String cdmServer = "127.0.0.1";
409
		String cdmDB = "cdm_edit_cichorieae";
410
		String cdmUserName = "edit";
411
		int port = 13306;
412
		return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
413
	}
414

    
415
	public static ICdmDataSource cdm_edit_cichorieae_preview_direct(){
416
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
417
		String cdmServer = "160.45.63.175";
418
		String cdmDB = "cdm_edit_cichorieae";
419
		String cdmUserName = "edit";
420
		int port = 3306;
421
		return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
422
	}
423

    
424
	public static ICdmDataSource cdm_edit_cichorieae_integration(){
425
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
426
		String cdmServer = "127.0.0.1";
427
		String cdmDB = "cdm_integration_cichorieae";
428
		String cdmUserName = "edit";
429
		int port = 13306;
430
		return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
431
	}
432

    
433
	public static ICdmDataSource cdm_edit_palmae_preview(){
434
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
435
		String cdmServer = "127.0.0.1";
436
		String cdmDB = "cdm_edit_palmae";
437
		String cdmUserName = "edit";
438
		int port = 13306;
439
		return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
440
	}
441

    
442
	public static ICdmDataSource cdm_edit_salvador(){
443
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
444
		String cdmServer = "192.168.2.10";
445
		String cdmDB = "cdm_edit_salvador";
446
		String cdmUserName = "edit";
447
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
448
	}
449

    
450
	public static ICdmDataSource cdm_import_salvador() {
451
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
452
		String cdmServer = "192.168.2.10";
453
		String cdmDB = "cdm_import_salvador";
454
		String cdmUserName = "edit";
455
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
456
	}
457

    
458
	public static ICdmDataSource cdm_salvador_production() {
459
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
460
		String cdmServer = "192.168.2.10";
461
		String cdmDB = "salvador_cdm";
462
		String cdmUserName = "salvador";
463
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
464
	}
465

    
466
	/**
467
     * patricia
468
     */
469
    public static ICdmDataSource mon_cdm() {
470
        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
471
        String cdmServer = "localhost";
472
        String cdmDB = "cdm_local";
473
        String cdmUserName = "root";
474
        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
475
    }
476

    
477
    public static ICdmDataSource mon_corvids() {
478
        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
479
        String cdmServer = "localhost";
480
        String cdmDB = "cdm_production_corvidae";
481
        String cdmUserName = "root";
482
        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, "mysqlr00t");
483
    }
484

    
485
   public static ICdmDataSource proibiosphere_chenopodium_local() {
486
        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
487
        String cdmServer = "localhost";
488
        String cdmDB = "cdm_production_proibiosphere_chenopodium_pilot";
489
        String cdmUserName = "root";
490
        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
491
    }
492

    
493
   public static ICdmDataSource proibiosphere_ants_local() {
494
       DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
495
       String cdmServer = "localhost";
496
       String cdmDB = "cdm_production_proibiosphere_ants_pilot";
497
       String cdmUserName = "root";
498
       return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
499
   }
500

    
501
   public static ICdmDataSource proibiosphere_fungi_local() {
502
       DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
503
       String cdmServer = "localhost";
504
       String cdmDB = "cdm_production_proibiosphere_fungi_pilot";
505
       String cdmUserName = "root";
506
       return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
507
   }
508

    
509
   public static ICdmDataSource proibiosphere_campylopus_local() {
510
       DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
511
       String cdmServer = "localhost";
512
       String cdmDB = "cdm_production_proibiosphere_campylopus_pilot";
513
       String cdmUserName = "root";
514
       return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
515
   }
516

    
517

    
518
   public static ICdmDataSource proibiosphere_eupolybothrus_local() {
519
       DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
520
       String cdmServer = "localhost";
521
       String cdmDB = "cdm_production_proibiosphere_eupolybothrus_pilot";
522
       String cdmUserName = "root";
523
       return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
524
   }
525

    
526
   public static ICdmDataSource proibiosphere_spiders_local() {
527
       DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
528
       String cdmServer = "localhost";
529
       String cdmDB = "cdm_production_proibiosphere_spiders_pilot";
530
       String cdmUserName = "root";
531
       return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
532
   }
533
//	public static ICdmDataSource LAPTOP_HP(){
534
//		DatabaseTypeEnum dbType = DatabaseTypeEnum.SqlServer2005;
535
//		String cdmServer = "LAPTOPHP";
536
//		String cdmDB = "cdmTest";
537
//		String cdmUserName = "edit";
538
//		return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);
539
//	}
540

    
541

    
542

    
543

    
544
	/**
545
	 * initializes source
546
	 * TODO only supports MySQL and PostgreSQL
547
	 *
548
	 * @param dbType
549
	 * @param cdmServer
550
	 * @param cdmDB
551
	 * @param port
552
	 * @param cdmUserName
553
	 * @param pwd
554
	 * @return
555
	 */
556
	public static ICdmDataSource makeDestination(DatabaseTypeEnum dbType, String cdmServer, String cdmDB, int port, String cdmUserName, String pwd ){
557
		//establish connection
558
		pwd = AccountStore.readOrStorePassword(cdmServer, cdmDB, cdmUserName, pwd);
559
		ICdmDataSource destination;
560
		if(dbType.equals(DatabaseTypeEnum.MySQL)){
561
			destination = CdmDataSource.NewMySqlInstance(cdmServer, cdmDB, port, cdmUserName, pwd, null);
562
		} else if(dbType.equals(DatabaseTypeEnum.PostgreSQL)){
563
			destination = CdmDataSource.NewPostgreSQLInstance(cdmServer, cdmDB, port, cdmUserName, pwd, null);
564
		} else {
565
			//TODO others
566
			throw new RuntimeException("Unsupported DatabaseType");
567
		}
568
		return destination;
569

    
570
	}
571

    
572

    
573
	/**
574
	 * Accepts a string array and tries to find a method returning an ICdmDataSource with
575
	 * the name of the given first string in the array
576
	 *
577
	 * @param args
578
	 * @return
579
	 */
580
	public static ICdmDataSource chooseDestination(String[] args) {
581
		if(args == null) {
582
            return null;
583
        }
584

    
585
		if(args.length != 1) {
586
            return null;
587
        }
588

    
589
		String possibleDestination = args[0];
590

    
591
		Method[] methods = CdmDestinations.class.getMethods();
592

    
593
		for (Method method : methods){
594
			if(method.getName().equals(possibleDestination)){
595
				try {
596
					return (ICdmDataSource) method.invoke(null, null);
597
				} catch (IllegalArgumentException e) {
598
					// TODO Auto-generated catch block
599
					e.printStackTrace();
600
				} catch (IllegalAccessException e) {
601
					// TODO Auto-generated catch block
602
					e.printStackTrace();
603
				} catch (InvocationTargetException e) {
604
					// TODO Auto-generated catch block
605
					e.printStackTrace();
606
				}
607
			}
608
		}
609
		return null;
610
	}
611

    
612
}
613

    
(3-3/6)