def get(self, recordid):
cursor = self.conn.cursor()
query = "SELECT team_records.id, team_id, win, loss, draw, year FROM (team_records JOIN team_sport ON teamSportID = team_sport.id) WHERE team_records.id = ?"
cursor.execute(query, (recordid, ))
record = cursor.fetchone()
cursor.close()
return TeamRecords(record[0], record[1], record[2], record[3],
record[4], record[5])
def editTeamRecord(self, recordid, json):
if json['team_id'] and json['wins'] and json['loss'] and json[
'draw'] and json['year']:
new_teamRecord = TeamRecords(recordid, json['team_id'],
json['wins'], json['loss'],
json['draw'], json['year'])
record = RecordsDAO().edit(new_teamRecord)
return jsonify(TeamRecords=record.__dict__), OK
else:
return jsonify(Error='Unexpected attributes in post'), BAD_REQUEST
def getall(self):
cursor = self.conn.cursor()
query = "SELECT team_records.id, team_id, win, loss, draw, year FROM (team_records JOIN team_sport ON teamSportID = team_sport.id)"
cursor.execute(query)
result = cursor.fetchall()
records_tup = [record for record in result]
records_obj = [
TeamRecords(record[0], record[1], record[2], record[3], record[4],
record[5]) for record in records_tup
]
cursor.close()
self.conn.close()
return records_obj
def add(self, soccerTeam, int):
self.conn = utils.connectDB()
cursor = self.conn.cursor()
query = "SELECT id FROM team_sport WHERE team_id = ?"
cursor.execute(query, (soccerTeam.team_id, ))
team_sportid = cursor.fetchone()[0]
query1 = "INSERT INTO soccer_team_statistics(team_sport_id, goals_for, goals_allowed, shots, shots_on_goal, saves, passes, possession, fouls, date) values(?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
cursor.execute(query1, (
team_sportid,
soccerTeam.goals_for,
soccerTeam.goals_allowed,
soccerTeam.shots,
soccerTeam.shots_on_goal,
soccerTeam.saves,
soccerTeam.passes,
soccerTeam.possession,
soccerTeam.fouls,
soccerTeam.date,
))
statid = cursor.lastrowid
stat_obj = self.get(statid)
self.conn.commit()
date = datetime.strptime(soccerTeam.date, "%Y-%m-%d")
year = date.year
if RecordsDAO().getByTeamIDAndYear(soccerTeam.team_id, year):
pass
else:
RecordsDAO().add(TeamRecords(0, soccerTeam.team_id, 0, 0, 0, year))
recordid = RecordsDAO().getByTeamIDAndYear(soccerTeam.team_id, year)
if int == 0:
RecordsDAO().addWinToRecord(recordid)
elif int == 1:
RecordsDAO().addLossToRecord(recordid)
elif int == 2:
RecordsDAO().addDrawToRecord(recordid)
cursor.close()
self.conn.close()
return stat_obj