prerna.reactor.masterdatabase.QueryTranslatorReactor Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of semoss Show documentation

SEMOSS

The newest version!

package prerna.reactor.masterdatabase;

import java.util.List;
import java.util.Map;
import java.util.Set;

import org.apache.logging.log4j.LogManager;
import org.apache.logging.log4j.Logger;

import prerna.masterdatabase.utility.MasterDatabaseUtility;
import prerna.query.parsers.SqlTranslator;
import prerna.reactor.AbstractReactor;
import prerna.sablecc2.om.PixelDataType;
import prerna.sablecc2.om.nounmeta.NounMetadata;
import prerna.util.Constants;
import prerna.util.Utility;

public class QueryTranslatorReactor extends AbstractReactor {
	
	private static final Logger classLogger = LogManager.getLogger(QueryTranslatorReactor.class);
	
	public QueryTranslatorReactor() {
		this.keysToGet = new String[] { "query", "sourceDB", "targetDB" };
	}

	@Override
	public NounMetadata execute() {
		organizeKeys();
		String query = this.keyValue.get(this.keysToGet[0]);
		query = Utility.decodeURIComponent(query);
		System.out.println(query);
		String sourceDbId = this.keyValue.get(this.keysToGet[1]);
		String targetDbId = this.keyValue.get(this.keysToGet[2]);
		sourceDbId = MasterDatabaseUtility.testDatabaseIdIfAlias(sourceDbId);
		targetDbId = MasterDatabaseUtility.testDatabaseIdIfAlias(targetDbId);
		// get physical to physical translation from sourceDB to targetDB
		Map> translation = MasterDatabaseUtility.databaseTranslator(sourceDbId, targetDbId);
		// generate translated queries
		SqlTranslator translator = new SqlTranslator(translation);
		Set queries = null;
		try {
			queries = translator.processQuery(query);
		} catch (Exception e) {
			// TODO Auto-generated catch block
			classLogger.error(Constants.STACKTRACE, e);
		}
		return new NounMetadata(queries, PixelDataType.CUSTOM_DATA_STRUCTURE);
	}
}