Package org.flywaydb.database.sqlserver

Class SQLServerSchema

java.lang.Object

org.flywaydb.core.internal.database.base.Schema<SQLServerDatabase,SQLServerTable>

org.flywaydb.database.sqlserver.SQLServerSchema

Direct Known Subclasses:

SynapseSchema

public class SQLServerSchema
extends org.flywaydb.core.internal.database.base.Schema<SQLServerDatabase,SQLServerTable>

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static class	SQLServerSchema.DBObject	SQL Server object meta-data.
protected static enum	SQLServerSchema.ObjectType	SQL Server object types for which we support automatic clean-up.

Field Summary

Fields

Modifier and Type	Field	Description
protected final String	databaseName

Fields inherited from class org.flywaydb.core.internal.database.base.Schema

database, jdbcTemplate, name

Constructor Summary

Constructors

Constructor	Description
SQLServerSchema(org.flywaydb.core.internal.jdbc.JdbcTemplate jdbcTemplate, SQLServerDatabase database, String databaseName, String name)

Method Summary

Modifier and Type	Method	Description
protected List<String>	cleanObjects(String dropQualifier, SQLServerSchema.ObjectType... objectTypes)
protected List<String>	cleanRules()
protected List<String>	cleanSynonyms()
protected List<String>	cleanTriggers()
protected SQLServerTable[]	doAllTables()
protected void	doClean()
protected void	doCreate()
protected void	doDrop()
protected boolean	doEmpty()
protected boolean	doExists()
org.flywaydb.core.internal.database.base.Table	getTable(String tableName)
protected List<SQLServerSchema.DBObject>	queryDBObjects(SQLServerSchema.ObjectType... types)	Query objects with any of the given types.

Methods inherited from class org.flywaydb.core.internal.database.base.Schema

allFunctions, allTables, allTypes, clean, create, doAllFunctions, drop, empty, equals, exists, getFunction, getName, getType, hashCode, toString

Methods inherited from class java.lang.Object

clone, finalize, getClass, notify, notifyAll, wait, wait, wait

Field Details

databaseName

protected final String databaseName

Constructor Details

SQLServerSchema

public SQLServerSchema(org.flywaydb.core.internal.jdbc.JdbcTemplate jdbcTemplate,
 SQLServerDatabase database,
 String databaseName,
 String name)

Method Details

doExists

protected boolean doExists()
                    throws SQLException

Specified by:

doExists in class org.flywaydb.core.internal.database.base.Schema<SQLServerDatabase,SQLServerTable>

Throws:

SQLException

doEmpty

protected boolean doEmpty()
                   throws SQLException

Specified by:

doEmpty in class org.flywaydb.core.internal.database.base.Schema<SQLServerDatabase,SQLServerTable>

Throws:

SQLException

doCreate

protected void doCreate()
                 throws SQLException

Specified by:

doCreate in class org.flywaydb.core.internal.database.base.Schema<SQLServerDatabase,SQLServerTable>

Throws:

SQLException

doDrop

protected void doDrop()
               throws SQLException

Specified by:

doDrop in class org.flywaydb.core.internal.database.base.Schema<SQLServerDatabase,SQLServerTable>

Throws:

SQLException

doClean

protected void doClean()
                throws SQLException

Specified by:

doClean in class org.flywaydb.core.internal.database.base.Schema<SQLServerDatabase,SQLServerTable>

Throws:

SQLException

queryDBObjects

protected List<SQLServerSchema.DBObject> queryDBObjects(SQLServerSchema.ObjectType... types)
                                                 throws SQLException

Query objects with any of the given types.

Parameters:

types - The object types to be queried.

Returns:

The found objects.

Throws:

SQLException - when the retrieval failed.

cleanTriggers

protected List<String> cleanTriggers()
                              throws SQLException

Returns:

The drop statements.

Throws:

SQLException - when the clean statements could not be generated.

cleanSynonyms

protected List<String> cleanSynonyms()
                              throws SQLException

Returns:

The drop statements.

Throws:

SQLException - when the clean statements could not be generated.

cleanRules

protected List<String> cleanRules()
                           throws SQLException

Returns:

The drop statements.

Throws:

SQLException - when the clean statements could not be generated.

cleanObjects

protected List<String> cleanObjects(String dropQualifier,
 SQLServerSchema.ObjectType... objectTypes)
                             throws SQLException

Parameters:

dropQualifier - The type of DROP statement to issue.

objectTypes - The type of objects to drop.

Returns:

The drop statements.

Throws:

SQLException - when the clean statements could not be generated.

doAllTables

protected SQLServerTable[] doAllTables()
                                throws SQLException

Specified by:

doAllTables in class org.flywaydb.core.internal.database.base.Schema<SQLServerDatabase,SQLServerTable>

Throws:

SQLException

getTable

public org.flywaydb.core.internal.database.base.Table getTable(String tableName)

Specified by:

getTable in class org.flywaydb.core.internal.database.base.Schema<SQLServerDatabase,SQLServerTable>