Qore OracleSqlUtilBase Module Reference 1.6
Loading...
Searching...
No Matches
OracleSqlUtilBase::OraclePrimaryKey Class Reference

represents an Oracle primary key More...

Public Member Functions

 clearIndex ()
 clears any index base for the constraint
string getDisableSql (string table_name)
 returns a string that can be used to temporarily disable the constraint from the database
string getDropSql (string table_name)
 returns a string that can be used to drop the constraint from the database
string getEnableSql (string table_name, *hash opt)
 returns a string that can be used to enable the constraint in the database
OracleColumn memberGate (string k)
 returns the OracleColumn value of the given key if it exists, otherwise throws a KEY-ERROR exception

Protected Attributes

*string tablespace
 any tablespace for the primary key index

Detailed Description

represents an Oracle primary key

Member Function Documentation

◆ getDropSql()

string OracleSqlUtilBase::OraclePrimaryKey::getDropSql ( string table_name)

returns a string that can be used to drop the constraint from the database

we use "keep index" to ensure that indexes are not dropped automatically for consistency's sake

◆ memberGate()

OracleColumn OracleSqlUtilBase::OraclePrimaryKey::memberGate ( string k)

returns the OracleColumn 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