Contents

# frozen_string_literal: true

require 'japan_etc/database_provider/base'
require 'japan_etc/tollbooth'
require 'faraday'
require 'spreadsheet'

module JapanETC
  module DatabaseProvider
    # https://www.hanshin-exp.co.jp/drivers/ryoukin/etc_ryokinsyo/
    class HanshinExpressway < Base
      URL = 'https://www.hanshin-exp.co.jp/drivers/ryoukin/files/code_20170516.xls'

      def fetch_tollbooths
        rows.flat_map do |row|
          process_row(row)
        end.compact
      end

      def process_row(row)
        route_name, road_number, tollbooth_number, tollbooth_name, _, note = row

        return nil if !road_number.is_a?(Numeric) || !tollbooth_number.is_a?(Numeric)

        tollbooth = Tollbooth.create(
          road_number: road_number,
          tollbooth_number: tollbooth_number,
          road_name: '阪神高速道路',
          route_name: route_name,
          name: tollbooth_name,
          note: note
        )

        remove_redundant_name_suffix!(tollbooth)

        tollbooth
      end

      def remove_redundant_name_suffix!(tollbooth)
        return unless tollbooth.entrance_or_exit

        tollbooth.name.sub!(/[入出]\z/) do |match|
          found_entrance_or_exit = EntranceOrExit.from(match)
          found_entrance_or_exit == tollbooth.entrance_or_exit ? '' : match
        end
      end

      def rows
        workbook.worksheets.first.rows
      end

      def workbook
        response = Faraday.get(URL)
        Spreadsheet.open(StringIO.new(response.body))
      end
    end
  end
end

Version data entries

8 entries across 8 versions & 1 rubygems

Version	Path
japan_etc-0.6.0	lib/japan_etc/database_provider/hanshin_expressway.rb
japan_etc-0.5.2	lib/japan_etc/database_provider/hanshin_expressway.rb
japan_etc-0.5.1	lib/japan_etc/database_provider/hanshin_expressway.rb
japan_etc-0.5.0	lib/japan_etc/database_provider/hanshin_expressway.rb
japan_etc-0.4.0	lib/japan_etc/database_provider/hanshin_expressway.rb
japan_etc-0.3.0	lib/japan_etc/database_provider/hanshin_expressway.rb
japan_etc-0.2.0	lib/japan_etc/database_provider/hanshin_expressway.rb
japan_etc-0.1.0	lib/japan_etc/database_provider/hanshin_expressway.rb