class DefaultMetrics:
def __init__(self, *args, **kwargs):
# Here, are there any variables that we will need?
# rank is what metric we rank by
self.rank = kwargs["rank"]
self.position = kwargs["position"]
self.playerDao = PlayerDao()
self.playerList = self.playerDao.getAllPlayersByKey()
if (self.rank == ""):
self.ranking = self.playerList
else:
self.rankList()
def rankList(self):
# This will rank the list based on the position sent in, and by the metric
self.ranking = self.playerDao.getPlayersOfPosition(self.position)
self.ranking.sort(key=lambda x: getattr(x.playerStats, self.rank), reverse=True)
def printList(self):
print self.rank + ": " + str(self.ranking)
class DefaultMetrics:
def __init__(self, *args, **kwargs):
# Here, are there any variables that we will need?
# rank is what metric we rank by
self.rank = kwargs["rank"]
self.position = kwargs["position"]
self.playerDao = PlayerDao()
self.playerList = self.playerDao.getAllPlayersByKey()
if (self.rank == ""):
self.ranking = self.playerList
else:
self.rankList()
def rankList(self):
# This will rank the list based on the position sent in, and by the metric
self.ranking = self.playerDao.getPlayersOfPosition(self.position)
self.ranking.sort(key=lambda x: getattr(x.playerStats, self.rank),
reverse=True)
def printList(self):
print self.rank + ": " + str(self.ranking)
Created on 2013-10-09
@author: Ivan
'''
import csv
from PlayerDao import PlayerDao
import MySQLdb
def getDbConnection():
db = MySQLdb.connect(host="localhost", user="******", passwd="watershipdown", db="nba_db")
return db
with open("dataload/ESPN_Master.csv") as csvplayers:
reader2 = csv.reader(csvplayers)
dao = PlayerDao()
playerList = dao.getAllPlayersByKey()
indArr = []
positionArr = []
i = 0
for row in reader2:
row[1] = row[1].replace("'", "''")
# split by | delimiter
elems = row[1].split("|")
j = 0
for elem in elems:
elems[j] = elem.replace('\xa0', ' ')
j = j+1
if (elems[0] in str(playerList)):
# First add the index to it
ind = dao.getPlayerKeyByName(elems[0])
indArr.append(ind)
