def createInitTMs(self, dsn):
app.storeT = StoreTM(app.config['dsn'])
newTm = tm('Veli', 'Male', 'Turkish', '1978', 1)
app.storeT.addTm(newTm, dsn)
newTm = tm('Ayşe', 'Female', 'Turkish', '1978', 1)
app.storeT.addTm(newTm, dsn)
newTm = tm('Jane', 'Female', 'English', '1982', 2)
app.storeT.addTm(newTm, dsn)
def technicMembers():
dsn = app.config['dsn']
app.store = StoreTM(dsn)
allCoaches = coaches.get_coaches()
if request.method == 'GET':
allTms = app.store.getAllTms(dsn)
elif 'delete' in request.form:
ids = request.form.getlist('tms')
for id in ids:
app.store.deleteTm(id, dsn)
allTms = app.store.getAllTms(dsn)
elif 'add' in request.form:
name = request.form['nameToAdd']
gender = request.form['genderToAdd']
nation = request.form['nationToAdd']
birthDate = request.form['birthDateToAdd']
coach = request.form['coachToAdd']
newTm = tm(name, gender, nation, birthDate, coach)
app.store.addTm(newTm, dsn)
allTms = app.store.getAllTms(dsn)
elif 'update' in request.form:
ids = request.form.getlist('tms')
id = ids[0]
name = request.form['nameToUpdate']
gender = request.form['genderToUpdate']
nation = request.form['nationToUpdate']
birthDate = request.form['birthDateToUpdate']
coach = request.form['coachToUpdate']
newTm = tm(name, gender, nation, birthDate, coach)
app.store.updateTm(newTm, id, dsn)
allTms = app.store.getAllTms(dsn)
elif 'find' in request.form:
name = request.form['nameToFind']
gender = request.form['genderToFind']
nation = request.form['nationToFind']
birthDate = request.form['birthDateToFind']
coach = request.form['coachToFind']
findTm = tm(name, gender, nation, birthDate, coach)
allTms = app.store.selectTms(findTm, dsn)
return render_template('technicMembers.html', tms = allTms, coaches = allCoaches )
