
import sys
from PyQt5 import QtCore, QtGui, QtWidgets
import sqlite3
from base import client_base
class Authorization_Window(object):
    def auth_Form(self):
        self.authwindow = QtWidgets.QMainWindow()
        self.authform = Authorization_Window()
        self.authform.setupUi(self.authwindow)
        self.authwindow.destroy()
    def client_window(self): # вызов дочернего окна
        self.window = QtWidgets.QMainWindow()
        self.client = client_base()
        self.client.setupUi(self.window)
        self.window.show()
    def auth_Check(self):
        username = self.lineEdit_login.text()
        password = self.lineEdit_pass.text()
        connection = sqlite3.connect("login.db")
        result = connection.execute("SELECT  * FROM  USERS WHERE  USERNAME = ? AND  PASSWORD = ?", (username, password))
        if (len(result.fetchall()) > 0): #если логин и пароль совпадают с БД, происходит вызов нового окна
            print("User Found! ")
            self.client_window()
            self.auth_Form()
        else:
            print("User not Found! ")
    def setupUi(self, MainWindow):
        MainWindow.setObjectName("MainWindow")
        MainWindow.setEnabled(True)
        MainWindow.resize(220, 195)
        self.centralwidget = QtWidgets.QWidget(MainWindow)
        self.centralwidget.setObjectName("centralwidget")
        self.label_login = QtWidgets.QLabel(self.centralwidget)
        self.label_login.setGeometry(QtCore.QRect(50, 10, 101, 16))
        self.label_login.setObjectName("label_login")
        self.label_pass = QtWidgets.QLabel(self.centralwidget)
        self.label_pass.setGeometry(QtCore.QRect(50, 50, 61, 16))
        self.label_pass.setObjectName("label_pass")
        self.lineEdit_login = QtWidgets.QLineEdit(self.centralwidget)
        self.lineEdit_login.setGeometry(QtCore.QRect(50, 30, 113, 20))
        self.lineEdit_login.setObjectName("lineEdit_login")
        self.lineEdit_pass = QtWidgets.QLineEdit(self.centralwidget)
        self.lineEdit_pass.setGeometry(QtCore.QRect(50, 70, 113, 20))
        self.lineEdit_pass.setObjectName("lineEdit_pass")
        self.Button_enter = QtWidgets.QPushButton(self.centralwidget)
        self.Button_enter.setGeometry(QtCore.QRect(50, 110, 111, 23))
        self.Button_enter.setObjectName("Button_enter")
        ###################EVENT#################
        self.Button_enter.clicked.connect(self.auth_Check)
        ################################################
        MainWindow.setCentralWidget(self.centralwidget)
        self.menubar = QtWidgets.QMenuBar(MainWindow)
        self.menubar.setGeometry(QtCore.QRect(0, 0, 220, 21))
        self.menubar.setObjectName("menubar")
        MainWindow.setMenuBar(self.menubar)
        self.statusbar = QtWidgets.QStatusBar(MainWindow)
        self.statusbar.setObjectName("statusbar")
        MainWindow.setStatusBar(self.statusbar)
        self.retranslateUi(MainWindow)
        QtCore.QMetaObject.connectSlotsByName(MainWindow)
    def retranslateUi(self, MainWindow):
        _translate = QtCore.QCoreApplication.translate
        MainWindow.setWindowTitle(_translate("MainWindow", "MainWindow"))
        self.label_login.setText(_translate("MainWindow", "Имя пользователя:"))
        self.label_pass.setText(_translate("MainWindow", "Пароль:"))
        self.Button_enter.setText(_translate("MainWindow", "Войти"))
def enter():   #вызов главного окна входа по логину и паролю
    app = QtWidgets.QApplication(sys.argv)
    enter_windows = QtWidgets.QMainWindow()
    ui_window = Authorization_Window()
    ui_window.setupUi(enter_windows)
    enter_windows.show()
    sys.exit(app.exec_())
enter()import sys
from PyQt5 import QtCore, QtGui, QtWidgets
import sqlite3
from base import client_base
class Authorization_Window(object):
    def auth_Form(self):
        self.authwindow = QtWidgets.QMainWindow()
        self.authform = Authorization_Window()
        self.authform.setupUi(self.authwindow)
        self.authwindow.destroy()
    def client_window(self): # вызов дочернего окна
        self.window = QtWidgets.QMainWindow()
        self.client = client_base()
        self.client.setupUi(self.window)
        self.window.show()
    def auth_Check(self):
        username = self.lineEdit_login.text()
        password = self.lineEdit_pass.text()
        connection = sqlite3.connect("login.db")
        result = connection.execute("SELECT  * FROM  USERS WHERE  USERNAME = ? AND  PASSWORD = ?", (username, password))
        if (len(result.fetchall()) > 0): #если логин и пароль совпадают с БД, происходит вызов нового окна
            print("User Found! ")
            self.client_window()
            self.auth_Form()
        else:
            print("User not Found! ")
    def setupUi(self, MainWindow):
        MainWindow.setObjectName("MainWindow")
        MainWindow.setEnabled(True)
        MainWindow.resize(220, 195)
        self.centralwidget = QtWidgets.QWidget(MainWindow)
        self.centralwidget.setObjectName("centralwidget")
        self.label_login = QtWidgets.QLabel(self.centralwidget)
        self.label_login.setGeometry(QtCore.QRect(50, 10, 101, 16))
        self.label_login.setObjectName("label_login")
        self.label_pass = QtWidgets.QLabel(self.centralwidget)
        self.label_pass.setGeometry(QtCore.QRect(50, 50, 61, 16))
        self.label_pass.setObjectName("label_pass")
        self.lineEdit_login = QtWidgets.QLineEdit(self.centralwidget)
        self.lineEdit_login.setGeometry(QtCore.QRect(50, 30, 113, 20))
        self.lineEdit_login.setObjectName("lineEdit_login")
        self.lineEdit_pass = QtWidgets.QLineEdit(self.centralwidget)
        self.lineEdit_pass.setGeometry(QtCore.QRect(50, 70, 113, 20))
        self.lineEdit_pass.setObjectName("lineEdit_pass")
        self.Button_enter = QtWidgets.QPushButton(self.centralwidget)
        self.Button_enter.setGeometry(QtCore.QRect(50, 110, 111, 23))
        self.Button_enter.setObjectName("Button_enter")
        ###################EVENT#################
        self.Button_enter.clicked.connect(self.auth_Check)
        ################################################
        MainWindow.setCentralWidget(self.centralwidget)
        self.menubar = QtWidgets.QMenuBar(MainWindow)
        self.menubar.setGeometry(QtCore.QRect(0, 0, 220, 21))
        self.menubar.setObjectName("menubar")
        MainWindow.setMenuBar(self.menubar)
        self.statusbar = QtWidgets.QStatusBar(MainWindow)
        self.statusbar.setObjectName("statusbar")
        MainWindow.setStatusBar(self.statusbar)
        self.retranslateUi(MainWindow)
        QtCore.QMetaObject.connectSlotsByName(MainWindow)
    def retranslateUi(self, MainWindow):
        _translate = QtCore.QCoreApplication.translate
        MainWindow.setWindowTitle(_translate("MainWindow", "MainWindow"))
        self.label_login.setText(_translate("MainWindow", "Имя пользователя:"))
        self.label_pass.setText(_translate("MainWindow", "Пароль:"))
        self.Button_enter.setText(_translate("MainWindow", "Войти"))
def enter():   #вызов главного окна входа по логину и паролю
    app = QtWidgets.QApplication(sys.argv)
    enter_windows = QtWidgets.QMainWindow()
    ui_window = Authorization_Window()
    ui_window.setupUi(enter_windows)
    enter_windows.show()
    sys.exit(app.exec_())
enter()