Project

General

Profile

Download (20.9 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.eflora;
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_alex(){
38
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
39
		String cdmServer = "192.168.2.10";
40
		String cdmDB = "cdm_production_palmae"; 
41
		String cdmUserName = "edit";
42
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
43
	}
44
	
45

    
46
	public static ICdmDataSource cdm_test_useSummary(){
47
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
48
		String cdmServer = "localhost";
49
		String cdmDB = "palmae_2011_07_17"; 
50
		String cdmUserName = "edit";
51
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
52
	}
53
	
54
	public static ICdmDataSource cdm_test_jaxb(){
55
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
56
		String cdmServer = "192.168.2.10";
57
		String cdmDB = "cdm_test_jaxb"; 
58
		String cdmUserName = "edit";
59
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
60
	}
61
	
62
	public static ICdmDataSource cdm_test_jaxb2(){
63
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
64
		String cdmServer = "192.168.2.10";
65
		String cdmDB = "cdm_test_jaxb2"; 
66
		String cdmUserName = "edit";
67
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
68
	}
69

    
70
	public static ICdmDataSource cdm_test_andreasM(){
71
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
72
		String cdmServer = "192.168.2.10";
73
		String cdmDB = "cdm_test_andreasM"; 
74
		String cdmUserName = "edit";
75
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
76
	}
77
	
78
	public static ICdmDataSource cdm_test_andreasM2(){
79
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
80
		String cdmServer = "192.168.2.10";
81
		String cdmDB = "cdm_test_andreasM2"; 
82
		String cdmUserName = "edit";
83
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
84
	}
85
	
86
	public static ICdmDataSource cdm_test_local_mysql(){
87
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
88
		String cdmServer = "127.0.0.1";
89
		String cdmDB = "cdm_test"; 
90
		String cdmUserName = "edit";
91
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
92
	}
93

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

    
110
	
111
	public static ICdmDataSource cdm_portal(){
112
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
113
		String cdmServer = "192.168.2.10";
114
		String cdmDB = "cdm_portal";
115
		String cdmUserName = "edit";
116
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
117
	}
118
	
119
	public static ICdmDataSource cdm_portal_test(){
120
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
121
		String cdmServer = "192.168.2.10";
122
		String cdmDB = "cdm_portal_test";
123
		String cdmUserName = "edit";
124
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
125
	}
126
	
127
	public static ICdmDataSource cdm_test_patricia(){
128
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
129
		String cdmServer = "192.168.2.10";
130
		String cdmDB = "cdm_test_patricia";
131
		String cdmUserName = "edit";
132
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
133
	}
134
	
135
	//
136
	public static ICdmDataSource cdm_test_andreasK1(){
137
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
138
		String cdmServer = "192.168.2.10";
139
		String cdmDB = "cdm_test_andreasK1";
140
		String cdmUserName = "edit";
141
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
142
	}
143
	
144

    
145
	public static ICdmDataSource cdm_pesi_erms(){
146
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
147
		String cdmServer = "192.168.2.10";
148
		String cdmDB = "cdm_pesi_erms";
149
		String cdmUserName = "edit";
150
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
151
	}
152
	
153
	public static ICdmDataSource cdm_campanulaceae(){
154
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
155
		String cdmServer = "192.168.2.10";
156
		String cdmDB = "cdm_campanulaceae";
157
		String cdmUserName = "edit";
158
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
159
	}
160

    
161
	public static ICdmDataSource cdm_ildis_dev(){
162
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
163
		String cdmServer = "160.45.63.201";
164
		String cdmDB = "cdm_edit_ildis";
165
		String cdmUserName = "edit";
166
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
167
	}
168
	
169
//
170
//	public static ICdmDataSource cdm_ildis_production(){
171
//		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
172
//		String cdmServer = "160.45.63.151";
173
//		String cdmDB = "cdm_edit_ildis";
174
//		String cdmUserName = "edit";
175
//		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
176
//	}
177
	
178
	public static ICdmDataSource cdm_cyprus_dev(){
179
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
180
		String cdmServer = "160.45.63.201";
181
		String cdmDB = "cdm_cyprus";
182
		String cdmUserName = "edit";
183
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
184
	}
185
	
186
	public static ICdmDataSource cdm_cyprus_production(){
187
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
188
		String cdmServer = "160.45.63.151";
189
		String cdmDB = "cdm_production_cyprus";
190
		String cdmUserName = "edit";
191
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
192
	}
193

    
194
	public static ICdmDataSource cdm_cyprus_production_tunnel(){
195
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
196
		String cdmServer = "127.0.0.1";
197
		int port = 13306;
198
		String cdmDB = "cdm_production_cyprus";
199
		String cdmUserName = "edit";
200
		return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
201
	}
202
	
203
	public static ICdmDataSource cdm_cyprus_dev_tunnel(){
204
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
205
		String cdmServer = "127.0.0.1";
206
		int port = 13306;
207
		String cdmDB = "cdm_cyprus";
208
		String cdmUserName = "edit";
209
		return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
210
	}
211
	
212
	public static ICdmDataSource cdm_campanulaceae_production(){
213
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
214
		String cdmServer = "160.45.63.151";
215
		String cdmDB = "cdm_production_campanulaceae";
216
		String cdmUserName = "edit";
217
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
218
	}
219
	
220
	public static ICdmDataSource cdm_flora_malesiana_preview(){
221
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
222
		String cdmServer = "160.45.63.201";
223
		String cdmDB = "cdm_edit_flora_malesiana";
224
		String cdmUserName = "edit";
225
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
226
	}
227
	
228
	
229

    
230
	public static ICdmDataSource cdm_flora_malesiana_production(){
231
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
232
		String cdmServer = "160.45.63.151";
233
		String cdmDB = "cdm_production_flora_malesiana";
234
		String cdmUserName = "edit";
235
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
236
	}
237
	
238
	public static ICdmDataSource cdm_flore_gabon_preview(){
239
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
240
		String cdmServer = "160.45.63.201";
241
		String cdmDB = "cdm_flore_gabon";
242
		String cdmUserName = "edit";
243
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
244
	}
245
	
246
	public static ICdmDataSource cdm_flore_gabon_production(){
247
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
248
		String cdmServer = "160.45.63.151";
249
		String cdmDB = "cdm_production_flore_gabon";
250
		String cdmUserName = "edit";
251
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
252
	}
253

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

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

    
430
	public static ICdmDataSource cdm_algaterra_preview(){
431
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
432
		String cdmServer = "160.45.63.201";
433
		String cdmDB = "cdm_edit_algaterra"; 
434
		String cdmUserName = "edit";
435
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
436
	}
437
	
438
	public static ICdmDataSource cdm_edit_cichorieae_PG(){
439
		DatabaseTypeEnum dbType = DatabaseTypeEnum.PostgreSQL;
440
		String cdmServer = "127.0.0.1";
441
		String cdmDB = "cdm_edit_cichorieae_a"; 
442
		String cdmUserName = "edit";
443
		int port = 15432;
444
		return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
445
	}
446

    
447
	public static ICdmDataSource cdm_cichorieae_preview(){
448
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
449
		String cdmServer = "160.45.63.201";
450
		String cdmDB = "cdm_edit_cichorieae"; 
451
		String cdmUserName = "edit";
452
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
453
	}
454
	
455
	public static ICdmDataSource cdm_production_cichorieae(){
456
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
457
		String cdmServer = "160.45.63.151";
458
//		String cdmServer = "127.0.0.1";
459
		String cdmDB = "cdm_production_cichorieae"; 
460
		String cdmUserName = "edit";
461
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
462
	}
463
	
464
	public static ICdmDataSource cdm_production_palmae(){
465
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
466
		String cdmServer = "160.45.63.151";
467
		String cdmDB = "cdm_production_palmae"; 
468
		String cdmUserName = "edit";
469
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
470
	}
471
	
472
	
473
	public static ICdmDataSource cdm_production_diptera(){
474
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
475
		String cdmServer = "160.45.63.151";
476
		String cdmDB = "cdm_production_diptera"; 
477
		String cdmUserName = "edit";
478
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
479
	}
480
	
481
	public static ICdmDataSource local_cdm_edit_cichorieae_a(){
482
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
483
		String cdmServer = "127.0.0.1";
484
		String cdmDB = "cdm_edit_cichorieae_a"; 
485
		String cdmUserName = "edit";
486
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
487
	}
488
	
489
	public static ICdmDataSource local_cdm_edit_cichorieae_b(){
490
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
491
		String cdmServer = "127.0.0.1";
492
		String cdmDB = "cdm_edit_cichorieae_b"; 
493
		String cdmUserName = "edit";
494
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
495
	}
496

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

    
505
	public static ICdmDataSource cdm_edit_diptera_preview_B(){
506
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
507
		String cdmServer = "127.0.0.1";
508
		String cdmDB = "cdm_edit_diptera_b"; 
509
		String cdmUserName = "edit";
510
		int port = 13306;
511
		return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
512
	}
513
	
514
	public static ICdmDataSource cdm_edit_cichorieae_preview(){
515
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
516
		String cdmServer = "127.0.0.1";
517
		String cdmDB = "cdm_edit_cichorieae"; 
518
		String cdmUserName = "edit";
519
		int port = 13306;
520
		return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
521
	}
522

    
523
	public static ICdmDataSource cdm_edit_palmae_preview(){
524
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
525
		String cdmServer = "127.0.0.1";
526
		String cdmDB = "cdm_edit_palmae"; 
527
		String cdmUserName = "edit";
528
		int port = 13306;
529
		return makeDestination(dbType, cdmServer, cdmDB, port, cdmUserName, null);
530
	}		
531
	
532
	public static ICdmDataSource cdm_edit_salvador(){
533
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
534
		String cdmServer = "192.168.2.10";
535
		String cdmDB = "cdm_edit_salvador"; 
536
		String cdmUserName = "edit";
537
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
538
	}
539
	
540
	public static ICdmDataSource cdm_import_salvador() {
541
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
542
		String cdmServer = "192.168.2.10";
543
		String cdmDB = "cdm_import_salvador"; 
544
		String cdmUserName = "edit";
545
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
546
	}
547
	
548
	public static ICdmDataSource cdm_salvador_production() {
549
		DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
550
		String cdmServer = "192.168.2.10";
551
		String cdmDB = "salvador_cdm"; 
552
		String cdmUserName = "salvador";
553
		return makeDestination(dbType, cdmServer, cdmDB, -1, cdmUserName, null);
554
	}
555
	
556
	
557
//	public static ICdmDataSource LAPTOP_HP(){
558
//		DatabaseTypeEnum dbType = DatabaseTypeEnum.SqlServer2005;
559
//		String cdmServer = "LAPTOPHP";
560
//		String cdmDB = "cdmTest"; 
561
//		String cdmUserName = "edit";
562
//		return makeDestination(cdmServer, cdmDB, -1, cdmUserName, null);
563
//	}
564
	
565
	
566

    
567
	 
568
	/**
569
	 * initializes source
570
	 * TODO only supports MySQL and PostgreSQL
571
	 * 
572
	 * @param dbType
573
	 * @param cdmServer
574
	 * @param cdmDB
575
	 * @param port
576
	 * @param cdmUserName
577
	 * @param pwd
578
	 * @return
579
	 */
580
	private static ICdmDataSource makeDestination(DatabaseTypeEnum dbType, String cdmServer, String cdmDB, int port, String cdmUserName, String pwd ){
581
		//establish connection
582
		pwd = AccountStore.readOrStorePassword(cdmServer, cdmDB, cdmUserName, pwd);
583
		ICdmDataSource destination;
584
		if(dbType.equals(DatabaseTypeEnum.MySQL)){
585
			destination = CdmDataSource.NewMySqlInstance(cdmServer, cdmDB, port, cdmUserName, pwd, null);			
586
		} else if(dbType.equals(DatabaseTypeEnum.PostgreSQL)){
587
			destination = CdmDataSource.NewPostgreSQLInstance(cdmServer, cdmDB, port, cdmUserName, pwd, null);			
588
		} else {
589
			//TODO others
590
			throw new RuntimeException("Unsupported DatabaseType");
591
		}
592
		return destination;
593

    
594
	}
595

    
596

    
597
	/**
598
	 * Accepts a string array and tries to find a method returning an ICdmDataSource with 
599
	 * the name of the given first string in the array
600
	 * 
601
	 * @param args
602
	 * @return
603
	 */
604
	public static ICdmDataSource chooseDestination(String[] args) {
605
		if(args == null)
606
			return null;
607
		
608
		if(args.length != 1)
609
			return null;
610
		
611
		String possibleDestination = args[0];
612
		
613
		Method[] methods = CdmDestinations.class.getMethods();
614
		
615
		for (Method method : methods){
616
			if(method.getName().equals(possibleDestination)){
617
				try {
618
					return (ICdmDataSource) method.invoke(null, null);
619
				} catch (IllegalArgumentException e) {
620
					// TODO Auto-generated catch block
621
					e.printStackTrace();
622
				} catch (IllegalAccessException e) {
623
					// TODO Auto-generated catch block
624
					e.printStackTrace();
625
				} catch (InvocationTargetException e) {
626
					// TODO Auto-generated catch block
627
					e.printStackTrace();
628
				}
629
			}
630
		}
631
		return null;
632
	}
633

    
634
}
635

    
(1-1/9)