27 lines
899 B
Python
27 lines
899 B
Python
import sys
|
|
from PyQt5.QtWidgets import QApplication, QMainWindow
|
|
from PyQt5 import QtSql
|
|
from PyQt5.uic import loadUi
|
|
|
|
class Frm_main(QMainWindow):
|
|
def __init__(self):
|
|
super(Frm_main, self).__init__()
|
|
loadUi("pyqt5.ui", self)
|
|
mod_geraete = QtSql.QSqlRelationalTableModel()
|
|
mod_geraete.setTable("Geraete")
|
|
mod_geraete.setRelation(2, QtSql.QSqlRelation("Kunden", "Kunden_Index", "Kunden_Name"))
|
|
mod_geraete.setRelation(6, QtSql.QSqlRelation("Pruefung", "Pruefung_Ablauf", "Pruefung_Name"))
|
|
mod_geraete.select()
|
|
self.tbl_geraete.setModel(mod_geraete)
|
|
|
|
db = QtSql.QSqlDatabase.addDatabase("QSQLITE")
|
|
db.setDatabaseName("meine.db")
|
|
|
|
|
|
app = QApplication(sys.argv)
|
|
frm_main = Frm_main()
|
|
frm_main.lbl_eins.setText("Ein Label")
|
|
#self.lbl_eins.setText(QCoreApplication.translate("MainWindow", u"Das Label", None))
|
|
frm_main.show()
|
|
app.exec()
|