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:
