near_test.rb

# encoding: utf-8
$: << File.join(File.dirname(__FILE__), "..")
require 'test_helper'

class NearTest < GeocoderTestCase

  def test_near_scope_options_without_sqlite_includes_bounding_box_condition
    result = PlaceWithCustomResultsHandling.send(:near_scope_options, 1.0, 2.0, 5)

    assert_match /test_table_name.latitude BETWEEN 0.9276\d* AND 1.0723\d* AND test_table_name.longitude BETWEEN 1.9276\d* AND 2.0723\d* AND /,
      result[:conditions][0]
  end

  def test_near_scope_options_without_sqlite_includes_radius_condition
    result = Place.send(:near_scope_options, 1.0, 2.0, 5)

    assert_match /BETWEEN \? AND \?$/, result[:conditions][0]
  end

  def test_near_scope_options_without_sqlite_includes_radius_default_min_radius
    result = Place.send(:near_scope_options, 1.0, 2.0, 5)

    assert_equal 0, result[:conditions][1]
    assert_equal 5, result[:conditions][2]
  end

  def test_near_scope_options_without_sqlite_includes_radius_custom_min_radius
    result = Place.send(:near_scope_options, 1.0, 2.0, 5, :min_radius => 3)

    assert_equal 3, result[:conditions][1]
    assert_equal 5, result[:conditions][2]
  end

  def test_near_scope_options_without_sqlite_includes_radius_bogus_min_radius
    result = Place.send(:near_scope_options, 1.0, 2.0, 5, :min_radius => 'bogus')

    assert_equal 0, result[:conditions][1]
    assert_equal 5, result[:conditions][2]
  end

  def test_near_scope_options_with_defaults
    result = PlaceWithCustomResultsHandling.send(:near_scope_options, 1.0, 2.0, 5)

    assert_match /AS distance/, result[:select]
    assert_match /AS bearing/, result[:select]
    assert_no_consecutive_comma(result[:select])
  end

  def test_near_scope_options_with_no_distance
    result = PlaceWithCustomResultsHandling.send(:near_scope_options, 1.0, 2.0, 5, :select_distance => false)

    assert_no_match /AS distance/, result[:select]
    assert_match /AS bearing/, result[:select]
    assert_no_match /distance/, result[:condition]
    assert_no_match /distance/, result[:order]
    assert_no_consecutive_comma(result[:select])
  end

  def test_near_scope_options_with_no_bearing
    result = PlaceWithCustomResultsHandling.send(:near_scope_options, 1.0, 2.0, 5, :select_bearing => false)

    assert_match /AS distance/, result[:select]
    assert_no_match /AS bearing/, result[:select]
    assert_no_consecutive_comma(result[:select])
  end

  def test_near_scope_options_with_custom_distance_column
    result = PlaceWithCustomResultsHandling.send(:near_scope_options, 1.0, 2.0, 5, :distance_column => 'calculated_distance')

    assert_no_match /AS distance/, result[:select]
    assert_match /AS calculated_distance/, result[:select]
    assert_no_match /\bdistance\b/, result[:order]
    assert_match /calculated_distance/, result[:order]
    assert_no_consecutive_comma(result[:select])
  end

  def test_near_scope_options_with_custom_bearing_column
    result = PlaceWithCustomResultsHandling.send(:near_scope_options, 1.0, 2.0, 5, :bearing_column => 'calculated_bearing')

    assert_no_match /AS bearing/, result[:select]
    assert_match /AS calculated_bearing/, result[:select]
    assert_no_consecutive_comma(result[:select])
  end

  private

  def assert_no_consecutive_comma(string)
    assert_no_match /, *,/, string, "two consecutive commas"
  end
end