Package org.pgcodekeeper.core.schema.ms

Class MsProcedure

java.lang.Object

org.pgcodekeeper.core.schema.PgStatement

org.pgcodekeeper.core.schema.AbstractFunction

org.pgcodekeeper.core.schema.ms.AbstractMsFunction

org.pgcodekeeper.core.schema.ms.MsProcedure

All Implemented Interfaces:

IHashable, IFunction, ISearchPath, IStatement, SourceStatement

public final class MsProcedure
extends AbstractMsFunction

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

Field Summary

Fields inherited from class org.pgcodekeeper.core.schema.PgStatement

GO

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method	Description
DbObjType	getStatementType()	Gets the type of this database object.
boolean	needDrop(AbstractFunction newFunction)	Determines whether this function needs to be dropped before creating the new version.

Methods inherited from class org.pgcodekeeper.core.schema.ms.AbstractMsFunction

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

Methods inherited from class org.pgcodekeeper.core.schema.AbstractFunction

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

Methods inherited from class org.pgcodekeeper.core.schema.PgStatement

addAllDeps, addDep, addPrivilege, appendAlterComments, appendComments, appendOwnerSQL, canDrop, checkComments, clearPrivileges, compareChildren, deepCopy, equals, getAuthor, getBareName, getChildren, getComment, getDeps, getDescendants, getDropSQL, getDropSQL, getLibName, getLocation, getName, getObjectState, getObjectState, getOwner, getParent, getPrivileges, getQualifiedName, getSQL, getTwin, getTypeName, hasChildren, hashCode, isLib, isOwned, isSubElement, setAuthor, setComment, setLibName, setLocation, setOwner, setParent, toString

Methods inherited from class java.lang.Object

getClass, notify, notifyAll, wait, wait, wait

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

getContainingSchema, getDatabase, getSchemaName

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

getBareName, getComment, getName, getParent, getQualifiedName

Methods inherited from interface org.pgcodekeeper.core.schema.SourceStatement

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(AbstractFunction newFunction)

Description copied from class: AbstractFunction

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

Specified by:

needDrop in class AbstractFunction

Parameters:

newFunction - the new function version to compare against

Returns:

true if the function needs to be dropped and recreated