Как взять из класса переменную и вставить в свой класс?
Я уже очень много смотрел в интернете , но чтобы я не пробовал постоянно вылазиют разные ошибки. Мне на взять переменную s_login и вставить в QLabel ПОМОГИТЕ ПОЖАЛУЙСТА
from Class_rep import *
from PyQt5.QtWidgets import*
from PyQt5.QtGui import*
from PyQt5.QtCore import*
import sys
import sqlite3
rep = Repository('E:\Запросы польз/orders.db')
rep.cur.execute("""CREATE TABLE IF NOT EXISTS users(
id BIGINT,
login TEXT,
pasword TEXT,
age BIGINT);
""")
rep.cur.execute("""CREATE TABLE IF NOT EXISTS orders(
id BIGINT,
idbox BIGINT NOT NULL);
""")
rep.conn.commit()
class Main_WINDOW(QMainWindow):
def __init__(self):
super(Main_WINDOW, self).__init__()
self.setWindowTitle('Заметки')
self.setGeometry(10,30,1920,1080)
self.setStyleSheet('.Main_WINDOW {background-image: url(bg_pastel.jpg);}')
#self.hide_button()
self.spisok = []
self.button()
#def hide_button(self):
def registr(self):
# global summ
# global s_name
# global s_surname
# global s_gender
# global s_login
# global s_pasword
# global s_age
#spisok_name = []
spisok_gender = ['Мужской','Женский','Неопределён']
self.s_name, b_ok = QInputDialog.getText(self, 'Создание профиля', 'Введите своё Имя:')
if b_ok:
self.s_surname, b_ok = QInputDialog.getText(self, 'Создание профиля', 'Введите свою фамилию:')
if b_ok:
self.s_gender, b_ok = QInputDialog.getItem(self, 'Создание профиля', 'Введите свой Пол:', spisok_gender)
if b_ok:
self.s_login, b_ok = QInputDialog.getText(self, 'Создание профиля', 'Введите свой логин:')
if b_ok:
self.s_pasword, b_ok = QInputDialog.getText(self, 'Создание профиля', 'Пароль:')
if b_ok:
self.i_age, b_ok = QInputDialog.getInt(self, 'Создание профиля', 'Введите свой возраст:', 18, 14, 100, 1)
if b_ok:
a = 1
self.summ = a + 1
#spisok_name.append(s_surname)
#spisok_name.append(s_name)
#spisok_name.append(s_gender)
rep.cur.execute("""INSERT INTO users (id, login, pasword, age, name, surname, gender) VALUES (?, ?, ?, ?, ?, ?, ?)""", (self.summ, self.s_login, self.s_pasword, self.i_age, self.s_name, self.s_surname, self.s_gender))
#{'summ':summ},{'s_login':s_login},{'s_pasword':s_pasword},{'i_age':i_age})
rep.cur.execute("""INSERT INTO orders (id) VALUES (:summ);""",{'summ':self.summ})
QMessageBox.information(self, 'Создание профиля', 'Профиль успешно добавлен!')
self.btn_prof.show()
self.btn_registr.hide()
self.btn_vhod.hide()
rep.conn.commit()
rep.conn.close()
else:
QMessageBox.critical(self, 'Canceled', 'Вы нажали на "Cancel"')
else:
QMessageBox.critical(self, 'Canceled', 'Вы нажали на "Cancel"')
else:
QMessageBox.critical(self, 'Canceled', 'Вы нажали на "Cancel"')
else:
QMessageBox.critical(self, 'Canceled', 'Вы нажали на "Cancel"')
else:
QMessageBox.critical(self, 'Canceled', 'Вы нажали на "Cancel"')
else:
QMessageBox.critical(self, 'Canceled', 'Вы нажали на "Cancel"')
def button(self):
self.instr = QLabel('P a s t e s h o p', self)
self.instr.setGeometry(760, 50, 780, 60)
self.instr.setFont(QFont('Tekton Pro', 40, 29, False))
#########################################################
self.l_1 = QLabel(' ', self)
self.l_1.setGeometry(1200,100, 325, 325)
self.l_1.setStyleSheet('.QLabel {background-image: url(buy1.jpg);}')
self.l_2 = QLabel(' ', self)
self.l_2.setGeometry(1200, 510, 325, 325)
self.l_2.setStyleSheet('.QLabel {background-image: url(buy2.jpg);}')
self.l_3 = QLabel(' ', self)
self.l_3.setGeometry(400, 100, 325, 325)
self.l_3.setStyleSheet('.QLabel {background-image: url(buy3.jpg);}')
self.l_4 = QLabel(' ', self)
self.l_4.setGeometry(400, 510, 325, 325)
self.l_4.setStyleSheet('.QLabel {background-image: url(buy4.jpg);}')
#############################################################
self.l_text_1 = QLabel('С глиной 1000$', self)
self.l_text_1.setGeometry(1230,250, 325, 325)
self.l_text_1.setStyleSheet('.QLabel {font-size: 28pt;}')
self.l_text_2 = QLabel('С бананом 2р', self)
self.l_text_2.setGeometry(1240, 650, 325, 325)
self.l_text_2.setStyleSheet('.QLabel {font-size: 28pt;}')
self.l_text_3 = QLabel('С картошкой 100р', self)
self.l_text_3.setGeometry(410, 250, 325, 325)
self.l_text_3.setStyleSheet('.QLabel {font-size: 28pt;}')
self.l_text_4 = QLabel('С чурками 0,3р', self)
self.l_text_4.setGeometry(440, 650, 325, 325)
self.l_text_4.setStyleSheet('.QLabel {font-size: 28pt;}')
##############################################################
self.label_1 = QLabel(' Войдите или зарегистрируйтесь', self)
self.label_1.setStyleSheet(".QLabel {color: black; font-size: 20px; background-color: red}")
self.label_1.setGeometry(1200, 450, 340, 50)
self.label_2 = QLabel(' Войдите или зарегистрируйтесь', self)
self.label_2.setStyleSheet(".QLabel {color: black; font-size: 20px; background-color: red}")
self.label_2.setGeometry(1200, 860, 340, 50)
self.label_3 = QLabel(' Войдите или зарегистрируйтесь', self)
self.label_3.setStyleSheet(".QLabel {color: black; font-size: 20px; background-color: red}")
self.label_3.setGeometry(400, 450, 340, 50)
self.label_4 = QLabel(' Войдите или зарегистрируйтесь', self)
self.label_4.setStyleSheet(".QLabel {color: black; font-size: 20px; background-color: red}")
self.label_4.setGeometry(400, 860, 340, 50)
self.btn_1 = QPushButton('Добавить в корзину', self)
self.btn_1.setGeometry(1200, 450, 325, 40)
self.btn_1.setStyleSheet('.QPushButton {background-image: url(.jpg);background-color: green; color: white;}')
self.btn_1.setFont(QFont('Arial', 22, 23, False))
self.btn_1.hide()
#self.btn_1.clicked.connect(self.Add_corz)
self.btn_2 = QPushButton('Добавить в корзину', self)
self.btn_2.setGeometry(1200, 860, 325, 40)
self.btn_2.setStyleSheet('.QPushButton {background-image: url(.jpg);background-color: green; color: white;}')
self.btn_2.setFont(QFont('Arial', 22, 23, False))
self.btn_2.hide()
#self.btn_2.clicked.connect(self.Add_corz)
self.btn_3 = QPushButton('Добавить в корзину', self)
self.btn_3.setGeometry(400, 450, 325, 40)
self.btn_3.setStyleSheet('.QPushButton {background-image: url(.jpg);background-color: green; color: white;}')
self.btn_3.setFont(QFont('Arial', 22, 23, False))
self.btn_3.hide()
#self.btn_3.clicked.connect(self.Add_corz)
self.btn_4 = QPushButton('Добавить в корзину', self)
self.btn_4.setGeometry(400, 860, 325, 40)
self.btn_4.setStyleSheet('.QPushButton {background-image: url(.jpg);background-color: green; color: white;}')
self.btn_4.setFont(QFont('Arial', 22, 23, False))
self.btn_4.hide()
#self.btn_4.clicked.connect(self.Add_corz)
#################################################################
self.btn_corz = QPushButton('Корзина', self)
self.btn_corz.setGeometry(1640, 100, 250, 50)
self.btn_corz.setStyleSheet('.QPushButton {background-color: blue; color: white;}')
self.btn_corz.setFont(QFont('Balker', 22, 23, False))
self.btn_prof = QPushButton('Профиль', self)
self.btn_prof.setGeometry(1640, 40, 250, 40)
self.btn_prof.setStyleSheet('.QPushButton {background-color: blue; color: white;}')
self.btn_prof.setFont(QFont('Balker', 22, 23, False))
self.btn_prof.clicked.connect(self.show_window_2)
self.btn_prof.hide()
self.btn_registr = QPushButton('Регистрация', self)
self.btn_registr.setGeometry(1640, 40, 250, 40)
self.btn_registr.setStyleSheet('.QPushButton {background-color: red; color: white;}')
self.btn_registr.setFont(QFont('Balker', 22, 23, False))
self.btn_registr.clicked.connect(self.registr)
self.btn_vhod = QPushButton('Войти', self)
self.btn_vhod.setGeometry(1400, 40, 220, 40)
self.btn_vhod.setStyleSheet('.QPushButton {background-color: blue; color: white;}')
self.btn_vhod.setFont(QFont('Balker', 22, 23, True))
self.btn_vhod.clicked.connect(self.vhod)
def vhod(self, s_loginn):
self.s_loginn = s_loginn
s_loginn, b_ok = QInputDialog.getText(self, 'Вход в аккаунт', 'Введите свой логин:')
if b_ok:
self.spisok.append(s_loginn)
rep.cur.execute("""SELECT login FROM users WHERE login = (?)""", (s_loginn,))
if rep.cur.fetchone() is None:
QMessageBox.information(self, 'Вход в аккаунт', 'Неверный логин')
else:
s_paswordd, b_ok = QInputDialog.getText(self, 'Вход в аккаунт', 'Введите свой пароль:')
if b_ok:
rep.cur.execute("""SELECT login FROM users WHERE pasword = (?)""", (s_paswordd,))
if rep.cur.fetchone() is None:
QMessageBox.information(self, 'Вход в аккаунт', 'Неверный пароль')
else:
QMessageBox.information(self, 'Вход в аккаунт', 'Вы успешно зашли на аккаунт!')
rep.conn.commit()
rep.conn.close()
self.label_1.hide()
self.label_2.hide()
self.label_3.hide()
self.label_4.hide()
self.btn_1.show()
self.btn_2.show()
self.btn_3.show()
self.btn_4.show()
self.btn_prof.show()
self.btn_registr.hide()
self.btn_vhod.hide()
else:
QMessageBox.critical(self, 'Canceled', 'Вы нажали на "Cancel"')
else:
QMessageBox.critical(self, 'Canceled', 'Вы нажали на "Cancel"')
def show_window_2(self): # открытие 2 окна
self.App1 = QApplication([])
self.w2 = PROFIL_NEW()
self.w2.show()
self.App1.exec_()
class PROFIL_NEW(QMainWindow):
def __init__(self):
super(PROFIL_NEW, self).__init__()
self.setWindowTitle('Профиль')
self.setGeometry(100,100,1000,900)
self.setStyleSheet('.PROFIL_NEW {background-image: url(profil1.jpg);}')
self.profil_instruct()
def profil_instruct(self):
self.photo = QLabel('', self)
self.photo.setGeometry(60,60,320,300)
self.photo.setStyleSheet('.QLabel {background-image: url(photo_profil.jpg);}')
self.lp_name = QLabel('Name:', self)
self.lp_name.setStyleSheet('.QLabel {color: #00b77b}')
self.lp_name.setFont(QFont('Arial', 38, 1, True))
self.lp_name.setGeometry(60,400,300,100)
self.lp_Surname = QLabel('Surname:', self)
self.lp_Surname.setGeometry(60,510,300,100)
self.lp_Surname.setStyleSheet('.QLabel {color: #00b77b;}')
self.lp_Surname.setFont(QFont('Arial', 35, 1, True))
self.lp_Age = QLabel('Age:', self)
self.lp_Age.setGeometry(60,620,300,100)
self.lp_Age.setStyleSheet('.QLabel {color: #00b77b;}')
self.lp_Age.setFont(QFont('Arial', 38, 1, True))
self.lp_Gender = QLabel('Gender:', self)
self.lp_Gender.setGeometry(60,730,300,100)
self.lp_Gender.setStyleSheet('.QLabel {color: #00b77b;}')
self.lp_Gender.setFont(QFont('Arial', 38, 1, True))
self.lp_id = QLabel('id:', self)
self.lp_id.setGeometry(420,50,100,100)
self.lp_id.setStyleSheet('.QLabel {color: #00b77b;}')
self.lp_id.setFont(QFont('Arial', 39, 1, True))
self.lp_login = QLabel('login:', self)
self.lp_login.setGeometry(420,150,200,100)
self.lp_login.setStyleSheet('.QLabel {color: #00b77b;}')
self.lp_login.setFont(QFont('Arial', 37, 1, True))
self.lp_pasword = QLabel('pasword:', self)
self.lp_pasword.setGeometry(420,250,300,100)
self.lp_pasword.setStyleSheet('.QLabel {color: #00b77b;}')
self.lp_pasword.setFont(QFont('Arial', 32, 1, True))
rep.cur.execute("""SELECT id FROM users WHERE login = (?)""", (self.s_loginn,))
database_profil = []
database_profil.append(list(rep.cur.fetchone()))
start_name = ( " ".join( str(e) for e in database_profil )[1:-1])
self.dt_name = QLabel('', self)
self.dt_name.setText(start_name)
self.dt_name.setStyleSheet('.QLabel {color: #ff8412}')
self.dt_name.setFont(QFont('Arial', 30, 1, True))
self.dt_name.setGeometry(530,58,600,100)
database_profil.clear()
rep.cur.execute("""SELECT login FROM users WHERE login = (?)""", (self.s_loginn,))
database_profil = []
database_profil.append(list(rep.cur.fetchone()))
start_name = ( " ".join( str(e) for e in database_profil )[1:-1][1:-1])
self.dt_name = QLabel('', self)
self.dt_name.setText(start_name)
self.dt_name.setStyleSheet('.QLabel {color: #ff8412}')
self.dt_name.setFont(QFont('Arial', 30, 1, True))
self.dt_name.setGeometry(570,150,600,100)
database_profil.clear()
rep.cur.execute("""SELECT pasword FROM users WHERE login = (?)""", (self.s_loginn,))
database_profil = []
database_profil.append(list(rep.cur.fetchone()))
start_name = ( " ".join( str(e) for e in database_profil )[1:-1][1:-1])
self.dt_name = QLabel('', self)
self.dt_name.setText(start_name)
self.dt_name.setStyleSheet('.QLabel {color: #ff8412}')
self.dt_name.setFont(QFont('Arial', 30, 1, True))
self.dt_name.setGeometry(620,255,600,100)
database_profil.clear()
rep.cur.execute("""SELECT name FROM users WHERE login = (?)""", (self.s_loginn,))
database_profil = []
database_profil.append(list(rep.cur.fetchone()))
start_name = ( " ".join( str(e) for e in database_profil )[1:-1][1:-1])
self.dt_name = QLabel('', self)
self.dt_name.setText(start_name)
self.dt_name.setStyleSheet('.QLabel {color: #ff8412}')
self.dt_name.setFont(QFont('Arial', 30, 1, True))
self.dt_name.setGeometry(250,405,600,100)
database_profil.clear()
rep.cur.execute("""SELECT surname FROM users WHERE login = (?)""", (self.s_loginn,))
database_profil.append(list(rep.cur.fetchone()))
start_name = ( " ".join( str(e) for e in database_profil )[1:-1][1:-1])
self.dt_surname = QLabel('', self)
self.dt_surname.setText(start_name)
self.dt_surname.setStyleSheet('.QLabel {color: #ff8412}')
self.dt_surname.setFont(QFont('Arial', 30, 1, True))
self.dt_surname.setGeometry(300,510,600,100)
database_profil.clear()
rep.cur.execute("""SELECT age FROM users WHERE login = (?)""", (self.s_loginn,))
database_profil.append(list(rep.cur.fetchone()))
start_name = ( " ".join( str(e) for e in database_profil )[1:-1])
self.dt_surname = QLabel('', self)
self.dt_surname.setText(start_name)
self.dt_surname.setStyleSheet('.QLabel {color: #ff8412}')
self.dt_surname.setFont(QFont('Arial', 30, 1, True))
self.dt_surname.setGeometry(240,625,600,100)
database_profil.clear()
rep.cur.execute("""SELECT gender FROM users WHERE login = (?)""", (self.s_loginn,))
database_profil.append(list(rep.cur.fetchone()))
start_name = ( " ".join( str(e) for e in database_profil )[1:-1][1:-1])
self.dt_surname = QLabel('', self)
self.dt_surname.setText(start_name)
self.dt_surname.setStyleSheet('.QLabel {color: #ff8412}')
self.dt_surname.setFont(QFont('Arial', 30, 1, True))
self.dt_surname.setGeometry(290,735,600,100)
database_profil.clear()
if __name__ == '__main__':
App = QApplication([])
w = Main_WINDOW()
w.show()
App.exec_()