pydev debugger: starting (pid: 7401)
/home/user/data01/Code/Python/mySqlFileLoader/mySqlFileLoader/modules/tests/fileReader.py:15: 
ResourceWarning: unclosed file <_io.TextIOWrapper name='../../settings/queries/test_query.txt' mode='r' encoding='UTF-8'>
  actual = self.qreader.readQuery()
.
----------------------------------------------------------------------
Ran 1 test in 0.004s

OK

class QueryFileReader():

    def __init__(self, query_file):
        self.query_file = query_file
        
    def readQuery(self):
        query = ""
        try:
            f = open(self.query_file, 'r')
        except FileNotFoundError:
            print('File does not exist: ', self.query_file)
            return
        except:
            print('error has occured while opening ', self.query_file)
            return
        else:         
            for line in f:
                query = query + " " + line
            f.close
            return(query) 

import unittest
from mySqlFileLoader.modules.fileReader import QueryFileReader

class TestQueryFileReader(unittest.TestCase):
    
    def test_QueryFileReader_readQuery_ok(self):
        self.qreader = QueryFileReader('../../settings/queries/test_query.txt')
        actual = self.qreader.readQuery()
        expected = " /* Test file: */\n /* for testing filereader script */"
        self.assertEqual(actual, expected, "The query text is not as expected.")

        
if __name__ == '__main__':
    unittest.main() 

class QueryFileReader():

    def __init__(self, query_file):
        self.query_file = query_file
    
        
    def readQuery(self):          
        try:
            f = open(self.query_file, 'r')
            query = f.read()
            f.close()
            return( query )
        except FileNotFoundError:
            print( 'File {} does not exist: '.format(self.query_file) )
            return
        except:
            print('error has occured while opening {} '.format(self.query_file) )
            return

class QueryFileReader():
    """
    class QueryFileReader
        properties:
           query_file: location of query file
        methods:
            readQuery(): reads query file into string
    """
    def __init__(self, query_file):
        self.query_file = query_file
    
        
    def readQuery(self):   
        file=None       
        try:
            file = open(self.query_file, 'r')
            query = file.read()
        
        except FileNotFoundError:
            print( 'File {} does not exist: '.format(self.query_file) )
            return
        
        except UnicodeDecodeError:
            print('The contents of the file were in an unknown encoding.')
            return 0
        
        except:
            import sys
            e = sys.exc_info()
            print('error has occured while opening {} '.format(self.query_file) )
            print('Error type:', e[0])
            print('Error message:', e[1])
            print('Error traceback: ', e[2])
            return
        
        else:
            return(query)
        
        finally:
            if file:
                file.close()