---

# 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}")









import pymysql
from pymysql.cursors import DictCursor


class QwerSql:
    def __init__(self):
        try:
            self.conn = pymysql.connect(
            host='kiribeh6.beget.tech',
            user='kiribeh6_databas',
            password='Vikun548',
            database='kiribeh6_databas',
            cursorclass=DictCursor
            )
            print('Ok')
            self.cursor = self.conn.cursor()
        except Exception as e:
            print('no')
            print(repr(e))

    def auth(self, login, password):
        sql = "SELECT * FROM users WHERE login=%s AND passw=%s"
        self.cursor.execute(sql, (login, password))
        return self.cursor.fetchone()

    def show_meters(self):
        sql = "SELECT * FROM users"
        self.cursor.execute(sql)
        return self.cursor.fetchall()


    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())

import os, sys
from PyQt6.QtWidgets import *
from PyQt6.QtCore import *


class MyBookShop(QMainWindow):
    def __init__(self, parent = None):
        super(MyBookShop, self).__init__(parent)
        self.stupUi(self)
        self.pushButton_2.clicked.connect(QApplication.instance().quit)