diff options
author | lonkaars <loek@pipeframe.xyz> | 2022-10-09 17:09:25 +0200 |
---|---|---|
committer | lonkaars <loek@pipeframe.xyz> | 2022-10-09 17:09:25 +0200 |
commit | d5469560cecafb8bf19db18ee930970491798f78 (patch) | |
tree | 4586a5f46b499715a14346ac45d06bd993340aa5 /eindopdracht/applicatie/main.py | |
parent | cbd5af58165bb2a05dcb8153804c9a9261be89b9 (diff) |
eindopdracht klaar
Diffstat (limited to 'eindopdracht/applicatie/main.py')
-rwxr-xr-x | eindopdracht/applicatie/main.py | 17 |
1 files changed, 13 insertions, 4 deletions
diff --git a/eindopdracht/applicatie/main.py b/eindopdracht/applicatie/main.py index 3327e07..2b6a19a 100755 --- a/eindopdracht/applicatie/main.py +++ b/eindopdracht/applicatie/main.py @@ -5,6 +5,7 @@ import sys import json from mysql.connector import MySQLConnection, Error import mysql.connector +from PyQt6.QtGui import QPixmap from PyQt6.QtWidgets import QApplication, QDialog, QComboBox, QLabel, QPlainTextEdit, QRadioButton, QHBoxLayout, QVBoxLayout db = mysql.connector.connect(host="localhost", user=os.getlogin(), database="mysql") @@ -28,8 +29,10 @@ def get_brand_info(brand): location_country = cursor.fetchone() return_dict["location"] = None if brand == None else location_country[0] return_dict["country"] = None if brand == None else location_country[1] - cursor.execute("select Naam from Merk where ID = %s", (brand,)) - return_dict["name"] = None if brand == None else cursor.fetchone()[0] + cursor.execute("select Naam, Logo from Merk where ID = %s", (brand,)) + name_logo_results = cursor.fetchone() + return_dict["name"] = None if brand == None else name_logo_results[0] + return_dict["logo_image_path"] = None if brand == None else name_logo_results[1] return return_dict def get_model_info(model): @@ -89,11 +92,15 @@ class MainWindow(QDialog): select_layout.addWidget(model_facts_label) select_layout.addWidget(self.model_facts) - viewer_layout = QVBoxLayout() + self.viewer_widget = QLabel() + self.viewer_widget.setScaledContents(True) + self.viewer_widget.setMinimumHeight(100) + self.viewer_widget.setMinimumWidth(100) layout = QHBoxLayout() layout.addLayout(select_layout) - layout.addLayout(viewer_layout) + layout.addWidget(self.viewer_widget) + layout.setStretch(0, 1) layout.setStretch(1, 2) self.brand_dropdown.clear() @@ -109,6 +116,8 @@ class MainWindow(QDialog): self.model_info = get_model_info(self.model) self.model_facts.setPlainText(self.get_model_info_human_readable()) + self.viewer_widget.setPixmap(QPixmap(self.brand_info["logo_image_path"])) + def switch_brand(self, index): self.brand = self.brand_dropdown.itemData(index) self.update() |