Project

General

Profile

Download (3.88 KB) Statistics
| Branch: | Revision:
1
/**
2
* Copyright (C) 2007 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.io.pesi.erms;
11

    
12
import java.sql.ResultSet;
13
import java.sql.SQLException;
14
import java.util.HashMap;
15
import java.util.HashSet;
16
import java.util.Map;
17
import java.util.Set;
18

    
19
import org.apache.log4j.Logger;
20
import org.springframework.stereotype.Component;
21

    
22
import eu.etaxonomy.cdm.io.common.IOValidator;
23
import eu.etaxonomy.cdm.io.common.mapping.DbImportExtensionCreationMapper;
24
import eu.etaxonomy.cdm.io.common.mapping.DbImportMapping;
25
import eu.etaxonomy.cdm.io.common.mapping.DbNotYetImplementedMapper;
26
import eu.etaxonomy.cdm.io.pesi.erms.validation.ErmsLinkImportValidator;
27
import eu.etaxonomy.cdm.model.common.CdmBase;
28
import eu.etaxonomy.cdm.model.common.Extension;
29
import eu.etaxonomy.cdm.model.common.ExtensionType;
30
import eu.etaxonomy.cdm.model.taxon.TaxonBase;
31

    
32

    
33
/**
34
 * @author a.mueller
35
 * @since 20.02.2010
36
 */
37
@Component
38
public class ErmsLinkImport  extends ErmsImportBase<TaxonBase> {
39
	@SuppressWarnings("unused")
40
	private static final Logger logger = Logger.getLogger(ErmsLinkImport.class);
41

    
42
	private DbImportMapping<ErmsImportState,ErmsImportConfigurator> mapping;
43
	
44
	private static final String pluralString = "links";
45
	private static final String dbTableName = "links";
46
	private static final Class<?> cdmTargetClass = Extension.class;
47

    
48
	public ErmsLinkImport(){
49
		super(pluralString, dbTableName, cdmTargetClass);
50
	}
51

    
52
	@Override
53
	protected String getRecordQuery(ErmsImportConfigurator config) {
54
		String strRecordQuery = 
55
			" SELECT * " + 
56
			" FROM links " +
57
			" WHERE ( links.id IN (" + ID_LIST_TOKEN + ") )";
58
		return strRecordQuery;
59
	}
60

    
61
	/* (non-Javadoc)
62
	 * @see eu.etaxonomy.cdm.io.erms.ErmsImportBase#getMapping()
63
	 */
64
	protected DbImportMapping<ErmsImportState,ErmsImportConfigurator> getMapping() {
65
		if (mapping == null){
66
			mapping = new DbImportMapping<ErmsImportState,ErmsImportConfigurator>();
67
			ExtensionType extensionType = ExtensionType.URL();
68
			//TODO do we need to add to TaxonNameBase too?
69
			mapping.addMapper(DbImportExtensionCreationMapper.NewInstance("tu_id", ErmsTaxonImport.TAXON_NAMESPACE, "link_url", "id", extensionType)); 
70
			//not yet implemented
71
			mapping.addMapper(DbNotYetImplementedMapper.NewInstance("link_text"));  //maybe implement as a second extension ?? but this is ambigous!
72
			mapping.addMapper(DbNotYetImplementedMapper.NewInstance("link_fn"));
73
			mapping.addMapper(DbNotYetImplementedMapper.NewInstance("note"));
74
		}
75
		return mapping;
76
	}
77

    
78
	@Override
79
	public Map<Object, Map<String, ? extends CdmBase>> getRelatedObjectsForPartition(ResultSet rs, ErmsImportState state) {
80
		String nameSpace;
81
		Class<?> cdmClass;
82
		Set<String> idSet;
83
		Map<Object, Map<String, ? extends CdmBase>> result = new HashMap<Object, Map<String, ? extends CdmBase>>();
84
		
85
		try{
86
			Set<String> taxonIdSet = new HashSet<String>();
87
			Set<String> languageIdSet = new HashSet<String>();
88
			while (rs.next()){
89
				handleForeignKey(rs, taxonIdSet, "tu_id");
90
			}
91
			
92
			//taxon map
93
			nameSpace = TAXON_NAMESPACE;
94
			cdmClass = TaxonBase.class;
95
			idSet = taxonIdSet;
96
			Map<String, TaxonBase> taxonMap = (Map<String, TaxonBase>)getCommonService().getSourcedObjectsByIdInSource(cdmClass, idSet, nameSpace);
97
			result.put(nameSpace, taxonMap);
98
			
99
		} catch (SQLException e) {
100
			throw new RuntimeException(e);
101
		}
102
		return result;
103
	}
104

    
105
	@Override
106
	protected boolean doCheck(ErmsImportState state){
107
		IOValidator<ErmsImportState> validator = new ErmsLinkImportValidator();
108
		return validator.validate(state);
109
	}
110
	
111
	@Override
112
	protected boolean isIgnore(ErmsImportState state){
113
		return ! state.getConfig().isDoLinks();
114
	}
115

    
116

    
117

    
118

    
119

    
120
}
(8-8/17)