def update():
try:
Teams = pd.read_csv("Teams.csv")
Teams = Teams['Name']
Choices =[]
for row in Teams:
choice=(row,row)
Choices.append(choice)
class up(FlaskForm):
blueSide=SelectField(u'Blue Side',choices=Choices)
redSide=SelectField(u'Red Side',choices=Choices)
score=SelectField(u'Score',choices=[("0","Blue side won"),("1","Red side won")])
submit = SubmitField('Submit')
db=DBHelper()
BlueSide = None
RedSide = None
Score = None
form =up()
if form.validate_on_submit():
BlueSide = form.blueSide.data
RedSide = form.redSide.data
Score = form.score.data
db.insertar("INSERT INTO Games VALUES('" + BlueSide + "','" + RedSide +"','" + Score+"')")
flash(f'Score successfully updated in to the database!',category='success')
print(db.leer())
return render_template('Update.html',name="Update results",form=form)
except Exception as error:
print(error)
return "Error"
def setUp(self):
self.db_name = 'test.db'
create_db(self.db_name)
self.dbh = DBHelper(self.db_name)
