HYTOS

                    """save hmb data catalog""" 

                    for data in hmb_list[0].datas[0]:

                        sql = f"insert into HMB_LIST(UID, Name, Unit, [index], [Type]) values(?,?,?,?,?)"

                        list_uid = str(uuid.uuid4())

                        params = (list_uid, data.name, data.unit, data.index, data.phase)

                        list_uids.append(list_uid)

                for hmb in hmb_list:

                    """stream no save"""

                    sql = f'insert into Stream_No(UID, Stream_No, [From], [To]) values(?,?,?,?)'

                    hmb.uid = hmb.uid if hmb.uid else str(uuid.uuid4())

                    params = (str(hmb.uid), hmb.stream_no, hmb.hfrom, hmb.hto)

                    cursor.execute(sql, params)

                cursor = conn.cursor()

                """delete stream line which has stream number is given data"""

                sql = "delete from HMB_From_To where Stream_No=?"

                params = (stream_line_list[0],)

                cursor.execute(sql, params)

                """up to here"""

                for stream_line in stream_line_list[1]:

                    sql = f"insert into HMB_From_To(UID,[Drawing_UID],[From_Component_UID],[To_Component_UID],[Stream_No],[Case]) values" \

                          f"(?,?,?,?,?,?)"

                    params = (str(uuid.uuid4()), stream_line[0], stream_line[1], stream_line[2], stream_line[3], stream_line[4])

                    cursor.execute(sql, params)

            except Exception as ex:

                for model_data in self._streamLineListModelDatas:

                    sql = f"insert into Stream_Line_List (UID, Drawing_UID, PnIDNumber, Tag_Seq_No, PipingMaterialsClass, InsulationPurpose, FluidCode, " \

                          f"UnitNumber, NominalDiameter, [From], [To], Stream_No, [Case], [Index]) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?)"

                    params = (str(uuid.uuid4()), drawing_uid, model_data['PnIDNumber'], model_data['Tag Seq No'], model_data['PipingMaterialsClass'], model_data['InsulationPurpose'], \

                              model_data['FluidCode'], model_data['UnitNumber'], model_data['NominalDiameter'], model_data['FROM'], model_data['TO'], model_data['Stream No'], model_data['Case'], index)

                    cursor.execute(sql, params)