Imported module returns to main module unexpectedly

q&a
1

I import a module expecting the imported module to handle some database maintenance based on variables passed from the main menu and display a customer maintenance window. The imported menu does not display the window. It executes the print up to line #36 (just before the class CM statement) but not the print on line #43 (just before the show() statement) nor any others before returning to the main module.

Below is the code for the imported module.

import os
import sys
import sqlite3 
import PySide6
import passed

print("Customer Maint Execution has begun")
#QUiLoader allows screen created in QT Designer to be loaded
from PySide6.QtUiTools import QUiLoader
from PySide6.QtCore import QSize
from PySide6.QtSql import QSqlDatabase, QSqlQuery, QSqlQueryModel
from PySide6.QtWidgets import (
    QApplication,
    QComboBox,
    QDataWidgetMapper,
    QDoubleSpinBox,
    QFormLayout,
    QLabel,
    QLineEdit,
    QMainWindow,
    QSpinBox,
    QWidget,
    )
print("passed.action = ", passed.action)
print("passed.cust_code = ", passed.cust_code)

loader = QUiLoader()
basedir = os.path.dirname(__file__)
print("Defining Widget")
class CM(QWidget):
    def __init__(self):
        super().__init__()
        self.cust_maint = loader.load(
            os.path.join(basedir, "windows/cust_maint.ui"), None
        )
        print("cust_maint show about to be executed")
        self.cust_maint.show()
        print("cust_maint show executed")
        self.cust_maint.setWindowTitle("Integrity Customer Maintenance")
        self.db = QSqlDatabase("QSQLITE")
        self.db.setDatabaseName(os.path.join(basedir, "databases/integrity.db"))
        self.db.open()
        self.connection_obj = sqlite3.connect('databases/integrity.db')
        self.cursor_obj = self.connection_obj.cursor()
        self.cursor_obj.execute('SELECT * FROM customer WHERE cust_code = ?', (main_menu(sys_cust_code,)))
        self.customer_rec = self.cursor_obj.fetchone()  # holds data from customer database
        self.code = self.customer_rec[0]
        self.name = self.customer_rec[1]
        self.bill_street1 = self.customer_rec[2]
        self.bill_street2 = self.customer_rec[3]
        self.bill_city = self.customer_rec[4]
        self.bill_state = self.customer_rec[5]
        self.bill_zip = self.customer_rec[6]
        print ("Key = ",self.sys_cust_code)
        print(self.customer_rec)
        print("")
        print("Printing Individual Fields")
        x=0
        while x < 16:
            print("Field", x,"Code = ", self.customer_rec[x])
            x=x+1
        self.cust_maint.code
        #self.cust_maint.code.setText(f'{self.code}: {self.name}')
        self.cust_maint.code.setText(f'{self.customer_rec [0]}')
        self.cust_maint.name.setText(f'{self.customer_rec[1]}')
        self.cust_maint.bill_street_1.setText(f'{self.customer_rec[2]}')
        self.cust_maint.bill_street_2.setText(f'{self.customer_rec[3]}')
        self.cust_maint.bill_city.setText(f'{self.customer_rec[4]}')
        self.cust_maint.bill_state.setText(f'{self.customer_rec[5]}')
        self.cust_maint.bill_zip.setText(f'{self.customer_rec[6]}')
        self.cust_maint.bill_zip_plus.setText(f'{self.customer_rec[7]}')
        self.cust_maint.ship_street_1.setText(f'{self.customer_rec[8]}')
        self.cust_maint.ship_street_2.setText(f'{self.customer_rec[9]}')
        self.cust_maint.ship_city.setText(f'{self.customer_rec[10]}')
        self.cust_maint.ship_state.setText(f'{self.customer_rec[11]}')
        self.cust_maint.ship_zip.setText(f'{self.customer_rec[12]}')
        self.cust_maint.ship_zip_plus.setText(f'{self.customer_rec[13]}')
        self.cust_maint.last_order.setText(f'{self.customer_rec[14]}')
        self.cust_maint.terms.setText(f'{self.customer_rec[15]}')
        mu = int(self.customer_rec[16])
        print('Type = ',type(mu))
        self.cust_maint.mark_up.setValue(mu)
        self.cust_maint.show()