|
1
|
/**
|
|
2
|
* Copyright (C) 2008 EDIT
|
|
3
|
* European Distributed Institute of Taxonomy
|
|
4
|
* http://www.e-taxonomy.eu
|
|
5
|
*/
|
|
6
|
|
|
7
|
package eu.etaxonomy.cdm.app.util;
|
|
8
|
|
|
9
|
import java.util.ArrayList;
|
|
10
|
import java.util.GregorianCalendar;
|
|
11
|
import java.util.List;
|
|
12
|
|
|
13
|
import org.apache.log4j.Logger;
|
|
14
|
import org.springframework.transaction.TransactionStatus;
|
|
15
|
|
|
16
|
import eu.etaxonomy.cdm.api.application.CdmApplicationController;
|
|
17
|
import eu.etaxonomy.cdm.common.AccountStore;
|
|
18
|
import eu.etaxonomy.cdm.database.CdmDataSource;
|
|
19
|
import eu.etaxonomy.cdm.database.DbSchemaValidation;
|
|
20
|
import eu.etaxonomy.cdm.database.ICdmDataSource;
|
|
21
|
import eu.etaxonomy.cdm.io.api.application.CdmIoApplicationController;
|
|
22
|
import eu.etaxonomy.cdm.io.jaxb.DataSet;
|
|
23
|
import eu.etaxonomy.cdm.model.agent.AgentBase;
|
|
24
|
import eu.etaxonomy.cdm.model.agent.Institution;
|
|
25
|
import eu.etaxonomy.cdm.model.agent.InstitutionalMembership;
|
|
26
|
import eu.etaxonomy.cdm.model.agent.Person;
|
|
27
|
import eu.etaxonomy.cdm.model.common.AnnotatableEntity;
|
|
28
|
import eu.etaxonomy.cdm.model.common.DefinedTermBase;
|
|
29
|
import eu.etaxonomy.cdm.model.common.TimePeriod;
|
|
30
|
import eu.etaxonomy.cdm.model.common.VersionableEntity;
|
|
31
|
import eu.etaxonomy.cdm.model.description.Feature;
|
|
32
|
import eu.etaxonomy.cdm.model.description.IndividualsAssociation;
|
|
33
|
import eu.etaxonomy.cdm.model.description.QuantitativeData;
|
|
34
|
import eu.etaxonomy.cdm.model.description.StatisticalMeasure;
|
|
35
|
import eu.etaxonomy.cdm.model.description.StatisticalMeasurementValue;
|
|
36
|
import eu.etaxonomy.cdm.model.description.TaxonDescription;
|
|
37
|
import eu.etaxonomy.cdm.model.description.TaxonInteraction;
|
|
38
|
import eu.etaxonomy.cdm.model.description.TaxonNameDescription;
|
|
39
|
import eu.etaxonomy.cdm.model.location.Country;
|
|
40
|
import eu.etaxonomy.cdm.model.location.NamedAreaType;
|
|
41
|
import eu.etaxonomy.cdm.model.name.BotanicalName;
|
|
42
|
import eu.etaxonomy.cdm.model.name.NomenclaturalCode;
|
|
43
|
import eu.etaxonomy.cdm.model.name.Rank;
|
|
44
|
import eu.etaxonomy.cdm.model.name.TaxonNameBase;
|
|
45
|
import eu.etaxonomy.cdm.model.occurrence.DerivedUnit;
|
|
46
|
import eu.etaxonomy.cdm.model.occurrence.SpecimenOrObservationBase;
|
|
47
|
import eu.etaxonomy.cdm.model.reference.Reference;
|
|
48
|
import eu.etaxonomy.cdm.model.reference.ReferenceFactory;
|
|
49
|
import eu.etaxonomy.cdm.model.taxon.Classification;
|
|
50
|
import eu.etaxonomy.cdm.model.taxon.Synonym;
|
|
51
|
import eu.etaxonomy.cdm.model.taxon.SynonymRelationshipType;
|
|
52
|
import eu.etaxonomy.cdm.model.taxon.Taxon;
|
|
53
|
import eu.etaxonomy.cdm.model.taxon.TaxonBase;
|
|
54
|
import eu.etaxonomy.cdm.model.taxon.TaxonNode;
|
|
55
|
|
|
56
|
/**
|
|
57
|
* @author a.babadshanjan
|
|
58
|
* @created 28.10.2008
|
|
59
|
*/
|
|
60
|
public class TestDatabase {
|
|
61
|
|
|
62
|
private static final String server = "192.168.2.10";
|
|
63
|
private static final String username = "edit";
|
|
64
|
|
|
65
|
private static final Logger logger = Logger.getLogger(TestDatabase.class);
|
|
66
|
|
|
67
|
public static ICdmDataSource CDM_DB(String dbname) {
|
|
68
|
|
|
69
|
logger.info("Setting DB " + dbname);
|
|
70
|
String password = AccountStore.readOrStorePassword(dbname, server, username, null);
|
|
71
|
ICdmDataSource datasource = CdmDataSource.NewMySqlInstance(server, dbname, username, password, NomenclaturalCode.ICNAFP);
|
|
72
|
return datasource;
|
|
73
|
}
|
|
74
|
|
|
75
|
public static CdmApplicationController initDb(ICdmDataSource db, DbSchemaValidation dbSchemaValidation, boolean omitTermLoading) {
|
|
76
|
|
|
77
|
logger.info("Initializing database '" + db.getName() + "'");
|
|
78
|
|
|
79
|
CdmApplicationController appCtrInit = CdmIoApplicationController.NewInstance(db, dbSchemaValidation, omitTermLoading);
|
|
80
|
|
|
81
|
return appCtrInit;
|
|
82
|
}
|
|
83
|
|
|
84
|
public static void loadTestData(String dbname, CdmApplicationController appCtr) {
|
|
85
|
|
|
86
|
logger.info("Loading test data into " + dbname);
|
|
87
|
|
|
88
|
TransactionStatus txStatus = appCtr.startTransaction();
|
|
89
|
DataSet dataSet = buildDataSet();
|
|
90
|
|
|
91
|
appCtr.getTermService().save(dataSet.getTerms());
|
|
92
|
appCtr.getTaxonService().save((List)dataSet.getTaxonBases());
|
|
93
|
|
|
94
|
appCtr.commitTransaction(txStatus);
|
|
95
|
appCtr.close();
|
|
96
|
}
|
|
97
|
|
|
98
|
/**
|
|
99
|
* This method constructs a small sample classification to test JAXB marshaling.
|
|
100
|
* The sample tree contains four taxa. The root taxon has two children taxa, and
|
|
101
|
* there is one "free" taxon without a parent and children.
|
|
102
|
*/
|
|
103
|
private static DataSet buildDataSet() {
|
|
104
|
|
|
105
|
List<AgentBase> agents = new ArrayList<AgentBase>();
|
|
106
|
List<VersionableEntity> agentData = new ArrayList<VersionableEntity>();
|
|
107
|
//List<Agent> agentData = new ArrayList<Agent>();
|
|
108
|
|
|
109
|
//List<TermBase> terms = new ArrayList<TermBase>();
|
|
110
|
List<DefinedTermBase> terms = new ArrayList<DefinedTermBase>();
|
|
111
|
List<Reference> references = new ArrayList<Reference>();
|
|
112
|
List<TaxonNameBase> taxonomicNames = new ArrayList<TaxonNameBase>();
|
|
113
|
List<TaxonBase> taxonBases = new ArrayList<TaxonBase>();
|
|
114
|
|
|
115
|
List<Feature> features = new ArrayList<Feature>();
|
|
116
|
|
|
117
|
Feature feature1 = Feature.BIOLOGY_ECOLOGY();
|
|
118
|
|
|
119
|
TaxonNameDescription taxNameDescription = TaxonNameDescription.NewInstance();
|
|
120
|
// taxNameDescription.addFeature(feature1); //no longer supported since v3.3
|
|
121
|
QuantitativeData element = QuantitativeData.NewInstance();
|
|
122
|
StatisticalMeasurementValue statisticalValue = StatisticalMeasurementValue.NewInstance();
|
|
123
|
statisticalValue.setType(StatisticalMeasure.MAX());
|
|
124
|
statisticalValue.setValue((float) 2.1);
|
|
125
|
element.addStatisticalValue(statisticalValue);
|
|
126
|
taxNameDescription.addElement(element);
|
|
127
|
|
|
128
|
SpecimenOrObservationBase<?> specimen = DerivedUnit.NewPreservedSpecimenInstance();
|
|
129
|
|
|
130
|
specimen.setIndividualCount(12);
|
|
131
|
|
|
132
|
|
|
133
|
Feature featureIndAss = Feature.INDIVIDUALS_ASSOCIATION();
|
|
134
|
TaxonNameDescription newTaxNameDesc = TaxonNameDescription.NewInstance();
|
|
135
|
// newTaxNameDesc.addFeature(featureIndAss); //no longer supported since v3.3
|
|
136
|
IndividualsAssociation indAss = IndividualsAssociation.NewInstance();
|
|
137
|
indAss.setAssociatedSpecimenOrObservation(specimen);
|
|
138
|
|
|
139
|
newTaxNameDesc.addElement(indAss);
|
|
140
|
|
|
141
|
|
|
142
|
|
|
143
|
|
|
144
|
// List<Synonym> synonyms = new ArrayList<Synonym>();
|
|
145
|
List<AnnotatableEntity> homotypicalGroups;
|
|
146
|
|
|
147
|
Reference citRef, sec;
|
|
148
|
BotanicalName name1, name2, name21, nameRoot1, nameFree, synName11, synName12, synName2, synNameFree;
|
|
149
|
BotanicalName nameRoot2, nameR2_1, nameR2_2;
|
|
150
|
Taxon child1, child2, child21, root1T, root2T, freeT;
|
|
151
|
Taxon childR2_1, childR2_2;
|
|
152
|
TaxonNode child1Node, child2Node, child21Node, root1TNode, root2TNode, freeTNode;
|
|
153
|
TaxonNode childR2_1Node, childR2_2Node;
|
|
154
|
Classification taxTree, taxTree2;
|
|
155
|
Synonym syn11, syn12, syn2, synFree;
|
|
156
|
Rank rankSpecies, rankSubspecies, rankGenus;
|
|
157
|
|
|
158
|
// agents
|
|
159
|
// - persons, institutions
|
|
160
|
|
|
161
|
Person linne = new Person("Carl", "Linne", "L.");
|
|
162
|
linne.setTitleCache("Linne & Karl", true);
|
|
163
|
GregorianCalendar birth = new GregorianCalendar(1707, 4, 23);
|
|
164
|
GregorianCalendar death = new GregorianCalendar(1778, 0, 10);
|
|
165
|
TimePeriod period = TimePeriod.NewInstance(birth, death);
|
|
166
|
linne.setLifespan(period);
|
|
167
|
|
|
168
|
// Keyword keyword = Keyword.NewInstance("plantarum", "lat", "");
|
|
169
|
// linne.addKeyword(keyword);
|
|
170
|
|
|
171
|
Institution institute = Institution.NewInstance();
|
|
172
|
|
|
173
|
agents.add(linne);
|
|
174
|
agents.add(institute);
|
|
175
|
|
|
176
|
// agent data
|
|
177
|
// - contacts, addresses, memberships
|
|
178
|
|
|
179
|
//Contact contact1 = new Contact();
|
|
180
|
//contact1.setEmail("someone@somewhere.org");
|
|
181
|
InstitutionalMembership membership
|
|
182
|
= new InstitutionalMembership(institute, linne, period, "Biodiversity", "Head");
|
|
183
|
//agentData.add(contact1);
|
|
184
|
|
|
185
|
agentData.add(membership);
|
|
186
|
|
|
187
|
// terms
|
|
188
|
// - ranks, keywords
|
|
189
|
|
|
190
|
rankSpecies = Rank.SPECIES();
|
|
191
|
rankSubspecies = Rank.SUBSPECIES();
|
|
192
|
rankGenus = Rank.GENUS();
|
|
193
|
|
|
194
|
// terms.add(keyword);
|
|
195
|
|
|
196
|
// taxonomic names
|
|
197
|
|
|
198
|
nameRoot1 = BotanicalName.NewInstance(rankGenus,"Calendula",null,null,null,linne,null,"p.100", null);
|
|
199
|
nameRoot1.addDescription(taxNameDescription);
|
|
200
|
nameRoot1.addDescription(newTaxNameDesc);
|
|
201
|
name1 = BotanicalName.NewInstance(rankSpecies,"Calendula",null,"arvensis",null,linne,null,"p.1", null);
|
|
202
|
synName11 = BotanicalName.NewInstance(rankSpecies,"Caltha",null,"arvensis",null,linne,null,"p.11", null);
|
|
203
|
synName12 = BotanicalName.NewInstance(rankSpecies,"Calendula",null,"sancta",null,linne,null,"p.12", null);
|
|
204
|
|
|
205
|
name2 = BotanicalName.NewInstance(rankSpecies,"Calendula",null,"lanzae",null,linne,null,"p.2", null);
|
|
206
|
synName2 = BotanicalName.NewInstance(rankSpecies,"Calendula",null,"echinata",null,linne,null,"p.2", null);
|
|
207
|
|
|
208
|
name21 = BotanicalName.NewInstance(rankSubspecies,"Calendula",null,"lanzea","something",linne,null,"p.1", null);
|
|
209
|
//name211 = BotanicalName.NewInstance(rankSpecies,"Calendula",null,"lanzea",null,linne,null,"p.1", null);
|
|
210
|
//name212 = BotanicalName.NewInstance(rankSpecies,"Calendula",null,"lanzea",null,linne,null,"p.1", null);
|
|
211
|
|
|
212
|
nameRoot2 =
|
|
213
|
BotanicalName.NewInstance(rankGenus,"Sonchus",null,null,null,linne,null,"p.200", null);
|
|
214
|
nameR2_1 = BotanicalName.NewInstance(rankSpecies,"Sonchus",null,"child1",null,linne,null,"p.1", null);
|
|
215
|
nameR2_2 = BotanicalName.NewInstance(rankSpecies,"Sonchus",null,"child2",null,linne,null,"p.2", null);
|
|
216
|
|
|
217
|
nameFree = BotanicalName.NewInstance(rankSpecies,"Cichorium",null,"intybus",null,linne,null,"p.200", null);
|
|
218
|
synNameFree = BotanicalName.NewInstance(rankSpecies,"Cichorium",null,"balearicum",null,linne,null,"p.2", null);
|
|
219
|
|
|
220
|
taxonomicNames.add(nameRoot1);
|
|
221
|
taxonomicNames.add(name1);
|
|
222
|
taxonomicNames.add(synName11);
|
|
223
|
taxonomicNames.add(synName12);
|
|
224
|
taxonomicNames.add(name2);
|
|
225
|
taxonomicNames.add(name21);
|
|
226
|
taxonomicNames.add(synName2);
|
|
227
|
taxonomicNames.add(nameFree);
|
|
228
|
taxonomicNames.add(synNameFree);
|
|
229
|
taxonomicNames.add(nameRoot2);
|
|
230
|
|
|
231
|
// references
|
|
232
|
sec = ReferenceFactory.newBook();
|
|
233
|
sec.setAuthorship(linne);
|
|
234
|
sec.setTitleCache("Plant Specification & Taxonomy", true);
|
|
235
|
references.add(sec);
|
|
236
|
|
|
237
|
citRef = ReferenceFactory.newDatabase();
|
|
238
|
citRef.setAuthorship(linne);
|
|
239
|
citRef.setTitleCache("BioCASE", true);
|
|
240
|
references.add(citRef);
|
|
241
|
|
|
242
|
// taxa
|
|
243
|
|
|
244
|
root1T = Taxon.NewInstance(nameRoot1, sec);
|
|
245
|
root2T = Taxon.NewInstance(nameRoot2, sec);
|
|
246
|
freeT = Taxon.NewInstance(nameFree, sec);
|
|
247
|
child1 = Taxon.NewInstance(name1, sec);
|
|
248
|
child2 = Taxon.NewInstance(name2, sec);
|
|
249
|
child21 = Taxon.NewInstance(name21, sec);
|
|
250
|
childR2_1 = Taxon.NewInstance(nameR2_1, sec);
|
|
251
|
childR2_2 = Taxon.NewInstance(nameR2_2, sec);
|
|
252
|
|
|
253
|
//TaxonInteractions
|
|
254
|
|
|
255
|
TaxonInteraction descBase = TaxonInteraction.NewInstance();
|
|
256
|
descBase.setTaxon2(root1T);
|
|
257
|
Feature hostplant = Feature.HOSTPLANT();
|
|
258
|
|
|
259
|
descBase.setFeature(hostplant);
|
|
260
|
TaxonDescription taxDesc = TaxonDescription.NewInstance();
|
|
261
|
taxDesc.addElement(descBase);
|
|
262
|
root2T.addDescription(taxDesc);
|
|
263
|
|
|
264
|
//locations
|
|
265
|
|
|
266
|
taxDesc = TaxonDescription.NewInstance();
|
|
267
|
Feature locationFeature = Feature.DISTRIBUTION();
|
|
268
|
|
|
269
|
|
|
270
|
//locationFeature.
|
|
271
|
Country area = Country.NewInstance("", "locationTest", null);
|
|
272
|
area.setType(NamedAreaType.NATURAL_AREA());
|
|
273
|
|
|
274
|
//Country woC= Country.NewInstance();
|
|
275
|
area.addCountry(Country.AFGHANISTAN());
|
|
276
|
taxDesc.addGeoScope(area);
|
|
277
|
// taxDesc.addFeature(locationFeature); //no longer supported since v3.3
|
|
278
|
root1T.addDescription(taxDesc);
|
|
279
|
|
|
280
|
|
|
281
|
// synonyms
|
|
282
|
|
|
283
|
synFree = Synonym.NewInstance(synNameFree, sec);
|
|
284
|
syn11 = Synonym.NewInstance(synName11, sec);
|
|
285
|
syn12 = Synonym.NewInstance(synName12, sec);
|
|
286
|
syn2 = Synonym.NewInstance(synName2, sec);
|
|
287
|
|
|
288
|
child1.addSynonym(syn11, SynonymRelationshipType.HOMOTYPIC_SYNONYM_OF());
|
|
289
|
child1.addSynonym(syn12, SynonymRelationshipType.HETEROTYPIC_SYNONYM_OF());
|
|
290
|
child2.addSynonym(syn2, SynonymRelationshipType.HETEROTYPIC_SYNONYM_OF());
|
|
291
|
freeT.addSynonym(synFree, SynonymRelationshipType.HETEROTYPIC_SYNONYM_OF());
|
|
292
|
|
|
293
|
taxonBases.add(synFree);
|
|
294
|
taxonBases.add(syn11);
|
|
295
|
taxonBases.add(syn12);
|
|
296
|
taxonBases.add(syn2);
|
|
297
|
|
|
298
|
// taxonomic children
|
|
299
|
|
|
300
|
//TODO: Adapt to classification
|
|
301
|
taxTree = Classification.NewInstance("TestTree");
|
|
302
|
|
|
303
|
root1TNode = taxTree.addChildTaxon(root1T, sec, null);
|
|
304
|
child1Node = root1TNode.addChildTaxon(child1, null, null);
|
|
305
|
child2Node = root1TNode.addChildTaxon(child2, null, null);
|
|
306
|
child21Node = child2Node.addChildTaxon(child21, null, null);
|
|
307
|
|
|
308
|
taxTree2 = Classification.NewInstance("TestTree2");
|
|
309
|
|
|
310
|
root2TNode = taxTree2.addChildTaxon(root2T, sec, null);
|
|
311
|
root2TNode.addChildTaxon(child1, sec, "p.1010").setSynonymToBeUsed(syn11);
|
|
312
|
root2TNode.addChildTaxon(child2, null, null);
|
|
313
|
|
|
314
|
/*
|
|
315
|
root1T.addTaxonomicChild(child1, sec, "p.1010");
|
|
316
|
root1T.addTaxonomicChild(child2, sec, "p.1020");
|
|
317
|
child2.addTaxonomicChild(child21, sec, "p.2000");
|
|
318
|
|
|
319
|
root2T.addTaxonomicChild(child1, sec, "p.1010");
|
|
320
|
root2T.addTaxonomicChild(child2, sec, "p.1020");
|
|
321
|
*/
|
|
322
|
//
|
|
323
|
|
|
324
|
|
|
325
|
taxonBases.add(root1T);
|
|
326
|
taxonBases.add(root2T);
|
|
327
|
taxonBases.add(freeT);
|
|
328
|
taxonBases.add(child1);
|
|
329
|
taxonBases.add(child2);
|
|
330
|
taxonBases.add(child21);
|
|
331
|
taxonBases.add(childR2_1);
|
|
332
|
taxonBases.add(childR2_2);
|
|
333
|
|
|
334
|
DataSet dataSet = new DataSet();
|
|
335
|
|
|
336
|
logger.warn("WARNING: TestDatabase has been commented in parts. Mainly, must be adapted to classification.");
|
|
337
|
|
|
338
|
dataSet.setTerms(terms);
|
|
339
|
dataSet.setAgents(agents);
|
|
340
|
// dataSet.setAgentData(agentData); //TODO
|
|
341
|
dataSet.setReferences(references);
|
|
342
|
dataSet.setTaxonomicNames(taxonomicNames);
|
|
343
|
dataSet.setTaxonBases((List)taxonBases);
|
|
344
|
|
|
345
|
|
|
346
|
return dataSet;
|
|
347
|
|
|
348
|
}
|
|
349
|
}
|