org.tinygroup.database

Interface DatabaseSQLGenerator

public interface DatabaseSQLGenerator

数据库脚本生成器

Author:

luoguo

Method Summary

Modifier and Type	Method and Description
String	getCreateIndexSql(String dialectName, String packgeName, String tableName, String indexName) 返回索引SQL
String	getCreateProcedureSql(String dialectName, String packgeName, String procedureName) 返回创建存储过程SQL
String	getCreateTableSql(String dialectName, String packgeName, String tableName) 返回建表语句
String	getCreateViewSql(String dialectName, String packgeName, String viewName) 返回视图创建SQL语句
String	getCustomSql(String dialectName, String packgeName, String customSqlName) 返回自定义SQL的SQL语句
List<String>	getInitDataSql(String dialectName, String tableName) 返回初始化脚本

Method Detail

getCustomSql

String getCustomSql(String dialectName,
                    String packgeName,
                    String customSqlName)

返回自定义SQL的SQL语句

Parameters:

dialectName - 方言名称

packgeName - 包名

customSqlName - 自定义Sql名称

Returns:

SQL语句

getCreateTableSql

String getCreateTableSql(String dialectName,
                         String packgeName,
                         String tableName)

返回建表语句

Parameters:

dialectName -

packgeName -

tableName -

Returns:

getCreateViewSql

String getCreateViewSql(String dialectName,
                        String packgeName,
                        String viewName)

返回视图创建SQL语句

Parameters:

dialectName -

packgeName -

viewName -

Returns:

getCreateIndexSql

String getCreateIndexSql(String dialectName,
                         String packgeName,
                         String tableName,
                         String indexName)

返回索引SQL

Parameters:

dialectName -

packgeName -

indexName -

Returns:

getCreateProcedureSql

String getCreateProcedureSql(String dialectName,
                             String packgeName,
                             String procedureName)

返回创建存储过程SQL

Parameters:

dialectName -

packgeName -

procedureName -

Returns:

getInitDataSql

List<String> getInitDataSql(String dialectName,
                            String tableName)

返回初始化脚本

Parameters:

dialectName -

tableName -

Returns: