org.tinygroup.database.table.TableSqlProcessor Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of org.tinygroup.database Show documentation

There is a newer version: 3.0.0

Show newest version

/**
 *  Copyright (c) 1997-2013, www.tinygroup.org ([email protected]).
 *
 *  Licensed under the GPL, Version 3.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.gnu.org/licenses/gpl.html
 *
 *  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 org.tinygroup.database.table;

import org.tinygroup.database.config.table.Table;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;


public interface TableSqlProcessor {
	String NULLABLE="NULLABLE";
	String TYPE_NAME="TYPE_NAME";
	String DATA_TYPE="DATA_TYPE";
	String COLUMN_SIZE="COLUMN_SIZE";
	String DECIMAL_DIGITS="DECIMAL_DIGITS";
	String COLUMN_NAME="COLUMN_NAME";
	String COLUMN_DEF="COLUMN_DEF";//默认值
	String REMARKS="REMARKS";//注释

	String INDEX_NON_UNIQUE = "NON_UNIQUE";//索引值是否可以不唯一
	/**
	 * 获得创建表格的语句(包含index)
	 * @param table
	 * @param packageName
	 * @return
	 */
	List getCreateSql(Table table, String packageName);
	/**
	 * 获得创建表格的语句(不包含index)
	 * @param table
	 * @param packageName
	 * @return
	 */
	List getTableCreateSql(Table table, String packageName);
	/**
	 * 获得创建索引的语句
	 * @param table
	 * @param packageName
	 * @return
	 */
	List getIndexCreateSql(Table table, String packageName);
	
	List getForeignKeySqls(Table table,
			String packageName);
	/**
	 * 获得(正向)Update表格的语句
	 * @param table
	 * @param packageName
	 * @param connection
	 * @return
	 */
	List getUpdateSql(Table table, String packageName,
			Connection connection)throws SQLException;
	
	
	String getDropSql(Table table, String packageName);
	
	boolean checkTableExist(Table table,Connection connection)throws SQLException;
	
	TableProcessor getTableProcessor() ;

	void setTableProcessor(TableProcessor tableProcessor);
}