Class: PLSQL::Sequence

Inherits:
Object
  • Object
show all
Extended by:
SequenceClassMethods
Defined in:
lib/plsql/sequence.rb

Instance Method Summary collapse

Methods included from SequenceClassMethods

find

Constructor Details

#initialize(schema, sequence, override_schema_name = nil) ⇒ Sequence

:nodoc:



31
32
33
34
35
 
# File 'lib/plsql/sequence.rb', line 31

def initialize(schema, sequence, override_schema_name = nil) #:nodoc:
  @schema = schema
  @schema_name = override_schema_name || schema.schema_name
  @sequence_name = sequence.to_s.upcase
end

Instance Method Details

#currval ⇒ Object

Get CURRVAL of sequence (can be called just after nextval)



43
44
45
 
# File 'lib/plsql/sequence.rb', line 43

def currval
  @schema.select_one "SELECT \"#{@schema_name}\".\"#{@sequence_name}\".CURRVAL FROM dual"
end

#nextval ⇒ Object

Get NEXTVAL of sequence



38
39
40
 
# File 'lib/plsql/sequence.rb', line 38

def nextval
  @schema.select_one "SELECT \"#{@schema_name}\".\"#{@sequence_name}\".NEXTVAL FROM dual"
end