+ //TODO check if this can all be done by getTaxonStatus\r
+ private boolean doPhaseUpdates(PesiExportState state) {\r
+ \r
+ \r
+ String oldStatusFilter = "= 7 "; //"= '" + PesiTransformer.T_STATUS_STR_UNACCEPTED + "' ";\r
+ String emStr = PesiTransformer.SOURCE_STR_EM;\r
+ String feStr = PesiTransformer.SOURCE_STR_FE;\r
+ String ifStr = PesiTransformer.SOURCE_STR_IF;\r
+ \r
+ //NOT ACCEPTED names\r
+ String updateNotAccepted = " UPDATE Taxon SET TaxonStatusFk = %d, TaxonStatusCache = '%s' " +\r
+ " WHERE OriginalDB = '%s' AND taxonstatusfk = 1 AND ParentTaxonFk %s AND RankFk > 180 ";\r
+ updateNotAccepted = String.format(updateNotAccepted, 8, "NOT ACCEPTED: TAXONOMICALLY VALUELESS LOCAL OR SINGULAR BIOTYPE", emStr, oldStatusFilter);\r
+ int updated = state.getConfig().getDestination().update(updateNotAccepted);\r
+ \r
+ //alternative names\r
+ String updateAlternativeName = "UPDATE Taxon SET TaxonStatusFk = 1, TaxonStatusCache = 'accepted' " + \r
+ " FROM RelTaxon RIGHT OUTER JOIN Taxon ON RelTaxon.TaxonFk1 = Taxon.TaxonId " +\r
+ " WHERE (RelTaxon.RelTaxonQualifierFk = 17) AND (Taxon.TaxonStatusFk %s) ";\r
+ updateAlternativeName = String.format(updateAlternativeName, oldStatusFilter);\r
+ updated = state.getConfig().getDestination().update(updateAlternativeName);\r
+ \r
+ String updateSynonyms = " UPDATE Taxon SET TaxonStatusFk = 2, TaxonStatusCache = 'synonym' " + \r
+ " FROM RelTaxon RIGHT OUTER JOIN Taxon ON RelTaxon.TaxonFk1 = Taxon.TaxonId " + \r
+ " WHERE (RelTaxon.RelTaxonQualifierFk in (1, 3)) AND (Taxon.TaxonStatusFk %S)";\r
+ updateSynonyms = String.format(updateSynonyms, oldStatusFilter);\r
+ updated = state.getConfig().getDestination().update(updateSynonyms);\r
+ \r
+ // cache citation - check if this can't be done in getCacheCitation\r
+ // cache citation - FE\r
+// String updateCacheCitationFE = " UPDATE Taxon " +\r
+// " SET CacheCitation = IsNull(SpeciesExpertName + '. ', '') + WebShowName + '. Accessed through: Fauna Europaea at http://www.faunaeur.org/full_results.php?id=' + cast(TempFE_Id as varchar) " +\r
+// " WHERE OriginalDb = '%s'";\r
+// updateCacheCitationFE = String.format(updateCacheCitationFE, feStr);\r
+// updated = state.getConfig().getDestination().update(updateCacheCitationFE);\r
+ \r
+ // cache citation - EM\r
+ String updateCacheCitationEM = " UPDATE Taxon " +\r
+ " SET CacheCitation = SpeciesExpertName + ' ' + WebShowName + '. Accessed through: Euro+Med PlantBase at http://ww2.bgbm.org/euroPlusMed/PTaxonDetail.asp?UUID=' + GUID " +\r
+ " WHERE OriginalDb = '%s'";\r
+ updateCacheCitationEM = String.format(updateCacheCitationEM, emStr);\r
+ updated = state.getConfig().getDestination().update(updateCacheCitationEM);\r
+ \r
+ // cache citation - IF\r
+// String updateCacheCitationIF = " UPDATE Taxon " +\r
+// " SET CacheCitation = IsNull(SpeciesExpertName + ' ', '') + WebShowName + '. Accessed through: Index Fungorum at http://www.indexfungorum.org/names/NamesRecord.asp?RecordID=' + cast(TempIF_Id as varchar) " +\r
+// " WHERE OriginalDb = '%s'";\r
+// updateCacheCitationIF = String.format(updateCacheCitationIF, ifStr);\r
+// updated = state.getConfig().getDestination().update(updateCacheCitationIF);\r
+ \r
+ return true;\r
+ }\r
+\r