from __future__ import division import sys import os from datetime import datetime from yahoo_auth import get_yahoo_auth from predict import update_model, predict_today, linear_interpolation sys.path.append('..') from utility.database import DatabaseCreate from utility.Send_Text import send_text db = DatabaseCreate(os.path.join(os.path.dirname(os.path.realpath(__file__)), 'data'), 'fantasy_football.db') def career_record(mobile, carrier, manager, opponent, week, year, type): """Returns career record (including playoffs) of two opponents""" query = "select count(*) from (select * from scoreboard_all where (manager1_name = '{0}' and manager2_name = '{1}')\ or (manager2_name = '{0}' and manager1_name = '{1}')) where team1_points>0 and type='{2}' and (week!={3} or\ year!= {4});".format(manager, opponent, type, week, year) x = int(db.fetch_one(query)) query = "select count(*) from (select * from scoreboard_all where ((manager1_name = '{0}' and manager2_name = '{1}' \ and team1_points > team2_points) or (manager2_name = '{0}' AND manager1_name = '{1}' and \ team2_points > team1_points))) where type = '{2}' and (week != {3} OR year != {4})".format( manager, opponent, type, week, year) y = int(db.fetch_one(query)) try: career_winning_percentage = '{:.2%}'.format(float(y) / float(x)) except ZeroDivisionError: