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

Class MsClrProcedure

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.MsAbstractClrFunction

org.pgcodekeeper.core.database.ms.schema.MsClrProcedure

All Implemented Interfaces:

IFunction, ISearchPath, IStatement, IHashable

public class MsClrProcedure
extends MsAbstractClrFunction

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

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
boolean	compare(IStatement obj)	This method does not account for nested child PgStatements.
String	getDeclaration(Argument arg)
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.MsAbstractClrFunction

addOption, computeHash

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, appendOwnerSQL, canDrop, clearPrivileges, deepCopy, formatSql, getAuthor, getBareName, getChildren, getComment, 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

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

getDeclaration

public String getDeclaration(Argument arg)

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