Class: Geocoder::Oracle::FunctionsGenerator

Inherits:
Rails::Generators::Base
  • Object
show all
Defined in:
lib/generators/geocoder/oracle/functions_generator.rb

Instance Method Summary collapse

Instance Method Details

#degrees_function ⇒ Object 



24
25
26
27
28
29
30
31
32
33
34
35
36
 
# File 'lib/generators/geocoder/oracle/functions_generator.rb', line 24

def degrees_function
  function = %q(
    CREATE OR REPLACE FUNCTION DEGREES(RADIAN IN NUMBER)
      RETURN NUMBER DETERMINISTIC IS
      DEGREES NUMBER;
    BEGIN
      SELECT RADIAN * 57.2957795 INTO DEGREES FROM DUAL;
      RETURN DEGREES;
    END DEGREES;
  )
  ActiveRecord::Base.connection().execute(function)
  puts 'DEGREES(RADIAN) function added.'
end

#pi_function ⇒ Object 



10
11
12
13
14
15
16
17
18
19
20
21
22
 
# File 'lib/generators/geocoder/oracle/functions_generator.rb', line 10

def pi_function
  function = %q(
    CREATE OR REPLACE FUNCTION PI
      RETURN NUMBER DETERMINISTIC IS
      PI NUMBER;
    BEGIN
      SELECT ACOS(-1) INTO PI FROM DUAL;
      RETURN PI;
    END PI;
  )
  ActiveRecord::Base.connection().execute(function)
  puts 'PI() function added.'
end

#radians_function ⇒ Object 



38
39
40
41
42
43
44
45
46
47
48
49
50
 
# File 'lib/generators/geocoder/oracle/functions_generator.rb', line 38

def radians_function
  function = %q(
    CREATE OR REPLACE FUNCTION RADIANS(DEGREE IN NUMBER)
      RETURN NUMBER DETERMINISTIC IS
      RADIANS NUMBER;
    BEGIN
      SELECT DEGREE / 57.2957795 INTO RADIANS FROM DUAL;
      RETURN RADIANS;
    END RADIANS;
  )
  ActiveRecord::Base.connection().execute(function)
  puts 'RADIANS(DEGREE) function added.'
end