def processScoringData(self):
"""
Get points per week for each team and wins
"""
for week in range(1, int(self.current_week)):
"""
Get results from each week
"""
scoreboard = self.yql.raw_query(
'select scoreboard from fantasysports.leagues.scoreboard where league_key="{}" and week={}'
.format(settings.LEAGUE_KEY, week),
format='json')
jsonScoreboard = json.loads(pretty_json(scoreboard.content))
matchups = jsonScoreboard['query']['results']['league'][
'scoreboard']['matchups']['matchup']
weeklyScores = {}
for matchup in matchups:
weeklyScores[matchup['teams']['team'][0]
['team_key']] = matchup['teams']['team'][0][
'team_points']['total']
weeklyScores[matchup['teams']['team'][1]
['team_key']] = matchup['teams']['team'][1][
'team_points']['total']
self.teamData[matchup['winner_team_key']]['wins'] += 1
self.pointsScored[week] = weeklyScores
def test_func_filter_unique(self, ):
func_filters = [{
'unique': [('field', 'content'), ('hideRepeatCount', 'false')]
}, ('truncate', 5)]
data = self.yql.get('yql.table.list', func_filters=func_filters)
logging.debug(pretty_json(data.content))
self.assertEqual(data.status_code, 200)
def test_filter_not_like(self, ):
data = self.yql.select('geo.counties',
['name', 'placeTypeName']).where(
['place', '=', 'CT'],
['name', 'NOT LIKE', '%d'])
logging.debug(pretty_json(data.content))
self.assertEqual(data.status_code, 200)
def test_filter_less_than_or_equal(self, ):
data = self.yql.select('geo.countries',
['name', 'placeTypeName']).where(
['place', '=', 'North America'],
['place.woeid', '<=', 23424758])
logging.debug(pretty_json(data.content))
self.assertEqual(data.status_code, 200)
def test_filter_not_equal(self, ):
data = self.yql.select('geo.countries',
['name', 'placeTypeName']).where(
['name', 'like', 'A%'],
['placeTypeName.content', '!=', 'Country'])
logging.debug(pretty_json(data.content))
self.assertEqual(data.status_code, 200)
def test_3_update(self, ):
json_data = json_get_data('yql_storage.json')
response = self.yql.update('yql.storage', ('value', ),
('https://josuebrunel.org', )).where(
['name', '=', json_data['update']])
logging.debug(pretty_json(response.content))
self.assertEqual(response.status_code, 200)
def test_variable_substitution(self,):
yql = YQL()
var = {'home': 'Congo'}
yql.set(var)
response = yql.select('geo.states', remote_filter=(5,)).where(['place', '=', '@home'])
logging.debug(pretty_json(response.content))
self.assertEqual(response.status_code, 200)
def test_variable_substitution(self,):
yql = YQL()
var = {'home': 'Congo'}
yql.set(var)
response = yql.select('geo.states', remote_filter=(5,)).where(['place', '=', '@home'])
logging.debug(pretty_json(response.content))
self.assertEqual(response.status_code, 200)
def test_filter_not_matches(self, ):
data = self.yql.select('geo.countries',
['name', 'placeTypeName']).where([
'placeTypeName.content', 'NOT MATCHES',
'^(Country|Territory)$'
])
logging.debug(pretty_json(data.content))
self.assertEqual(data.status_code, 200)
def test_select_in_2(self, ):
response = self.yql.select(
'weather.forecast', ['units', 'atmosphere']).where([
'woeid', 'IN',
('select woeid from geo.places(1) where text="Paris"', )
])
logging.debug(pretty_json(response.content))
self.assertEqual(response.status_code, 200)
def test_get_historical_info_with_args(self, ):
data = self.stock.get_historical_info(
'YHOO',
items=['Open', 'Close', 'High', 'Low'],
limit=5,
startDate='2014-09-11',
endDate='2015-02-10')
logging.debug(pretty_json(data.content))
self.assertEqual(data.status_code, 200)
def test_filter_not_in(self, ):
data = self.yql.select('geo.countries',
['name', 'placeTypeName']).where([
'placeTypeName.content', 'NOT IN',
('Country', 'Territory',
'Overseas Collectivity')
])
logging.debug(pretty_json(data.content))
self.assertEqual(data.status_code, 200)
def test_func_filter_unique(self,):
func_filters = [
{'unique': [
('field','content'),
('hideRepeatCount','false')
]},
('truncate', 5)
]
data = self.yql.get('yql.table.list', func_filters=func_filters)
logging.debug(pretty_json(data.content))
self.assertEqual(data.status_code, 200)
def test_func_filter_sort(self,):
func_filters = [
{'sort': [
('field','name'),
('descending','true')
]},
('tail', 10),
#('reverse')
]
data = self.yql.select('geo.counties', func_filters=func_filters).where(['place', '=', 'CA'])
logging.debug(pretty_json(data.content))
self.assertEqual(data.status_code, 200)
def test_1_insert(self,):
response = self.yql.insert('yql.storage.admin',('value',),('http://josuebrunel.org',))
try:
logging.debug(pretty_json(response.content))
data = response.json()['query']['results']['inserted']
logging.debug(data)
json_write_data(data,'yql_storage.json')
except (Exception,) as e:
logging.error(response.content)
logging.error(e)
self.assertEqual(response.status_code, 200)
def test_1_insert(self,):
response = self.yql.insert('yql.storage.admin',('value',),('http://josuebrunel.org',))
try:
logging.debug(pretty_json(response.content))
data = response.json()['query']['results']['inserted']
logging.debug(data)
json_write_data(data,'yql_storage.json')
except (Exception,) as e:
logging.error(response.content)
logging.error(e)
self.assertEqual(response.status_code, 200)
def test_func_filter_sort(self,):
func_filters = [
{'sort': [
('field','name'),
('descending','true')
]},
('tail', 10),
#('reverse')
]
data = self.yql.select('geo.counties', func_filters=func_filters).where(['place', '=', 'CA'])
logging.debug(pretty_json(data.content))
self.assertEqual(data.status_code, 200)
def processTeamData(self):
"""
Team data
"""
teams = self.yql.raw_query(
'select * from fantasysports.leagues.standings where league_key="{}"'
.format(settings.LEAGUE_KEY),
format='json')
jsonTeams = json.loads(pretty_json(teams.content))
teamInfo = jsonTeams['query']['results']['league']['standings'][
'teams']['team']
self.current_week = jsonTeams['query']['results']['league'][
'current_week']
for team in teamInfo:
self.teamData[team['team_key']] = {
'season': team['team_points']['season'],
'wins': 0,
'team_name': team['name'],
'logo': team['team_logos']['team_logo']['url'],
'manager': team['managers']['manager']['nickname']
}
def test_get_options_info(self,):
data = self.stock.get_options_info('YHOO')
logging.debug(pretty_json(data.content))
self.assertEqual(data.status_code, 200)
def test_get_current_info_with_one_symbol(self,):
data = self.stock.get_current_info(["J&KBANK.BO"])
logging.debug(pretty_json(data.content))
self.assertEqual(data.status_code, 200)
def test_get_historical_info_with_args(self,):
data = self.stock.get_historical_info('YHOO',items=['Open','Close','High','Low'], limit=5,startDate='2014-09-11',endDate='2015-02-10')
logging.debug(pretty_json(data.content))
self.assertEqual(data.status_code, 200)
def test_get_xchange_rate(self, ):
data = self.stock.get_xchange_rate(['EURUSD', 'GBPUSD'])
logging.debug(pretty_json(data.content))
self.assertEqual(data.status_code, 200)
def test_get_astronomy(self,):
data = self.weather.get_astronomy('Congo')
logging.debug(pretty_json(data.content))
self.assertEqual(data.status_code, 200)
def test_raw_query(self,):
response = self.yql.raw_query('select name, woeid from geo.states where place="Congo"')
logging.debug(pretty_json(response.content))
self.assertEqual(response.status_code, 200)
def test_get_index_summary(self, ):
data = self.stock.get_index_summary('GOOG', ('Volume', 'Change'))
logging.debug(pretty_json(data.content))
self.assertEqual(data.status_code, 200)
def test_get_historical_info_without_args(self, ):
data = self.stock.get_historical_info('YHOO')
logging.debug(pretty_json(data.content))
self.assertEqual(data.status_code, 200)
def test_oauth1():
oauth = OAuth1(None, None, from_file='oauth1.json')
yql = myql.MYQL(oauth=oauth)
response = yql.get_guid('josue_brunel')
logging.debug(pretty_json(response.content))
assert response.status_code == 200
def test_select(self, ):
response = self.yql.select('geo.countries',
['name', 'code', 'woeid']).where(
['name', '=', 'Canada'])
logging.debug(pretty_json(response.content))
self.assertEqual(response.status_code, 200)
def test_select_in(self, ):
response = self.yql.select('yahoo.finance.quotes').where(
['symbol', 'in', ("YHOO", "AAPL", "GOOG")])
logging.debug(pretty_json(response.content))
self.assertEqual(response.status_code, 200)
def test_raw_query(self, ):
response = self.yql.raw_query(
'select name, woeid from geo.states where place="Congo"')
logging.debug(pretty_json(response.content))
self.assertEqual(response.status_code, 200)
def test_get_balancesheet(self, ):
data = self.stock.get_balancesheet('YHOO')
logging.debug(pretty_json(data.content))
self.assertEqual(data.status_code, 200)
def test_get_dividendhistory(self, ):
data = self.stock.get_dividendhistory('AAPL', "2008-01-01",
"2015-06-15")
logging.debug(pretty_json(data.content))
self.assertEqual(data.status_code, 200)
def test_get_symbols(self,):
data = self.stock.get_symbols('Google')
logging.debug(pretty_json(data.content))
self.assertIn(data.status_code, (200, 400, "Web Service is currently Down!!"))
def test_oauth2():
oauth = OAuth2(None, None, from_file='oauth2.yaml')
response = oauth.session.get(
'https://social.yahooapis.com/v1/me/guid?format=json')
logging.debug(pretty_json(response.content))
assert response.status_code == 200
def test_get_dividendhistory(self,):
data = self.stock.get_dividendhistory('AAPL',"2008-01-01", "2015-06-15")
logging.debug(pretty_json(data.content))
self.assertEqual(data.status_code, 200)
def test_get_weather_description(self,):
data = self.weather.get_weather_description('dolisie')
logging.debug(pretty_json(data.content))
self.assertEqual(data.status_code, 200)
def test_select_in(self,):
response = self.yql.select('yahoo.finance.quotes').where(['symbol','in',("YHOO","AAPL","GOOG")])
logging.debug(pretty_json(response.content))
self.assertEqual(response.status_code, 200)
def test_get_current_atmosphere(self,):
data = self.weather.get_current_atmosphere('Scotland')
logging.debug(pretty_json(data.content))
self.assertEqual(data.status_code, 200)
def test_get_weather_forecast(self,):
data = self.weather.get_weather_forecast('choisy-le-roi')
logging.debug(pretty_json(data.content))
self.assertEqual(data.status_code, 200)
def test_get_symbols(self, ):
data = self.stock.get_symbols('Google')
logging.debug(pretty_json(data.content))
self.assertIn(data.status_code,
(200, 400, "Web Service is currently Down!!"))
def test_get_current_condition(self,):
data = self.weather.get_current_condition('Nantes')
logging.debug(pretty_json(data.content))
self.assertEqual(data.status_code, 200)
def test_get_news_feed(self, ):
data = self.stock.get_news_feed('YHOO')
logging.debug(pretty_json(data.content))
self.assertEqual(data.status_code, 200)
def test_get_current_wind(self,):
data = self.weather.get_current_wind('Barcelona')
logging.debug(pretty_json(data.content))
self.assertEqual(data.status_code, 200)
def test_get_current_info_with_one_symbol(self, ):
data = self.stock.get_current_info(["J&KBANK.BO"])
logging.debug(pretty_json(data.content))
self.assertEqual(data.status_code, 200)
def test_get_current_info(self,):
data = self.stock.get_current_info(["YHOO","AAPL","GOOG","J&KBANK.BO"])
logging.debug(pretty_json(data.content))
self.assertEqual(data.status_code, 200)
def test_get_current_info(self, ):
data = self.stock.get_current_info(
["YHOO", "AAPL", "GOOG", "J&KBANK.BO"])
logging.debug(pretty_json(data.content))
self.assertEqual(data.status_code, 200)
def test_get_news_feed(self,):
data = self.stock.get_news_feed('YHOO')
logging.debug(pretty_json(data.content))
self.assertEqual(data.status_code, 200)
def test_func_filter_truncate(self,):
func_filters = [('truncate', 2)]
data = self.yql.select('geo.states', func_filters=func_filters).where(['place', '=', 'Congo'])
logging.debug(pretty_json(data.content))
self.assertEqual(data.status_code, 200)
def test_get_historical_info_without_args(self,):
data = self.stock.get_historical_info('YHOO')
logging.debug(pretty_json(data.content))
self.assertEqual(data.status_code, 200)
def test_get_astronomy(self, ):
data = self.weather.get_astronomy('Congo')
logging.debug(pretty_json(data.content))
self.assertEqual(data.status_code, 200)
def test_get_index_summary(self,):
data = self.stock.get_index_summary('GOOG',('Volume','Change'))
logging.debug(pretty_json(data.content))
self.assertEqual(data.status_code, 200)
def test_remote_filter_get_start_and_count(self,):
data = self.yql.get('geo.countries', remote_filter=(100,10))
logging.debug(pretty_json(data.content))
self.assertEqual(data.status_code, 200)
def test_get_xchange_rate(self,):
data = self.stock.get_xchange_rate(['EURUSD','GBPUSD'])
logging.debug(pretty_json(data.content))
self.assertEqual(data.status_code, 200)
def test_remote_filter_select_start_and_count(self,):
data = self.yql.select('geo.counties', remote_filter=(60,20)).where(['place', '=', 'CA'])
logging.debug(pretty_json(data.content))
self.assertEqual(data.status_code, 200)
def test_get_balancesheet(self,):
data = self.stock.get_balancesheet('YHOO')
logging.debug(pretty_json(data.content))
self.assertEqual(data.status_code, 200)
def test_get_guid(self,):
oauth = OAuth1(None, None, from_file='credentials.json')
yql = MYQL(format='json', oauth=oauth)
response = yql.get_guid('josue_brunel')
logging.debug(pretty_json(response.content))
self.assertEqual(response.status_code, 200)
def test_select(self,):
response = self.yql.select('geo.countries', ['name', 'code', 'woeid']).where(['name', '=', 'Canada'])
logging.debug(pretty_json(response.content))
self.assertEqual(response.status_code, 200)
def test_get_weather_in_with_unit(self):
data = self.weather.get_weather_in('choisy-le-roi', 'c',['location', 'units', 'item.condition'])
logging.debug(pretty_json(data.content))
self.assertEqual(data.status_code, 200)
def test_select_in_2(self,):
response = self.yql.select('weather.forecast',['units','atmosphere']).where(['woeid','IN',('select woeid from geo.places(1) where text="Paris"',)])
logging.debug(pretty_json(response.content))
self.assertEqual(response.status_code, 200)
def test_get_options_info(self, ):
data = self.stock.get_options_info('YHOO')
logging.debug(pretty_json(data.content))
self.assertEqual(data.status_code, 200)
