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