Project

General

Profile

Download (23.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
	public static ICdmDataSource cdm_1_1(){
27
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
28
		String cdmServer = "192.168.2.10";
29
		String cdmDB = "cdm_1_1"; // values: "cdm_1_1"  "cdm_build"
30
		String cdmUserName = "edit";
31
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
32
	}
33
	
34
	
35
	public static ICdmDataSource cdm_build(){
36
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
37
		String cdmServer = "192.168.2.10";
38
		String cdmDB = "cdm_build"; // values: "cdm_1_1"  "cdm_build"
39
		String cdmUserName = "edit";
40
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
41
	}
42
	
43
	/**
44
	 * Intended to be used for imports
45
	 */
46
	public static ICdmDataSource import_a(){
47
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
48
		String cdmServer = "localhost";
49
		String cdmDB = "import_a";
50
		String cdmUserName = "root";
51
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
52
	}
53
	
54
	public static ICdmDataSource cdm_import(){
55
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
56
		String cdmServer = "192.168.2.10";
57
		String cdmDB = "cdm_import";
58
		String cdmUserName = "edit";
59
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
60
	}
61
	
62
	public static ICdmDataSource cdm_test(){
63
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
64
		String cdmServer = "192.168.2.10";
65
		String cdmDB = "cdm_test"; // values: "cdm_1_1"  "cdm_build"
66
		String cdmUserName = "edit";
67
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
68
	}
69
	
70
	public static ICdmDataSource cdm_test_jaxb(){
71
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
72
		String cdmServer = "192.168.2.10";
73
		String cdmDB = "cdm_test_jaxb"; 
74
		String cdmUserName = "edit";
75
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
76
	}
77
	
78
	public static ICdmDataSource cdm_test_jaxb2(){
79
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
80
		String cdmServer = "192.168.2.10";
81
		String cdmDB = "cdm_test_jaxb2"; 
82
		String cdmUserName = "edit";
83
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
84
	}
85

    
86
	
87
	public static ICdmDataSource cdm_test_andreas_palmae(){
88
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
89
		String cdmServer = "192.168.2.10";
90
		String cdmDB = "cdm_test_andreas_palmae"; 
91
		String cdmUserName = "edit";
92
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
93
	}
94
	
95
	public static ICdmDataSource cdm_test_andreas_cichorieae(){
96
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
97
		String cdmServer = "192.168.2.10";
98
		String cdmDB = "cdm_test_andreas_cichorieae"; 
99
		String cdmUserName = "edit";
100
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
101
	}
102
	
103
	public static ICdmDataSource cdm_test_andreasM(){
104
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
105
		String cdmServer = "192.168.2.10";
106
		String cdmDB = "cdm_test_andreasM"; 
107
		String cdmUserName = "edit";
108
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
109
	}
110
	
111
	public static ICdmDataSource cdm_test_andreasM2(){
112
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
113
		String cdmServer = "192.168.2.10";
114
		String cdmDB = "cdm_test_andreasM2"; 
115
		String cdmUserName = "edit";
116
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
117
	}
118
	
119
	public static ICdmDataSource cdm_test_andreasM3(){
120
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
121
		String cdmServer = "192.168.2.10";
122
		String cdmDB = "cdm_test_andreasM3"; 
123
		String cdmUserName = "edit";
124
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
125
	}
126
	
127
	
128
	public static ICdmDataSource cdm_editor2(){
129
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
130
		String cdmServer = "192.168.2.10";
131
		String cdmDB = "cdm_editor_test2"; 
132
		String cdmUserName = "edit";
133
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
134
	}
135
	
136
		public static ICdmDataSource cdm_portal(){
137
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
138
		String cdmServer = "192.168.2.10";
139
		String cdmDB = "cdm_portal";
140
		String cdmUserName = "edit";
141
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
142
	}
143
	
144
	public static ICdmDataSource cdm_portal_test(){
145
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
146
		String cdmServer = "192.168.2.10";
147
		String cdmDB = "cdm_portal_test";
148
		String cdmUserName = "edit";
149
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
150
	}
151
	
152
	public static ICdmDataSource cdm_test_patricia(){
153
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
154
		String cdmServer = "192.168.2.10";
155
		String cdmDB = "cdm_test_patricia";
156
		String cdmUserName = "edit";
157
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
158
	}
159

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

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

    
176
	public static ICdmDataSource cdm_test_niels1(){
177
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
178
		String cdmServer = "192.168.2.10";
179
		String cdmDB = "cdm_test_niels1";
180
		String cdmUserName = "edit";
181
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
182
	}
183
	
184
	public static ICdmDataSource cdm_test_niels2(){
185
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
186
		String cdmServer = "192.168.2.10";
187
		String cdmDB = "cdm_test_niels2";
188
		String cdmUserName = "edit";
189
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
190
	}
191
	
192
	//
193
	public static ICdmDataSource cdm_test_andreasK1(){
194
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
195
		String cdmServer = "192.168.2.10";
196
		String cdmDB = "cdm_test_andreasK1";
197
		String cdmUserName = "edit";
198
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
199
	}
200
	
201
	public static ICdmDataSource cdm_test_andreasK2(){
202
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
203
		String cdmServer = "192.168.2.10";
204
		String cdmDB = "cdm_test_andreasK2";
205
		String cdmUserName = "edit";
206
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
207
	}
208
	
209

    
210
	public static ICdmDataSource cdm_pesi_erms(){
211
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
212
		String cdmServer = "192.168.2.10";
213
		String cdmDB = "cdm_pesi_erms";
214
		String cdmUserName = "edit";
215
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
216
	}
217
	
218
	public static ICdmDataSource cdm_campanulaceae(){
219
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
220
		String cdmServer = "192.168.2.10";
221
		String cdmDB = "cdm_campanulaceae";
222
		String cdmUserName = "edit";
223
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
224
	}
225
	
226
	public static ICdmDataSource cdm_campanulaceae_production(){
227
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
228
		String cdmServer = "160.45.63.151";
229
		String cdmDB = "cdm_production_campanulaceae";
230
		String cdmUserName = "edit";
231
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
232
	}
233
	
234
	public static ICdmDataSource cdm_flora_malesiana_preview(){
235
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
236
		String cdmServer = "160.45.63.201";
237
		String cdmDB = "cdm_edit_flora_malesiana_a";
238
		String cdmUserName = "edit";
239
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
240
	}
241

    
242
	public static ICdmDataSource cdm_flora_malesiana_production(){
243
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
244
		String cdmServer = "160.45.63.151";
245
		String cdmDB = "cdm_production_flora_malesiana";
246
		String cdmUserName = "edit";
247
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
248
	}
249
	
250
	public static ICdmDataSource cdm_flora_central_africa_preview(){
251
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
252
		String cdmServer = "160.45.63.201";
253
		String cdmDB = "cdm_edit_flora_central_africa";
254
		String cdmUserName = "edit";
255
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
256
	}
257
	
258
	public static ICdmDataSource cdm_flora_central_africa_production(){
259
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
260
		String cdmServer = "160.45.63.151";
261
		String cdmDB = "cdm_production_flora_central_africa";
262
		String cdmUserName = "edit";
263
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
264
	}
265
	
266
	public static ICdmDataSource cdm_pesi_euroMed(){
267
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
268
		String cdmServer = "192.168.2.10";
269
		String cdmDB = "cdm_pesi_euroMed";
270
		String cdmUserName = "edit";
271
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
272
	}
273
	
274
	public static ICdmDataSource cdm_pesi_all(){
275
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
276
		String cdmServer = "192.168.2.10";
277
		String cdmDB = "cdm_pesi_all";
278
		String cdmUserName = "edit";
279
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
280
	}
281
	
282
	public static ICdmDataSource cdm_portal_test_localhost(){
283
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
284
		String cdmServer = "127.0.0.1";
285
		String cdmDB = "cdm_portal_test";
286
		String cdmUserName = "edit";
287
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
288
	}
289
	
290
	public static ICdmDataSource cdm_portal_test_localhost2(){
291
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
292
		String cdmServer = "127.0.0.1";
293
		String cdmDB = "cdm_portal_test2";
294
		String cdmUserName = "edit";
295
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
296
	}
297
	
298
	public static ICdmDataSource cdm_local_cichorieae(){
299
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
300
		String cdmServer = "127.0.0.1";
301
		String cdmDB = "cdm_edit_cichorieae";
302
		String cdmUserName = "edit";
303
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
304
	}
305
	
306
	public static ICdmDataSource cdm_local_dipera(){
307
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
308
		String cdmServer = "127.0.0.1";
309
		String cdmDB = "cdm_edit_diptera";
310
		String cdmUserName = "edit";
311
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
312
	}
313
	
314
	public static ICdmDataSource cdm_local_palmae(){
315
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
316
		String cdmServer = "127.0.0.1";
317
		String cdmDB = "cdm_edit_palmae";
318
		String cdmUserName = "edit";
319
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
320
	}
321
	
322
	public static ICdmDataSource cdm_local_globis(){
323
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
324
		String cdmServer = "127.0.0.1";
325
		String cdmDB = "cdm_globis";
326
		String cdmUserName = "edit";
327
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
328
	}
329
	
330
	public static ICdmDataSource cdm_local_cichorieae_d(){
331
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
332
		String cdmServer = "127.0.0.1";
333
		String cdmDB = "cdm_edit_cichorieae_d";
334
		String cdmUserName = "root";
335
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
336
	}
337
	
338
	public static ICdmDataSource cdm_local_postgres_CdmTest(){
339
		DatabaseTypeEnum dbType = DatabaseTypeEnum.PostgreSQL;
340
		String cdmServer = "127.0.0.1";
341
		String cdmDB = "CdmTest";
342
		String cdmUserName = "edit";
343
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
344
	}
345

    
346
	public static ICdmDataSource cdm_local_tdwg2010(){
347
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
348
		String cdmServer = "127.0.0.1";
349
		String cdmDB = "cdm_tdwg2010";
350
		String cdmUserName = "edit";
351
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
352
	}
353
	
354
	
355
	public static ICdmDataSource NULL(){
356
		return null;
357
	}
358
	
359
	
360
	public static ICdmDataSource localH2(){
361
		return CdmDataSource.NewH2EmbeddedInstance("cdm", "sa", "");
362
	}
363
	
364
	public static ICdmDataSource localH2(String database, String username, String filePath){
365
		return CdmDataSource.NewH2EmbeddedInstance(database, "sa", "", filePath, null);
366
	}
367
	
368
	public static ICdmDataSource localH2Salvador(){
369
		return CdmDataSource.NewH2EmbeddedInstance("salvador", "sa", "");
370
	}
371
	
372
	public static ICdmDataSource localH2Diptera(){
373
		return CdmDataSource.NewH2EmbeddedInstance("diptera", "sa", "");
374
	}
375
	
376
	
377
	public static ICdmDataSource localH2Cichorieae(){
378
		return CdmDataSource.NewH2EmbeddedInstance("cichorieae", "sa", "");
379
	}
380
	
381
	public static ICdmDataSource localH2Palmae(){
382
		return CdmDataSource.NewH2EmbeddedInstance("palmae", "sa", "");
383
	}
384
	
385
	public static ICdmDataSource localH2EuroMed(){
386
		return CdmDataSource.NewH2EmbeddedInstance("euroMed", "sa", "");
387
	}
388
	
389
	public static ICdmDataSource localH2Erms(){
390
		return CdmDataSource.NewH2EmbeddedInstance("erms", "sa", "");
391
	}
392
	
393
	public static ICdmDataSource localH2_viola(){
394
		return CdmDataSource.NewH2EmbeddedInstance("testViola", "sa", "");
395
	}
396
	
397
	public static ICdmDataSource localH2_LIAS(){
398
		return CdmDataSource.NewH2EmbeddedInstance("testLIAS", "sa", "");
399
	}
400
	
401
	public static ICdmDataSource localH2_Erythroneura(){
402
		return CdmDataSource.NewH2EmbeddedInstance("testErythroneura", "sa", "");
403
	}
404
	
405
	public static ICdmDataSource localH2_Cicad(){
406
		return CdmDataSource.NewH2EmbeddedInstance("testCicad", "sa", "");
407
	}
408
	
409
	public static ICdmDataSource localH2_ValRosandraFRIDAKey(){
410
		return CdmDataSource.NewH2EmbeddedInstance("testValRosandraFRIDAKey", "sa", "");
411
	}
412
	
413
	public static ICdmDataSource localH2_FreshwaterAquaticInsects(){
414
		return CdmDataSource.NewH2EmbeddedInstance("testFreshwaterAquaticInsects", "sa", "");
415
	}
416
	
417
	public static ICdmDataSource cdm_portal_test_pollux(){
418
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
419
		String cdmServer = "192.168.2.11";
420
		String cdmDB = "cdm_portal_test";
421
		String cdmUserName = "edit";
422
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
423
	}
424
	
425
	public static ICdmDataSource cdm_edit_cichorieae_PG(){
426
		DatabaseTypeEnum dbType = DatabaseTypeEnum.PostgreSQL;
427
		String cdmServer = "127.0.0.1";
428
		String cdmDB = "cdm_edit_cichorieae_a"; 
429
		String cdmUserName = "edit";
430
		int port = 15432;
431
		return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
432
	}
433
	
434
	public static ICdmDataSource cdm_edit_cichorieae_a(){
435
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
436
		String cdmServer = "192.168.2.10";
437
		String cdmDB = "cdm_edit_cichorieae_a"; 
438
		String cdmUserName = "edit";
439
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
440
	}
441

    
442
	public static ICdmDataSource cdm_cichorieae_a_preview(){
443
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
444
		String cdmServer = "160.45.63.201";
445
		String cdmDB = "cdm_edit_cichorieae_a"; 
446
		String cdmUserName = "edit";
447
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
448
	}
449
	
450
	public static ICdmDataSource cdm_production_cichorieae(){
451
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
452
		String cdmServer = "160.45.63.151";
453
		String cdmDB = "cdm_production_cichorieae"; 
454
		String cdmUserName = "edit";
455
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
456
	}
457
	
458
	public static ICdmDataSource cdm_production_palmae(){
459
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
460
		String cdmServer = "160.45.63.151";
461
		String cdmDB = "cdm_production_palmae"; 
462
		String cdmUserName = "edit";
463
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
464
	}
465

    
466
	
467
	
468
	public static ICdmDataSource local_cdm_edit_cichorieae_a(){
469
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
470
		String cdmServer = "127.0.0.1";
471
		String cdmDB = "cdm_edit_cichorieae_a"; 
472
		String cdmUserName = "edit";
473
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
474
	}
475
	
476
	public static ICdmDataSource local_cdm_edit_cichorieae_b(){
477
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
478
		String cdmServer = "127.0.0.1";
479
		String cdmDB = "cdm_edit_cichorieae_b"; 
480
		String cdmUserName = "edit";
481
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
482
	}
483
	
484
	public static ICdmDataSource cdm_edit_cichorieae_b(){
485
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
486
		String cdmServer = "192.168.2.10";
487
		String cdmDB = "cdm_edit_cichorieae_b"; 
488
		String cdmUserName = "edit";
489
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
490
	}
491
	
492
	public static ICdmDataSource cdm_edit_diptera_a(){
493
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
494
		String cdmServer = "192.168.2.10";
495
		String cdmDB = "cdm_edit_diptera_a"; 
496
		String cdmUserName = "edit";
497
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
498
	}
499
	
500
	public static ICdmDataSource cdm_edit_diptera_b(){
501
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
502
		String cdmServer = "192.168.2.10";
503
		String cdmDB = "cdm_edit_diptera_b"; 
504
		String cdmUserName = "edit";
505
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
506
	}
507
		
508

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

    
517
	public static ICdmDataSource cdm_edit_palmae_b(){
518
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
519
		String cdmServer = "192.168.2.10";
520
		String cdmDB = "cdm_edit_palmae_b"; 
521
		String cdmUserName = "edit";
522
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
523
	}
524
	
525
	public static ICdmDataSource cdm_edit_diptera_preview_B(){
526
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
527
		String cdmServer = "127.0.0.1";
528
		String cdmDB = "cdm_edit_diptera_b"; 
529
		String cdmUserName = "edit";
530
		int port = 13306;
531
		return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
532
	}
533
	
534
	public static ICdmDataSource cdm_edit_cichorieae_preview_B(){
535
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
536
		String cdmServer = "127.0.0.1";
537
		String cdmDB = "cdm_edit_cichorieae_b"; 
538
		String cdmUserName = "edit";
539
		int port = 13306;
540
		return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
541
	}
542

    
543
	public static ICdmDataSource cdm_edit_palmae_preview_A(){
544
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
545
		String cdmServer = "127.0.0.1";
546
		String cdmDB = "cdm_edit_palmae_a"; 
547
		String cdmUserName = "edit";
548
		int port = 13306;
549
		return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
550
	}		
551
	
552
	public static ICdmDataSource cdm_edit_palmae_preview_B(){
553
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
554
		String cdmServer = "127.0.0.1";
555
		String cdmDB = "cdm_edit_palmae_b"; 
556
		String cdmUserName = "edit";
557
		int port = 13306;
558
		return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
559
	}
560
	
561
	public static ICdmDataSource cdm_v1_palmae(){
562
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
563
		String cdmServer = "192.168.2.10";
564
		String cdmDB = "cdm_v1_palmae"; 
565
		String cdmUserName = "edit";
566
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
567
	}
568
	
569
	public static ICdmDataSource cdm_edit_salvador(){
570
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
571
		String cdmServer = "192.168.2.10";
572
		String cdmDB = "cdm_edit_salvador"; 
573
		String cdmUserName = "edit";
574
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
575
	}
576
	
577
	public static ICdmDataSource cdm_import_cichorieae() {
578
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
579
		String cdmServer = "192.168.2.10";
580
		String cdmDB = "cdm_import_cichorieae"; 
581
		String cdmUserName = "edit";
582
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
583
	}
584
	
585
	public static ICdmDataSource cdm_import_diptera() {
586
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
587
		String cdmServer = "192.168.2.10";
588
		String cdmDB = "cdm_import_diptera"; 
589
		String cdmUserName = "edit";
590
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
591
	}
592
	
593
	public static ICdmDataSource cdm_import_palmae() {
594
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
595
		String cdmServer = "192.168.2.10";
596
		String cdmDB = "cdm_import_palmae"; 
597
		String cdmUserName = "edit";
598
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
599
	}
600
	
601
	public static ICdmDataSource cdm_import_salvador() {
602
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
603
		String cdmServer = "192.168.2.10";
604
		String cdmDB = "cdm_import_salvador"; 
605
		String cdmUserName = "edit";
606
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
607
	}
608
	
609
	public static ICdmDataSource cdm_salvador_production() {
610
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
611
		String cdmServer = "192.168.2.10";
612
		String cdmDB = "salvador_cdm"; 
613
		String cdmUserName = "salvador";
614
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
615
	}
616
	
617
	
618
//	public static ICdmDataSource LAPTOP_HP(){
619
//		DatabaseTypeEnum dbType = DatabaseTypeEnum.SqlServer2005;
620
//		String cdmServer = "LAPTOPHP";
621
//		String cdmDB = "cdmTest"; 
622
//		String cdmUserName = "edit";
623
//		return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);
624
//	}
625
	
626
	
627

    
628
	 
629
	/**
630
	 * initializes source
631
	 * TODO only supports MySQL and PostgreSQL
632
	 * 
633
	 * @param dbType
634
	 * @param cdmServer
635
	 * @param cdmDB
636
	 * @param port
637
	 * @param cdmUserName
638
	 * @param pwd
639
	 * @return
640
	 */
641
	private static ICdmDataSource makeDestination(DatabaseTypeEnum dbType, String cdmServer, String cdmDB, int port, String cdmUserName, String pwd ){
642
		//establish connection
643
		pwd = AccountStore.readOrStorePassword(cdmServer, cdmDB, cdmUserName, pwd);
644
		ICdmDataSource destination;
645
		if(dbType.equals(DatabaseTypeEnum.MySQL)){
646
			destination = CdmDataSource.NewMySqlInstance(cdmServer, cdmDB, port, cdmUserName, pwd, null);			
647
		} else if(dbType.equals(DatabaseTypeEnum.PostgreSQL)){
648
			destination = CdmDataSource.NewPostgreSQLInstance(cdmServer, cdmDB, port, cdmUserName, pwd, null);			
649
		} else {
650
			//TODO others
651
			throw new RuntimeException("Unsupported DatabaseType");
652
		}
653
		return destination;
654

    
655
	}
656

    
657

    
658
	/**
659
	 * Accepts a string array and tries to find a method returning an ICdmDataSource with 
660
	 * the name of the given first string in the array
661
	 * 
662
	 * @param args
663
	 * @return
664
	 */
665
	public static ICdmDataSource chooseDestination(String[] args) {
666
		if(args == null)
667
			return null;
668
		
669
		if(args.length != 1)
670
			return null;
671
		
672
		String possibleDestination = args[0];
673
		
674
		Method[] methods = CdmDestinations.class.getMethods();
675
		
676
		for (Method method : methods){
677
			if(method.getName().equals(possibleDestination)){
678
				try {
679
					return (ICdmDataSource) method.invoke(null, null);
680
				} catch (IllegalArgumentException e) {
681
					// TODO Auto-generated catch block
682
					e.printStackTrace();
683
				} catch (IllegalAccessException e) {
684
					// TODO Auto-generated catch block
685
					e.printStackTrace();
686
				} catch (InvocationTargetException e) {
687
					// TODO Auto-generated catch block
688
					e.printStackTrace();
689
				}
690
			}
691
		}
692
		return null;
693
	}
694

    
695
}
696

    
(1-1/4)