Revision 6d4b8d16
Added by Andreas Müller about 13 years ago
cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/database/update/SchemaUpdaterStepBase.java | ||
---|---|---|
9 | 9 |
*/ |
10 | 10 |
package eu.etaxonomy.cdm.database.update; |
11 | 11 |
|
12 |
import java.sql.ResultSet; |
|
12 | 13 |
import java.sql.SQLException; |
13 | 14 |
import java.util.ArrayList; |
14 | 15 |
import java.util.List; |
16 |
import java.util.UUID; |
|
15 | 17 |
|
16 | 18 |
import org.apache.commons.lang.StringUtils; |
17 | 19 |
import org.apache.log4j.Logger; |
... | ... | |
19 | 21 |
import eu.etaxonomy.cdm.common.IProgressMonitor; |
20 | 22 |
import eu.etaxonomy.cdm.database.DatabaseTypeEnum; |
21 | 23 |
import eu.etaxonomy.cdm.database.ICdmDataSource; |
24 |
import eu.etaxonomy.cdm.model.common.Language; |
|
22 | 25 |
|
23 | 26 |
/** |
24 | 27 |
* @author a.mueller |
... | ... | |
77 | 80 |
return result; |
78 | 81 |
} |
79 | 82 |
|
83 |
protected Integer getEnglishLanguageId(ICdmDataSource datasource, IProgressMonitor monitor) throws SQLException { |
|
84 |
return getLanguageId(Language.uuidEnglish, datasource, monitor); |
|
85 |
} |
|
86 |
|
|
87 |
/** |
|
88 |
* @param uuidLanguage |
|
89 |
* @param datasource |
|
90 |
* @param monitor |
|
91 |
* @return |
|
92 |
* @throws SQLException |
|
93 |
*/ |
|
94 |
protected Integer getLanguageId(UUID uuidLanguage, ICdmDataSource datasource, IProgressMonitor monitor) throws SQLException { |
|
95 |
ResultSet rs; |
|
96 |
Integer langId = null; |
|
97 |
String sqlLangId = " SELECT id FROM DefinedTermBase WHERE uuid = '" + uuidLanguage + "'"; |
|
98 |
rs = datasource.executeQuery(sqlLangId); |
|
99 |
if (rs.next()){ |
|
100 |
langId = rs.getInt("id"); |
|
101 |
}else{ |
|
102 |
String warning = "Term for language (" + uuidLanguage + ") does not exist!"; |
|
103 |
monitor.warning(warning); |
|
104 |
} |
|
105 |
return langId; |
|
106 |
} |
|
107 |
|
|
80 | 108 |
|
81 | 109 |
public List<ISchemaUpdaterStep> getInnerSteps(){ |
82 | 110 |
return new ArrayList<ISchemaUpdaterStep>(); |
Also available in: Unified diff
implemented parsing and new handling for "unranked" ranks #2141