class Oraora::Meta::Sequence

Public Instance Methods

describe(options = {}) click to toggle source
# File lib/oraora/meta/sequence.rb, line 18
      def describe(options = {})
        <<-HERE.reset_indentation
          Sequence #{@schema}.#{@name}
          Min value:    #{@min.to_i}
          Max value:    #{@max.to_i}
          Increment by: #{@inc.to_i}
          Last value:   #{@last.to_i}
        HERE
      end
list(options = {}, filter = nil) click to toggle source
# File lib/oraora/meta/sequence.rb, line 28
def list(options = {}, filter = nil)
  raise NotApplicable, "Nothing to list for sequence"
end
load_from_oci(oci) click to toggle source
# File lib/oraora/meta/sequence.rb, line 10
def load_from_oci(oci)
  @min, @max, @inc, @last = oci.select_one("SELECT min_value, max_value, increment_by, last_number
                                              FROM all_sequences
                                             WHERE sequence_owner = :schema AND sequence_name = :name", @schema, @name)
  raise NotExists if !@min
  self
end
type() click to toggle source
# File lib/oraora/meta/sequence.rb, line 6
def type
  'SEQUENCE'
end