/*
* Copyright 2003,2004,2005 Colin Crist
*
* 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 hermes.store.schema;
/**
* @author colincrist@hermesjms.com
* @version $Id: DefaultStatements.java,v 1.4 2005/08/10 17:15:26 colincrist Exp $
*/
public class DefaultStatements implements Statements
{
/* (non-Javadoc)
* @see hermes.store.schema.Statements#getCreateDatabaseStatements(int)
*/
public String[] getCreateDatabaseStatements(int maxMessageSize, int maxDestinationSize)
{
return new String[] { "create table storeInfo (storeid varchar (64) not null constraint storeInfo_cid unique )",
"create table stores (storeid varchar(64) not null, destination varchar(" + maxDestinationSize + ") not null, domain integer not null, messageid varchar(256) not null)",
"create index stores_didx on stores(destination)", "create index stores_sidx on stores(storeid)", "create index stores_midx on stores(messageid)", "create index stores_smidx on stores(storeid, messageid)",
"create table messages (messageid varchar(256) not null, message clob(" + maxMessageSize + ") not null)",
"create index messages_midx on messages(messageid)",
"alter table stores alter destination set data type varchar (" + maxDestinationSize +")" };
}
/* (non-Javadoc)
* @see hermes.store.schema.Statements#getDeleteDatabaseStatements()
*/
public String[] getDeleteDatabaseStatements()
{
return new String[] { "drop table stores", "drop table messages", "drop table storeInfo" };
}
/* (non-Javadoc)
* @see hermes.store.schema.Statements#getDepthStatement()
*/
public String getDepthStatement()
{
return "select count(messageid) from stores where storeId=? and destination=?" ;
}
public String getStoresStatement()
{
return "select distinct(storeid) from storeInfo" ;
}
public String[] getRemoveStoreStatements()
{
return new String[] { "delete from stores where storeId=?", "delete from messages where messageid in (select messageid from stores where storeid=?)", "delete from storeInfo where storeid=?" } ;
}
}