Package org.pgcodekeeper.core.schema.ms

Class MsClrProcedure

java.lang.Object

org.pgcodekeeper.core.schema.PgStatement

org.pgcodekeeper.core.schema.AbstractFunction

org.pgcodekeeper.core.schema.ms.AbstractMsClrFunction

org.pgcodekeeper.core.schema.ms.MsClrProcedure

All Implemented Interfaces:

IHashable, IFunction, ISearchPath, IStatement

public final class MsClrProcedure
extends AbstractMsClrFunction

Represents a Microsoft SQL CLR stored procedure. CLR procedures are implemented in managed code and executed within the SQL Server runtime.

Field Summary

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

GO

Constructor Summary

Constructors

Constructor	Description
MsClrProcedure(String name, String assembly, String assemblyClass, String assemblyMethod)	Creates a new Microsoft SQL CLR procedure.

Method Summary

Modifier and Type	Method	Description
String	getDeclaration(Argument arg)
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.AbstractMsClrFunction

addOption, computeHash, getDbType, 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

getDatabase, getSchemaName

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

getBareName, getComment, getName, getParent, getQualifiedName

Constructor Details

MsClrProcedure

public MsClrProcedure(String name,
 String assembly,
 String assemblyClass,
 String assemblyMethod)

Creates a new Microsoft SQL CLR procedure.

Parameters:

name - the procedure name

assembly - the assembly name containing the implementation

assemblyClass - the class within the assembly

assemblyMethod - the method within the class

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

getDeclaration

public String getDeclaration(Argument arg)