CST316TeamJ/SportsApp — pull request #23 by adelorme82 (2014-04-09 05:11:10+00:00)
Title: logic and files to add overunder for recent tourney years

re-run the dbCreation.txt script in mySql

run tourneyResults.py

Spot check the spreadsheet to make sure that the data is on the right games - you can run this query

SELECT gameID, t1.teamName, t1.conference, t1.totalChampWins, t2.teamName, t2.conference, t2.totalChampWins, team1, team2, played, team1Score, team2Score, date, upsetPossible, upsetHappened, round, botUpset, location, overunder, spread, s1.region, s1.seed, s1.apRank, s1.coachRank, s1.rpiRank, s2.region, s2.seed, s2.apRank, s2.coachRank, s2.rpiRank
FROM game g
inner join seasonteam s1 on g.team1=s1.seasonTeamId
inner join seasonteam s2 on g.team2=s2.seasonTeamId
inner join team t1 on s1.teamid=t1.teamid
inner join team t2 on s2.teamid=t2.teamid
order by date