Project

General

Profile

Download (20.2 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
	public static ICdmDataSource cdm_test_useSummary(){
28
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
29
		String cdmServer = "localhost";
30
		String cdmDB = "palmae_2011_07_17";
31
		String cdmUserName = "root";
32
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
33
	}
34

    
35
	public static ICdmDataSource cdm_test_local_mysql(){
36
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
37
		String cdmServer = "127.0.0.1";
38
		String cdmDB = "cdm_test";
39
		String cdmUserName = "root";
40
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
41
	}
42

    
43

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

    
52
	public static ICdmDataSource cdm_test_local_mysql_standardliste(){
53
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
54
		String cdmServer = "127.0.0.1";
55
		String cdmDB = "standardliste";
56
		String cdmUserName = "root";
57
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
58
	}
59
	public static ICdmDataSource cdm_test_local_mysql_standardliste2(){
60
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
61
		String cdmServer = "127.0.0.1";
62
		String cdmDB = "standardliste2"; 
63
		String cdmUserName = "root";
64
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
65
	}
66

    
67

    
68
	public static ICdmDataSource cdm_test_local_mysql_dwca(){
69
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
70
		String cdmServer = "127.0.0.1";
71
		String cdmDB = "dwca";
72
		String cdmUserName = "edit";
73
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
74
	}
75

    
76

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

    
85
	public static ICdmDataSource cdm_test_local_mysql_test(){
86
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
87
		String cdmServer = "127.0.0.1";
88
		String cdmDB = "test";
89
		String cdmUserName = "root";     //root on pesiimport2
90
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
91
	}
92

    
93
	public static ICdmDataSource cdm_test_local_euromed(){
94
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
95
		String cdmServer = "127.0.0.1";
96
		String cdmDB = "euroMed";
97
		String cdmUserName = "root";
98
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
99
	}
100
	
101
	public static ICdmDataSource cdm_test_local_euromed2(){
102
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
103
		String cdmServer = "127.0.0.1";
104
		String cdmDB = "euroMed2";
105
		String cdmUserName = "root";
106
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
107
	}
108
	public static ICdmDataSource cdm_test_local_euromed3(){
109
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
110
		String cdmServer = "127.0.0.1";
111
		String cdmDB = "euroMed3";
112
		String cdmUserName = "root";
113
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
114
	}
115
	
116
	
117
	public static ICdmDataSource cdm_local_EDITImport(){
118
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
119
		String cdmServer = "127.0.0.1";
120
		String cdmDB = "EDITImport";
121
		String cdmUserName = "edit";     //root on pesiimport2
122
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
123
	}
124
	
125
	public static ICdmDataSource cdm_test_euroMed(){
126
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
127
		String cdmServer = "160.45.63.175";
128
		String cdmDB = "cdm_test_euromed";
129
		String cdmUserName = "edit";
130
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
131
	}
132

    
133
	public static ICdmDataSource cdm_pesi_euromed(){
134
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
135
		String cdmServer = "160.45.63.175";
136
		String cdmDB = "cdm_pesi_euromed";
137
		String cdmUserName = "edit";
138
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
139
	}
140
	
141
	public static ICdmDataSource cdm_corvidae_dev(){
142
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
143
		String cdmServer = "160.45.63.175";
144
		String cdmDB = "cdm_corvidae";
145
		String cdmUserName = "edit";
146
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
147
	}
148

    
149
	public static ICdmDataSource cdm_ildis_dev(){
150
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
151
		String cdmServer = "160.45.63.175";
152
		String cdmDB = "cdm_edit_ildis";
153
		String cdmUserName = "edit";
154
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
155
	}
156

    
157
//
158
//	public static ICdmDataSource cdm_ildis_production(){
159
//		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
160
//		String cdmServer = "160.45.63.171";
161
//		String cdmDB = "cdm_edit_ildis";
162
//		String cdmUserName = "edit";
163
//		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
164
//	}
165

    
166

    
167
	public static ICdmDataSource cdm_redlist_moose_dev(){
168
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
169
		String cdmServer = "160.45.63.175";
170
		String cdmDB = "cdm_mt_moose";
171
		String cdmUserName = "edit";
172
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
173
	}
174

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

    
183
	public static ICdmDataSource cdm_cyprus_dev(){
184
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
185
		String cdmServer = "160.45.63.175";
186
		String cdmDB = "cdm_cyprus";
187
		String cdmUserName = "edit";
188
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
189
	}
190

    
191
	public static ICdmDataSource cdm_cyprus_production(){
192
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
193
		String cdmServer = "160.45.63.171";
194
		String cdmDB = "cdm_production_cyprus";
195
		String cdmUserName = "edit";
196
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
197
	}
198

    
199
	public static ICdmDataSource cdm_cyprus_production_tunnel(){
200
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
201
		String cdmServer = "127.0.0.1";
202
		int port = 13306;
203
		String cdmDB = "cdm_production_cyprus";
204
		String cdmUserName = "edit";
205
		return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
206
	}
207

    
208
	public static ICdmDataSource cdm_cyprus_dev_tunnel(){
209
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
210
		String cdmServer = "127.0.0.1";
211
		int port = 13306;
212
		String cdmDB = "cdm_cyprus";
213
		String cdmUserName = "edit";
214
		return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
215
	}
216

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

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

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

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

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

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

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

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

    
281
	public static ICdmDataSource cdm_globis_dev(){
282
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
283
		String cdmServer = "160.45.63.175";
284
		String cdmDB = "cdm_edit_globis";
285
		String cdmUserName = "edit";
286
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
287
	}
288
	
289
	public static ICdmDataSource cdm_globis_production(){
290
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
291
		String cdmServer = "160.45.63.171";
292
		String cdmDB = "cdm_production_globis";
293
		String cdmUserName = "edit";
294
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
295
	}
296

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

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

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

    
321

    
322
	public static ICdmDataSource NULL(){
323
		return null;
324
	}
325

    
326

    
327
	public static ICdmDataSource localH2(){
328
		return CdmDataSource.NewH2EmbeddedInstance("cdm", "sa", "");
329
	}
330

    
331
	public static ICdmDataSource localH2(String database, String username, String filePath){
332
		return CdmDataSource.NewH2EmbeddedInstance(database, "sa", "", filePath, null);
333
	}
334

    
335
	public static ICdmDataSource localH2Salvador(){
336
		return CdmDataSource.NewH2EmbeddedInstance("salvador", "sa", "");
337
	}
338

    
339
	public static ICdmDataSource localH2Armeria(){
340
		return CdmDataSource.NewH2EmbeddedInstance("armeria", "sa", "");
341
	}
342

    
343

    
344
	public static ICdmDataSource localH2Cichorieae(){
345
		return CdmDataSource.NewH2EmbeddedInstance("cichorieae", "sa", "");
346
	}
347

    
348
	public static ICdmDataSource localH2Palmae(){
349
		return CdmDataSource.NewH2EmbeddedInstance("palmae", "sa", "");
350
	}
351

    
352
	public static ICdmDataSource localH2EuroMed(){
353
		return CdmDataSource.NewH2EmbeddedInstance("euroMed", "sa", "");
354
	}
355

    
356
	public static ICdmDataSource localH2Erms(){
357
		return CdmDataSource.NewH2EmbeddedInstance("erms", "sa", "");
358
	}
359

    
360

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

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

    
377
	public static ICdmDataSource cdm_edit_cichorieae_local_PG(){
378
		DatabaseTypeEnum dbType = DatabaseTypeEnum.PostgreSQL;
379
		String cdmServer = "127.0.0.1";
380
		String cdmDB = "cdm_edit_cichorieae_a";
381
		String cdmUserName = "edit";
382
		int port = 15432;
383
		return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
384
	}
385

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

    
394
	public static ICdmDataSource cdm_production_cichorieae(){
395
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
396
		String cdmServer = "160.45.63.171";
397
//		String cdmServer = "127.0.0.1";
398
		String cdmDB = "cdm_production_cichorieae";
399
		String cdmUserName = "edit";
400
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
401
	}
402

    
403
	public static ICdmDataSource cdm_production_palmae(){
404
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
405
		String cdmServer = "160.45.63.171";
406
		String cdmDB = "cdm_production_palmae";
407
		String cdmUserName = "edit";
408
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
409
	}
410
	
411
	public static ICdmDataSource cdm_production_flora_deutschland(){
412
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
413
		String cdmServer = "160.45.63.171";
414
		String cdmDB = "cdm_production_rl_standardliste";
415
		String cdmUserName = "edit";
416
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
417
	}
418

    
419

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

    
428
	public static ICdmDataSource cdm_edit_cichorieae_preview(){
429
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
430
		String cdmServer = "127.0.0.1";
431
		String cdmDB = "cdm_edit_cichorieae";
432
		String cdmUserName = "edit";
433
		int port = 13306;
434
		return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
435
	}
436

    
437
	public static ICdmDataSource cdm_edit_cichorieae_preview_direct(){
438
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
439
		String cdmServer = "160.45.63.175";
440
		String cdmDB = "cdm_edit_cichorieae";
441
		String cdmUserName = "edit";
442
		int port = 3306;
443
		return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
444
	}
445

    
446
	public static ICdmDataSource cdm_production_piB(String database){
447
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
448
		String cdmServer = "160.45.63.171";
449
		String cdmDB = "cdm_production_" + database + "_pilot";
450
		String cdmUserName = "edit";
451
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
452
	}
453
	
454
	public static ICdmDataSource cdm_local_piB(String database){
455
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
456
		String cdmServer = "127.0.0.1";
457
		String cdmDB = "piB_" + database;
458
		String cdmUserName = "root";
459
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
460
	}
461
	
462
	/**
463
     * patricia
464
     */
465
    public static ICdmDataSource mon_cdm() {
466
        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
467
        String cdmServer = "localhost";
468
        String cdmDB = "cdm_local";
469
        String cdmUserName = "root";
470
        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
471
    }
472

    
473
   public static ICdmDataSource proibiosphere_chenopodium_local() {
474
        DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
475
        String cdmServer = "localhost";
476
        String cdmDB = "cdm_production_proibiosphere_chenopodium_pilot";
477
        String cdmUserName = "root";
478
        return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
479
    }
480

    
481
   public static ICdmDataSource proibiosphere_ants_local() {
482
       DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
483
       String cdmServer = "localhost";
484
       String cdmDB = "cdm_production_proibiosphere_ants_pilot";
485
       String cdmUserName = "root";
486
       return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
487
   }
488

    
489
   public static ICdmDataSource proibiosphere_fungi_local() {
490
       DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
491
       String cdmServer = "localhost";
492
       String cdmDB = "cdm_production_proibiosphere_fungi_pilot";
493
       String cdmUserName = "root";
494
       return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
495
   }
496

    
497
   public static ICdmDataSource proibiosphere_campylopus_local() {
498
       DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
499
       String cdmServer = "localhost";
500
       String cdmDB = "cdm_production_proibiosphere_campylopus_pilot";
501
       String cdmUserName = "root";
502
       return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
503
   }
504

    
505

    
506
   public static ICdmDataSource proibiosphere_eupolybothrus_local() {
507
       DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
508
       String cdmServer = "localhost";
509
       String cdmDB = "cdm_production_proibiosphere_eupolybothrus_pilot";
510
       String cdmUserName = "root";
511
       return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
512
   }
513

    
514
   public static ICdmDataSource proibiosphere_spiders_local() {
515
       DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
516
       String cdmServer = "localhost";
517
       String cdmDB = "cdm_production_proibiosphere_spiders_pilot";
518
       String cdmUserName = "root";
519
       return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
520
   }
521
//	public static ICdmDataSource LAPTOP_HP(){
522
//		DatabaseTypeEnum dbType = DatabaseTypeEnum.SqlServer2005;
523
//		String cdmServer = "LAPTOPHP";
524
//		String cdmDB = "cdmTest";
525
//		String cdmUserName = "edit";
526
//		return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);
527
//	}
528

    
529

    
530

    
531

    
532
	/**
533
	 * initializes source
534
	 * TODO only supports MySQL and PostgreSQL
535
	 *
536
	 * @param dbType
537
	 * @param cdmServer
538
	 * @param cdmDB
539
	 * @param port
540
	 * @param cdmUserName
541
	 * @param pwd
542
	 * @return
543
	 */
544
	public static ICdmDataSource makeDestination(DatabaseTypeEnum dbType, String cdmServer, String cdmDB, int port, String cdmUserName, String pwd ){
545
		//establish connection
546
		pwd = AccountStore.readOrStorePassword(cdmServer, cdmDB, cdmUserName, pwd);
547
		ICdmDataSource destination;
548
		if(dbType.equals(DatabaseTypeEnum.MySQL)){
549
			destination = CdmDataSource.NewMySqlInstance(cdmServer, cdmDB, port, cdmUserName, pwd, null);
550
		} else if(dbType.equals(DatabaseTypeEnum.PostgreSQL)){
551
			destination = CdmDataSource.NewPostgreSQLInstance(cdmServer, cdmDB, port, cdmUserName, pwd, null);
552
		} else {
553
			//TODO others
554
			throw new RuntimeException("Unsupported DatabaseType");
555
		}
556
		return destination;
557

    
558
	}
559

    
560

    
561
	/**
562
	 * Accepts a string array and tries to find a method returning an ICdmDataSource with
563
	 * the name of the given first string in the array
564
	 *
565
	 * @param args
566
	 * @return
567
	 */
568
	public static ICdmDataSource chooseDestination(String[] args) {
569
		if(args == null) {
570
            return null;
571
        }
572

    
573
		if(args.length != 1) {
574
            return null;
575
        }
576

    
577
		String possibleDestination = args[0];
578

    
579
		Method[] methods = CdmDestinations.class.getMethods();
580

    
581
		for (Method method : methods){
582
			if(method.getName().equals(possibleDestination)){
583
				try {
584
					return (ICdmDataSource) method.invoke(null, null);
585
				} catch (IllegalArgumentException e) {
586
					// TODO Auto-generated catch block
587
					e.printStackTrace();
588
				} catch (IllegalAccessException e) {
589
					// TODO Auto-generated catch block
590
					e.printStackTrace();
591
				} catch (InvocationTargetException e) {
592
					// TODO Auto-generated catch block
593
					e.printStackTrace();
594
				}
595
			}
596
		}
597
		return null;
598
	}
599

    
600
}
601

    
(3-3/6)