1
|
/**
|
2
|
* Copyright (C) 2009 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.test.function;
|
11
|
|
12
|
import java.io.IOException;
|
13
|
import java.util.UUID;
|
14
|
|
15
|
import javax.servlet.http.HttpServletResponse;
|
16
|
|
17
|
import org.apache.log4j.Logger;
|
18
|
|
19
|
import eu.etaxonomy.cdm.api.application.CdmApplicationController;
|
20
|
import eu.etaxonomy.cdm.config.AccountStore;
|
21
|
import eu.etaxonomy.cdm.database.CdmDataSource;
|
22
|
import eu.etaxonomy.cdm.database.DbSchemaValidation;
|
23
|
import eu.etaxonomy.cdm.database.ICdmDataSource;
|
24
|
import eu.etaxonomy.cdm.remote.controller.TaxonPortalController;
|
25
|
import eu.etaxonomy.cdm.remote.editor.UuidList;
|
26
|
import eu.etaxonomy.cdm.remote.io.application.CdmRemoteApplicationController;
|
27
|
|
28
|
/**
|
29
|
* @author a.mueller
|
30
|
* @since 08.11.2021
|
31
|
*/
|
32
|
public class TestScript {
|
33
|
|
34
|
private static final Logger logger = Logger.getLogger(TestScript.class);
|
35
|
|
36
|
|
37
|
private void testNewConfigControler(){
|
38
|
|
39
|
DbSchemaValidation schema = DbSchemaValidation.VALIDATE;
|
40
|
|
41
|
String server;
|
42
|
String database;
|
43
|
String username;
|
44
|
ICdmDataSource dataSource;
|
45
|
|
46
|
// List<CdmPersistentDataSource> lsDataSources = CdmPersistentDataSource.getAllDataSources();
|
47
|
// System.out.println(lsDataSources);
|
48
|
// dataSource = lsDataSources.get(1);
|
49
|
|
50
|
// DatabaseTypeEnum dbType = DatabaseTypeEnum.MySQL;
|
51
|
|
52
|
// server = "localhost";
|
53
|
// database = "cdm_bupleurum";
|
54
|
//// database = "cdm_production_edaphobase";
|
55
|
// username = "edit";
|
56
|
// dataSource = CdmDataSource.NewMySqlInstance(server, database, username, AccountStore.readOrStorePassword(server, database, username, null));
|
57
|
|
58
|
// server = "160.45.63.171";
|
59
|
// database = "cdm_production_campanulaceae";
|
60
|
// username = "edit";
|
61
|
// dataSource = CdmDataSource.NewMySqlInstance(server, database, username, AccountStore.readOrStorePassword(server, database, username, null));
|
62
|
|
63
|
|
64
|
// server = "test.e-taxonomy.eu";
|
65
|
// database = "cdm_rem_conf_am";
|
66
|
// username = "edit";
|
67
|
// dataSource = CdmDataSource.NewMySqlInstance(server, database, username, AccountStore.readOrStorePassword(server, database, username, null));
|
68
|
|
69
|
// String server = "localhost";
|
70
|
// String database = "testCDM";
|
71
|
// String username = "postgres";
|
72
|
// dataSource = CdmDataSource.NewInstance(DatabaseTypeEnum.PostgreSQL, server, database, DatabaseTypeEnum.PostgreSQL.getDefaultPort(), username, AccountStore.readOrStorePassword(server, database, username, null));
|
73
|
|
74
|
|
75
|
// //SQLServer
|
76
|
// server = "BGBM-PESISQL";
|
77
|
// database = "cdm36";
|
78
|
// int port = 1433;
|
79
|
// username = "cdmupdater";
|
80
|
// dataSource = CdmDataSource.NewSqlServer2012Instance(server, database, port, username, AccountStore.readOrStorePassword(server, database, username, null));
|
81
|
//
|
82
|
// //H2
|
83
|
// String path = "C:\\Users\\a.mueller\\.cdmLibrary\\writableResources\\h2\\LocalH2";
|
84
|
//// String path = "C:\\Users\\pesiimport\\.cdmLibrary\\writableResources\\h2\\LocalH2";
|
85
|
//// String path = "C:\\Users\\a.mueller\\eclipse\\svn\\cdmlib-trunk\\cdmlib-remote-webapp\\src\\test\\resources\\h2";
|
86
|
// username = "sa";
|
87
|
// dataSource = CdmDataSource.NewH2EmbeddedInstance("cdm", username, "", path);
|
88
|
|
89
|
// dataSource = CdmDataSource.NewH2EmbeddedInstance(database, username, "sa");
|
90
|
|
91
|
|
92
|
server = "160.45.63.201";
|
93
|
database = "cdm_integration_cichorieae";
|
94
|
username = "edit";
|
95
|
dataSource = CdmDataSource.NewMySqlInstance(server, database, username, AccountStore.readOrStorePassword(server, database, username, null));
|
96
|
|
97
|
CdmApplicationController appCtr = CdmRemoteApplicationController.NewRemoteInstance(dataSource, schema);
|
98
|
|
99
|
try {
|
100
|
doTemporary(appCtr);
|
101
|
} catch (IOException e) {
|
102
|
// TODO Auto-generated catch block
|
103
|
e.printStackTrace();
|
104
|
}
|
105
|
|
106
|
// List<UuidAndTitleCache<TaxonBase>> list = appCtr.getTaxonService().getUuidAndTitleCache(null, 10, "Abies alba%");
|
107
|
// System.out.println(list);
|
108
|
// appCtr.getOccurrenceService().findRootUnitDTOs(UUID.fromString("2debf5ee-cb57-40bc-af89-173d1d17cefe"));
|
109
|
// aggregateDDS(appCtr);
|
110
|
// aggregateDistribution(appCtr);
|
111
|
|
112
|
appCtr.close();
|
113
|
System.exit(0);
|
114
|
}
|
115
|
|
116
|
private void doTemporary(CdmApplicationController appCtr) throws IOException {
|
117
|
|
118
|
UUID taxonUUID = UUID.fromString("85176c77-e4b6-4899-a08b-e257ab09350a");
|
119
|
boolean includeTaxonomicChildren = true;
|
120
|
UuidList relationshipUuids = new UuidList();
|
121
|
UuidList relationshipInversUuids = new UuidList();
|
122
|
boolean includeTaxonDescriptions = true;
|
123
|
boolean includeOccurrences = true;
|
124
|
boolean includeTaxonNameDescriptions = true;
|
125
|
HttpServletResponse response = null;
|
126
|
TaxonPortalController taxonPortalController = (TaxonPortalController) appCtr.getBean("taxonPortalController");
|
127
|
|
128
|
taxonPortalController.doGet(taxonUUID, null, response);
|
129
|
|
130
|
}
|
131
|
|
132
|
private void test(){
|
133
|
System.out.println("Start TestScript");
|
134
|
testNewConfigControler();
|
135
|
//testDatabaseChange();
|
136
|
|
137
|
System.out.println("\nEnd TestScript");
|
138
|
}
|
139
|
|
140
|
public static void main(String[] args) {
|
141
|
TestScript cc = new TestScript();
|
142
|
cc.test();
|
143
|
}
|
144
|
|
145
|
}
|