Project

General

Profile

« Previous | Next » 

Revision 6d4b8d16

Added by Andreas Müller over 13 years ago

implemented parsing and new handling for "unranked" ranks #2141

View differences:

cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/database/update/v30_31/LanguageLabelUpdater.java
53 53 
		datasource.executeUpdate(sql);
54 54
55 55 
		//update term titleCache
56 
		//FIXME only for English representations
57 56 
		sql = " UPDATE DefinedTermBase dtb " +
58 57 
			  " SET titleCache = " +
59 58 
					" ( " +
60 59 
					" SELECT rep.label  " +
61 60 
					" FROM DefinedTermBase_Representation MN " +
62 61 
					" INNER JOIN Representation rep ON MN.representations_id = rep.id " +
63 
					" WHERE dtb.id = MN.DefinedTermBase_id) " +
62 
					" WHERE dtb.id = MN.DefinedTermBase_id AND rep.language_id = @langId) " +
64 63 
				" WHERE dtb.DTYPE = 'Language'";
64 
		String englishId = String.valueOf(getEnglishLanguageId(datasource, monitor));
65 
		if (englishId == null){
66 
			throw new NullPointerException("English id could not be found");
67 
		}
68 
		sql = sql.replace("@langId", englishId);
65 69 
		datasource.executeUpdate(sql);
66 70
67 71 
		return 0;

Also available in: Unified diff