Module: WorldDB

Defined in:
lib/worlddb.rb,
lib/worlddb/reader.rb,
lib/worlddb/schema.rb,
lib/worlddb/version.rb,
lib/worlddb/cli/opts.rb,
lib/worlddb/cli/runner.rb

Defined Under Namespace

Modules: Models Classes: CreateDB, Deleter, Opts, Reader, Runner, Stats

Constant Summary collapse

VERSION = 
'0.7.1'

Class Method Summary collapse

Class Method Details

.africa_fixtures ⇒ Object 



72
73
74
75
76
77
 
# File 'lib/worlddb.rb', line 72

def self.africa_fixtures
  ['countries',
  '1_codes/fifa',
  '1_codes/internet',
  '1_codes/iso3'].map { |path| "africa/#{path}" }
end

.america_fixtures ⇒ Object 



79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
 
# File 'lib/worlddb.rb', line 79

def self.america_fixtures
['countries',
 '1_codes/fifa',
 '1_codes/internet',
 '1_codes/iso3',
 '1_codes/motor',
 'br/regions',
 'ca/regions',
 'ca/cities',
 'mx/regions',
 'mx/cities',
 'us/regions',
 'us/cities',
 've/regions',
 've/cities'].map { |path| "america/#{path}" }
end

.asia_fixtures ⇒ Object 



96
97
98
99
100
101
102
 
# File 'lib/worlddb.rb', line 96

def self.asia_fixtures
['countries',
 '1_codes/fifa',
 '1_codes/internet',
 '1_codes/iso3',
 'jp/cities'].map { |path| "asia/#{path}" }
end
 


43
44
45
 
# File 'lib/worlddb.rb', line 43

def self.banner
  "worlddb #{VERSION} on Ruby #{RUBY_VERSION} (#{RUBY_RELEASE_DATE}) [#{RUBY_PLATFORM}]"
end

.create ⇒ Object 



60
61
62
 
# File 'lib/worlddb.rb', line 60

def self.create
  CreateDB.up
end

.data_path ⇒ Object

builtin path to fixture data



52
53
54
 
# File 'lib/worlddb.rb', line 52

def self.data_path
  "#{root}/data"
end

.delete! ⇒ Object

delete ALL records (use with care!)



207
208
209
210
 
# File 'lib/worlddb.rb', line 207

def self.delete!
  puts '*** deleting world table records/data...'
  Deleter.new.run
end

.europe_fixtures ⇒ Object 



104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
 
# File 'lib/worlddb.rb', line 104

def self.europe_fixtures
['countries',
 '1_codes/fifa',
 '1_codes/internet',
 '1_codes/iso3',
 '1_codes/motor',
 'at/regions',
 'at/cities',
 'be/regions',
 'be/cities',
 'bg/cities',
 'by/cities',
 'ch/cities',
 'cy/cities',
 'cz/regions',
 'cz/cities',
 'de/regions',
 'de/cities',
 'dk/cities',
 'ee/cities',
 'en/regions',
 'en/cities',
 'es/regions',
 'es/cities',
 'fi/cities',
 'fr/regions',
 'fr/cities',
 'gr/cities',
 'hr/cities',
 'hu/cities',
 'ie/cities',
 'it/cities',
 'lt/cities',
 'lv/cities',
 'nl/cities',
 'no/cities',
 'pl/cities',
 'pt/cities',
 'ro/cities',
 'rs/cities',
 'ru/cities',
 'sc/cities',
 'se/cities',
 'tr/cities',
 'ua/cities',
 'wa/cities'].map { |path| "europe/#{path}" }
end

.fixtures ⇒ Object

all builtin fixtures; helper for covenience



64
65
66
67
68
69
70
 
# File 'lib/worlddb.rb', line 64

def self.fixtures  # all builtin fixtures; helper for covenience
   africa_fixtures  +
   america_fixtures +
   europe_fixtures  +
   asia_fixtures    +
   oceania_fixtures
end

.main ⇒ Object 



56
57
58
 
# File 'lib/worlddb.rb', line 56

def self.main
  Runner.new.run(ARGV)
end

.oceania_fixtures ⇒ Object 



152
153
154
155
156
157
158
 
# File 'lib/worlddb.rb', line 152

def self.oceania_fixtures
 ['countries',
 '1_codes/fifa',
 '1_codes/internet',
 '1_codes/iso3',
 'au/cities'].map { |path| "oceania/#{path}" }
end

.props ⇒ Object 



244
245
246
 
# File 'lib/worlddb.rb', line 244

def self.props
  Stats.new.props
end

.read(ary) ⇒ Object

todo/fix: rename to load/load_all - why? why not?? or just add an alias?



162
163
164
165
166
167
 
# File 'lib/worlddb.rb', line 162

def self.read( ary )
  reader = Reader.new
  ary.each do |name|
    reader.load_builtin( name )
  end
end

.read_all ⇒ Object

load all builtins (using plain text reader); helper for convenience



169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
 
# File 'lib/worlddb.rb', line 169

def self.read_all  # load all builtins (using plain text reader); helper for convenience
  reader = Reader.new

  # too big for heroku free db plan (10,000 record limit)
  #  - sorry, can't load by default
  fixture_excludes = [
    'america/ve/cities'
  ]
  
  ary = fixtures - fixture_excludes
  
  ary.each do |name|
   reader.load_builtin( name )
  end # each name
end

.root ⇒ Object 



47
48
49
 
# File 'lib/worlddb.rb', line 47

def self.root
  "#{File.expand_path( File.dirname(File.dirname(__FILE__)) )}"
end

.stats ⇒ Object 



234
235
236
237
238
 
# File 'lib/worlddb.rb', line 234

def self.stats
  stats = Stats.new
  stats.tables
  ### stats.props
end

.tables ⇒ Object 



240
241
242
 
# File 'lib/worlddb.rb', line 240

def self.tables
  Stats.new.tables
end