---

# import MySQLdb as mdb
import pymysql as mdb


class SQLQw:
    def __init__(self):
        try:
            self.con =mdb.connect(
                host='kozinelm.beget.tech',
                user='kozinelm_databas',
                password='PasswordDatabase',
                database='kozinelm_databas'
            )
            print("Connection db")
            self.con.close()
        except Exception as e:
            print(f"Error Connection {e}")


    def auth(self, login, password, db=None):
        db=SQLQw()
        cur=db.cursor()
        rows = cur.execute(f"SELECT * FROM user_profile WHERE login = '{login}' AND password = '{password}'")
        data=cur.fetchall()
        print("Authorization")
        cur.close()
        return data

if __name__ == "__main__":
    sql = SQLQw()


import os, sys
from PyQt6.QtWidgets import *
from PyQt6.QtCore import *
from DatabaseConnection import *
from BookShop import MyBookShop
import MySQLdb as mdb


class RegistrationWindow(QWidget):
    def __init__(self):
        super().__init__()
        self.setWindowTitle("window")
        self.setStyleSheet("background-color: purple; color: black;")
        self.resize(600, 600)

        layout = QVBoxLayout()

        layout.addWidget(QLabel("Book Shop"))

        layout.addWidget(QLabel("Логин"))
        layout.addWidget(QLineEdit())
        layout.addWidget(QLabel("Пароль"))
        layout.addWidget(QLineEdit())

        self.btn_enter = QPushButton("Войти")
        self.btn_close = QPushButton("Закрыть")

        self.btn_enter.clicked.connect(self.onClicked)
        self.btn_close.clicked.connect(QApplication.instance().quit)


        layout.addWidget(self.btn_enter)
        layout.addWidget(self.btn_close)

        self.setLayout(layout)

    def onClicked(self):
        login = self.loginEdit.text()
        passw = self.passEdit.text()
        data=SQLQw.auth(login=login, password=passw)
        print('Test. OpenWindow')

        if data:
            print('Test Open window')
            self.ww = MyBookShop()
            self.ww.show()
        else:
            QMessageBox.about(self, 'Ошибка аутентификации', 'неверно введен логин или пароль')
        


if __name__ == "__main__":
    app=QApplication(sys.argv)
    window=RegistrationWindow()
    window.show()
    sys.exit(app.exec())