layout_csvviewpushtoloadwidget.py

import csv, codecs # base python, no pip install needed
import os # base python, no pip install needed
 
from PyQt5 import QtCore, QtGui, QtWidgets, QtPrintSupport 
from PyQt5.QtGui import QImage, QPainter
from PyQt5.QtCore import QFile, Qt

import sys # base python, no pip install needed

from PyQt5.QtWidgets import QDialog, QApplication, QFileDialog
from PyQt5.uic import loadUi

from pathlib import Path # base python, no pip install needed

from healdata_utils.cli import convert_to_vlmd

#from frictionless import plugins # frictionless already installed as a healdata_utils dependency, no pip install needed
#from frictionless.plugins import remote
#from frictionless import describe

import pandas as pd # pandas already installed as a healdata_utils dependency, no pip install needed
import json # base python, no pip install needed
import pipe

import dsc_pkg_utils # local module, no pip install needed
#from layout_csveditwidget import CSVEditWindow
from layout_csvviewwidget import CSVViewWindow

class CSVViewPushToLoadWindow(QtWidgets.QMainWindow):

    def __init__(self, workingDataPkgDirDisplay, fileBaseName, fileStartsWith, fileTypeTitle):
        super().__init__()
        self.w = None  # No external window yet.
        self.workingDataPkgDirDisplay = workingDataPkgDirDisplay
        self.fileBaseName = fileBaseName
        self.fileStartsWith = fileStartsWith
        self.fileTypeTitle = fileTypeTitle
        
        widget = QtWidgets.QWidget()

        buttonText = "View CSV"
        if self.fileTypeTitle:
            buttonText = "View " + self.fileTypeTitle 
        
        self.buttonViewCsv = QtWidgets.QPushButton(text=buttonText, parent=self)
        self.buttonViewCsv.clicked.connect(self.view_csv)
        

        # maybe switch Line edit to this: https://doc.qt.io/qtforpython-5/PySide2/QtWidgets/QPlainTextEdit.html#more
        #self.userMessageBox = QtWidgets.QLineEdit(parent=self)
        self.userMessageBox = QtWidgets.QTextEdit(parent=self)
        self.userMessageBox.setReadOnly(True)
        
        layout = QtWidgets.QVBoxLayout()
        layout.addWidget(self.buttonViewCsv)
        layout.addWidget(self.userMessageBox)

        widget.setLayout(layout)
        self.setCentralWidget(widget)

    
    def view_csv(self,checked):

        # check if user has set a working data package dir - if not exit gracefully with informative message
        if not dsc_pkg_utils.getWorkingDataPkgDir(self=self):
            return

        if self.fileBaseName:
            self.fileName = os.path.join(self.workingDataPkgDir,self.fileBaseName)

            # check that file exists in working data pkg dir, if not, return
            if not os.path.exists(self.fileName):
                messageText = "<br>There is no " + self.fileTypeTitle + " file in your working Data Package Directory; Your working Data Package Directory must contain a " + self.fileTypeTitle + " file to proceed - The file should be named: " + self.fileBaseName + ". If you need to change your working Data Package Directory or create a new one, head to the \"Data Package\" tab >> \"Create or Continue Data Package\" sub-tab to set a new working Data Package Directory or create a new one. <br><br>"
                saveFormat = '<span style="color:red;">{}</span>'
                self.userMessageBox.append(saveFormat.format(messageText))
                return
            
            # check that file is closed (user doesn't have it open in excel for example)
            try: 
                with open(self.fileName,'r+') as f:
                    print("file is closed, proceed!!")
            except PermissionError:
                    messageText = "<br>The " + self.fileTypeTitle + " file in your working Data Package Directory is open in another application, and must be closed to proceed; Check if the " + self.fileTypeTitle + " file is open in Excel or similar application, close the file, and try again. <br><br>"
                    saveFormat = '<span style="color:red;">{}</span>'
                    self.userMessageBox.append(saveFormat.format(messageText))
                    return


        else:
            self.fileName = self.workingDataPkgDir

            # check that all at least one of the desired file types exist to view and that all files of that type are closed (user doesn't have it open in excel for example)
            trackersList = [filename for filename in os.listdir(self.workingDataPkgDir) if filename.startswith(self.fileStartsWith)]
            print("trackersList: ", trackersList)
            
            if trackersList:
                for tracker in trackersList:

                    try: 
                        with open(os.path.join(self.workingDataPkgDir,tracker),'r+') as f:
                            print("file is closed, proceed!!")
                    except PermissionError:
                            messageText = "<br>At least one " + self.fileTypeTitle + " file that already exists in your working Data Package Directory is open in another application, and must be closed to proceed; Check if any " + self.fileTypeTitle + " files are open in Excel or similar application, close the file(s), and try again. <br><br>"
                            saveFormat = '<span style="color:red;">{}</span>'
                            self.userMessageBox.append(saveFormat.format(messageText))
                            return
            else: 
                messageText = "<br>There are no " + self.fileTypeTitle + " files in your working Data Package Directory to view. There must be at least one " + self.fileTypeTitle + " file in your working Data Package Directory in order to proceed to view a file of this type. Files of this type should have a file name that starts with: " + self.fileStartsWith + ".<br><br>"
                saveFormat = '<span style="color:red;">{}</span>'
                self.userMessageBox.append(saveFormat.format(messageText))
                return





        if self.w is None:
            self.w = CSVViewWindow(fileName=self.fileName,fileStartsWith=self.fileStartsWith,fileTypeTitle=self.fileTypeTitle)
            self.w.show()

        else:
            self.w.close()  # Close window.
            self.w = None  # Discard reference.

if __name__ == "__main__":
    
    #app = QtWidgets.QApplication(sys.argv)

    #app.exec_()

    app = QtWidgets.QApplication(sys.argv)
    window = CSVViewPushToLoadWindow()
    window.show()
    sys.exit(app.exec_())