def editTeam(teamName):
conn = sqlite3.connect("football.db")
if request.method == "GET":
cursor = conn.execute("SELECT * FROM TEAM WHERE TEAM_NAME=?",
(teamName, )).fetchone()
print(os.getcwd())
b = [
"teamName", "teamLogo", "squadPic", "founded", "homeGround",
"teamCost", "teamWebsite", "teamOwner", "teamCoach", "teamSponsor",
"country", "about"
]
teamInfo = dict(zip(b, cursor))
conn.close()
return render_template("teamEditForm.html", teamInfo=teamInfo)
elif request.method == "POST":
t = Team(teamName)
about = request.form.get("teamAbout", None)
if about.strip() == "":
about = "This team is prominent team in league"
t.insert_team(teamLogo=request.form.get("teamLogo", None),
squadpic=request.form.get("squadPic", None),
founded=request.form.get("founded", None),
homeground=request.form.get("homeGround", None),
teamcost=eval(request.form.get("teamCost", 0)),
teamWebsite=request.form.get("teamWebsite", None),
teamowner=request.form.get("teamOwner", None),
teamcoach=request.form.get("teamCoach", None),
sponser=request.form.get("teamSponsor", None),
country=request.form.get("country", None),
about=about,
operation="update")
flash("You Just Edited a Team " + teamName, "message")
return redirect(url_for("showTeam"))
def editTeam(teamName):
if request.method == "GET":
a = db.info.find_one({"teamName": teamName}, {
"players": 0,
"_id": 0,
"fixture": 0
})
return render_template("teamEditForm.html", teamInfo=a)
elif request.method == "POST":
t = Team(teamName)
about = request.form.get("teamAbout", None)
if about == "" or about == " ":
about = "This team is prominent team in league"
t.insert_team(teamLogo=request.form.get("teamLogo", None),
squadpic=request.form.get("squadPic", None),
founded=request.form.get("founded", None),
homeground=request.form.get("homeGround", None),
teamcost=eval(request.form.get("teamCost", 0)),
teamWebsite=request.form.get("teamWebsite", None),
teamowner=request.form.get("teamOwner", None),
teamcoach=request.form.get("teamCoach", None),
sponser=request.form.get("teamSponsor", None),
country=request.form.get("country", None),
about=about,
operation="update")
print(request.form)
return redirect(url_for("showTeam"))
def editPlayers(teamName, playerName):
if request.method == "POST":
t = Team(teamName)
about = request.form.get("about", None)
if about == "" or about == " ":
about = "This Player is a prominent Player in " + teamName
t.insertPlayer(playername=request.form.get("playerName", None),
country=request.form.get("country", None),
age=request.form.get("playerAge", None),
dateofbirth=request.form.get("playerDateOfBirth", None),
numberofgoals=request.form.get("numberOfGoals", None),
photo=request.form.get("playerPhoto", None),
playerposition=request.form.get("playerPosition", None),
playercost=request.form.get("playerCost", None),
jerseynum=request.form.get("playerJerseyNum", 0),
about=about,
operation="update",
oldPlayerName=playerName)
return redirect(url_for("teamPlayers", teamName=teamName))
elif request.method == "GET":
mydict = {
"Goalkeeper": "Goalkeeper",
"Right full back": "Right full back",
"Left full back": " Left full back",
"Right half back": "Right half back",
"Centre half back": "Centre half back",
"Left half back": "Left half back"
}
a = db.info.aggregate([{
"$unwind": "$players"
}, {
"$match": {
"teamName": teamName,
"players.playerName": playerName
}
}, {
"$project": {
"players": 1,
"_id": 0
}
}],
useCursor=False)
abc = ""
for ab in a:
abc = ab["players"]
return render_template("playerEditForm.html",
teamPlayerData=abc,
mydict=mydict,
target=abc["playerPosition"])
def editPlayers(teamName, playerId):
if request.method == "POST":
t = Team(teamName)
about = request.form.get("about", None)
if about.strip() == "":
about = "This Player is a prominent Player in " + teamName
t.insertPlayer(playername=request.form.get("playerName", None),
country=request.form.get("country", None),
age=request.form.get("playerAge", None),
dateofbirth=request.form.get("playerDateOfBirth", None),
numberofgoals=request.form.get("numberOfGoals", None),
photo=request.form.get("playerPhoto", None),
playerposition=request.form.get("playerPosition", None),
playercost=request.form.get("playerCost", None),
jerseynum=request.form.get("playerJerseyNum", 0),
about=about,
operation="update",
oldPlayerid=playerId)
flash(
"You Just Updated " + request.form.get("playerName", None) +
" Information", "message")
return redirect(url_for("teamPlayers", teamName=teamName))
elif request.method == "GET":
conn = sqlite3.connect("football.db")
conn.execute('PRAGMA FOREIGN_KEYS = ON ')
cursor = conn.execute("SELECT * FROM PLAYER WHERE PLAYER_ID =?",
(playerId, )).fetchone()
mydict = {
"Goalkeeper": "Goalkeeper",
"Right full back": "Right full back",
"Left full back": " Left full back",
"Right half back": "Right half back",
"Centre half back": "Centre half back",
"Left half back": "Left half back"
}
b = [
"teamName", "playerId", "playerName", "country", "playerAge",
"playerPhoto", "playerDate", "numberOfGoals", "playerPosition",
"playerCost", "playerJerseyNum", "about"
]
abc = dict(zip(b, cursor))
return render_template("playerEditForm.html",
teamPlayerData=abc,
mydict=mydict,
target=abc["playerPosition"])
def addTeam():
if request.method == 'POST':
t = Team(request.form["teamName"])
t.insert_team(teamLogo=request.form.get("teamLogo", None),
squadpic=request.form.get("squadPic", None),
founded=request.form.get("founded", None),
homeground=request.form.get("homeGround", None),
teamcost=eval(request.form.get("teamCost", 0)),
teamWebsite=request.form.get("teamWebsite", None),
teamowner=request.form.get("teamOwner", None),
teamcoach=request.form.get("teamCoach", None),
sponser=request.form.get("teamSponsor", None),
country=request.form.get("country", None),
operation="insert")
return redirect(url_for("teamInfo"))
else:
return render_template("teamAddForm.html")
def addTeam():
if request.method == 'POST':
about = request.form.get("teamAbout", None)
if about == "" or about == " ":
about = "This team is prominent team in league"
t = Team(request.form.get("teamName", None))
t.insert_team(teamLogo=request.form.get("teamLogo", None),
squadpic=request.form.get("squadPic", None),
founded=request.form.get("founded", None),
homeground=request.form.get("homeGround", None),
teamcost=eval(request.form.get("teamCost", 0)),
teamWebsite=request.form.get("teamWebsite", None),
teamowner=request.form.get("teamOwner", None),
teamcoach=request.form.get("teamCoach", None),
sponser=request.form.get("teamSponsor", None),
country=request.form.get("country", None),
about=about,
operation="insert")
return redirect(url_for("showTeam"))
else:
return render_template("teamAddForm.html")
def addPlayers(teamName):
if request.method == "POST":
t = Team(teamName)
about = request.form.get("about", None)
if about == "" or about == " ":
about = "This Player is a prominent Player in " + teamName
t.insertPlayer(playername=request.form.get("playerName", None),
country=request.form.get("country", None),
age=request.form.get("playerAge", None),
dateofbirth=request.form.get("playerDateOfBirth", None),
numberofgoals=request.form.get("numberOfGoals", None),
photo=request.form.get("playerPhoto", None),
playerposition=request.form.get("playerPosition", None),
playercost=request.form.get("playerCost", None),
jerseynum=request.form.get("playerJerseyNum", 0),
about=about,
operation="insert",
oldPlayerid="")
return redirect(url_for("teamPlayers", teamName=teamName))
elif request.method == "GET":
return render_template("playerAddForm.html")
