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

Class MsRole

java.lang.Object

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

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

org.pgcodekeeper.core.database.ms.schema.MsRole

All Implemented Interfaces:

IStatement, IHashable

public class MsRole
extends MsAbstractStatement

Represents a Microsoft SQL database role. Roles are used to group users and manage permissions at the database level.

Constructor Summary

Constructors

Constructor	Description
MsRole(String name)	Creates a new Microsoft SQL role.

Method Summary

Modifier and Type	Method	Description
void	addMember(String member)	Adds a member to this role.
ObjectState	appendAlterSQL(IStatement newCondition, SQLScript script)	Fill script with object changes and return change type
boolean	compare(IStatement obj)	This method does not account for nested child PgStatements.
void	computeHash(Hasher hasher)	Computes the hash of the implementing object using the provided hasher.
void	getCreationSQL(SQLScript script)	Generates the SQL statements needed to create this database object.
void	getDropSQL(SQLScript script, boolean optionExists)	Generates DROP SQL for this statement.
DbObjType	getStatementType()	Gets the type of this database object.

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, canDropBeforeCreate, checkComments, clearPrivileges, compareChildren, deepCopy, equals, fillChildrenList, fillDescendantsList, getAuthor, getBareName, getChildren, getComment, getDependencies, getDescendants, 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.IStatement

getDatabase, getQuotedName, getTypeName, quote, toObjectReference

Constructor Details

MsRole

public MsRole(String name)

Creates a new Microsoft SQL role.

Parameters:

name - the role name

Method Details

getStatementType

public DbObjType getStatementType()

Description copied from interface: IStatement

Gets the type of this database object.

Returns:

the database object type

getCreationSQL

public void getCreationSQL(SQLScript script)

Description copied from interface: IStatement

Generates the SQL statements needed to create this database object. This is an abstract method that must be implemented by subclasses to provide the specific CREATE SQL for each object type.

Parameters:

script - the SQL script to append creation statements to

appendAlterSQL

public ObjectState appendAlterSQL(IStatement newCondition,
 SQLScript script)

Description copied from interface: IStatement

Fill script with object changes and return change type

Parameters:

newCondition - new object state

script - script to collect changes

Returns:

object change type

getDropSQL

public void getDropSQL(SQLScript script,
 boolean optionExists)

Description copied from interface: IStatement

Generates DROP SQL for this statement.

Specified by:

getDropSQL in interface IStatement

Overrides:

getDropSQL in class AbstractStatement

Parameters:

script - the SQL script to append the DROP statement to

optionExists - whether to include "IF EXISTS" in the DROP statement

addMember

public void addMember(String member)

Adds a member to this role.

Parameters:

member - the user or role name to add as a member

computeHash

public void computeHash(Hasher hasher)

Description copied from interface: IHashable

Computes the hash of the implementing object using the provided hasher. The implementation should call appropriate put methods on the hasher for all fields that should contribute to the hash value.

Parameters:

hasher - the hasher instance to use for hash computation

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 AbstractStatement