U f¨Ih<ã@s®ddlZddlmZmZmZddlZddlZddlZej ej dde e¡Z eeeedœdd„Zeeeedœd d „Zeeeefdœdd „Zdeeeedœdd„ZdS)éN)ÚOptionalÚListÚDictz4%(asctime)s - %(name)s - %(levelname)s - %(message)s)ÚlevelÚformat)ÚcontentÚ base_nameÚreturnc Csä|r|st d¡tdƒdStj dd¡}|›d}tj ||¡}zHtj|ddt|d d d}| |¡W5QRXt d|›¡|WSt k rÞ}z4t d |›d|›¡td|›d|›ƒWY¢dSd}~XYnXdS)zÕSave test script to file. Args: content (str): Content to write to file base_name (str): Base name for the file Returns: Optional[str]: Filename if successful, None otherwise z$Filename and content cannot be emptyu(âŒ Filename and content cannot be emptyNÚtestsÚ generatedz.txtT©Úexist_okÚwzutf-8)Úencodingz Test script saved successfully: zError saving file z: uâŒ Error saving file )ÚloggerÚerrorÚprintÚosÚpathÚjoinÚmakedirsÚopenÚwriteÚinfoÚ Exception)rrÚ output_dirÚfilenameÚ file_pathÚfileÚe©r ú?/var/www/html/testcasegenerator.evdpl.com/utils/file_handler.pyÚsave_test_scripts" r")Ú test_casesrr c sÒ|r|st d¡tdƒdS|›d}tj dd¡}tj|ddtj ||¡}z0t|ƒ}|svt d ¡t |ƒ}nBt d t |ƒ›d¡g}| ¡D]\}}t ||d} | | ¡q˜|rÆt |¡nt ¡‰ˆjrt d ¡tdƒt dgd gdgdgdgdgdœ¡‰dˆjkr"dˆd<nˆd d¡ˆd<dddddddg} | D]}|ˆjkrJdˆ|<qJdˆjkrˆˆd dd„¡ˆd<ˆ d¡‰ddddddddg}ˆjD]}||kr¬| |¡q¬‡fdd„|Dƒ}ˆj|d‰t j|d d!v} ˆj| d"d#d$| jd#}tˆjƒD]J\}}tˆ| t¡ t ¡ ¡t |ƒƒ}t|d%d&ƒ|jtd'|ƒ_ qW5QRXt d(|›¡|WSt!k rÌ}z(t d)|›¡td*|›ƒWY¢dSd}~XYnXdS)+zéSave test cases to Excel file. Args: test_cases (str): Test cases content to write to Excel base_name (str): Base name for the file Returns: Optional[str]: Filename if successful, None otherwise z'Filename and test cases cannot be emptyu+âŒ Filename and test cases cannot be emptyNz.xlsxr rTrz6No TEST TYPE sections found, using traditional parsingzFound z TEST TYPE sections)Údefault_sectionzNo test cases could be parsedu$âš ï¸ No test cases could be parsedzNo test cases foundÚ)ÚSectionÚTitleÚScenarioÚStepsúExpected Resultú Actual Resultr&ÚGeneralr'r(r)r*r+ÚStatusÚPrioritycSs*t|tƒr"d dd„t|ƒDƒ¡S|p(dS)NÚ cSs"g|]\}}|d›d|›‘qS)éz. r )Ú.0ÚiÚstepr r r!Ú lsz7save_excel_report....r%)Ú isinstanceÚlistrÚ enumerate)Úxr r r!Úlóz#save_excel_report..csg|]}|ˆjkr|‘qSr ©Úcolumns)r1Úcol©Údfr r!r4ys z%save_excel_report..r;Zopenpyxl)ZengineFz Test Cases)ÚindexZ sheet_nameéé2éAz!Excel report saved successfully: zError saving Excel report: uâŒ Error saving Excel report: )"rrrrrrrÚextract_test_type_sectionsrÚparse_traditional_formatÚlenÚitemsÚextendÚpdZ DataFrameÚemptyÚwarningr<ZfillnaÚapplyÚappendZreindexZExcelWriterÚto_excelZsheetsr7ÚmaxZastypeÚstrÚminZcolumn_dimensionsÚchrÚwidthr)r#rrrÚfilepathÚsectionsÚ test_dataÚsection_nameÚsection_contentZsection_dataZrequired_columnsr=Zcolumn_orderÚwriterZ worksheetÚidxÚ max_lengthrr r>r!Úsave_excel_report*sz ú þ,r\)r#r c CsŒi}d}tt ||¡ƒ}|s iSt|ƒD]^\}}| d¡ ¡}| ¡}|dt|ƒkrf||d ¡nt|ƒ}|||… ¡} | ||<q(|S)zêExtract sections from test cases content based on TEST TYPE markers. Args: test_cases (str): The full test cases content Returns: Dict[str, str]: Dictionary of section name to section content zTEST TYPE:\s*([^\n]+)r0) r6ÚreÚfinditerr7ÚgroupÚstripÚendrFÚstart) r#rUZsection_patternZsection_matchesr2ÚmatchrWÚ start_posÚend_posrXr r r!rD‘s ( rDr,)r#r$r cCsÌg}i}|}d}g}t d|›¡d|krÄd|krÄt d¡t d|¡}|D]N}| ¡}|rRt|ƒdkrrqRd|krRi} || d<t d |¡} | r¨| d ¡ ¡| d<t d|¡}|rÊ| d ¡ ¡| d <t d|¡}|r| d ¡ ¡} t d| ¡}|r|| d<n | g| d<t d|tj ¡}|r8| d ¡ ¡| d<t d|tj ¡}|r`| d ¡ ¡| d<t d|¡}|r„| d ¡ ¡| d<| | ¡t d| d›¡qR|rÄt dt|ƒ›d¡|St d¡| d¡}d}|t|ƒkr”|| ¡}|d 7}|sqÜ| d¡r.| dd¡ ¡p(|}qÜt d |¡} | r~|r^|rT||d<| |¡|| d ¡ ¡d!œ}d}g}qÜt d"|¡}|r¬|r¬| d ¡ ¡|d <qÜt d#|¡}|rÐ|rÐd$}g}qÜ|rvt d%|¡rd}||d<t d&|¡}|rÜ| d ¡ ¡|d<qÜt d'|¡}|rZ| ¡d(rB| d)¡n|}| | ¡¡qÜn| ¡rv| | ¡¡qÜt d&|¡}|r¤|r¤| d ¡ ¡|d<qÜt d*|¡}|rÒ|rÒ| d ¡ ¡|d<qÜt d+|¡}|r|r| d ¡ ¡|d<qÜ|rÜ|sÜ|rÜd|kr2|dd,|7<n^d|krR|dd,|7<n>d|krr|dd,|7<nd |krÜ|d d,|7<qÜ|r²|r¨||d<| |¡t dt|ƒ›d-¡|S).a Parse test cases using the traditional format. Args: test_cases (str): Test cases content to parse default_section (str): Default section name if none is specified Returns: List[Dict]: List of test case dictionaries Fz)Parsing test cases with default section: zTitle:zSteps to reproduce:zDDetected standard test case format with Title and Steps to reproducez\n\s*\né r&zTitle:\s*(.*?)(?:\n|$)r0r'zScenario:\s*(.*?)(?:\n|$)r(z-Steps to reproduce:([\s\S]*?)Expected Result:zK(?:^|\n)\s*(?:\d+\.\s*|\*\s*|\-\s*)(.*?)(?=\n\s*(?:\d+\.\s*|\*\s*|\-\s*)|$)r)z6Expected Result:\s*(.*?)(?:Actual Result:|Priority:|$)r*z%Actual Result:\s*(.*?)(?:Priority:|$)r+zPriority:\s*(.*?)(?:\n|$)r.zExtracted test case: z Extracted z test cases using block parsingz)Using line-by-line parsing for test casesr/rz###ú#r%z/^(?:\d+\.\s*)?(?:\*\*)?Title:(?:\*\*)?\s*(.*?)$)r&r'z%^(?:\*\*)?Scenario:(?:\*\*)?\s*(.*?)$z+^(?:\*\*)?Steps(?: to reproduce)?:(?:\*\*)?Tz#^(?:\*\*)?Expected Result:(?:\*\*)?z,^(?:\*\*)?Expected Result:(?:\*\*)?\s*(.*?)$z^(?:(\d+)\.|\-|\*)\s*(.*?)$éÿÿÿÿrAz*^(?:\*\*)?Actual Result:(?:\*\*)?\s*(.*?)$z%^(?:\*\*)?Priority:(?:\*\*)?\s*(.*?)$Ú z& test cases using line-by-line parsing)rrr]Úsplitr`rFÚsearchr_ÚfindallÚDOTALLrMÚdebugÚ startswithÚreplacercÚgroups)r#r$rVZcurrent_testZcurrent_sectionZcollecting_stepsZ current_stepsZtest_case_blocksÚblockÚ test_caseZtitle_matchZscenario_matchZsteps_matchÚ steps_textZ step_linesZexpected_matchZactual_matchZpriority_matchÚlinesr2ÚlineZer_matchZ step_matchZ step_textr r r!rE°sì þ rE)r,)rÚtypingrrrÚloggingÚpandasrIr]ÚbasicConfigÚINFOÚ getLoggerÚ__name__rrPr"r\rDrEr r r r!Ús g