PEDatabaseDDL.java

package com.tesora.dve.sql.util;

/*
 * #%L
 * Tesora Inc.
 * Database Virtualization Engine
 * %%
 * Copyright (C) 2011 - 2014 Tesora Inc.
 * %%
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU Affero General Public License, version 3,
 * as published by the Free Software Foundation.
 * 
 * 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/>.
 * #L%
 */

import java.util.ArrayList;
import java.util.List;

import com.tesora.dve.common.catalog.FKMode;
import com.tesora.dve.common.catalog.MultitenantMode;
import com.tesora.dve.common.catalog.TemplateMode;
import com.tesora.dve.sql.template.TemplateBuilder;

public class PEDatabaseDDL extends DatabaseDDL {

	private String template;
	private boolean loadTemplate = true;
	private Boolean strict;
	private MultitenantMode mtmode;
	private FKMode fkmode;
	private StorageGroupDDL persGroup;
	
	public PEDatabaseDDL(String name, String tag) {
		this(name,tag,null,null);
	}
	
	public PEDatabaseDDL(String name, String tag, String charset, String collation) {
		super(name,tag, charset, collation);
	}
	
	public PEDatabaseDDL(String name) {
		this(name,"database");
	}
		
	public PEDatabaseDDL withTemplate(String temp, boolean strict) {
		this.template = temp;
		this.strict = strict;
		return this;
	}

	public PEDatabaseDDL withMTMode(MultitenantMode mm) {
		this.mtmode = mm;
		return this;
	}

	public MultitenantMode getMultitenantMode() {
		return mtmode;
	}
	
	public PEDatabaseDDL withFKMode(FKMode fkm) {
		this.fkmode = fkm;
		return this;
	}
	
	public PEDatabaseDDL withLoadTemplate(boolean v) {
		this.loadTemplate = v;
		return this;
	}
	
	public FKMode getForeignKeyMode() {
		return fkmode;
	}
	
	public PEDatabaseDDL withStorageGroup(StorageGroupDDL sg) {
		persGroup = sg;
		return this;
	}
	
	@Override
	public boolean isNative() {
		return false;
	}

	@Override
	public DatabaseDDL copy() {
		return new PEDatabaseDDL(dbn,dbtag).withMTMode(mtmode).withStorageGroup(persGroup).withTemplate(template, strict);
	}

	@Override
	public String getCreateDatabaseStatement() {
		StringBuffer out = new StringBuffer();
		out.append("create ");
		if (mtmode != null && mtmode.isMT())
			out.append(" multitenant ");
		out.append(dbtag).append(" if not exists ").append(dbn);
		if (charset != null)
			out.append(" default character set " + charset);
		if (collation != null)
			out.append(" default collate " + collation);
		if (persGroup != null)
			out.append(" default persistent group ").append(persGroup.getName());
		if (template != null) {
			out.append(" using template ").append(template);
		} else {
			out.append(" using template ").append(TemplateMode.OPTIONAL);
		}
		if (fkmode != null)
			out.append(" foreign key mode ").append(fkmode.getPersistentValue());
		return out.toString();
	}

	@Override
	public List<String> getCreateStatements() throws Exception {
		ArrayList<String> buf = new ArrayList<String>();
		if (isCreated()) 
			buf.add("drop" + (mtmode != null ? " multitenant " : " ") + "database if exists " + dbn);
		// here
		if (template != null && loadTemplate) {
			buf.add(TemplateBuilder.getClassPathCreate(template));
		}
		buf.add(getCreateDatabaseStatement());
		setCreated();
		buf.add("use " + dbn);
		return buf;
	}

	@Override
	public List<String> getDestroyStatements() throws Exception {
		return null;
	}

	@Override
	public List<String> getSetupDrops() {
		ArrayList<String> out = new ArrayList<String>();
		// first the database itself
		out.add("DROP DATABASE IF EXISTS " + dbn);
		// and then the dyn sites; note that we're relying on the dyn sites being configured for 5 sites here
		for(int i = 1; i < 6; i++)
			out.add("DROP DATABASE IF EXISTS OnPremise_LOCAL_dyn" + i + "_" + dbn);
		return out;
	}

	@Override
	public String getDropStatement() {
		return "drop " + (mtmode != null ? "multitenant " : "") + "database if exists " + dbn; 
	}

}