SubstringFormatEntry¶
-
class
oci.data_safe.models.SubstringFormatEntry(**kwargs)¶ Bases:
oci.data_safe.models.format_entry.FormatEntryThe Substring masking format extracts a portion of the original column value and uses it to replace the original value. It internally uses the Oracle SUBSTR function. It takes the start position and length as input, extracts substring from the original value using SUBSTR, and uses the substring to replace the original value. To learn more, check Substring in the Data Safe documentation.
Attributes
TYPE_DELETE_ROWSstr(object=’’) -> str TYPE_DETERMINISTIC_ENCRYPTIONstr(object=’’) -> str TYPE_DETERMINISTIC_ENCRYPTION_DATEstr(object=’’) -> str TYPE_DETERMINISTIC_SUBSTITUTIONstr(object=’’) -> str TYPE_FIXED_NUMBERstr(object=’’) -> str TYPE_FIXED_STRINGstr(object=’’) -> str TYPE_LIBRARY_MASKING_FORMATstr(object=’’) -> str TYPE_NULL_VALUEstr(object=’’) -> str TYPE_PATTERNstr(object=’’) -> str TYPE_POST_PROCESSING_FUNCTIONstr(object=’’) -> str TYPE_PRESERVE_ORIGINAL_DATAstr(object=’’) -> str TYPE_RANDOM_DATEstr(object=’’) -> str TYPE_RANDOM_DECIMAL_NUMBERstr(object=’’) -> str TYPE_RANDOM_DIGITSstr(object=’’) -> str TYPE_RANDOM_LISTstr(object=’’) -> str TYPE_RANDOM_NUMBERstr(object=’’) -> str TYPE_RANDOM_STRINGstr(object=’’) -> str TYPE_RANDOM_SUBSTITUTIONstr(object=’’) -> str TYPE_REGULAR_EXPRESSIONstr(object=’’) -> str TYPE_SHUFFLEstr(object=’’) -> str TYPE_SQL_EXPRESSIONstr(object=’’) -> str TYPE_SUBSTRINGstr(object=’’) -> str TYPE_TRUNCATE_TABLEstr(object=’’) -> str TYPE_USER_DEFINED_FUNCTIONstr(object=’’) -> str descriptionGets the description of this FormatEntry. length[Required] Gets the length of this SubstringFormatEntry. start_position[Required] Gets the start_position of this SubstringFormatEntry. type[Required] Gets the type of this FormatEntry. Methods
__init__(**kwargs)Initializes a new SubstringFormatEntry object with values from keyword arguments. get_subtype(object_dictionary)Given the hash representation of a subtype of this class, use the info in the hash to return the class of the subtype. -
TYPE_DELETE_ROWS= 'DELETE_ROWS'¶
-
TYPE_DETERMINISTIC_ENCRYPTION= 'DETERMINISTIC_ENCRYPTION'¶
-
TYPE_DETERMINISTIC_ENCRYPTION_DATE= 'DETERMINISTIC_ENCRYPTION_DATE'¶
-
TYPE_DETERMINISTIC_SUBSTITUTION= 'DETERMINISTIC_SUBSTITUTION'¶
-
TYPE_FIXED_NUMBER= 'FIXED_NUMBER'¶
-
TYPE_FIXED_STRING= 'FIXED_STRING'¶
-
TYPE_LIBRARY_MASKING_FORMAT= 'LIBRARY_MASKING_FORMAT'¶
-
TYPE_NULL_VALUE= 'NULL_VALUE'¶
-
TYPE_PATTERN= 'PATTERN'¶
-
TYPE_POST_PROCESSING_FUNCTION= 'POST_PROCESSING_FUNCTION'¶
-
TYPE_PRESERVE_ORIGINAL_DATA= 'PRESERVE_ORIGINAL_DATA'¶
-
TYPE_RANDOM_DATE= 'RANDOM_DATE'¶
-
TYPE_RANDOM_DECIMAL_NUMBER= 'RANDOM_DECIMAL_NUMBER'¶
-
TYPE_RANDOM_DIGITS= 'RANDOM_DIGITS'¶
-
TYPE_RANDOM_LIST= 'RANDOM_LIST'¶
-
TYPE_RANDOM_NUMBER= 'RANDOM_NUMBER'¶
-
TYPE_RANDOM_STRING= 'RANDOM_STRING'¶
-
TYPE_RANDOM_SUBSTITUTION= 'RANDOM_SUBSTITUTION'¶
-
TYPE_REGULAR_EXPRESSION= 'REGULAR_EXPRESSION'¶
-
TYPE_SHUFFLE= 'SHUFFLE'¶
-
TYPE_SQL_EXPRESSION= 'SQL_EXPRESSION'¶
-
TYPE_SUBSTRING= 'SUBSTRING'¶
-
TYPE_TRUNCATE_TABLE= 'TRUNCATE_TABLE'¶
-
TYPE_USER_DEFINED_FUNCTION= 'USER_DEFINED_FUNCTION'¶
-
__init__(**kwargs)¶ Initializes a new SubstringFormatEntry object with values from keyword arguments. The default value of the
typeattribute of this class isSUBSTRINGand it should not be changed. The following keyword arguments are supported (corresponding to the getters/setters of this class):Parameters: - type (str) – The value to assign to the type property of this SubstringFormatEntry. Allowed values for this property are: “DELETE_ROWS”, “DETERMINISTIC_SUBSTITUTION”, “DETERMINISTIC_ENCRYPTION”, “DETERMINISTIC_ENCRYPTION_DATE”, “FIXED_NUMBER”, “FIXED_STRING”, “LIBRARY_MASKING_FORMAT”, “NULL_VALUE”, “PATTERN”, “POST_PROCESSING_FUNCTION”, “PRESERVE_ORIGINAL_DATA”, “RANDOM_DATE”, “RANDOM_DECIMAL_NUMBER”, “RANDOM_DIGITS”, “RANDOM_LIST”, “RANDOM_NUMBER”, “RANDOM_STRING”, “RANDOM_SUBSTITUTION”, “REGULAR_EXPRESSION”, “SHUFFLE”, “SQL_EXPRESSION”, “SUBSTRING”, “TRUNCATE_TABLE”, “USER_DEFINED_FUNCTION”
- description (str) – The value to assign to the description property of this SubstringFormatEntry.
- start_position (int) – The value to assign to the start_position property of this SubstringFormatEntry.
- length (int) – The value to assign to the length property of this SubstringFormatEntry.
-
description¶ Gets the description of this FormatEntry. The description of the format entry.
Returns: The description of this FormatEntry. Return type: str
-
static
get_subtype(object_dictionary)¶ Given the hash representation of a subtype of this class, use the info in the hash to return the class of the subtype.
-
length¶ [Required] Gets the length of this SubstringFormatEntry. The number of characters that should be there in the substring. It should be an integer and greater than zero.
Returns: The length of this SubstringFormatEntry. Return type: int
-
start_position¶ [Required] Gets the start_position of this SubstringFormatEntry. The starting position in the original string from where the substring should be extracted. It can be either a positive or a negative integer. If It’s negative, the counting starts from the end of the string.
Returns: The start_position of this SubstringFormatEntry. Return type: int
-
type¶ [Required] Gets the type of this FormatEntry. The type of the format entry.
Allowed values for this property are: “DELETE_ROWS”, “DETERMINISTIC_SUBSTITUTION”, “DETERMINISTIC_ENCRYPTION”, “DETERMINISTIC_ENCRYPTION_DATE”, “FIXED_NUMBER”, “FIXED_STRING”, “LIBRARY_MASKING_FORMAT”, “NULL_VALUE”, “PATTERN”, “POST_PROCESSING_FUNCTION”, “PRESERVE_ORIGINAL_DATA”, “RANDOM_DATE”, “RANDOM_DECIMAL_NUMBER”, “RANDOM_DIGITS”, “RANDOM_LIST”, “RANDOM_NUMBER”, “RANDOM_STRING”, “RANDOM_SUBSTITUTION”, “REGULAR_EXPRESSION”, “SHUFFLE”, “SQL_EXPRESSION”, “SUBSTRING”, “TRUNCATE_TABLE”, “USER_DEFINED_FUNCTION”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
Returns: The type of this FormatEntry. Return type: str
-