Class: GeocodeRecords
- Inherits:
-
Object
- Object
- GeocodeRecords
- 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
-
#clean ⇒ Object
readonly
Returns the value of attribute clean.
-
#database_url ⇒ Object
readonly
Returns the value of attribute database_url.
-
#include_invalid ⇒ Object
readonly
optional.
-
#num ⇒ Object
readonly
Returns the value of attribute num.
-
#subquery ⇒ Object
readonly
Returns the value of attribute subquery.
-
#table_name ⇒ Object
readonly
Returns the value of attribute table_name.
Class Method Summary collapse
Instance Method Summary collapse
-
#initialize(database_url:, table_name:, subquery: nil, include_invalid: false, num: 1, clean: true) ⇒ GeocodeRecords
constructor
A new instance of GeocodeRecords.
- #perform ⇒ Object
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
#clean ⇒ Object (readonly)
Returns the value of attribute clean.
39 40 41 |
# File 'lib/geocode_records.rb', line 39 def clean @clean end |
#database_url ⇒ Object (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_invalid ⇒ Object (readonly)
optional
36 37 38 |
# File 'lib/geocode_records.rb', line 36 def include_invalid @include_invalid end |
#num ⇒ Object (readonly)
Returns the value of attribute num.
38 39 40 |
# File 'lib/geocode_records.rb', line 38 def num @num end |
#subquery ⇒ Object (readonly)
Returns the value of attribute subquery.
37 38 39 |
# File 'lib/geocode_records.rb', line 37 def subquery @subquery end |
#table_name ⇒ Object (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
#perform ⇒ Object
57 58 59 60 |
# File 'lib/geocode_records.rb', line 57 def perform geocode glob: false geocode glob: true end |