Build scripts for football.db, worldcup.db, bundesliga.db, etc.
License: Creative Commons Zero v1.0 Universal
Yo, robot auto-update:
More:
I am just getting to know the football.db project, but a problem that I encoutered as soon as I tried to build the databases is that I don't know which Ruby should I use to run the build tasks, and I don't know which gems should I install to make it work.
For example, it is obvious that I need rake, but what version? I also discovered I need ActiveRecord, but the only way to discover that was making the task fail.
My suggestion: why don't we use Bundler (http://bundler.io/)? All modern ruby projects use Bundler.. You can just specify the gem dependencies on a Gemfile in the root of the project and then the only thing you have to do is run bundle install and it will install all gems you need with the right versions.
I also suggest you use RVM, so you can have multiple rubies and Gemsets in your computer. Then all we would have to do would be to add 2 simple hidden files to the project that specify which ruby and which gemset should be used. The people that do not use RVM would not be affected in any form.
If you want I can help doing those things, I just need to know what ruby are you using and which gems (name/version) one should have installed to run the build tasks.
I am new to ruby/rake but it looks like the logDb.Create is not being called soon enough.
I get the following error: ActiveRecord::StatementInvalid: Could not find table 'logs'
Stack trace:
$ rake build
before require 'sportdb'
activerecord-utils/0.2.0 (activerecord/4.1.1) on Ruby 2.1.0 (2013-12-25) [x86_64-darwin12.0]
confdb/1.1.1 on Ruby 2.1.0 (2013-12-25) [x86_64-darwin12.0]
tagutils/0.2.2 on Ruby 2.1.0 (2013-12-25) [x86_64-darwin12.0]
[TagDb.has_many_tags] adding taggings n tags has_many assocs to model >WorldDb::Model::Country<
[TagDb.has_many_tags] adding taggings n tags has_many assocs to model >WorldDb::Model::Region<
[TagDb.has_many_tags] adding taggings n tags has_many assocs to model >WorldDb::Model::City<
worlddb/2.0.4 on Ruby 2.1.0 (2013-12-25) [x86_64-darwin12.0]
logdb 0.6.0 on Ruby 2.1.0 (2013-12-25) [x86_64-darwin12.0]
persondb/0.3.1 on Ruby 2.1.0 (2013-12-25) [x86_64-darwin12.0]
fetcher/0.4.3 on Ruby 2.1.0 (2013-12-25) [x86_64-darwin12.0]
sportdb/1.8.26 on Ruby 2.1.0 (2013-12-25) [x86_64-darwin12.0]
after require 'sportdb'
using DATA_KEY >worldcup<
rm ./build/football.db
{:adapter=>"sqlite3", :database=>"./build/football.db"}
[warn] Rakefile - 2014-05-25 14:04:41 -0400
rake aborted!
ActiveRecord::StatementInvalid: Could not find table 'logs'
/Users/joekampschmidt/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.1/lib/active_record/connection_adapters/sqlite3_adapter.rb:512:in `table_structure'
/Users/joekampschmidt/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.1/lib/active_record/connection_adapters/sqlite3_adapter.rb:387:in `columns'
/Users/joekampschmidt/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.1/lib/active_record/connection_adapters/schema_cache.rb:93:in `block in prepare_default_proc'
/Users/joekampschmidt/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.1/lib/active_record/connection_adapters/schema_cache.rb:44:in `yield'
/Users/joekampschmidt/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.1/lib/active_record/connection_adapters/schema_cache.rb:44:in `columns'
/Users/joekampschmidt/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.1/lib/active_record/model_schema.rb:214:in `columns'
/Users/joekampschmidt/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.1/lib/active_record/model_schema.rb:223:in `columns_hash'
/Users/joekampschmidt/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.1/lib/active_record/inheritance.rb:180:in `subclass_from_attributes?'
/Users/joekampschmidt/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.1/lib/active_record/inheritance.rb:23:in `new'
/Users/joekampschmidt/.rvm/gems/ruby-2.1.0/gems/activerecord-4.1.1/lib/active_record/validations.rb:39:in `create!'
/Users/joekampschmidt/.rvm/gems/ruby-2.1.0/gems/logutils-0.6.0/lib/logutils/db.rb:44:in `write'
/Users/joekampschmidt/.rvm/gems/ruby-2.1.0/gems/logutils-0.6.0/lib/logutils/logger.rb:177:in `block in write'
/Users/joekampschmidt/.rvm/gems/ruby-2.1.0/gems/logutils-0.6.0/lib/logutils/logger.rb:177:in `each'
/Users/joekampschmidt/.rvm/gems/ruby-2.1.0/gems/logutils-0.6.0/lib/logutils/logger.rb:177:in `write'
/Users/joekampschmidt/.rvm/gems/ruby-2.1.0/gems/logutils-0.6.0/lib/logutils/logger.rb:158:in `warn'
/Users/joekampschmidt/Projects/openfootball/build/Rakefile:56:in `block in <top (required)>'
/Users/joekampschmidt/.rvm/gems/ruby-2.1.0/bin/ruby_executable_hooks:15:in `eval'
/Users/joekampschmidt/.rvm/gems/ruby-2.1.0/bin/ruby_executable_hooks:15:in `<main>'
Tasks: TOP => build => create => env
(See full trace by running task with --trace)
I've built my db but when testing the rake pull command I get the following error
** Execute pull
*** update event fixtures...
update event >>World Cup Quali Africa 2014<< (world.quali.africa+2014)
using dlbase >>https://raw.github.com/openfootball/world-cup/master/2014<<
downloading source (1/3) >>https://raw.github.com/openfootball/world-cup/master/2014/africa_i.txt<< ...
*** error - fetch HTTP - 404 Not Found
importing/reading source...
rake aborted!
NoMethodError: undefined method `read_fixtures_worker' for #<SportDb::GameReader:0x007fcefccf2e48 @include_path="/tmp">
/Users/ryan/.rbenv/versions/2.1.1/lib/ruby/gems/2.1.0/gems/sportdb-1.8.23/lib/sportdb/readers/game.rb:53:in `read_fixtures_from_string'
Hello,
When trying to build the initial database with the rake build command, I am getting the following error:
** Invoke importworld (first_time)
** Invoke configworld (first_time)
** Invoke config (first_time)
** Invoke env
** Execute config
[warn] Rakefile - 2015-02-02 17:43:00 +0300
rake aborted!
RangeError: 69936435566960 is out of range for ActiveRecord::Type::Integer with limit 4I suspect that it could be happening in
## log all warns, errors, fatals to db
LogDb.setupbut I could be wrong.
How should I deal with this?
Thanks in advance.
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
Django
The Web framework for perfectionists with deadlines.
Laravel
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
Microsoft
Open source projects and samples from Microsoft.
Google
Google ❤️ Open Source for everyone.
Alibaba
Alibaba Open Source for everyone
D3
Data-Driven Documents codes.
Tencent
China tencent open source team.