FIFA Worldcup 2014 Brazil mySQL and JSON dumps, includes data for all participating teams, venues and matches.
Note that match contains a parameter stage:
0 => Group games
8 => Round of 16
4 => Quarter-Finals
FIFA Worldcup 2014 Brazil mySQL and JSON dumps, includes data for all participating teams, venues and matches.
Note that match contains a parameter stage:
0 => Group games
8 => Round of 16
4 => Quarter-Finals
| from flask import Flask, request, abort, g, current_app | |
| from flask.ext.principal import Principal | |
| from flask.ext.principal import Identity, identity_changed, identity_loaded | |
| from flask.ext.principal import Permission, Need, RoleNeed, ItemNeed | |
| app = Flask(__name__) | |
| app.config['SECRET_KEY'] = 'test_secret_key' | |
| app.config['TESTING'] = True |
| -- show running queries (pre 9.2) | |
| SELECT procpid, age(clock_timestamp(), query_start), usename, current_query | |
| FROM pg_stat_activity | |
| WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' | |
| ORDER BY query_start desc; | |
| -- show running queries (9.2) | |
| SELECT pid, age(clock_timestamp(), query_start), usename, query | |
| FROM pg_stat_activity | |
| WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' |
| /* | |
| * Normalized hide address bar for iOS & Android | |
| * (c) Scott Jehl, scottjehl.com | |
| * MIT License | |
| */ | |
| (function( win ){ | |
| var doc = win.document; | |
| // If there's a hash, or addEventListener is undefined, stop here | |
| if( !location.hash && win.addEventListener ){ |
| application: you-app-name-here | |
| version: 1 | |
| runtime: python | |
| api_version: 1 | |
| default_expiration: "30d" | |
| handlers: | |
| - url: /(.*\.(appcache|manifest)) | |
| mime_type: text/cache-manifest |