Class: DbMeta::Oracle::Sequence

Inherits:
Base
  • Object
show all
Defined in:
lib/db_meta/oracle/types/sequence.rb

Constant Summary

Constants inherited from Base

Base::TYPES

Instance Attribute Summary collapse

Attributes inherited from Base

#extract_type, #name, #status, #system_object, #type

Instance Method Summary collapse

Methods inherited from Base

#ddl_drop, from_type, #initialize, register_type, #system_object?

Methods included from Helper

#block, #create_folder, #pluralize, #remove_folder, #type_sequence, #write_buffer_to_file

Constructor Details

This class inherits a constructor from DbMeta::Oracle::Base

Instance Attribute Details

#cache_size ⇒ Object (readonly)

Returns the value of attribute cache_size.



6
7
8
 
# File 'lib/db_meta/oracle/types/sequence.rb', line 6

def cache_size
  @cache_size
end

#cycle_flag ⇒ Object (readonly)

Returns the value of attribute cycle_flag.



6
7
8
 
# File 'lib/db_meta/oracle/types/sequence.rb', line 6

def cycle_flag
  @cycle_flag
end

#increment_by ⇒ Object (readonly)

Returns the value of attribute increment_by.



6
7
8
 
# File 'lib/db_meta/oracle/types/sequence.rb', line 6

def increment_by
  @increment_by
end

#last_number ⇒ Object (readonly)

Returns the value of attribute last_number.



6
7
8
 
# File 'lib/db_meta/oracle/types/sequence.rb', line 6

def last_number
  @last_number
end

#max_value ⇒ Object (readonly)

Returns the value of attribute max_value.



6
7
8
 
# File 'lib/db_meta/oracle/types/sequence.rb', line 6

def max_value
  @max_value
end

#min_value ⇒ Object (readonly)

Returns the value of attribute min_value.



6
7
8
 
# File 'lib/db_meta/oracle/types/sequence.rb', line 6

def min_value
  @min_value
end

#order_flag ⇒ Object (readonly)

Returns the value of attribute order_flag.



6
7
8
 
# File 'lib/db_meta/oracle/types/sequence.rb', line 6

def order_flag
  @order_flag
end

Instance Method Details

#extract(args = {}) ⇒ Object 



25
26
27
28
29
30
31
32
33
34
35
36
37
 
# File 'lib/db_meta/oracle/types/sequence.rb', line 25

def extract(args={})
  buffer = [block(@name)]
  buffer << "CREATE SEQUENCE #{@name}"
  buffer << "  START WITH #{@last_number}"
  buffer << "  MAXVALUE #{@max_value}"
  buffer << "  MINVALUE #{@min_value}"
  buffer << (@cycle_flag == 'N' ? '  NOCYCLE' : '  CYCLE')
  buffer << (@cache_size == 0 ? '  NOCACHE' : "  CACHE #{@cache_size}")
  buffer << (@order_flag == 'N' ? '  NOORDER' : '  ORDER')
  buffer << ';'
  buffer << nil
  buffer.join("\n")
end

#fetch ⇒ Object 



8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
 
# File 'lib/db_meta/oracle/types/sequence.rb', line 8

def fetch
  connection = Connection.instance.get
  cursor = connection.exec("select to_char(min_value), to_char(max_value), to_char(increment_by), cycle_flag, order_flag, to_char(cache_size), to_char(last_number) from user_sequences where sequence_name = '#{@name}'")
  while row = cursor.fetch()
    @min_value = row[0].to_i
    @max_value = row[1].to_i
    @increment_by = row[2].to_i
    @cycle_flag = row[3].to_s
    @order_flag = row[4].to_s
    @cache_size = row[5].to_i
    @last_number = row[6].to_i
  end
  cursor.close
ensure
  connection.logoff
end