Sha256: ab13d6e5bec3ecd7579d2e00c1d754ade28811bd84d42c503422da73c18f883c
Contents?: true
Size: 688 Bytes
Versions: 12
Compression:
Stored size: 688 Bytes
Contents
class Zips < Thor
desc 'load [full path to zip_code file]', "Load geonames zips with lat longs into Redis"
def load(zip_code_file=nil)
require './config/environment'
raise "Can't find that zip code file '#{zip_code_file}'" unless File.exist? zip_code_file
ZipCode.connection.execute "TRUNCATE `zip_codes`"
st = ZipCode.connection.raw_connection.prepare "INSERT IGNORE INTO `zip_codes` (`zip_code`, `city`, `state_short`, `lat`, `lng`) VALUES (?, ?, ?, ?, ?)"
File.readlines(zip_code_file).each_with_index do |line|
data = line.force_encoding("UTF-8").split("\t")
st.execute(data[1],data[2],data[4], data[9], data[10])
end
st.close
end
end
Version data entries
12 entries across 12 versions & 1 rubygems