1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
|
import mariadb
from PyQt6.QtGui import *
from PyQt6.QtWidgets import *
from tab_drivers import *
from tab_teams import *
from tab_calendar import *
from tab_circuits import *
from tab_races import *
class MainWindow(QMainWindow):
cursor: mariadb.Cursor = None
menu_bar: QMenuBar
_tab_drivers: TabDrivers
_tab_teams: TabTeams
_tab_calendar: TabCalendar
_tab_circuits: TabCircuits
_tab_races: TabRaces
def set_cursor(self, cursor):
self.cursor = cursor
def call_update_flags(self):
folder = QFileDialog().getExistingDirectory(self, "Open directory", "/var/dab2/")
self.cursor.execute("call spUpdateFlags(?)", (folder,))
def call_update_persons(self):
folder = QFileDialog().getExistingDirectory(self, "Open directory", "/var/dab2/")
self.cursor.execute("call spUpdatePersons(?)", (folder,))
def call_delete_flags(self):
self.cursor.execute("call spDeleteFlags()")
def __init__(self, parent=None):
super(MainWindow, self).__init__(parent)
self.setWindowTitle("[floating] dab2 eindopdracht main window")
self.setMinimumHeight(500)
self._tab_drivers = TabDrivers(self)
self._tab_teams = TabTeams(self)
self._tab_calendar = TabCalendar(self)
self._tab_circuits = TabCircuits(self)
self._tab_races = TabRaces(self)
main_layout = QTabWidget(self);
main_layout.addTab(self._tab_drivers, "drivers")
main_layout.addTab(self._tab_teams, "teams")
main_layout.addTab(self._tab_calendar, "calendar")
main_layout.addTab(self._tab_circuits, "cirucits")
main_layout.addTab(self._tab_races, "races")
self.menu_bar = QMenuBar(self)
menu_procedures = self.menu_bar.addMenu("procedures")
sp_update_flags = menu_procedures.addAction("Import/update flags")
sp_update_flags.triggered.connect(self.call_update_flags)
sp_update_persons = menu_procedures.addAction("Import/update driver portraits")
sp_update_persons.triggered.connect(self.call_update_persons)
sp_delete_flags = menu_procedures.addAction("Delete flags")
sp_delete_flags.triggered.connect(self.call_delete_flags)
self.setMenuBar(self.menu_bar)
self.setCentralWidget(main_layout)
|