InputTeradataConverter.java example

Explorer
Hydrograph-master
/*******************************************************************************
 * Copyright 2017 Capital One Services, LLC and Bitwise, Inc.
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 * http://www.apache.org/licenses/LICENSE-2.0
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 *******************************************************************************/
package hydrograph.ui.engine.converter.impl;

import java.math.BigInteger;
import java.util.ArrayList;
import java.util.List;

import org.apache.commons.lang.StringUtils;
import org.slf4j.Logger;

import hydrograph.engine.jaxb.commontypes.ElementValueIntegerType;
import hydrograph.engine.jaxb.commontypes.ElementValueStringType;
import hydrograph.engine.jaxb.commontypes.TypeBaseField;
import hydrograph.engine.jaxb.commontypes.TypeInputOutSocket;
import hydrograph.engine.jaxb.inputtypes.Teradata;
import hydrograph.engine.jaxb.iteradata.TypeInputTeradataOutSocket;
import hydrograph.ui.common.util.Constants;
import hydrograph.ui.datastructure.property.DatabaseSelectionConfig;
import hydrograph.ui.datastructure.property.GridRow;
import hydrograph.ui.datastructure.property.MatchValueProperty;
import hydrograph.ui.engine.constants.PropertyNameConstants;
import hydrograph.ui.engine.converter.InputConverter;
import hydrograph.ui.graph.model.Component;
import hydrograph.ui.graph.model.Link;
import hydrograph.ui.logging.factory.LogFactory;
import hydrograph.ui.propertywindow.messages.Messages;

/**
 * The Class InputTeradata Converter implementation for Input Teradata Component
 * @author Bitwise
 *
 */
public class InputTeradataConverter extends InputConverter{

	private static final Logger logger = LogFactory.INSTANCE.getLogger(InputTeradataConverter.class);
	
	public InputTeradataConverter(Component component) {
		super(component);
		this.baseComponent = new Teradata();
		this.component = component;
		this.properties = component.getProperties();
	}

	@Override
	protected List<TypeInputOutSocket> getInOutSocket() {
		logger.debug("Generating TypeInputOutSocket data for {}", properties.get(Constants.PARAM_NAME));
		List<TypeInputOutSocket> inputOutSockets = new ArrayList<>();
		for (Link link : component.getSourceConnections()) {
			TypeInputTeradataOutSocket inputTeradataOutSocket = new TypeInputTeradataOutSocket();
			inputTeradataOutSocket.setId(link.getSourceTerminal());
			inputTeradataOutSocket.setType(link.getSource().getPort(link.getSourceTerminal()).getPortType());
			inputTeradataOutSocket.setSchema(getSchema());
			inputTeradataOutSocket.getOtherAttributes();
			inputOutSockets.add(inputTeradataOutSocket);
		}
		return inputOutSockets;
	}

	@Override
	public void prepareForXML() {
		super.prepareForXML();
		Teradata teradataInput = (Teradata) baseComponent;
		teradataInput.setRuntimeProperties(getRuntimeProperties());

		ElementValueStringType dataBaseName = new ElementValueStringType();
		if(StringUtils.isNotBlank((String) properties.get(PropertyNameConstants.DATABASE_NAME.value()))){
			dataBaseName.setValue(String.valueOf(properties.get(PropertyNameConstants.DATABASE_NAME.value())));
			teradataInput.setDatabaseName(dataBaseName);
		}
		
		ElementValueStringType hostName = new ElementValueStringType();
		if(StringUtils.isNotBlank((String) properties.get(PropertyNameConstants.HOST_NAME.value()))){
			hostName.setValue(String.valueOf(properties.get(PropertyNameConstants.HOST_NAME.value())));
			teradataInput.setHostName(hostName);
		}
		
		ElementValueStringType driverName = new ElementValueStringType();
		if(StringUtils.isNotBlank((String) properties.get(PropertyNameConstants.JDBC_DRIVER.value()))){
			driverName.setValue(String.valueOf(properties.get(PropertyNameConstants.JDBC_DRIVER.value())));
			teradataInput.setJdbcDriver(driverName);
		}
		
		ElementValueIntegerType portNo = new ElementValueIntegerType();
		BigInteger portValue = getPortValue(PropertyNameConstants.PORT_NO.value());
		portNo.setValue(portValue);
		teradataInput.setPort(portNo);
		
		ElementValueStringType userName = new ElementValueStringType();
		if(StringUtils.isNotBlank((String) properties.get(PropertyNameConstants.USER_NAME.value()))){
			userName.setValue(String.valueOf(properties.get(PropertyNameConstants.USER_NAME.value())));
			teradataInput.setUsername(userName);
		}
		
		ElementValueStringType password = new ElementValueStringType();
		if(StringUtils.isNotBlank((String) properties.get(PropertyNameConstants.PASSWORD.value()))){
			password.setValue(String.valueOf(properties.get(PropertyNameConstants.PASSWORD.value())));
			teradataInput.setPassword(password);
		}
		
		teradataInput.setExportOptions(getSelectExportValue());
		
		DatabaseSelectionConfig databaseSelectionConfig = (DatabaseSelectionConfig) 
				properties.get(PropertyNameConstants.SELECT_OPTION.value());
		
		if (databaseSelectionConfig != null) {

			if (databaseSelectionConfig.isTableName()) {
				ElementValueStringType tableName = new ElementValueStringType();
				tableName.setValue(databaseSelectionConfig.getTableName());
				teradataInput.setTableName(tableName);
				
			} else {
				ElementValueStringType sqlQuery = new ElementValueStringType();
				if(StringUtils.isNotBlank(databaseSelectionConfig.getSqlQuery())){
					sqlQuery.setValue(databaseSelectionConfig.getSqlQuery());
					teradataInput.setSelectQuery(sqlQuery);
				}
			}
		}
	}
	
	@Override
	protected List<TypeBaseField> getFieldOrRecord(List<GridRow> list) {
		logger.debug("Generating data for {} for property {}",
				new Object[] { properties.get(Constants.PARAM_NAME), PropertyNameConstants.SCHEMA.value() });

		List<TypeBaseField> typeBaseFields = new ArrayList<>();
		if (list != null && list.size() != 0) {
			for (GridRow object : list) {
				typeBaseFields.add(converterHelper.getSchemaGridTargetData(object));
			}
		}
		return typeBaseFields;
	}
	
	private ElementValueStringType getSelectExportValue() {
		MatchValueProperty matchValueProperty =  (MatchValueProperty) properties.get(PropertyNameConstants.SELECT_INTERFACE.value());
		
		if(matchValueProperty != null){
			ElementValueStringType type = new ElementValueStringType();
			if(Messages.FAST_EXPORT.equalsIgnoreCase(matchValueProperty.getMatchValue())){
				type.setValue(Constants.FASTEXPORT);
			}
			else{
				type.setValue(Constants.DEFAULT);
			}
			return type;
		}
		return null;
	}
}