/*
* JBoss, Home of Professional Open Source.
* See the COPYRIGHT.txt file distributed with this work for information
* regarding copyright ownership. Some portions may be licensed
* to Red Hat, Inc. under one or more contributor license agreements.
*
* This library is free software; you can redistribute it and/or
* modify it under the terms of the GNU Lesser General Public
* License as published by the Free Software Foundation; either
* version 2.1 of the License, or (at your option) any later version.
*
* This library is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
* Lesser General Public License for more details.
*
* You should have received a copy of the GNU Lesser General Public
* License along with this library; if not, write to the Free Software
* Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
* 02110-1301 USA.
*/
package org.teiid.query.resolver.command;
import java.util.ArrayList;
import java.util.Collection;
import java.util.HashSet;
import java.util.Set;
import org.teiid.api.exception.query.QueryResolverException;
import org.teiid.designer.runtime.version.spi.ITeiidServerVersion;
import org.teiid.designer.runtime.version.spi.TeiidServerVersion.Version;
import org.teiid.metadata.BaseColumn.NullType;
import org.teiid.metadata.Column;
import org.teiid.metadata.Schema;
import org.teiid.query.metadata.TempMetadataAdapter;
import org.teiid.query.metadata.TempMetadataID;
import org.teiid.query.resolver.CommandResolver;
import org.teiid.query.resolver.QueryResolver;
import org.teiid.query.resolver.util.ResolverUtil;
import org.teiid.query.resolver.util.ResolverVisitor;
import org.teiid.query.sql.lang.Command;
import org.teiid.query.sql.lang.Create;
import org.teiid.query.sql.lang.Drop;
import org.teiid.query.sql.symbol.ElementSymbol;
import org.teiid.query.sql.symbol.GroupSymbol;
import org.teiid.query.sql.symbol.Symbol;
import org.teiid.runtime.client.Messages;
/**
* @since 5.5
*/
public class TempTableResolver extends CommandResolver {
/**
* @param queryResolver
*/
public TempTableResolver(QueryResolver queryResolver) {
super(queryResolver);
}
/**
* @see org.teiid.query.resolver.CommandResolver#resolveCommand(org.teiid.query.sql.lang.Command, org.teiid.query.metadata.TempMetadataAdapter, boolean)
*/
public void resolveCommand(Command command, TempMetadataAdapter metadata, boolean resolveNullLiterals)
throws Exception {
if(command.getType() == Command.TYPE_CREATE) {
Create create = (Create)command;
GroupSymbol group = create.getTable();
//assuming that all temp table creates are local, the user must use a local name
if (group.getName().indexOf(Symbol.SEPARATOR) != -1) {
throw new QueryResolverException(Messages.gs(Messages.TEIID.TEIID30117, group.getName()));
}
//this will only check non-temp groups
Collection exitsingGroups = metadata.getMetadata().getGroupsForPartialName(group.getName());
if(!exitsingGroups.isEmpty()) {
throw new QueryResolverException(Messages.gs(Messages.TEIID.TEIID30118, group.getName()));
}
if (metadata.getMetadata().hasProcedure(group.getName())) {
throw new QueryResolverException(Messages.gs(Messages.TEIID.TEIID30118, group.getName()));
}
//now we will be more specific for temp groups
TempMetadataID id = metadata.getMetadataStore().getTempGroupID(group.getName());
if (id != null && !metadata.isTemporaryTable(id)) {
throw new QueryResolverException(Messages.gs(Messages.TEIID.TEIID30118, group.getName()));
}
//if we get here then either the group does not exist or has already been defined as a temp table
//if it has been defined as a temp table, that's ok we'll use this as the new definition and throw an
//exception at runtime if the user has not dropped the previous table yet
TempMetadataID tempTable = ResolverUtil.addTempTable(metadata, group, create.getColumnSymbols());
ResolverUtil.resolveGroup(create.getTable(), metadata);
Set<GroupSymbol> groups = new HashSet<GroupSymbol>();
groups.add(create.getTable());
ResolverVisitor visitor = new ResolverVisitor(command.getTeiidVersion());
visitor.resolveLanguageObject(command, groups, metadata);
addAdditionalMetadata(create, tempTable);
tempTable.setOriginalMetadataID(create.getTableMetadata());
if (create.getOn() != null) {
Object mid = null;
try {
mid = metadata.getModelID(create.getOn());
} catch (Exception e) {
throw new QueryResolverException(Messages.gs(Messages.TEIID.TEIID31134, create.getOn()));
}
if (mid != null && (metadata.isVirtualModel(mid) || !(mid instanceof Schema))) {
throw new QueryResolverException(Messages.gs(Messages.TEIID.TEIID31135, create.getOn()));
}
create.getTableMetadata().setParent((Schema)mid);
tempTable.getTableData().setModel(mid);
}
} else if(command.getType() == Command.TYPE_DROP) {
ResolverUtil.resolveGroup(((Drop)command).getTable(), metadata);
}
}
public static void addAdditionalMetadata(Create create, TempMetadataID tempTable) {
ITeiidServerVersion teiidVersion = create.getTeiidVersion();
if (!create.getPrimaryKey().isEmpty()) {
ArrayList<TempMetadataID> primaryKey = new ArrayList<TempMetadataID>(create.getPrimaryKey().size());
for (ElementSymbol symbol : create.getPrimaryKey()) {
if (teiidVersion.isGreaterThanOrEqualTo(Version.TEIID_8_10)) {
Object mid = symbol.getMetadataID();
if (mid instanceof TempMetadataID) {
primaryKey.add((TempMetadataID)mid);
} else if (mid instanceof Column) {
//TODO: this breaks our normal metadata usage
primaryKey.add(tempTable.getElements().get(((Column)mid).getPosition() - 1));
}
} else {
primaryKey.add((TempMetadataID) symbol.getMetadataID());
}
}
tempTable.setPrimaryKey(primaryKey);
}
for (int i = 0; i < create.getColumns().size(); i++) {
Column column = create.getColumns().get(i);
TempMetadataID tid = tempTable.getElements().get(i);
if (column.isAutoIncremented()) {
tid.setAutoIncrement(true);
}
if (column.getNullType() == NullType.No_Nulls) {
tid.setNotNull(true);
}
}
}
}