Class: OCI::DatabaseManagement::Models::DropSqlsInSqlTuningSetDetails
- Inherits:
-
Object
- Object
- OCI::DatabaseManagement::Models::DropSqlsInSqlTuningSetDetails
- Defined in:
- lib/oci/database_management/models/drop_sqls_in_sql_tuning_set_details.rb
Overview
Drops the selected list of Sql statements from the current Sql tuning set. The basicFilter parameter specifies the Sql predicate to filter the Sql from the Sql tuning set defined on attributes of the SQLSET_ROW. If a valid filter criteria is specified, then, Sql statements matching this filter criteria will be deleted from the current Sql tuning set. If filter criteria is not specified, then, all Sql statements will be deleted from the current Sql tuning set. It takes either credentialDetails or databaseCredential. It's recommended to provide databaseCredential
Instance Attribute Summary collapse
-
#basic_filter ⇒ String
Specifies the Sql predicate to filter the Sql from the Sql tuning set defined on attributes of the SQLSET_ROW.
- #credential_details ⇒ OCI::DatabaseManagement::Models::SqlTuningSetAdminCredentialDetails
- #database_credential ⇒ OCI::DatabaseManagement::Models::DatabaseCredentialDetails
-
#name ⇒ String
[Required] The name of the Sql tuning set.
-
#owner ⇒ String
The owner of the Sql tuning set.
-
#show_sql_only ⇒ Integer
Flag to indicate whether to drop the Sql statements or just display the plsql used to drop the Sql statements.
Class Method Summary collapse
-
.attribute_map ⇒ Object
Attribute mapping from ruby-style variable name to JSON key.
-
.swagger_types ⇒ Object
Attribute type mapping.
Instance Method Summary collapse
-
#==(other) ⇒ Object
Checks equality by comparing each attribute.
-
#build_from_hash(attributes) ⇒ Object
Builds the object from hash.
- #eql?(other) ⇒ Boolean
-
#hash ⇒ Fixnum
Calculates hash code according to all attributes.
-
#initialize(attributes = {}) ⇒ DropSqlsInSqlTuningSetDetails
constructor
Initializes the object.
-
#to_hash ⇒ Hash
Returns the object in the form of hash.
-
#to_s ⇒ String
Returns the string representation of the object.
Constructor Details
#initialize(attributes = {}) ⇒ DropSqlsInSqlTuningSetDetails
Initializes the object
82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 |
# File 'lib/oci/database_management/models/drop_sqls_in_sql_tuning_set_details.rb', line 82 def initialize(attributes = {}) return unless attributes.is_a?(Hash) # convert string to symbol for hash key attributes = attributes.each_with_object({}) { |(k, v), h| h[k.to_sym] = v } self.credential_details = attributes[:'credentialDetails'] if attributes[:'credentialDetails'] raise 'You cannot provide both :credentialDetails and :credential_details' if attributes.key?(:'credentialDetails') && attributes.key?(:'credential_details') self.credential_details = attributes[:'credential_details'] if attributes[:'credential_details'] self.database_credential = attributes[:'databaseCredential'] if attributes[:'databaseCredential'] raise 'You cannot provide both :databaseCredential and :database_credential' if attributes.key?(:'databaseCredential') && attributes.key?(:'database_credential') self.database_credential = attributes[:'database_credential'] if attributes[:'database_credential'] self.show_sql_only = attributes[:'showSqlOnly'] if attributes[:'showSqlOnly'] raise 'You cannot provide both :showSqlOnly and :show_sql_only' if attributes.key?(:'showSqlOnly') && attributes.key?(:'show_sql_only') self.show_sql_only = attributes[:'show_sql_only'] if attributes[:'show_sql_only'] self.owner = attributes[:'owner'] if attributes[:'owner'] self.owner = "null" if owner.nil? && !attributes.key?(:'owner') # rubocop:disable Style/StringLiterals self.name = attributes[:'name'] if attributes[:'name'] self.basic_filter = attributes[:'basicFilter'] if attributes[:'basicFilter'] self.basic_filter = "null" if basic_filter.nil? && !attributes.key?(:'basicFilter') # rubocop:disable Style/StringLiterals raise 'You cannot provide both :basicFilter and :basic_filter' if attributes.key?(:'basicFilter') && attributes.key?(:'basic_filter') self.basic_filter = attributes[:'basic_filter'] if attributes[:'basic_filter'] self.basic_filter = "null" if basic_filter.nil? && !attributes.key?(:'basicFilter') && !attributes.key?(:'basic_filter') # rubocop:disable Style/StringLiterals end |
Instance Attribute Details
#basic_filter ⇒ String
Specifies the Sql predicate to filter the Sql from the Sql tuning set defined on attributes of the SQLSET_ROW. User could use any combination of the following columns with appropriate values as Sql predicate Refer to the documentation docs.oracle.com/en/database/oracle/oracle-database/18/arpls/DBMS_SQLTUNE.html#GUID-1F4AFB03-7B29-46FC-B3F2-CB01EC36326C
40 41 42 |
# File 'lib/oci/database_management/models/drop_sqls_in_sql_tuning_set_details.rb', line 40 def basic_filter @basic_filter end |
#credential_details ⇒ OCI::DatabaseManagement::Models::SqlTuningSetAdminCredentialDetails
17 18 19 |
# File 'lib/oci/database_management/models/drop_sqls_in_sql_tuning_set_details.rb', line 17 def credential_details @credential_details end |
#database_credential ⇒ OCI::DatabaseManagement::Models::DatabaseCredentialDetails
20 21 22 |
# File 'lib/oci/database_management/models/drop_sqls_in_sql_tuning_set_details.rb', line 20 def database_credential @database_credential end |
#name ⇒ String
[Required] The name of the Sql tuning set.
33 34 35 |
# File 'lib/oci/database_management/models/drop_sqls_in_sql_tuning_set_details.rb', line 33 def name @name end |
#owner ⇒ String
The owner of the Sql tuning set.
29 30 31 |
# File 'lib/oci/database_management/models/drop_sqls_in_sql_tuning_set_details.rb', line 29 def owner @owner end |
#show_sql_only ⇒ Integer
Flag to indicate whether to drop the Sql statements or just display the plsql used to drop the Sql statements.
25 26 27 |
# File 'lib/oci/database_management/models/drop_sqls_in_sql_tuning_set_details.rb', line 25 def show_sql_only @show_sql_only end |
Class Method Details
.attribute_map ⇒ Object
Attribute mapping from ruby-style variable name to JSON key.
43 44 45 46 47 48 49 50 51 52 53 54 |
# File 'lib/oci/database_management/models/drop_sqls_in_sql_tuning_set_details.rb', line 43 def self.attribute_map { # rubocop:disable Style/SymbolLiteral 'credential_details': :'credentialDetails', 'database_credential': :'databaseCredential', 'show_sql_only': :'showSqlOnly', 'owner': :'owner', 'name': :'name', 'basic_filter': :'basicFilter' # rubocop:enable Style/SymbolLiteral } end |
.swagger_types ⇒ Object
Attribute type mapping.
57 58 59 60 61 62 63 64 65 66 67 68 |
# File 'lib/oci/database_management/models/drop_sqls_in_sql_tuning_set_details.rb', line 57 def self.swagger_types { # rubocop:disable Style/SymbolLiteral 'credential_details': :'OCI::DatabaseManagement::Models::SqlTuningSetAdminCredentialDetails', 'database_credential': :'OCI::DatabaseManagement::Models::DatabaseCredentialDetails', 'show_sql_only': :'Integer', 'owner': :'String', 'name': :'String', 'basic_filter': :'String' # rubocop:enable Style/SymbolLiteral } end |
Instance Method Details
#==(other) ⇒ Object
Checks equality by comparing each attribute.
127 128 129 130 131 132 133 134 135 136 137 |
# File 'lib/oci/database_management/models/drop_sqls_in_sql_tuning_set_details.rb', line 127 def ==(other) return true if equal?(other) self.class == other.class && credential_details == other.credential_details && database_credential == other.database_credential && show_sql_only == other.show_sql_only && owner == other.owner && name == other.name && basic_filter == other.basic_filter end |
#build_from_hash(attributes) ⇒ Object
Builds the object from hash
162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 |
# File 'lib/oci/database_management/models/drop_sqls_in_sql_tuning_set_details.rb', line 162 def build_from_hash(attributes) return nil unless attributes.is_a?(Hash) self.class.swagger_types.each_pair do |key, type| if type =~ /^Array<(.*)>/i # check to ensure the input is an array given that the the attribute # is documented as an array but the input is not if attributes[self.class.attribute_map[key]].is_a?(Array) public_method("#{key}=").call( attributes[self.class.attribute_map[key]] .map { |v| OCI::Internal::Util.convert_to_type(Regexp.last_match(1), v) } ) end elsif !attributes[self.class.attribute_map[key]].nil? public_method("#{key}=").call( OCI::Internal::Util.convert_to_type(type, attributes[self.class.attribute_map[key]]) ) end # or else data not found in attributes(hash), not an issue as the data can be optional end self end |
#eql?(other) ⇒ Boolean
142 143 144 |
# File 'lib/oci/database_management/models/drop_sqls_in_sql_tuning_set_details.rb', line 142 def eql?(other) self == other end |
#hash ⇒ Fixnum
Calculates hash code according to all attributes.
151 152 153 |
# File 'lib/oci/database_management/models/drop_sqls_in_sql_tuning_set_details.rb', line 151 def hash [credential_details, database_credential, show_sql_only, owner, name, basic_filter].hash end |
#to_hash ⇒ Hash
Returns the object in the form of hash
195 196 197 198 199 200 201 202 203 204 |
# File 'lib/oci/database_management/models/drop_sqls_in_sql_tuning_set_details.rb', line 195 def to_hash hash = {} self.class.attribute_map.each_pair do |attr, param| value = public_method(attr).call next if value.nil? && !instance_variable_defined?("@#{attr}") hash[param] = _to_hash(value) end hash end |
#to_s ⇒ String
Returns the string representation of the object
189 190 191 |
# File 'lib/oci/database_management/models/drop_sqls_in_sql_tuning_set_details.rb', line 189 def to_s to_hash.to_s end |