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