/**
* Copyright (C) 2009-2013 FoundationDB, LLC
*
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU Affero General Public License as published by
* the Free Software Foundation, either version 3 of the License, or
* (at your option) any later version.
*
* This program 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 Affero General Public License for more details.
*
* You should have received a copy of the GNU Affero General Public License
* along with this program. If not, see <http://www.gnu.org/licenses/>.
*/
package com.foundationdb.sql.aisddl;
import com.foundationdb.server.api.DDLFunctions;
import com.foundationdb.server.error.*;
import com.foundationdb.server.service.session.Session;
import com.foundationdb.server.types.common.types.TypesTranslator;
import com.foundationdb.sql.optimizer.AISBinderContext;
import com.foundationdb.sql.optimizer.AISViewDefinition;
import com.foundationdb.sql.parser.CreateViewNode;
import com.foundationdb.sql.parser.DropViewNode;
import com.foundationdb.sql.parser.NodeTypes;
import com.foundationdb.sql.parser.ResultColumn;
import com.foundationdb.sql.types.DataTypeDescriptor;
import com.foundationdb.sql.types.TypeId;
import com.foundationdb.ais.model.AISBuilder;
import com.foundationdb.ais.model.AkibanInformationSchema;
import com.foundationdb.ais.model.Columnar;
import com.foundationdb.ais.model.TableName;
import com.foundationdb.ais.model.View;
import com.foundationdb.qp.operator.QueryContext;
import java.util.Collection;
import java.util.Map;
import static com.foundationdb.sql.aisddl.DDLHelper.convertName;
import static com.foundationdb.sql.aisddl.DDLHelper.skipOrThrow;
/** DDL operations on Views */
public class ViewDDL
{
private ViewDDL() {
}
public static void createView(DDLFunctions ddlFunctions,
Session session,
String defaultSchemaName,
CreateViewNode createView,
AISBinderContext binderContext,
QueryContext context) {
TableName fullName = convertName(defaultSchemaName, createView.getObjectName());
String schemaName = fullName.getSchemaName();
String viewName = fullName.getTableName();
View curView = ddlFunctions.getAIS(session).getView(schemaName, viewName);
if((curView != null) &&
skipOrThrow(context, createView.getExistenceCheck(), curView, new DuplicateViewException(schemaName, viewName))) {
return;
}
TypesTranslator typesTranslator = ddlFunctions.getTypesTranslator();
AISViewDefinition viewdef = binderContext.getViewDefinition(createView);
Map<TableName,Collection<String>> tableColumnReferences = viewdef.getTableColumnReferences();
AISBuilder builder = new AISBuilder();
builder.view(schemaName, viewName, viewdef.getQueryExpression(),
binderContext.getParserProperties(schemaName), tableColumnReferences);
int colpos = 0;
for (ResultColumn rc : viewdef.getResultColumns()) {
DataTypeDescriptor type = rc.getType();
if (type == null) {
if (rc.getExpression().getNodeType() != NodeTypes.UNTYPED_NULL_CONSTANT_NODE)
throw new AkibanInternalException(rc.getName() + " has unknown type");
type = new DataTypeDescriptor(TypeId.CHAR_ID, true, 0);
}
TableDDL.addColumn(builder, typesTranslator,
schemaName, viewName, rc.getName(), colpos++,
type, null, null);
}
View view = builder.akibanInformationSchema().getView(schemaName, viewName);
ddlFunctions.createView(session, view);
}
public static void dropView (DDLFunctions ddlFunctions,
Session session,
String defaultSchemaName,
DropViewNode dropView,
AISBinderContext binderContext,
QueryContext context) {
TableName viewName = convertName(defaultSchemaName, dropView.getObjectName());
View curView = ddlFunctions.getAIS(session).getView(viewName);
if((curView == null) &&
skipOrThrow(context, dropView.getExistenceCheck(), curView, new UndefinedViewException(viewName))) {
return;
}
checkDropTable(ddlFunctions, session, viewName);
ddlFunctions.dropView(session, viewName);
}
public static void checkDropTable(DDLFunctions ddlFunctions, Session session,
TableName name) {
AkibanInformationSchema ais = ddlFunctions.getAIS(session);
Columnar table = ais.getColumnar(name);
if (table == null) return;
for (View view : ais.getViews().values()) {
if (view.referencesTable(table)) {
throw new ViewReferencesExist(view.getName().getSchemaName(),
view.getName().getTableName(),
table.getName().getSchemaName(),
table.getName().getTableName());
}
}
}
}