Заполнение данных в бд

    def register(self):
        firstname = self.FirstName.text()
        lastname = self.LastName.text()
        email = self.Email.text()
        password = self.Password.text()
        confirmpassword = self.ConfirmPassword.text()
 
        #Проверка пароля
        regex = r'\b[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Z|a-z]{2,7}\b'
        count_digit = 0
        count_upper = 0
        count_spec=0
        spec_simvol = '!@#$%&'
        for s in password:
            if s.isdigit():
                count_digit += 1
            if s.isupper():
                count_upper+=1
            if s in spec_simvol:
                count_spec+=1
        if count_digit >= 3 and count_upper > 0 and count_spec > 0 and len(password) >= 6 and len(password) <= 20 and len(firstname) > 0 and len(email)>0:
            coursor.execute('INSERT INTO  users VALUES(?,?,?,?,?,?);',(firstname, lastname, email, password, confirmpassword,None))
            result_pass = coursor.fetchone()
            if not result_pass:
                self.abouttheprogram = AboutTheProgram()
                self.abouttheprogram.show()
                self.hide()
            db.commit()

        if count_digit >= 3 and count_upper > 0 and count_spec > 0 and len(password) >= 6 and len(password) <= 20 and len(firstname) > 0 and len(email)>0:
            coursor.execute('INSERT INTO  users VALUES(?,?,?,?,?,?);', (firstname, lastname, email, password, confirmpassword,None))
            self.abouttheprogram = AboutTheProgram()
            self.abouttheprogram.show()
            self.hide()
            db.commit()