Class: GeocodeRecords

Inherits:
Object
  • Object
show all
Defined in:
lib/geocode_records.rb,
lib/geocode_records/version.rb,
lib/geocode_records/geocode_csv.rb,
lib/geocode_records/dump_sql_to_csv.rb,
lib/geocode_records/update_table_from_csv.rb

Defined Under Namespace

Classes: DumpSqlToCsv, GeocodeCsv, UpdateTableFromCsv

Constant Summary collapse

VERSION =
'1.4.2'

Instance Attribute Summary collapse

Class Method Summary collapse

Instance Method Summary collapse

Constructor Details

#initialize(database_url:, table_name:, subquery: nil, include_invalid: false, num: 1, clean: true) ⇒ GeocodeRecords

Returns a new instance of GeocodeRecords.



41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
# File 'lib/geocode_records.rb', line 41

def initialize(
  database_url:,
  table_name:,
  subquery: nil,
  include_invalid: false,
  num: 1,
  clean: true
)
  @database_url = database_url
  @table_name = table_name
  @subquery = subquery
  @include_invalid = include_invalid
  @num = num
  @clean = clean
end

Instance Attribute Details

#cleanObject (readonly)

Returns the value of attribute clean.



39
40
41
# File 'lib/geocode_records.rb', line 39

def clean
  @clean
end

#database_urlObject (readonly)

Returns the value of attribute database_url.



32
33
34
# File 'lib/geocode_records.rb', line 32

def database_url
  @database_url
end

#include_invalidObject (readonly)

optional



36
37
38
# File 'lib/geocode_records.rb', line 36

def include_invalid
  @include_invalid
end

#numObject (readonly)

Returns the value of attribute num.



38
39
40
# File 'lib/geocode_records.rb', line 38

def num
  @num
end

#subqueryObject (readonly)

Returns the value of attribute subquery.



37
38
39
# File 'lib/geocode_records.rb', line 37

def subquery
  @subquery
end

#table_nameObject (readonly)

Returns the value of attribute table_name.



33
34
35
# File 'lib/geocode_records.rb', line 33

def table_name
  @table_name
end

Class Method Details

.new_tmp_path(hint) ⇒ Object



14
15
16
# File 'lib/geocode_records.rb', line 14

def new_tmp_path(hint)
  Dir::Tmpname.create(hint[0,64].delete('"').gsub(/\W/,'_').squeeze) {}
end

.psql(database_url, sql) ⇒ Object



18
19
20
21
22
23
24
25
26
27
28
29
# File 'lib/geocode_records.rb', line 18

def psql(database_url, sql)
  system(
    'psql',
    database_url,
    '-v', 'ON_ERROR_STOP=on',
    # '--echo-all',
    '--quiet',
    '--no-psqlrc',
    '--pset', 'pager=off',
    '--command', sql
  ) or raise("psql failed")
end

Instance Method Details

#performObject



57
58
59
60
# File 'lib/geocode_records.rb', line 57

def perform
  geocode glob: false
  geocode glob: true
end