HYTOS

    def check_runs(self):

        """ check run item duplication """

        with self.project.database.connect() as conn:

            try:

                # Get a cursor object

                cursor = conn.cursor()

                sql = "select [Components_UID], count([Components_UID]) as count from [PipeRunItems] " \

                      "group by [Components_UID] having count([Components_UID]) > 1"

                cursor.execute(sql)

                rows = cursor.fetchall()

                items = []

                if rows:

                    for row in rows:

                        sql = "select c.[UID], d.[Name] from [Components] c inner join [Drawings] d on c.Drawings_UID=d.[UID]" \

                              "where c.[UID]='" + row["Components_UID"] + "'"

                        cursor.execute(sql)

                        _rows = cursor.fetchall()

                        if _rows:

                            items = items + _rows

                return items

                # Catch the exception

            except Exception as ex:

                from App import App

                message = 'error occurred({}) in {}:{}'.format(ex, sys.exc_info()[-1].tb_frame.f_code.co_filename,

                                                              sys.exc_info()[-1].tb_lineno)

                App.mainWnd().addMessage.emit(MessageType.Error, message)

        error_items = app_doc_data.check_runs()

        if error_items:

            self.error = True

            msg = ""

            for error_item in error_items:

                msg += 'UID : ' + error_item["UID"] + '\nDrawing : ' + error_item["Name"] + ',\n'

            QMessageBox.warning(self, self.tr('Warning'), 'Please check following items.\n' + msg)

            return