Module: SportDb

Defined in:
lib/sportdb/standings.rb,
lib/sportdb/calc.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/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/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/stage.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/indexers/team.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/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/stage_team.rb,
lib/sportdb/models/assoc_assoc.rb,
lib/sportdb/models/team_compat.rb,
lib/sportdb/readers/event_meta.rb,
lib/sportdb/readers/squad_club.rb,
lib/sportdb/models/event_ground.rb,
lib/sportdb/readers/event_table.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, Deleter, EventMetaReader, EventReader, EventTableReader, GameReader, GroundReader, LeagueReader, NationalTeamSquadReader, Patcher, PrettyPrinter, Reader, ReaderBase, RsssfGameReader, SeasonReader, Standings, StandingsLine, Stats, TeamIndexer, TeamReader, ZipReader

Constant Summary collapse

MAJOR =

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

1
MINOR = 
18
PATCH = 
6
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 (2nd,3rd,4th or 5th can be number or underscore _)

'\A[A-Z_][A-Z0-9_]{1,4}\z'
TEAM_CODE_PATTERN_MESSAGE = 
"expected two or three or four or five 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

.connect(config = {}) ⇒ Object 



172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
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
 
# File 'lib/sportdb/models.rb', line 172

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 



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

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

.create_all ⇒ Object 



110
111
112
113
114
115
116
117
118
 
# File 'lib/sportdb/models.rb', line 110

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

.delete! ⇒ Object

delete ALL records (use with care!)



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

def self.delete!
  puts '*** deleting sport table records/data...'
  Deleter.new.run
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.



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

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



132
133
134
 
# File 'lib/sportdb/models.rb', line 132

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

.read_builtin ⇒ Object 



136
137
138
 
# File 'lib/sportdb/models.rb', line 136

def self.read_builtin
  puts "!! WARN - deprecated SportDb.read_builtin call - remove!! no longer in use; will get removed soon"
end

.read_setup(setup, include_path) ⇒ Object 



121
122
123
124
 
# File 'lib/sportdb/models.rb', line 121

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 ??



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

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 



223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
 
# File 'lib/sportdb/models.rb', line 223

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 



167
168
169
 
# File 'lib/sportdb/models.rb', line 167

def self.tables
  Stats.new.tables
end

.test_data_path ⇒ Object 



99
100
101
 
# File 'lib/sportdb/models.rb', line 99

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

.update! ⇒ Object

method delete!



161
162
163
164
 
# File 'lib/sportdb/models.rb', line 161

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