class Geocoder::Oracle::FunctionsGenerator

Public Instance Methods

degrees_function() click to toggle source
# 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() click to toggle source
# 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() click to toggle source
# 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