HYTOS

                        cursor.execute(sql)

                    for titleBlockProp in titleBlockProps:

                        cursor.execute(sql, param)

                    conn.commit()

                    # Catch the exception

                    # Get a cursor object

                    cursor = conn.cursor()

                    cursor.execute(sql)

                    rows = cursor.fetchall()

                    for row in rows:

                        attr.append(row[0])  # uid

                        attr.append(row[1])  # name

                        attr.append(row[2])  # area

                        self._titleBlockProperties.append(attr)

                    res = self._titleBlockProperties

                    params.append(svg_blob_data)

                image_display_blob_data = None

                    with open(image_file, 'rb') as file:

                        image_display_blob_data = file.read()

                    cols.append('Image_display=?')

                sql = "delete from LINE_DATA_LIST where PNID_NO = '{}'".format(drawing_name)

                cursor.execute(sql)

                cursor.execute(sql)

                # delete LineNoAttributes

        try:

            appDocData = AppDocData.instance()

            items = appDocData.allItems

            titleBlockItems = []

            for item in items:

                if type(item) is QEngineeringTextItem:

                    for titleBlockProp in titleBlockProps:

                        if item.area == titleBlockProp[0]:

                            titleBlockItems.append(item)

            db_items = [item for item in items if issubclass(type(item), QEngineeringAbstractItem) and type(

                item) is not QGraphicsBoundingBoxItem and type(item) is not QEngineeringErrorItem and type(

                item) is not QEngineeringLineNoTextItem]

            db_items.extend([item for item in items if type(item) is QEngineeringLineNoTextItem])

            db_items.extend([line for line in appDocData.tracerLineNos if type(line) is QEngineeringTrimLineNoTextItem])

            appDocData.saveToDatabase(db_items, self.show_progress)

            self.resultStr = SaveWorkCommand.save_to_xml()

        for index in range(self.ui.tableWidgetEquipmentDescArea.columnCount()):

            self.ui.tableWidgetEquipmentDescArea.horizontalHeaderItem(0).setSizeHint(QSize(25, 25))

            self.ui.tableWidgetEquipmentDescArea.setColumnWidth(index, len(self.ui.tableWidgetEquipmentDescArea.horizontalHeaderItem(index).text()) * 8 + 10)

        for index in range(self.ui.tableWidgetTitleBlockArea.columnCount()):

            self.ui.tableWidgetTitleBlockArea.horizontalHeaderItem(0).setSizeHint(QSize(25, 25))

            self.ui.tableWidgetTitleBlockArea.setColumnWidth(index, len(self.ui.tableWidgetTitleBlockArea.horizontalHeaderItem(index).text()) * 8 + 10)

            item.setFlags(Qt.ItemIsEnabled)

            item.tag = boundingBox

            self.ui.tableWidgetTitleBlockArea.setItem(row, 2, item)

            row += 1

        section = '{} Equipment Desc Area'.format(docData.imgName)

            item.setFlags(Qt.ItemIsEnabled)

            item.tag = boundingBox

            self.ui.tableWidgetTitleBlockArea.setItem(row, 2, item)

            self.ui.tableWidgetTitleBlockArea.resizeColumnsToContents()

            # up to here

        elif self._cmd.tag is self.ui.lineEditTypicalArea:

            x, y = round(x), round(y)

            titleBlockProps = []

            for row in range(self.ui.tableWidgetTitleBlockArea.rowCount()):

                if self.ui.tableWidgetTitleBlockArea.item(row, 1).text() != '':

                self.removeArea(self.ui.tableWidgetTitleBlockArea.item(row, 2).tag)

            docData.updateTitleBlockProperties(titleBlockProps)

        '''

        try:

            appDocData = AppDocData.instance()

            titleBlockProps = appDocData.getTitleBlockProperties()

            titleBlockItems = []

            for item in items:

                # if type(item) is QEngineeringLineNoTextItem:

                    for titleBlockProp in titleBlockProps:

                        if item.area == titleBlockProp[0]:

                            titleBlockItems.append(item)

            # unknown item is not saved now for performance

            db_items = [item for item in items if issubclass(type(item), QEngineeringAbstractItem) and type(

                      NOT NULL,

    NAME VARCHAR(32)         NOT NULL

                      UNIQUE,

);

CREATE TABLE TitleBlockValues (