Qore MssqlSqlUtilBase Module Reference 1.0
Loading...
Searching...
No Matches
MssqlSqlUtilBase::MssqlUniqueConstraint Class Reference

class modeling a unique constraint More...

#include <MssqlSqlUtilBase.qm.dox.h>

Inheritance diagram for MssqlSqlUtilBase::MssqlUniqueConstraint:
[legend]

Public Member Methods

 constructor (string n, hash n_cols, bool e=True, *string ts)
 creates the object with the given attributes More...
 
string getCreateSql (string name, string table_name, *hash opts)
 returns a string that can be used to rename the constraint
 
string getCreateSql (string table_name, *hash opts)
 returns a string that can be used to create the constraint
 
bool isEnabled ()
 returns True if the constraint is enabled, False if not
 
MssqlColumn memberGate (string k)
 returns the MssqlColumn value of the given key if it exists, otherwise throws a KEY-ERROR exception More...
 
- Public Member Methods inherited from MssqlSqlUtilBase::MssqlUniqueConstraintCommon
 clearIndex ()
 clears any index base for the constraint
 
 constructor (*string ts)
 creates the constraint with an optional filegroup name
 
 getIndexSql (reference< string > sql, string name, *hash opts)
 adds index options onto the sql creation string
 
*string getTablespace ()
 returns the filegroup name used for this constraint, if known
 
bool setIndexBase (string ix)
 sets the supporting index name
 
 setTablespace (*string ts)
 sets or clears the filegroup name
 

Private Attributes

bool enabled
 True if the constraint is enabled, False if not
 
- Private Attributes inherited from MssqlSqlUtilBase::MssqlUniqueConstraintCommon
*string filegroup
 any filegroup for the unique key index
 

Additional Inherited Members

- Private Member Methods inherited from MssqlSqlUtilBase::MssqlUniqueConstraintCommon
 constructor ()
 empty constructor for subclasses
 

Detailed Description

class modeling a unique constraint

Member Function Documentation

◆ constructor()

MssqlSqlUtilBase::MssqlUniqueConstraint::constructor ( string  n,
hash  n_cols,
bool  e = True,
*string  ts 
)

creates the object with the given attributes

Parameters
nname of the constraint
n_colscolumn hash
ethe enabled status of the constraint
tsoptional filegroup name

◆ memberGate()

MssqlColumn MssqlSqlUtilBase::MssqlUniqueConstraint::memberGate ( string  k)

returns the MssqlColumn value of the given key if it exists, otherwise throws a KEY-ERROR exception

Example:
auto v = c.name;
Parameters
kthe name of the key to access
Returns
the value of the given key in the contained hash if it exists
Exceptions
KEY-ERRORthe given key does not exist in the contained hash
Note
this method is called automatically when an unknown or inaccessible member name is accessed from outside the class
See also
memberGate() Method