Package org.pgcodekeeper.core.database.ms.schema

Class MsProcedure

java.lang.Object

org.pgcodekeeper.core.database.base.schema.AbstractStatement

org.pgcodekeeper.core.database.ms.schema.MsAbstractStatement

org.pgcodekeeper.core.database.ms.schema.MsAbstractCommonFunction

org.pgcodekeeper.core.database.ms.schema.MsAbstractFunction

org.pgcodekeeper.core.database.ms.schema.MsProcedure

All Implemented Interfaces:

IFunction, ISearchPath, IStatement, MsSourceStatement, IHashable

public class MsProcedure
extends MsAbstractFunction

Represents a Microsoft SQL stored procedure. Supports execution of SQL statements and business logic within the database.

Constructor Summary

Constructors

Constructor	Description
MsProcedure(String name)	Creates a new Microsoft SQL stored procedure.

Method Summary

Modifier and Type	Method	Description
boolean	compare(IStatement obj)	This method does not account for nested child PgStatements.
DbObjType	getStatementType()	Gets the type of this database object.
boolean	needDrop(IFunction newFunction)	Determines whether this function needs to be dropped before creating the new version.

Methods inherited from class org.pgcodekeeper.core.database.ms.schema.MsAbstractFunction

computeHash, getFirstPart, getSecondPart, isAnsiNulls, isQuotedIdentified, setAnsiNulls, setFirstPart, setQuotedIdentified, setSecondPart

Methods inherited from class org.pgcodekeeper.core.database.ms.schema.MsAbstractCommonFunction

addArgument, appendAlterSQL, canDropBeforeCreate, getArguments, getCreationSQL, getReturns, getReturnsColumns, setReturns

Methods inherited from class org.pgcodekeeper.core.database.ms.schema.MsAbstractStatement

appendOwnerSQL, formatSql, getQuoter, getRenameCommand, getSeparator, isOwned

Methods inherited from class org.pgcodekeeper.core.database.base.schema.AbstractStatement

addDependency, addPrivilege, appendAlterComments, appendComments, appendPrivileges, canDrop, checkComments, clearPrivileges, compareChildren, deepCopy, equals, fillChildrenList, fillDescendantsList, getAuthor, getBareName, getChildren, getComment, getDependencies, getDescendants, getDropSQL, getDropSQL, getLibName, getLocation, getName, getObjectState, getObjectState, getOwner, getParent, getPrivileges, getQualifiedName, getSQL, getTwin, hasChildren, hashCode, isLib, setAuthor, setComment, setLibName, setLocation, setOwner, setParent, shallowCopy, toString

Methods inherited from class java.lang.Object

getClass, notify, notifyAll, wait, wait, wait

Methods inherited from interface org.pgcodekeeper.core.database.api.schema.ISearchPath

getContainingSchema, getDatabase, getSchemaName, toObjectReference

Methods inherited from interface org.pgcodekeeper.core.database.api.schema.IStatement

addDependency, appendAlterSQL, appendOwnerSQL, canDrop, canDropBeforeCreate, clearPrivileges, deepCopy, formatSql, getAuthor, getBareName, getChildren, getComment, getCreationSQL, getDependencies, getDescendants, getDropSQL, getLibName, getLocation, getName, getOwner, getParent, getPrivileges, getQualifiedName, getQuotedName, getQuoter, getRenameCommand, getSeparator, getSQL, getTwin, getTypeName, hasChildren, isLib, isOwned, quote, setComment, setLibName, setLocation, setOwner, shallowCopy

Methods inherited from interface org.pgcodekeeper.core.database.ms.schema.MsSourceStatement

appendName, appendSourceStatement

Constructor Details

MsProcedure

public MsProcedure(String name)

Creates a new Microsoft SQL stored procedure.

Parameters:

name - the procedure name

Method Details

getStatementType

public DbObjType getStatementType()

Description copied from interface: IStatement

Gets the type of this database object.

Returns:

the database object type

needDrop

public boolean needDrop(IFunction newFunction)

Description copied from interface: IFunction

Determines whether this function needs to be dropped before creating the new version.

Parameters:

newFunction - the new function version to compare against

Returns:

true if the function needs to be dropped and recreated

compare

public boolean compare(IStatement obj)

Description copied from class: AbstractStatement

This method does not account for nested child PgStatements. Shallow version of AbstractStatement.equals(Object)

Specified by:

compare in interface IStatement

Overrides:

compare in class MsAbstractCommonFunction