Test your AI Agents with the all-new Agent to Agent Testing Platform.Learn More

How to use reportOutput method in fMBT

Best Python code snippet using fMBT_python

Lupin_general_validations.py

Source:Lupin_general_validations.py

1import pyodbc2from shutil import ReadError3defaultchannels = ['Commercial w/o Managed Medicaid', 'Managed Medicaid']4defaultRegions = ['43000', '44000', '99000']5cnxnto15Db = pyodbc.connect(6    'DRIVER={SQL Server Native Client 10.0};SERVER=10.0.0.15;PORT=1433;DATABASE=Reports_DB;UID=m1bqc;PWD=m1b0813')7cnxnto36Db = pyodbc.connect(8    'DRIVER={SQL Server Native Client 10.0};SERVER=10.0.0.36;PORT=1433;DATABASE=M1B_LupRx;UID=m1bqc;PWD=m1bqc@0813')9cursor = cnxnto15Db.cursor()10cursorOn36Db = cnxnto36Db.cursor()11Suprax_TRX_drugs = ['cefdinir', 'Suprax']12WomensHealthCare_TQTY_drugs = ['Cleocin Vaginal', 'Cleocin Vaginal Ovules', 'clindamycin phosphate vaginal cream',13                               'Clindesse', 'Flagyl', 'Metrogel-Vaginal', 'metronidazole', 'metronidazole vaginal',14                               'Nuvessa', 'Solosec', 'Tindamax', 'tinidazole']15ReportOutput = []16RAWDbOutputSupraxCapTabManagedMedicaid = []17RAWDbOutputSupraxCapTabcommercialwithoutManagedMedicaid = []18RAWDBMattyWomensHealthcarecommercialwithoutManagedMedicaid = []19RAWDBMattyWomensHealthcare_Managed_Medicaid = []20def CheckRegions_For_Report():21    regionQuery1 = "SELECT DISTINCT Region FROM LupinAllPrescribersReportData"22    regionQueryoutput = cursor.execute(regionQuery1)23    region = regionQueryoutput.fetchall()24    regionlist = []25    for i in range(list(region).__len__()):26        regionlist.append(tuple(region[i]).__getitem__(0))27        Missing_Regions_IN_All_PrescriberReport = set(regionlist) - set(defaultRegions)28        if (Missing_Regions_IN_All_PrescriberReport.__len__()) == 0:29            print("The region is matching aganist The Requiement")30        else:31            print("The region is not matching against The Reqirement")32            print(Missing_Regions_IN_All_PrescriberReport)33    return Missing_Regions_IN_All_PrescriberReport.__len__()34####  Checking Channel for Suprax _TRX  ######35def Channels_Suprax_TRX():36    Channels_Suprax_TRX_query = "Select DISTINCT CHANNEL [Suprax_TRX] FROM LupinAllPrescribersReportData Where REPORT_NO =3"37    Channels_Suprax_TRX_query_output = cursor.execute(Channels_Suprax_TRX_query)38    Suprax_TRX_ReportChannel = Channels_Suprax_TRX_query_output.fetchall()39    Suprax_TRX_ReportChannel_list1 = []40    #print(ReportChannel)41    for i in range(list(Suprax_TRX_ReportChannel).__len__()):42        Suprax_TRX_ReportChannel_list1.append(tuple(Suprax_TRX_ReportChannel[i]).__getitem__(0))43        Missing_Channels_IN_Suprax_TRX = set(Suprax_TRX_ReportChannel_list1) - set(defaultchannels)44    ##print(res)45    if(Missing_Channels_IN_Suprax_TRX.__len__())==0:46        print("The Channel is matching aganist The Requiement")47    else:48        print("The Channel is not matching against The Reqirement")49    return Missing_Channels_IN_Suprax_TRX.__len__()50####  Checking Channel for WomensHealthCare_TQTY  ######51def Channels_WomensHealthCare_TQTY():52    Channels_WomensHealthCare_TQTY_query1 = "Select DISTINCT CHANNEL [Antara NRX] FROM LupinAllPrescribersReportData Where REPORT_NO =4"53    Channels_WomensHealthCare_TQTY_output1 = cursor.execute(Channels_WomensHealthCare_TQTY_query1)54    WomensHealthCare_TQTY_ReportChannel = Channels_WomensHealthCare_TQTY_output1.fetchall()55    WomensHealthCare_TQTY_list1 = []56    # print(ReportChannel)57    for i in range(list(WomensHealthCare_TQTY_ReportChannel).__len__()):58        WomensHealthCare_TQTY_list1.append(tuple(WomensHealthCare_TQTY_ReportChannel[i]).__getitem__(0))59    Missing_Chhanels_InWomensHealthCare_TQTY = set(WomensHealthCare_TQTY_list1) - set(defaultchannels)60    ##print(Missing_Chhanels_InWomensHealthCare_TQTY)61    if(Missing_Chhanels_InWomensHealthCare_TQTY.__len__())==0:62        print("The Channel is matching aganist The Requiement")63    else:64        print("The Channel is not matching against The Reqirement")65    return Missing_Chhanels_InWomensHealthCare_TQTY.__len__()66####  Checking Drugs for Suprax_TRX  ######67def Drugs_Suprax_TRX():68    query3 = "Select DISTINCT [Drug Name] [Suprax TRX] FROM LupinAllPrescribersReportData Where REPORT_NO =3"69    output3 = cursor.execute(query3)70    ReportDrugs = output3.fetchall()71    list1 = []72    # print(ReportChannel)73    for i in range(list(ReportDrugs).__len__()):74        list1.append(tuple(ReportDrugs[i]).__getitem__(0))75    res = set(list1) - set(Suprax_TRX_drugs)76    print(res)77    return res.__len__()78####  Checking Drugs for WomensHealthCare_TQTY  ######79def Drugs_WomensHealthCare_TQTY():80    query4 = "Select DISTINCT [Drug Name] [Suprax TRX] FROM LupinAllPrescribersReportData Where REPORT_NO =4"81    output4 = cursor.execute(query4)82    ReportDrugs1 = output4.fetchall()83    list1 = []84    # print(ReportChannel)85    for i in range(list(ReportDrugs1).__len__()):86        list1.append(tuple(ReportDrugs1[i]).__getitem__(0))87    res = set(list1) - set(WomensHealthCare_TQTY_drugs)88    print(res)89    return res.__len__()90###     Getting The Report Matty and saving it into a Variable "ReportMatty"    ###91def Report_Matty():92    global ReportOutput93    query5 =    """     SELECT Channel,[Drug Name],[Prescriber Name],[Prescriber ME #],Region,Report_NO,94				CASE 95					WHEN REPORT_NO=1 THEN 'Antara Market TRX'96					WHEN REPORT_No=2 THEN 'Antara Market NRX'97					WHEN REPORT_No=3 THEN 'Suprax Chew MAREKT TRX'98					WHEN REPORT_No=4 THEN 'Womens Health Care Market TQTY' END AS MARKET ,sum(Matty) Matty99                        into #tmp FROM LupinAllPrescribersReportData100                        group by Channel,Report_No,[Drug Name],[Prescriber Name],[Prescriber ME #],Region,Report_NO101                        order by sum(Matty) desc 102                """103    output5 = cursor.execute(query5)104    ##tempReportMatty = output5.fetchall()105    query6= """         SELECT MARKET,Channel,Region,SUM(MATTY) AS Matty FROM #tmp WHERE MARKET IN ('Suprax Chew MAREKT TRX','Womens Health Care Market TQTY')106                        GROUP BY Region,Channel,MARKET107                        ORDER BY MARKET,Region,Channel 108            """109    output6 = cursor.execute(query6)110    ReportMatty = output6.fetchall()111    print("-------------------Report OutPut-----------------")112    for each in range(list(ReportMatty).__len__()):113        ##print("Report Matty is :---------",ReportMatty)114        ##ReportOutput.append(ReportMatty[each][0]+"|"+str(ReportMatty[each][1])+"|"+str(ReportMatty[each][2])+"|"+str(round(ReportMatty[each][3],2)))115        ReportOutput.append(ReportMatty[each][0] + "|" + ReportMatty[each][1] + "|" + str(ReportMatty[each][2]) + "|" + str(ReportMatty[each][3]))116    print(ReportOutput)117###     Getting The  Matty of Suprax Cap  Tab TRX for Managed medicaid Cahhenl   ###118def RAWDBMattySupraxCapTabManagedMedicaid():119        global RAWDbOutputSupraxCapTabManagedMedicaid120        rawDbQuery1= """    Select regionid,BUID,ME_NO,SRA2 IMSDR_Key,F_NM,L_NM,c.drug_name DrugName,Case when F.IMS_NUM IS NULL Then 'N' else 'Y' End as PDRP,121                            SUM(TRX1+TRX2+TRX3+TRX4+TRX5+TRX6+TRX7+TRX8+TRX9+TRX10+TRX11+TRX12) Matty 122                            into #MMRX_Thera_Name1 from EXT_RAW_DATA A  123                            INNER JOIN DI_MASTER.dbo.MHC_EXT_DRUG_REL B	ON A.PROD_ID=B.EXT_DRUG_ID AND B.CLIENT_ID = 2 AND B.STATUS='A' 124                            Inner join [B1-124].M1B_DF.DBO.MASTER_THERA_Class H ON B.THERA_ID=H.THERA_ID AND Thera_Name='Antibiotics Market Suprax Cap/Tab'--Change Thera125                            INNER JOIN [B1-124].M1B_DF.DBO.MASTER_THERA_DRUG C ON B.DRUG_BRD_ID=C.DRUG_ID  AND C.DRUG_STRENGTH='ALL' 126                            AND C.DRUG_NAME in ('cefdinir','Suprax')--Change Drugs as per market 127                            INNER JOIN DI_MASTER..TMP_ENTITY_IMS_XREF D ON A.PAYER_PLAN_CD=D.PAYER_PLAN_ID  128                            INNER JOIN [B1-124].[BOTMAster].Dbo.VWLinkageChannelXref G ON D.Channel_id=G.Subchannelid AND G.subchannel='managed Medicaid'--Change Channel129                            LEFT JOIN DF_PDRP_LIST F ON A.SRA2=F.IMS_NUM  130                            Inner join [B1-124].M1B_LUP.dbo.PrescriberAlignment T on A.SRA2=T.IMSID  and BUID is not null                            131                            inner join [b1-124].M1B_LUP.DBO.MHC_SLS_ORG_RETL u132                            on u.LVL_NO=1 AND u.THERA_ID=774  and t.TerritoryID=u.RETL_TERR_ID133                            Group by RegionID,BUID,ME_NO,SRA2,F_NM,L_NM,c.drug_name,Case when F.IMS_NUM IS NULL Then 'N' else 'Y' End134                     """135        rawDbOutput1=cursorOn36Db.execute(rawDbQuery1)136        rawDbQuery2=""" Select ME_NO,IMSDR_Key,F_NM,L_NM,DrugName,RegionID,PDRP,Matty into #tmp1 FROM  #MMRX_Thera_Name1137                        Where  PDRP='N' AND RegionID NOT IN ('41000','42000')138                         Group BY ME_NO,IMSDR_Key,F_NM,L_NM,DrugName,RegionID,PDRP,Matty139                    """140        rawDbOutput2=cursorOn36Db.execute(rawDbQuery2)141        rawDbQuery4=""" SELECT RegionID,SUM(MATTY) FROM #tmp1 GROUP BY RegionID """142        rawDbOutput4 = cursorOn36Db.execute(rawDbQuery4)143        RAWDbMatty = rawDbOutput4.fetchall()144        for each in range(list(RAWDbMatty).__len__()):145            print("-------------------RAW DB OutPut-----------------")146            RAWDbOutputSupraxCapTabManagedMedicaid.append("Suprax Chew MAREKT TRX" + "|" + "Managed Medicaid"+ "|" + RAWDbMatty[each][0] + "|" + str(RAWDbMatty[each][1]))147            print(RAWDbOutputSupraxCapTabManagedMedicaid)148###     Comparing The  Matty of Suprax Cap  Tab TRX for Managed medicaid Channel against Report Matty   ###149def CompareMattySupraxCapTabManagedMedicaid():150        global ReportOutput151        Report_Matty()152        RAWDBMattySupraxCapTabManagedMedicaid()153        count = 0154        #print(ReportOutput)155        for i in range(RAWDbOutputSupraxCapTabManagedMedicaid.__len__()):156            item = RAWDbOutputSupraxCapTabManagedMedicaid[i]157            print("item ", item)158            if (ReportOutput.__contains__(item)):159                print("passed")160            else:161                count = count + 1162                print("Failed")163        return count164###     Getting  The  Matty of Suprax Cap  Tab TRX for Commercial w/o Managed medicaid Channel     ###165def RAWDBMattySupraxCapTabcommercialwithoutManagedMedicaid():166    global RAWDbOutputSupraxCapTabcommercialwithoutManagedMedicaid167    rawDbQuery2 = """    Select regionid,BUID,ME_NO,SRA2 IMSDR_Key,F_NM,L_NM,c.drug_name DrugName,Case when F.IMS_NUM IS NULL Then 'N' else 'Y' End as PDRP,168                            SUM(TRX1+TRX2+TRX3+TRX4+TRX5+TRX6+TRX7+TRX8+TRX9+TRX10+TRX11+TRX12) Matty 169                            into #MMRX_Thera_Name2 from EXT_RAW_DATA A  170                            INNER JOIN DI_MASTER.dbo.MHC_EXT_DRUG_REL B	ON A.PROD_ID=B.EXT_DRUG_ID AND B.CLIENT_ID = 2 AND B.STATUS='A' 171                            Inner join [B1-124].M1B_DF.DBO.MASTER_THERA_Class H ON B.THERA_ID=H.THERA_ID AND Thera_Name='Antibiotics Market Suprax Cap/Tab'--Change Thera172                            INNER JOIN [B1-124].M1B_DF.DBO.MASTER_THERA_DRUG C ON B.DRUG_BRD_ID=C.DRUG_ID  AND C.DRUG_STRENGTH='ALL' 173                            AND C.DRUG_NAME in ('cefdinir','Suprax')--Change Drugs as per market 174                            INNER JOIN DI_MASTER..TMP_ENTITY_IMS_XREF D ON A.PAYER_PLAN_CD=D.PAYER_PLAN_ID 175                            INNER JOIN [B1-124].[BOTMAster].Dbo.VWLinkageChannelXref G ON D.Channel_id=G.Subchannelid AND G.subchannel='commercial w/o managed Medicaid'--Change Channel176                            LEFT JOIN DF_PDRP_LIST F ON A.SRA2=F.IMS_NUM  177                            Inner join [B1-124].M1B_LUP.dbo.PrescriberAlignment T on A.SRA2=T.IMSID  and BUID is not null178                            inner join [b1-124].M1B_LUP.DBO.MHC_SLS_ORG_RETL u179                            on u.LVL_NO=1 AND u.THERA_ID=774  and t.TerritoryID=u.RETL_TERR_ID180                            Group by RegionID,BUID,ME_NO,SRA2,F_NM,L_NM,c.drug_name,Case when F.IMS_NUM IS NULL Then 'N' else 'Y' End181                         """182    rawDbOutput2 = cursorOn36Db.execute(rawDbQuery2)183    rawDbQuery3 = """ Select ME_NO,IMSDR_Key,F_NM,L_NM,DrugName,RegionID,PDRP,Matty into #tmp2 FROM  #MMRX_Thera_Name2184                            Where  PDRP='N' AND RegionID NOT IN ('41000','42000')185                             Group BY ME_NO,IMSDR_Key,F_NM,L_NM,DrugName,RegionID,PDRP,Matty186                        """187    rawDbOutput3 = cursorOn36Db.execute(rawDbQuery3)188    rawDbQuery5 = """ SELECT RegionID,SUM(MATTY) FROM #tmp2 GROUP BY RegionID """189    rawDbOutput5 = cursorOn36Db.execute(rawDbQuery5)190    RAWDbMatty2 = rawDbOutput5.fetchall()191    for each in range(list(RAWDbMatty2).__len__()):192        print("-------------------RAW DB OutPut-----------------")193        RAWDbOutputSupraxCapTabcommercialwithoutManagedMedicaid.append("Suprax Chew MAREKT TRX" + "|" + "Commercial w/o Managed Medicaid" + "|" + RAWDbMatty2[each][0] + "|" + str(RAWDbMatty2[each][1]))194        ###RAWDbOutputSupraxCapTabManagedMedicaid.append                 ("Suprax Chew MAREKT TRX" + "|" + "Commercial w/o Managed Medicaid" + "|" + RAWDbMatty2[each][0] + "|" + str(RAWDbMatty2[each][1]))195        print(RAWDbOutputSupraxCapTabcommercialwithoutManagedMedicaid)196###     Comparing  The  Matty of Suprax Cap  Tab TRX for Commercial w/o Managed medicaid Channel against Report Matty    ###197def CompareMattySupraxCapTabcommercialwoManagedMedicaid():198        global ReportOutput,RAWDbOutputSupraxCapTabcommercialwithoutManagedMedicaid199        #Report_Matty()200        RAWDBMattySupraxCapTabcommercialwithoutManagedMedicaid()201        count1 = 0202        print("------------------ReportOutput----------------------",ReportOutput)203        for i in range(RAWDbOutputSupraxCapTabcommercialwithoutManagedMedicaid.__len__()):204            item1 = RAWDbOutputSupraxCapTabcommercialwithoutManagedMedicaid[i]205            print("item1 ",item1)206            if(ReportOutput.__contains__(item1)):207                print("passed")208            else:209                count1 = count1 + 1210                print("Failed")211            """ for j in range(ReportOutput.__len__()):212                print(ReportOutput[j])213                if (ReportOutput[j] == item1):214                    print(" comming")215                else:216                    count1 = count1 + 1"""217        return count1218###     Getting  The  Matty of Womens' Healthcare TQTY for  Managed medicaid Channel      ###219def RAWDBMattyWomensHealthcareManagedMedicaid():220    global RAWDBMattyWomensHealthcare_Managed_Medicaid221    rawDbQuery3 = """    Select regionid,BUID,ME_NO,SRA2 IMSDR_Key,F_NM,L_NM,c.drug_name DrugName,Case when F.IMS_NUM IS NULL Then 'N' else 'Y' End as PDRP,222                            SUM(TQTY1+TQTY2+TQTY3+TQTY4+TQTY5+TQTY6+TQTY7+TQTY8+TQTY9+TQTY10+TQTY11+TQTY12) Matty 223                            into #MMRX_Thera_Name5 from EXT_RAW_DATA A  224                            INNER JOIN DI_MASTER.dbo.MHC_EXT_DRUG_REL B	ON A.PROD_ID=B.EXT_DRUG_ID AND B.CLIENT_ID = 2 AND B.STATUS='A' 225                            Inner join [B1-124].M1B_DF.DBO.MASTER_THERA_Class H ON B.THERA_ID=H.THERA_ID AND Thera_Name='Bacterial Vaginosis'--Change Thera226                            INNER JOIN [B1-124].M1B_DF.DBO.MASTER_THERA_DRUG C ON B.DRUG_BRD_ID=C.DRUG_ID  AND C.DRUG_STRENGTH='ALL' 227                            AND C.DRUG_NAME in  ('Cleocin Vaginal','Cleocin Vaginal Ovules','clindamycin phosphate vaginal cream','Clindesse',228                            'Flagyl','Metrogel-Vaginal','metronidazole','metronidazole vaginal','Nuvessa','Solosec','Tindamax','tinidazole')--Change Drugs as per market 229                            INNER JOIN DI_MASTER..TMP_ENTITY_IMS_XREF D ON A.PAYER_PLAN_CD=D.PAYER_PLAN_ID 230                            INNER JOIN [B1-124].[BOTMAster].Dbo.VWLinkageChannelXref G ON D.Channel_id=G.Subchannelid AND G.subchannel='managed Medicaid'--Change Channel231                            LEFT JOIN DF_PDRP_LIST F ON A.SRA2=F.IMS_NUM  232                            Inner join [B1-124].M1B_LUP.dbo.PrescriberAlignment T on A.SRA2=T.IMSID  and BUID is not null233                            inner join [b1-124].M1B_LUP.DBO.MHC_SLS_ORG_RETL u234                            on u.LVL_NO=1 AND u.THERA_ID=774  and t.TerritoryID=u.RETL_TERR_ID235                            Group by RegionID,BUID,ME_NO,SRA2,F_NM,L_NM,c.drug_name,Case when F.IMS_NUM IS NULL Then 'N' else 'Y' End236                                             """237    rawDbOutput3 = cursorOn36Db.execute(rawDbQuery3)238    rawDbQuery4 = """   Select ME_NO,IMSDR_Key,F_NM,L_NM,DrugName,RegionID,PDRP,Matty239                        into #tmp3 FROM  #MMRX_Thera_Name5 240                        Where  PDRP='N' AND RegionID NOT IN ('41000','42000')241                        Group BY ME_NO,IMSDR_Key,F_NM,L_NM,DrugName,RegionID,PDRP,Matty242                  """243    rawDbOutput4 = cursorOn36Db.execute(rawDbQuery4)244    rawDbQuery6 = """ SELECT RegionID,SUM(MATTY) FROM #tmp3 GROUP BY RegionID """245    rawDbOutput5 = cursorOn36Db.execute(rawDbQuery6)246    RAWDbMatty3 = rawDbOutput5.fetchall()247    for each in range(list(RAWDbMatty3).__len__()):248        print("-------------------RAW DB OutPut-----------------")249       ## RAWDBMattyWomensHealthcareManagedMedicaid.append("Womens Health Care Market TQTY" + "|" + "Managed Medicaid" + "|" + RAWDbMatty3[each][0] + "|" + str(RAWDbMatty3[each][1]))250        RAWDBMattyWomensHealthcare_Managed_Medicaid.append("Womens Health Care Market TQTY" + "|" + "Managed Medicaid" + "|" + RAWDbMatty3[each][0] + "|" + str(RAWDbMatty3[each][1]))251        ###RAWDbOutputSupraxCapTabManagedMedicaid.append                 ("Suprax Chew MAREKT TRX" + "|" + "Commercial w/o Managed Medicaid" + "|" + RAWDbMatty2[each][0] + "|" + str(RAWDbMatty2[each][1]))252        print(RAWDBMattyWomensHealthcare_Managed_Medicaid)253###     Comparing  The  Matty of Womens' Healthcare TQTY for  Managed medicaid Channel against Report Matty    ###254def CompareRAWDBMattyWomensHealthcareManagedMedicaid():255        global RAWDBMattyWomensHealthcare_Managed_Medicaid256        RAWDBMattyWomensHealthcareManagedMedicaid()257        count10 = 0258        #Report_Matty()259        print("------------------ReportOutput----------------------", ReportOutput)260        for i in range(RAWDBMattyWomensHealthcare_Managed_Medicaid.__len__()):261            item1 = RAWDBMattyWomensHealthcare_Managed_Medicaid[i]262            print(" ")263            print("item1 ",item1)264            if(ReportOutput.__contains__(item1)):265                print("passed")266            else:267                count10 = count10 + 1268                print("Failed")269            """for j in range(ReportOutput.__len__()):270                ##print(ReportOutput[j])271                if (ReportOutput[j] == item1):272                    print(" ")273                else:274                    count10 = count10 + 1"""275        return count10276###     Getting  The  Matty of Womens' Healthcare TQTY for  commercial w/o Managed medicaid Channel      ###277def RAWDBMattyWomensHealthcarecommwithoutManagedMedicaid():278    global RAWDBMattyWomensHealthcarecommercialwithoutManagedMedicaid279    rawDbQuery4 = """    Select regionid,BUID,ME_NO,SRA2 IMSDR_Key,F_NM,L_NM,c.drug_name DrugName,Case when F.IMS_NUM IS NULL Then 'N' else 'Y' End as PDRP,280                            SUM(TQTY1+TQTY2+TQTY3+TQTY4+TQTY5+TQTY6+TQTY7+TQTY8+TQTY9+TQTY10+TQTY11+TQTY12) Matty 281                            into #MMRX_Thera_Name4 from EXT_RAW_DATA A  282                            INNER JOIN DI_MASTER.dbo.MHC_EXT_DRUG_REL B	ON A.PROD_ID=B.EXT_DRUG_ID AND B.CLIENT_ID = 2 AND B.STATUS='A' 283                            Inner join [B1-124].M1B_DF.DBO.MASTER_THERA_Class H ON B.THERA_ID=H.THERA_ID AND Thera_Name='Bacterial Vaginosis'--Change Thera284                            INNER JOIN [B1-124].M1B_DF.DBO.MASTER_THERA_DRUG C ON B.DRUG_BRD_ID=C.DRUG_ID  AND C.DRUG_STRENGTH='ALL' 285                            AND C.DRUG_NAME in  ('Cleocin Vaginal','Cleocin Vaginal Ovules','clindamycin phosphate vaginal cream','Clindesse',286                            'Flagyl','Metrogel-Vaginal','metronidazole','metronidazole vaginal','Nuvessa','Solosec','Tindamax','tinidazole')--Change Drugs as per market 287                            INNER JOIN DI_MASTER..TMP_ENTITY_IMS_XREF D ON A.PAYER_PLAN_CD=D.PAYER_PLAN_ID 288                            INNER JOIN [B1-124].[BOTMAster].Dbo.VWLinkageChannelXref G ON D.Channel_id=G.Subchannelid AND G.subchannel='commercial w/o managed Medicaid'--Change Channel289                            LEFT JOIN DF_PDRP_LIST F ON A.SRA2=F.IMS_NUM  290                            Inner join [B1-124].M1B_LUP.dbo.PrescriberAlignment T on A.SRA2=T.IMSID  and BUID is not null291                            inner join [b1-124].M1B_LUP.DBO.MHC_SLS_ORG_RETL u292                            on u.LVL_NO=1 AND u.THERA_ID=774  and t.TerritoryID=u.RETL_TERR_ID293                            Group by RegionID,BUID,ME_NO,SRA2,F_NM,L_NM,c.drug_name,Case when F.IMS_NUM IS NULL Then 'N' else 'Y' End294                 """295    rawDbOutput4 = cursorOn36Db.execute(rawDbQuery4)296    rawDbQuery5 = """ Select ME_NO,IMSDR_Key,F_NM,L_NM,DrugName,RegionID,PDRP,Matty297                        into #tmp4 FROM  #MMRX_Thera_Name4 298                        Where  PDRP='N' 299                        Group BY ME_NO,IMSDR_Key,F_NM,L_NM,DrugName,RegionID,PDRP,Matty300                  """301    rawDbOutput6 = cursorOn36Db.execute(rawDbQuery5)302    rawDbQuery7 = """ SELECT RegionID,SUM(MATTY) FROM #tmp4 GROUP BY RegionID """303    rawDbOutput6 = cursorOn36Db.execute(rawDbQuery7)304    RAWDbMatty4 = rawDbOutput6.fetchall()305    for each in range(list(RAWDbMatty4).__len__()):306        print("-------------------RAW DB OutPut-----------------")307        RAWDBMattyWomensHealthcarecommercialwithoutManagedMedicaid.append("Womens Health Care Market TQTY" + "|" + "Commercial w/o Managed Medicaid" + "|" + RAWDbMatty4[each][0] + "|" + str(RAWDbMatty4[each][1]))308        ###RAWDbOutputSupraxCapTabManagedMedicaid.append                 ("Suprax Chew MAREKT TRX" + "|" + "Commercial w/o Managed Medicaid" + "|" + RAWDbMatty2[each][0] + "|" + str(RAWDbMatty2[each][1]))309        print(RAWDBMattyWomensHealthcarecommercialwithoutManagedMedicaid)310###     Comparing  The  Matty of Womens' Healthcare TQTY for  commercial w/o Managed medicaid Channel against Report Matty    ###311def CompareRAWDBMattyWomensHealthcarecommercialwithoutManagedMedicaid():312    global RAWDBMattyWomensHealthcarecommercialwithoutManagedMedicaid313    RAWDBMattyWomensHealthcarecommwithoutManagedMedicaid()314    count3 = 0315    #Report_Matty()316    print("------------------ReportOutput----------------------", ReportOutput)317    for i in range(RAWDBMattyWomensHealthcarecommercialwithoutManagedMedicaid.__len__()):318        item1 = RAWDBMattyWomensHealthcarecommercialwithoutManagedMedicaid[i]319        ##print("RAWDBMattyWomensHealthcarecommercialwithoutManagedMedicaid",RAWDBMattyWomensHealthcarecommercialwithoutManagedMedicaid)320        print(" ")321        print("item1 ", item1)322        """for j in range(ReportOutput.__len__()):323        ##print(ReportOutput[j])324            print("item1 ",item1)"""325        if(ReportOutput.__contains__(item1)):326                print("passed")327        else:328                count3 = count3 + 1329                print("Failed")...

ReportOutput_Fm.py

Source:ReportOutput_Fm.py

1# -*- coding: utf-8 -*-2# Form implementation generated from reading ui file 'F:\code\Top\ui\ReportOutput.ui'3#4# Created by: PyQt5 UI code generator 5.8.15#6# WARNING! All changes made in this file will be lost!7from PyQt5 import QtCore, QtGui, QtWidgets8class Ui_ReportOutput(object):9    def setupUi(self, ReportOutput):10        ReportOutput.setObjectName("ReportOutput")11        ReportOutput.resize(736, 577)12        icon = QtGui.QIcon()13        icon.addPixmap(QtGui.QPixmap(":/new/wl/Logo_ico.png"), QtGui.QIcon.Normal, QtGui.QIcon.Off)14        ReportOutput.setWindowIcon(icon)15        self.groupBox = QtWidgets.QGroupBox(ReportOutput)16        self.groupBox.setGeometry(QtCore.QRect(3, 3, 731, 571))17        self.groupBox.setTitle("")18        self.groupBox.setObjectName("groupBox")19        self.retranslateUi(ReportOutput)20        QtCore.QMetaObject.connectSlotsByName(ReportOutput)21    def retranslateUi(self, ReportOutput):22        _translate = QtCore.QCoreApplication.translate23        ReportOutput.setWindowTitle(_translate("ReportOutput", "Dialog"))...

Automation Testing Tutorials

Learn to execute automation testing from scratch with LambdaTest Learning Hub. Right from setting up the prerequisites to run your first automation test, to following best practices and diving deeper into advanced test scenarios. LambdaTest Learning Hubs compile a list of step-by-step guides to help you be proficient with different test automation frameworks i.e. Selenium, Cypress, TestNG etc.