Module: SportDb

Defined in:
lib/sportdb/standings.rb,
lib/sportdb/calc.rb,
lib/sportdb/lang.rb,
lib/sportdb/stats.rb,
lib/sportdb/utils.rb,
lib/sportdb/models.rb,
lib/sportdb/reader.rb,
lib/sportdb/schema.rb,
lib/sportdb/deleter.rb,
lib/sportdb/matcher.rb,
lib/sportdb/version.rb,
lib/sportdb/patterns.rb,
lib/sportdb/utils_map.rb,
lib/sportdb/csv_reader.rb,
lib/sportdb/reader_zip.rb,
lib/sportdb/utils_date.rb,
lib/sportdb/models/game.rb,
lib/sportdb/models/goal.rb,
lib/sportdb/models/team.rb,
lib/sportdb/reader_file.rb,
lib/sportdb/utils_goals.rb,
lib/sportdb/utils_group.rb,
lib/sportdb/utils_round.rb,
lib/sportdb/utils_teams.rb,
lib/sportdb/finders/date.rb,
lib/sportdb/models/assoc.rb,
lib/sportdb/models/badge.rb,
lib/sportdb/models/event.rb,
lib/sportdb/models/group.rb,
lib/sportdb/models/round.rb,
lib/sportdb/models/utils.rb,
lib/sportdb/readers/game.rb,
lib/sportdb/readers/team.rb,
lib/sportdb/rsssf_reader.rb,
lib/sportdb/utils_scores.rb,
lib/sportdb/finders/goals.rb,
lib/sportdb/models/ground.rb,
lib/sportdb/models/league.rb,
lib/sportdb/models/roster.rb,
lib/sportdb/models/season.rb,
lib/sportdb/readers/assoc.rb,
lib/sportdb/readers/event.rb,
lib/sportdb/finders/scores.rb,
lib/sportdb/models/forward.rb,
lib/sportdb/pretty_printer.rb,
lib/sportdb/readers/ground.rb,
lib/sportdb/readers/league.rb,
lib/sportdb/readers/season.rb,
lib/sportdb/models/event_team.rb,
lib/sportdb/models/group_team.rb,
lib/sportdb/models/assoc_assoc.rb,
lib/sportdb/models/team_compat.rb,
lib/sportdb/readers/squad_club.rb,
lib/sportdb/models/event_ground.rb,
lib/sportdb/models/stats/event_standing.rb,
lib/sportdb/models/stats/group_standing.rb,
lib/sportdb/readers/squad_national_team.rb,
lib/sportdb/models/stats/alltime_standing.rb,
lib/sportdb/models/stats/event_standing_entry.rb,
lib/sportdb/models/stats/group_standing_entry.rb,
lib/sportdb/models/stats/alltime_standing_entry.rb

Overview

forward references

require first to resolve circular references

Defined Under Namespace

Modules: FixtureHelpers, Matcher, Model, StandingsHelper Classes: AssocReader, ClubSquadReader, CreateDb, CsvGameReader, DateFinder, DateFinderBase, Deleter, EventReader, GameReader, GoalStruct, GoalsFinder, GoalsMinuteStruct, GoalsParser, GoalsPlayerStruct, GroundReader, Lang, LeagueReader, NationalTeamSquadReader, Patcher, PrettyPrinter, Reader, ReaderBase, RsssfDateFinder, RsssfGameReader, ScoresFinder, SeasonReader, Standings, StandingsLine, Stats, TeamMapper, TeamReader, ZipReader

Constant Summary collapse

MAJOR =

todo: namespace inside version or something - why? why not??

1
MINOR = 
15
PATCH = 
0
VERSION = 
[MAJOR,MINOR,PATCH].join('.')
TEAM_KEY_PATTERN =

about ruby regexps

try the rubular - Ruby regular expression editor and tester

-> http://rubular.com
 code -> ??  by ??

Jeff Avallone’s Regexper - Shows State-Automata Diagrams

try -> http://regexper.com
  code -> https://github.com/javallone/regexper

Regular Expressions | The Bastards Book of Ruby by Dan Nguyen

ruby.bastardsbook.com/chapters/regexes/

move to notes regex|patterns on geraldb.github.io ??

'\A[a-z]{3,}\z'
TEAM_KEY_PATTERN_MESSAGE = 
"expected three or more lowercase letters a-z /#{TEAM_KEY_PATTERN}/"
TEAM_CODE_PATTERN =

must start w/ letter a-z (2 n 3 can be number or underscore _)

'\A[A-Z][A-Z0-9][A-Z0-9_]?\z'
TEAM_CODE_PATTERN_MESSAGE = 
"expected two or three uppercase letters A-Z (and 0-9_; must start with A-Z) /#{TEAM_CODE_PATTERN}/"
Models =

add backwards compatible n convenience namespace

Model

Class Method Summary collapse

Class Method Details



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

def self.banner
  "sportdb-models/#{VERSION} on Ruby #{RUBY_VERSION} (#{RUBY_RELEASE_DATE}) [#{RUBY_PLATFORM}]"
end

.config_path ⇒ Object 



101
102
103
 
# File 'lib/sportdb/models.rb', line 101

def self.config_path
  "#{root}/config"
end

.connect(config = {}) ⇒ Object 



193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
 
# File 'lib/sportdb/models.rb', line 193

def self.connect( config={} )

  if config.empty?
    puts "ENV['DATBASE_URL'] - >#{ENV['DATABASE_URL']}<"

    ### change default to ./sport.db ?? why? why not?
    db = URI.parse( ENV['DATABASE_URL'] || 'sqlite3:///sport.db' )

    if db.scheme == 'postgres'
      config = {
        adapter: 'postgresql',
        host: db.host,
        port: db.port,
        username: db.user,
        password: db.password,
        database: db.path[1..-1],
        encoding: 'utf8'
      }
    else # assume sqlite3
     config = {
       adapter: db.scheme, # sqlite3
       database: db.path[1..-1] # sport.db (NB: cut off leading /, thus 1..-1)
    }
    end
  end

  ## todo/check: use if defined?( JRUBY_VERSION ) instead ??
  if RUBY_PLATFORM =~ /java/ && config[:adapter] == 'sqlite3' 
    # quick hack for JRuby sqlite3 support via jdbc
    puts "jruby quick hack - adding jdbc libs for jruby sqlite3 database support"
    require 'jdbc/sqlite3'
    require 'active_record/connection_adapters/jdbc_adapter'
    require 'active_record/connection_adapters/jdbcsqlite3_adapter'
  end

  puts "Connecting to db using settings: "
  pp config
  ActiveRecord::Base.establish_connection( config )
  # ActiveRecord::Base.logger = Logger.new( STDOUT )

  ## if sqlite3 add (use) some pragmas for speedups 
  if config[:adapter] == 'sqlite3'
    ## check/todo: if in memory e.g. ':memory:' no pragma needed!!
    con = ActiveRecord::Base.connection
    con.execute( 'PRAGMA synchronous=OFF;' )
    con.execute( 'PRAGMA journal_mode=OFF;' )
    con.execute( 'PRAGMA temp_store=MEMORY;' )
  end
end

.create ⇒ Object 



126
127
128
129
 
# File 'lib/sportdb/models.rb', line 126

def self.create
  CreateDb.new.up
  ConfDb::Model::Prop.create!( key: 'db.schema.sport.version', value: VERSION )
end

.create_all ⇒ Object 



131
132
133
134
135
136
137
138
139
 
# File 'lib/sportdb/models.rb', line 131

def self.create_all
  ## build schema - convenience helper
  LogDb.create
  ConfDb.create
  TagDb.create
  WorldDb.create
  PersonDb.create
  SportDb.create
end

.data_path ⇒ Object 



105
106
107
 
# File 'lib/sportdb/models.rb', line 105

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

.delete! ⇒ Object

delete ALL records (use with care!)



177
178
179
180
 
# File 'lib/sportdb/models.rb', line 177

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

.lang ⇒ Object 



114
115
116
117
118
119
120
121
122
123
 
# File 'lib/sportdb/models.rb', line 114

def self.lang
  # todo/fix: find a better way for single instance ??
  #  will get us ruby warning:  instance variable @lang not initialized   => find a better way!!!
  #   just use @lang w/o .nil?  e.g.
  #  @lang =|| Lang.new   why? why not??  or better use @@lang =|| Lang.new  for class variable!!!
   if @lang.nil?
     @lang = Lang.new
   end
   @lang
end

.read(ary, include_path) ⇒ Object

load built-in (that is, bundled within the gem) named plain text seeds

  • pass in an array of pairs of event/seed names e.g. [[‘at.2012/13’, ‘at/2012_13/bl’],

    ['cl.2012/13', 'cl/2012_13/cl']] etc.



167
168
169
170
171
172
173
 
# File 'lib/sportdb/models.rb', line 167

def self.read( ary, include_path )
  reader = Reader.new( include_path )
  ## todo: check kind_of?( Array ) or kind_of?(String) to support array or string
  ary.each do |name|
    reader.load( name )
  end
end

.read_all(include_path) ⇒ Object

convenience helper



153
154
155
 
# File 'lib/sportdb/models.rb', line 153

def self.read_all( include_path )   # convenience helper
  read_setup( 'setups/all', include_path )
end

.read_builtin ⇒ Object 



157
158
159
 
# File 'lib/sportdb/models.rb', line 157

def self.read_builtin
  read_setup( 'setups/all', data_path )
end

.read_setup(setup, include_path) ⇒ Object 



142
143
144
145
 
# File 'lib/sportdb/models.rb', line 142

def self.read_setup( setup, include_path )
  reader = Reader.new( include_path )
  reader.load_setup( setup )
end

.read_setup_from_zip(zip_name, setup, include_path, opts = {}) ⇒ Object

todo/check - use a better (shorter) name ??



147
148
149
150
151
 
# File 'lib/sportdb/models.rb', line 147

def self.read_setup_from_zip( zip_name, setup, include_path, opts={} ) ## todo/check - use a better (shorter) name ??
  reader = ZipReader.new( zip_name, include_path, opts )
  reader.load_setup( setup )
  reader.close
end

.root ⇒ Object 



18
19
20
 
# File 'lib/sportdb/version.rb', line 18

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

.setup_in_memory_db ⇒ Object 



244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
 
# File 'lib/sportdb/models.rb', line 244

def self.setup_in_memory_db

  # Database Setup & Config
  ActiveRecord::Base.logger = Logger.new( STDOUT )
  ## ActiveRecord::Base.colorize_logging = false  - no longer exists - check new api/config setting?

  self.connect( adapter:  'sqlite3',
                database: ':memory:' )

  ## build schema
  SportDb.create_all

  ## read builtins - why? why not?
  SportDb.read_builtin
end

.tables ⇒ Object 



188
189
190
 
# File 'lib/sportdb/models.rb', line 188

def self.tables
  Stats.new.tables
end

.test_data_path ⇒ Object 



109
110
111
 
# File 'lib/sportdb/models.rb', line 109

def self.test_data_path
  "#{root}/test/data"
end

.update! ⇒ Object

method delete!



182
183
184
185
 
# File 'lib/sportdb/models.rb', line 182

def self.update!
  puts '*** update event fixtures...'
  Updater.new.run
end

.version ⇒ Object 



10
11
12
 
# File 'lib/sportdb/version.rb', line 10

def self.version
  VERSION
end