HYTOS

    def getDocumentNameList(self):

        '''

            @brief      get documentName list

            @author     euisung

            @date       2018.12.11

        '''

        result = []

        try:

            # Creates or opens a file called mydb with a SQLite3 DB

            dbPath = os.path.join(self.getCurrentProject().getDbFilePath(), 'ITI_PID.db')

            conn = sqlite3.connect(dbPath)

            # Get a cursor object

            cursor = conn.cursor()

            sql = 'select DISTINCT(PNID_NO) from LINE_DATA_LIST'

            cursor.execute(sql)

            sql = 'select DISTINCT(PNID_NO) from EQUIPMENT_DATA_LIST'

            cursor.execute(sql)

            sql = 'select DISTINCT(PNID_NO) from INSTRUMENT_DATA_LIST'

            cursor.execute(sql)

            sql = 'select DISTINCT(PNID_NO) from NOTE_DATA_LIST'

            cursor.execute(sql)

            sql = 'select DISTINCT(PNID_NO) from VALVE_DATA_LIST'

            cursor.execute(sql)

            rows = cursor.fetchall()

            for row in rows:

                result.append(row[0])

            result = list(set(result))

            result.sort()

        # Catch the exception

        except Exception as ex:

            # Roll back any change if something goes wrong

            conn.rollback()

            print('error occured({}) in {}:{}'.format(ex, sys.exc_info()[-1].tb_frame.f_code.co_filename, sys.exc_info()[-1].tb_lineno))

        finally:

            # Close the db connection

            conn.close()

        return result

        documentNameData = docData.getDocumentNameList()