def lstParty(self):
bddConnect = bdd.Bdd()
liste_party = bddConnect.read(
"SELECT * FROM partytype ORDER BY partytypename")
for row in liste_party:
self.cmb_party.addItem(str(row[1]), str(row[0]))
def lstStarter(self):
bddConnect = bdd.Bdd()
liste_starter = bddConnect.read(
"SELECT * FROM starterballs ORDER BY starterballsname")
for row in liste_starter:
self.cmb_starter.addItem(str(row[1]), str(row[0]))
def lstWeather(self):
bddConnect = bdd.Bdd()
liste_weather = bddConnect.read(
"SELECT * FROM weather ORDER BY weathername")
for row in liste_weather:
self.cmb_weather.addItem(str(row[1]), str(row[0]))
def lstCourses(self):
bddConnect = bdd.Bdd()
liste_courses = bddConnect.read(
"SELECT courses.coursesname, courses.idcourses, golfs.golfsname FROM golfs, courses WHERE courses.idgolfs = golfs.idgolfs ORDER BY golfs.golfsname"
)
for row in liste_courses:
self.cmb_course.addItem(str(row[0] + " : " + row[2]), str(row[1]))
def scoreCardsPage(self):
# Hide ToolBar
self.toolBarCards.hide()
self.toolBarParameters.hide()
self.toolBarStats.hide()
# Show ToolBar
self.toolBarCards.show()
self.stacked.setCurrentIndex(0)
self.tab_result.setColumnCount(9)
self.tab_result.setHorizontalHeaderLabels([
"Id carte", "Date", "Parcours", "Score", "Nb Fairway",
"Greens en régulation", "Météo", "Fluidité de jeu", "Mode de jeu"
])
# self.tab_result.cellDoubleClicked.connect(lambda item: self.addCardPage(item=item))
self.setWindowTitle("Mes cartes de score")
sql = "SELECT scorecards.idscorecards, " \
"scorecards.scorecardsdate, " \
"courses.coursesname, " \
"sum(results.resultscore) as resultat, " \
"sum(results.resultfairway) as fairway, " \
"sum(results.resultgreen) as green, " \
"weather.weathername, " \
"partytype.partytypename, " \
"termes.termesname " \
"FROM scorecards, courses, results, weather, partytype, termes " \
"WHERE scorecards.idcourses = courses.idcourses AND " \
"scorecards.idweather = weather.idweather AND " \
"scorecards.idtermes = termes.idtermes AND " \
"scorecards.idpartytype = partytype.idpartytype AND " \
"scorecards.idscorecards = results.idscorecards " \
"GROUP BY scorecards.idscorecards;"
bddConnect = bdd.Bdd()
list_card = bddConnect.read(sql)
self.tab_result.setRowCount(0)
for row_number, row_data in enumerate(list_card):
self.tab_result.insertRow(row_number)
for column_number, data in enumerate(row_data):
self.tab_result.setItem(row_number, column_number,
QTableWidgetItem(str(data)))
def lstBalls(self):
bddConnect = bdd.Bdd()
liste_balls = bddConnect.read("SELECT * FROM balls ORDER BY ballsname")
for row in liste_balls:
self.cmb_balls.addItem(str(row[1]), str(row[0]))
def lstSpeed(self):
bddConnect = bdd.Bdd()
liste_speed = bddConnect.read("SELECT * FROM termes ORDER BY termesname")
for row in liste_speed:
self.cmb_speed.addItem(str(row[1]), str(row[0]))