Module: SportDb

Defined in:
lib/sportdb/models/models/forward.rb,
lib/sportdb/models.rb,
lib/sportdb/models.rb,
lib/sportdb/models/stats.rb,
lib/sportdb/models/utils.rb,
lib/sportdb/models/schema.rb,
lib/sportdb/models/deleter.rb,
lib/sportdb/models/formats.rb,
lib/sportdb/models/version.rb,
lib/sportdb/models/models/goal.rb,
lib/sportdb/models/models/team.rb,
lib/sportdb/models/models/assoc.rb,
lib/sportdb/models/models/badge.rb,
lib/sportdb/models/models/event.rb,
lib/sportdb/models/models/group.rb,
lib/sportdb/models/models/match.rb,
lib/sportdb/models/models/round.rb,
lib/sportdb/models/models/stage.rb,
lib/sportdb/models/models/ground.rb,
lib/sportdb/models/models/league.rb,
lib/sportdb/models/models/lineup.rb,
lib/sportdb/models/models/season.rb,
lib/sportdb/models/models/stats/event_standing.rb,
lib/sportdb/models/models/stats/group_standing.rb,
lib/sportdb/models/models/stats/alltime_standing.rb

Overview

forward references

require first to resolve circular references

Defined Under Namespace

Modules: Model, Module Classes: CreateDb, Deleter, Stats

Constant Summary collapse

TEAM_KEY_RE =

todo: add a patterns.md page to github ??

- add regexper pics??

%r{ \A
 [a-z_][a-z0-9_]*
\z}x
TEAM_KEY_MESSAGE = 
"expected one or more lowercase letters a-z (or 0-9 or _; must start with a-z or _)"
TEAM_CODE_RE =

must start w/ letter A-Z (2nd,3rd,4th or 5th can be number)

%r{ \A
 [A-Z_][A-Z0-9_]*
\z}x
TEAM_CODE_MESSAGE = 
"expected one or more uppercase letters A-Z (or 0-9 or _; must start with A-Z or _)"
VERSION =

add convenience shortcuts

Module::Models::VERSION
Models =

add backwards compatible n convenience namespace

Model

Class Method Summary collapse

Class Method Details

.connect(config = {}) ⇒ Object 



77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
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
 
# File 'lib/sportdb/models.rb', line 77

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' )

    config =  if db.scheme == 'postgres'
                  { adapter: 'postgresql',
                    host:     db.host,
                    port:     db.port,
                    username: db.user,
                    password: db.password,
                    database: db.path[1..-1],
                    encoding: 'utf8'
                  }
                else # assume sqlite3
                  { adapter:  db.scheme,       # sqlite3
                    database: db.path[1..-1]   # sport.db (NB: cut off leading /, thus 1..-1)
                  }
                end
  else
    ## note: for compatibility lets you also pass-in/use string keys
    ##   e.g. YAML.load uses/returns always string keys - always auto-convert to symbols
    config = config.symbolize_keys
  end


  ## todo/check/fix: move jruby "hack" to attic - why? why not?
  ## 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'  &&
     config[:database] != ':memory:'
    ## note: if in memory database e.g. ':memory:' no pragma needed!!
    ## try to speed up sqlite
    ##   see http://www.sqlite.org/pragma.html
    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 



50
51
52
53
 
# File 'lib/sportdb/models.rb', line 50

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

.create_all ⇒ Object 



55
56
57
58
59
60
61
62
63
 
# File 'lib/sportdb/models.rb', line 55

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!)



66
67
68
69
 
# File 'lib/sportdb/models.rb', line 66

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

.setup_in_memory_db ⇒ Object 



135
136
137
138
139
140
141
142
143
144
145
 
# File 'lib/sportdb/models.rb', line 135

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?

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

  ## build schema
  create_all
end

.tables ⇒ Object 



72
73
74
 
# File 'lib/sportdb/models.rb', line 72

def self.tables
  Stats.new.tables
end