Class: OCI::DatabaseManagement::Models::DropSqlsInSqlTuningSetDetails

Inherits:
Object
  • Object
show all
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.

Instance Attribute Summary collapse

Class Method Summary collapse

Instance Method Summary collapse

Constructor Details

#initialize(attributes = {}) ⇒ DropSqlsInSqlTuningSetDetails

Initializes the object

Parameters:

  • attributes (Hash) (defaults to: {}) —

    Model attributes in the form of hash

Options Hash (attributes):



76
77
78
79
80
81
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
 
# File 'lib/oci/database_management/models/drop_sqls_in_sql_tuning_set_details.rb', line 76

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.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

Returns:

  • (String) 


37
38
39
 
# File 'lib/oci/database_management/models/drop_sqls_in_sql_tuning_set_details.rb', line 37

def basic_filter
  @basic_filter
end

#credential_details ⇒ OCI::DatabaseManagement::Models::SqlTuningSetAdminCredentialDetails

This attribute is required.

Returns:



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

#name ⇒ String

[Required] The name of the Sql tuning set.

Returns:

  • (String) 


30
31
32
 
# File 'lib/oci/database_management/models/drop_sqls_in_sql_tuning_set_details.rb', line 30

def name
  @name
end

#owner ⇒ String

The owner of the Sql tuning set.

Returns:

  • (String) 


26
27
28
 
# File 'lib/oci/database_management/models/drop_sqls_in_sql_tuning_set_details.rb', line 26

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.

Returns:

  • (Integer) 


22
23
24
 
# File 'lib/oci/database_management/models/drop_sqls_in_sql_tuning_set_details.rb', line 22

def show_sql_only
  @show_sql_only
end

Class Method Details

.attribute_map ⇒ Object

Attribute mapping from ruby-style variable name to JSON key.



40
41
42
43
44
45
46
47
48
49
50
 
# File 'lib/oci/database_management/models/drop_sqls_in_sql_tuning_set_details.rb', line 40

def self.attribute_map
  {
    # rubocop:disable Style/SymbolLiteral
    'credential_details': :'credentialDetails',
    'show_sql_only': :'showSqlOnly',
    'owner': :'owner',
    'name': :'name',
    'basic_filter': :'basicFilter'
    # rubocop:enable Style/SymbolLiteral
  }
end

.swagger_types ⇒ Object

Attribute type mapping.



53
54
55
56
57
58
59
60
61
62
63
 
# File 'lib/oci/database_management/models/drop_sqls_in_sql_tuning_set_details.rb', line 53

def self.swagger_types
  {
    # rubocop:disable Style/SymbolLiteral
    'credential_details': :'OCI::DatabaseManagement::Models::SqlTuningSetAdminCredentialDetails',
    '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.

Parameters:

  • other (Object) —

    the other object to be compared



115
116
117
118
119
120
121
122
123
124
 
# File 'lib/oci/database_management/models/drop_sqls_in_sql_tuning_set_details.rb', line 115

def ==(other)
  return true if equal?(other)

  self.class == other.class &&
    credential_details == other.credential_details &&
    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

Parameters:

  • attributes (Hash) —

    Model attributes in the form of hash

Returns:

  • (Object) —

    Returns the model itself



149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
 
# File 'lib/oci/database_management/models/drop_sqls_in_sql_tuning_set_details.rb', line 149

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

Parameters:

  • other (Object) —

    the other object to be compared

Returns:

  • (Boolean)

See Also:

  • `==` method


129
130
131
 
# File 'lib/oci/database_management/models/drop_sqls_in_sql_tuning_set_details.rb', line 129

def eql?(other)
  self == other
end

#hash ⇒ Fixnum

Calculates hash code according to all attributes.

Returns:

  • (Fixnum) —

    Hash code



138
139
140
 
# File 'lib/oci/database_management/models/drop_sqls_in_sql_tuning_set_details.rb', line 138

def hash
  [credential_details, show_sql_only, owner, name, basic_filter].hash
end

#to_hash ⇒ Hash

Returns the object in the form of hash

Returns:

  • (Hash) —

    Returns the object in the form of hash



182
183
184
185
186
187
188
189
190
191
 
# File 'lib/oci/database_management/models/drop_sqls_in_sql_tuning_set_details.rb', line 182

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

Returns:

  • (String) —

    String presentation of the object



176
177
178
 
# File 'lib/oci/database_management/models/drop_sqls_in_sql_tuning_set_details.rb', line 176

def to_s
  to_hash.to_s
end