HYTOS

                sql = "delete from Components where Drawings_UID='{}'".format(drawing_uid)

                cursor.execute(sql)

                for item in items:

                    if type(sql) is list:

                        for item in sql:

                            if item is not None and 2 == len(item):

                    self.progress.show()

                    ## Load data on xml

                    path = os.path.join(appDocData.getCurrentProject().getTempPath(), appDocData.imgName + '.xml')

                        self.loadRecognitionResultFromXml(path)

                    else:

                        self.load_drawing(appDocData.activeDrawing)

        return node 

        """ convert equipment data to sql query """

        from AppDocData import AppDocData

        res = []

        appDocData = AppDocData.instance()

            for assoc in self.associations():

                param = [str(uuid.uuid4()), QEngineeringAbstractItem.assoc_type(assoc), str(self.uid), str(assoc.uid)]

                sql = 'insert into Associations({}) values({})'.format(','.join(cols), ','.join(values))

        # save connectors to database

        if self.connectors:

                    str(connector._connected_at))\

                        )

            sql = 'insert into Points({}) values({})'.format(','.join(cols), ','.join(values))

        # up to here

    '''

        @brief      return equip Data List

        except Exception as ex:

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

        """ convert instrument data to sql query """

        import uuid

        from AppDocData import AppDocData

        res = []

        appDocData = AppDocData.instance()

        cols = ['UID', 'PNID_NO']

            for assoc in self.associations():

                params.append((str(uuid.uuid4()), QEngineeringAbstractItem.assoc_type(assoc), str(self.uid), str(assoc.uid)))

            sql = 'insert into Associations({}) values({})'.format(','.join(cols), ','.join(values))

        # save connectors to database

        if self.connectors:

                        )

                index += 1

            sql = 'insert into Points({}) values({})'.format(','.join(cols), ','.join(values))

        # up to here

    '''

        @brief      return inst Data List

        return node

        """ generate sql phrase to save line to database """

        import uuid

        from AppDocData import AppDocData

        res = []

        app_doc_data = AppDocData.instance()

        cols = ['UID', 'Drawings_UID', 'Symbol_UID', 'X', 'Y', 'Width', 'Height', 'Rotation', 'Area', 'Owner', 'SpecialItemTypes_UID']

                str(connector._connected_at)))

            index += 1

        sql = 'insert into Points({}) values({})'.format(','.join(cols), ','.join(values))

        # up to here

        # save attributes

        res.append((sql, tuple(param)))

        # up to here

    '''

        @brief      Delete Line Item from scene

        return _attrs

    '''

        """ convert valve data to sql query """

        import uuid

        from AppDocData import AppDocData

        res = []

        appDocData = AppDocData.instance()

        cols = ['UID', 'ITEM_NO', 'PNID_NO', 'MainSize', 'SubSize']

                        )

                index += 1

            sql = 'insert into Points({}) values({})'.format(','.join(cols), ','.join(values))

        # up to here

    '''

    def __init__(self, path, uid=None, flip=0):

        from SymbolAttr import SymbolProp

        SymbolSvgItem.__init__(self, path, uid, flip=flip)

        attr = SymbolAttr()

        attr.Attribute = 'UpStream'

        attr.AttributeType = 'Comp Item'

        attr.Attribute = 'DownStream'

        attr.AttributeType = 'Comp Item'

        self.attrs[attr] = None

        self._properties = \

            {\

        return node 

        """ convert unknown data to sql query """

        import uuid

        from AppDocData import AppDocData

        res = []

        appDocData = AppDocData.instance()

        cols = ['UID', 'Drawings_UID', 'Symbol_UID', 'X', 'Y', 'Width', 'Height', 'Area']

            str(self.uid), index, pt.x(), pt.y()))

            index += 1

        sql = 'insert into Points({}) values({})'.format(','.join(cols), ','.join(values))

        # save attributes

        cols = ['UID', 'Components_UID', 'SymbolAttribute_UID', 'Value']

        res.append((sql, tuple(param)))

        # up to here

    '''

        @brief      Delete from Scene

        return vendorItem

        """ convert vendor package data to sql query """

        import uuid

        res = []

        app_doc_data = AppDocData.instance()

        cols = ['UID', 'Drawings_UID', 'Symbol_UID', 'X', 'Y', 'Width', 'Height', 'Rotation', 'Area', 'Owner', 'SpecialItemTypes_UID']

            params.append((#str(uuid.uuid4()),

            str(self.uid), index, point[0], point[1]))

        sql = 'insert or replace into Points({}) values({})'.format(','.join(cols), ','.join(values))

        # up to here

    @staticmethod 

    def fromXml(node):

        return super().itemChange(change, value)

        """ convert valve data to sql query """

        import uuid

        from AppDocData import AppDocData

        res = []

        appDocData = AppDocData.instance()

        cols = ['UID', 'ITEM_NO', 'MainSize', 'SubSize', 'PNID_NO']

            for assoc in self.associations():

                params.append((str(uuid.uuid4()), QEngineeringAbstractItem.assoc_type(assoc), str(self.uid), str(assoc.uid)))

            sql = 'insert into Associations({}) values({})'.format(','.join(cols), ','.join(values))

        # save connectors to database

        if self.connectors:

                        )

                index += 1

            sql = 'insert into Points({}) values({})'.format(','.join(cols), ','.join(values))

        # up to here

    '''

        @brief  build symbol item

        '''

        propertyComboBox = QComboBox(self)

        attrs = AppDocData.instance().getSymbolAttribute('Segment Breaks')

            propertyComboBox.addItem(attr.DisplayAttribute)   

        #propertyComboBox.addItem('NominalDiameter')

        #propertyComboBox.addItem('FluidCode')