def newClub():
if 'username' not in login_session:
return redirect('/login')
if request.method == 'POST':
newClub = Club(name=request.form['name'])
session.add(newClub)
session.commit()
return redirect(url_for('viewClubs'))
else:
return render_template('newClub.html')
def newClub():
if 'username' not in login_session:
return redirect('/login')
if request.method == 'POST':
newClub = Club(
name=request.form['name'], user_id=login_session['user_id'])
session.add(newClub)
flash('Novo Clube %s Criado com Sucesso' % newClub.name)
session.commit()
return redirect(url_for('showClubs'))
else:
return render_template('newClub.html')
def new_club():
if 'username' not in login_session:
return redirect('/login')
if request.method == 'POST':
club = Club(name=request.form['name'],
description=request.form['description'],
Country_id=request.form['coun'],
user_id=login_session['user_id'])
session.add(club)
session.commit()
flash('New Club Added!')
return redirect(url_for('main'))
else:
return render_template('New Club.html')
def newTeam(league_id):
if 'username' not in login_session:
return redirect('/login')
league = session.query(League).filter_by(id=league_id).one()
if login_session['user_id'] != league.user_id:
return "<script>function myFunction() {alert('You are not authorized to add menu items to this league. Please create your own league in order to add items.');}</script><body onload='myFunction()''>"
if request.method == 'POST':
newItem = Club(name=request.form['name'],
founded=request.form['founded'],
description=request.form['description'],
league_id=league_id)
session.add(newItem)
session.commit()
flash("New Soccer Team %s Created!" % (newItem.name))
return redirect(url_for('soccerClub', league_id=league_id))
else:
return render_template('newteamadding.html', league_id=league_id)
def add_club(league_id):
if 'username' not in login_session:
flash("You were not authorised to access that page.")
return redirect(url_for('login'))
elif request.method == 'POST':
item = session.query(Club).filter_by(name=request.form['name']).first()
if item:
if item.name == request.form['name']:
flash('The item already exists in the database!')
return redirect(url_for("add_item"))
new_item = Club(
name=request.form['name'],
league_id=league_id,
description=request.form['description'],
user_id=login_session['user_id'])
session.add(new_item)
session.commit()
flash('New item successfully created!')
return redirect(url_for('all_clubs', league_id=league_id))
else:
category = session.query(League).filter_by(id=league_id).first()
return render_template('new_item.html', category=category)
)
session.add(user1)
session.commit()
'#England'
country1 = Country(name='England',
img_url='https://images3.alphacoders.com/743/74305.jpg')
session.add(country1)
session.commit()
club1 = Club(
name='Liverpool',
description="Liverpool Football Club is a\
professional football club in Liverpool, England, that competes in the\
Premier League, the top tier of English football. The club has won six\
European Cups, more than any other English club, three UEFA Cups and four\
UEFA Super Cups, also English records, eighteen League titles, seven FA Cups\
a record eight League Cups and fifteen FA Community Shields.",
img_url=
'https://pluspng.com/img-png/logo-liverpool-fc-png-liverpool-fc-logo-500.png',
country=country1,
user_id=1)
session.add(club1)
session.commit()
club2 = Club(
name='Manchester City',
description="Manchester City Football\
Club is\
an English football club based in Manchester, that competes in the Premier\
League, the top flight of English football. The club have won six domestic\
league titles. Under the management of Pep Guardiola they won the Premier\
session = DBSession()
# Create dummy user
User1 = User(name="Arslan Yazlyyev", email="*****@*****.**", picture="https://pbs.twimg.com/profile_images/2671170543/18debd694829ed78203a5a36dd364160_400x400.png")
session.add(User1)
session.commit()
#league
league1 = League(user_id=1, name = "England Premier League")
session.add(league1)
session.commit()
team1 = Club(user_id=1, name = "Arsenal",
founded = "1886",
description = "Stadium: Emirates Stadium, Manager: Arsene Wenger, Location: London, United Kingdom",
league = league1)
session.add(team1)
session.commit()
team2 = Club(user_id=1, name = "Chelsea",
founded = "1905",
description = "Stadium: Stamford Bridge, Manager: Antonio Conte, Location: London, United Kingdom",
league = league1)
session.add(team2)
session.commit()
team3 = Club( user_id=1, name = "Manchester United",
DBSession = sessionmaker(bind=engine)
''' A DBSession() instance establishes all conversations with the database
and represents a "staging zone" for all the objects loaded into the
database session object. Any change made against the objects in the
session won't be persisted into the database until you call
session.commit(). You can revert all of them back to the last commit by
calling session.rollback()
'''
session = DBSession()
# create a user
# User's name and email is given
User1 = User(name="Surya Dasari", email="*****@*****.**")
# Team for Barcelona
club1 = Club(name="Barcelona")
session.add(club1)
session.commit()
# commits are done
# Team players are added here
teamPlayer1 = TeamPlayer(
name="Lionel Messi",
description=
"Argentine professional footballer who plays as a forward for Spanish club Barcelona and the Argentine national team. Often considered the best player in the world.",
price="$2.99",
course="Striker",
club=club1)