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]))