oi^  dZddlZddlZddlZddlZddlZddlmZmZmZddl Z dZ dZ dZ dZ dZejj!d Zej$Zee_ddgd ddgd ddgd ddgd ddgd ddgd d Ziad Zd!d ZdZdZdZdZdZdZdZdZ dZ!dZ"dZ#dZ$dZ%dZ&dZ'dZ(dZ)dZ*e+d k(re*yy)"zt Comprehensive Test Suite for Vera Medical CRM Tests all phases: 1, 2, 3, 4, and 5 Generates a detailed test report N)datetimedate timedeltazhttp://localhost:5050zdatabase/vera_medical.dbadminadmin123z %Y%m%d_%H%M%S)passedfailedtests)phase1phase2phase3phase4phase5generalctjtd}|jd|jdtj|_|S)z,Get database connection with proper settingsg>@timeoutzPRAGMA journal_mode=WALzPRAGMA busy_timeout=30000)sqlite3connectDB_PATHexecuteRow row_factory)conns =/home/ab5.sw7ft.com/public_html/scripts/test_comprehensive.py get_db_connr)s= ??7D 1DLL*+LL,-{{D Kc4|rdnd}|||tjjd}t|dj ||r&t|dxxdz cc<t d|d|y t|d xxdz cc<t d|d|d |y ) zLog test resultu✅ PASSu❌ FAIL)namestatusmessage timestampr r  : r z - N)rnow isoformat test_resultsappendprint)phase test_namer r"r!results rlog_testr/1s!ZzF\\^--/ F  ''/ UH%*% 6("YK()UH%*% 6("YKs7)45rctd tjtdt}|j dk7rytj tdttdtd}|j dk(rDd |jjvsd |jjvr td yy#t$r}td |Yd }~yd }~wwxYw)zLogin to the applicationu 🔐 Logging in.../loginrF)usernamepasswordTdatarallow_redirectslogoutz case searchu✅ Login successfulu❌ Login failed: N) r+sessiongetBASE_URLREQUEST_TIMEOUT status_codepostUSERNAMEPASSWORDtextlower Exception)responsees rloginrFBs !;;(62O;L   3 &<<j &H=#      3 &H 8K8K8M,MQ^bjbobobububwQw ( )  "1#&'s1CBC C# CC#ctdi} t}|jddtdtdtdtddtdd d d d d f j}||d<|jddtddd dfj}||d<|jddtdddddfj}||d<|jddtdt|d tdd!d"td#d$tdfj}||d%<|jd&d'td'td(d)tt j jd*||||d+f j}||d,<|jd-|t j td./zjd0d1d2d(d(d3d4d5d6d7td8tf j}||d9<|jd:d;tt j j||d(dd?d@dAd+f j}||dB<|jdCdDtdEt j j|dFdAdGtdHtd+f j} | |dI<|jdJdKtdLtt j td./zj|||dMdNd+f j} | |dO<|j|jtdP|S#t$r.} tdQ| d4dFl } | jicYdF} ~ SdF} ~ wwxYw)Rz*Create test data for comprehensive testingu 📦 Creating test data...z INSERT INTO claimants ( first_name, last_name, full_name, date_of_birth, email, address, city, province, postal_code, home_phone ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) TEST_FIRST_ TEST_LAST_z TEST_LAST_ 1990-01-01test_ @example.com 123 Test StCalgaryABT1T1T1z 403-555-1234 claimant_idz INSERT INTO clients ( company_name, address, city, province, postal_code ) VALUES (?, ?, ?, ?, ?) TEST_CLIENT_z456 Client AveEdmontonT2T2T2 client_idz INSERT INTO lawyer_firms ( firm_name, address, city, province, postal_code, phone ) VALUES (?, ?, ?, ?, ?, ?) TEST_FIRM_z 789 Firm BlvdTorontoONM1M1M1z 416-555-5678firm_idz INSERT INTO lawyer_contacts ( first_name, last_name, lawyer_firm_id, email, fax, assistant_name, assistant_phone, assistant_email ) VALUES (?, ?, ?, ?, ?, ?, ?, ?) TEST_LAWYER_FIRST_TEST_LAWYER_LAST_ test_lawyer_z 416-555-5679TEST_ASSISTANT_z 416-555-5680test_assistant_ lawyer_ida> INSERT INTO cases ( record_id, file_case_id, assessment_type, case_notes, file_open_date, service_location, claimant_id, lawyer_firm_id, lawyer_contact_id, client_id, created_by ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) TEST_CASE_IME - StandardTEST_CASE_NOTES_ Calgary, ABTestUsercase_idaA INSERT INTO appointments ( case_id, appointment_date, appointment_time, doctor_name, location, service_code, assessment_type, status, invoiced, timezone, provider_specialty, reference, notes ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) )daysz10:00zDr. Test Doctorz Test Clinic scheduledrzAmerica/Edmonton Orthopedic TEST_REF_TEST_APPT_NOTES_appointment_ida, INSERT INTO invoices ( invoice_number, invoice_date, case_id, appointment_id, service_code, service_description, fee, tax_rate, tax_amount, total_amount, status, created_by ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) TEST_INV_z Test Serviceg@@g@gI@gh@draft invoice_idz INSERT INTO reports ( report_title, report_type, report_date, case_id, doctor_id, status, description, notes, uploaded_by ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) TEST_REPORT_z IME ReportNzTest report description zTest report notes report_idz INSERT INTO bring_forward_tasks ( task_title, task_description, due_date, case_id, appointment_id, invoice_id, status, priority, created_by ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) TEST_TASK_zTest task description pendingmediumtask_idu"✅ Test data created successfullyu❌ Error creating test data: )r+rrTEST_TIMESTAMP lastrowidrtodayr(rcommitcloserC traceback print_exc) test_datarrQrUrZr`rfrmrprrrvrEr|s rcreate_test_datarYsJ ()Iz}ll$ .) *( ).)^4D E N#< 0        9! "$/ - LL" >* +        9 "+ +,, ( )         9  ' )LL" ! 0 1/ 0 >*, 7 n- . n-\ :    9 "+ +,, ( )( ) ~. / JJL " " $         & 9' ( ' )'   ZZ\I1- - 8 8 :        ' (~. /  ( 9) *'5 "#\\# ' ( JJL " " $             & 9' (#- ,LL" >* +  JJL " " $   &~&6 7  0 1     9  "+ +,, ( )$^$4 5 ZZ\I1- - 8 8 :          9  ' )   23  .qc23 sLL M)#M MMc Ztd t}gd}|D]=\}}|r|jd|d|d|d|d '|dk(s-|jd ?|j|j td y #t $r}td |Yd }~y d }~wwxYw) zClean up all test datau 🧹 Cleaning up test data...))bring_forward_tasks task_title) case_reports file_name)generated_lettersletter_subject)claimant_name_historynotes)invoice_line_itemsN)invoicesinvoice_number)appointment_medsr)medical_documentationr)appointment_additional_services service_type) appointmentsr)reports report_title)cases case_notes) claimants first_name)clients company_name)lawyer_contactsr) lawyer_firms firm_namez DELETE FROM z WHERE z LIKE 'TEST_%' OR z LIKE '%TEST_PHASE%' OR z LIKE '%TEST_TIMESTAMP%'rz DELETE FROM invoice_line_items WHERE invoice_id IN ( SELECT id FROM invoices WHERE invoice_number LIKE 'TEST_%' ) u✅ Cleanup completeu⚠️ Cleanup warning: N)r+rrrzr{rC)rtablestablefieldrEs rcleanup_test_datars +,(/} &# LE5 |E7'%@RSXRYYqrwqxyQRS00LL"    $% / )!-../sB B*B%%B*c V tdtdtd tjtdt}t dd|j dk( tjtd t}t dd |j dk( tjtd t}t dd|j dk( tjtdt}t dd|j dk( tjtdt}t dd|j dk( tjtdt}t dd|j dk( tjtdt}t dd|j dk( tjtdt}t dd|j dk( t}|jdj}|j|rCtjtd|ddt}t dd|j dk(nt ddd d t}|jdj}|j|rCtjtd |dd!t}t dd"|j dk(nt dd"d d# t}|jd$j}|j|rCtjtd%|dd!t}t dd&|j dk(y t dd&d d'y #t$r"}t ddd t|Yd }~yd }~wwxYw#t$r"}t dd d t|Yd }~jd }~wwxYw#t$r"}t ddd t|Yd }~[d }~wwxYw#t$r"}t ddd t|Yd }~Ld }~wwxYw#t$r"}t ddd t|Yd }~=d }~wwxYw#t$r"}t ddd t|Yd }~.d }~wwxYw#t$r"}t ddd t|Yd }~d }~wwxYw#t$r"}t ddd t|Yd }~d }~wwxYw#t$r"}t ddd t|Yd }~d }~wwxYw#t$r"}t dd"d t|Yd }~Rd }~wwxYw#t$r!}t dd&d t|Yd }~y d }~wwxYw)(z&Test general application functionality= ============================================================zGENERAL APPLICATION TESTS<============================================================/rrzHome page loadsr2FN/caseszCases list page loads/clientszClients list page loads/lawyerszLawyers list page loads/doctorszDoctors list page loads /appointmentszAppointments list page loads /invoiceszInvoices list page loads/reportsReports list page loadsSELECT id FROM clients LIMIT 1 /clients/id /contacts/newzClient contact form loadszNo clients found&SELECT id FROM lawyer_contacts LIMIT 1 /lawyers//editzLawyer view/edit functionalityzNo lawyers foundSELECT id FROM doctors LIMIT 1 /doctors/zDoctor view/edit functionalityzNo doctors found) r+r9r:r;r<r/r=rCstrrrfetchoner{)rDrErclientlawyerdoctors r test_generalrKs - %& &M>;;(1~;G-x/C/Cs/JK D;;(62O;L3X5I5IS5PQ F;;(84o;N5x7K7Ks7RS F;;(84o;N5x7K7Ks7RS F;;(84o;N5x7K7Ks7RS K;;(=9?;S:H?HHJ {{hZym#T^m{nH Y ;X=Q=QUX=X Y Y ;UDV W M}FGPPR {{hZye#LVe{fH Y @(BVBVZ]B] ^ Y @%I[ \ M}>?HHJ {{hZye#LVe{fH Y @(BVBVZ]B] ^ Y @%I[ \s >-uc!f==> D3UCFCCD F5uc!fEEF F5uc!fEEF F5uc!fEEF K:E3q6JJK G6s1vFFG F5uc!fEEF H7AGGH M#U>2 O;OO P )PP  P9P44P9< Q'Q""Q'* R3RR S!R>>S S1S,,S14 T=TT" U +UU  U;U66U;> V(V##V(ctdtdtd tjtdt}d|j j v}tdd| tjtdt}d |j vxsd |j j v}d|j v}tdd|xr| tjtdt}d|j j vxsd|j j v}d|j j vxs:d|j j vxsd|j j v}tdd|xr| ddddtdddtdtddd td!tdd" }tjtd|td#$}tdd%|jd&k(y #t$r"}tdd d t|Yd }~d }~wwxYw#t$r"}tddd t|Yd }~d }~wwxYw#t$r!}tddd t|Yd }~d }~wwxYw#t$r!}tdd%d t|Yd }~y d }~wwxYw)'zTest Phase 1 featuresrz,PHASE 1 TESTS - Case Management Enhancementsr /cases/newrfile_open_dater z"Case form has file_open_date fieldzCase form loadsFN service_codes service codeIMEzService codes loaded from CSVservice_locationservice locationcalgaryedmontontorontoz%Service location dropdown with citiesrbrd 2020-01-01 TEST_PHASE1_zMr.MaleTEST_PHASE1_FIRST_TEST_PHASE1_LAST_rJV1N1J5TEST_PHASE1_CLIENT_TEST_PHASE1_CLIENTNAME_) assessment_typer date_of_lossrclaimant_titleclaimant_genderclaimant_first_nameclaimant_last_nameclaimant_date_of_birthclaimant_postal_codeclient_company_nameclient_client_nameclient_postal_codeTr5z!Create case with service locationr2) r+r9r:r;r<rArBr/rCrrwr>r=)rDhas_file_open_daterEhas_service_codeshas_imehas_service_locationhas_city_dropdown case_datas r test_phase1rs - 89 &M=;;(:6;P-1D1D1FF?AST K;;(:6;P+x}}<gRZR_R_ReReRg@g8==(:>L*PXP]P]PcPcPeBeLirv~wDwDwJwJwLjLBDXDn]no O/ -(((89#%%77G#H$5n5E"F&2$,%88H#I$;N;K"L"* <<8*J 7iQ`rv<w>@T@TX[@[\S =,eSV<<= K:E3q6JJK SBE3q6RRS, O>s1vNNOscA H/A-ICI1#A1J IH;;I I. I))I.1 J:JJ K'KKc | tdtdtd tjtdt}d|j j v}d|j j vxsd|j j v}td d |xr| tjtdt}d|j vxsd|j j v}d|j v}td d|xr| tjtdt}td d|jdk( trdtvr td}nOt}|jdj}|j|std dd dy |d}tjtd|t}|jdv} |jdk(rtd|j j vxs:d|j j vxsd|j j v} td d| d|jntd dd d!|jd" t}|jdj}|j|rCtjtd|dd#t}td d$|jdk(ntd d$d d t}|jdj}|j|rCtjtd|dd%t}td d&|jdk(y td d&d dy #t$r"}td d d t|Yd }~%d }~wwxYw#t$r"}td dd t|Yd }~d }~wwxYw#t$r"}td dd t|Yd }~d }~wwxYw#t$r"}td dd t|Yd }~d }~wwxYw#t$r"}td d$d t|Yd }~ld }~wwxYw#t$r!}td d&d t|Yd }~y d }~wwxYw)'z!Test Phase 2 appointment featuresrz(PHASE 2 TESTS - Appointment Enhancementsr/appointments/newrtimezoneprovider_specialty specialtyr z#Appointment form has Phase 2 fieldszAppointment form loadsFNrrrz+Appointment form has service codes from CSV/appointments/uninvoicedz"Uninvoiced appointments page loadsr2rm#SELECT id FROM appointments LIMIT 11Appointment view has confirmation letters sectionNo appointments foundr/appointments/r2letterupload confirmationStatus: TRoute exists (Status:  - may have template issues)/additional_servicesz*Appointment additional services page loads/printzAppointment print view loads)r+r9r:r;r<rArBr/rCrr=r~rrrr{) rD has_timezonehas_provider_specialtyrErrrmr appointmenthas_pagehas_letter_contents r test_phase2rs - 45 &MD;;(+<=;W!X]]%8%8%:: !59L9L9N!N!vR]aiananatatavRv@,BiSij Y;;(+<=;W+x}}<gRZR_R_ReReRg@g8==(HJ[Jg`gh P;;(+CDo;^?AUAUY\A\] _ )Y6&'78N=D,,'LMVVXK JJL#VX]_vw(.N;;(>.9IJTc;d'':5   3 &!)X]]-@-@-B!B"ShRZR_R_ReReRgFg"Sky~F~K~K~Q~Q~SlS  XRTfjrs{tHtHsIiJ K XRTX\rs{tHtHsIIe[f g X}ll#HIRRT  {{hZ~k$>O=PPd#eo~{H XKXMaMaehMh i XKUTk l J}ll#HIRRT  {{hZ~k$>O=PPV#Wap{qH X=x?S?SWZ?Z [ X=uF] ^K D3UCFCCD YH%QTUVQWXXY P?AOOP8 _NPUWZ[\W]^^_ XGPSTUPVWWX J95#a&IIJsB N+-A-OQQ # R,R  R R;R66R;c tdtdtd t}|jdj}|j |rCt j td|ddt}td d |jd k(ntd d d d  t}|jdj}|j |rtd dddytd dd d y#t$r!}td d d t|Yd}~d}~wwxYw#t$r!}td dd t|Yd}~yd}~wwxYw)zTest Phase 3 featuresrz;PHASE 3 TESTS - Additional Services & Medical DocumentationrrrrrrrzAdditional services page loadsr2FrNz)Medical documentation upload route existsTzRoute implemented) r+rrrr{r9r:r;r<r/r=rCr)rrrDrEs r test_phase3rLs@ - GH &M L}ll#HIRRT  {{hZ~k$>O=PPd#eo~{H X?AUAUY\A\ ] X?H_ ` W}ll#HIRRT   XJDRe f XJESj k L;UCFKKL WFsSTvVVWs7B D 0A D6:D6 D3D..D36 E ?EE c tdtdtd tjtdt}d|j j v}d|j j v}tdd |xr| tdd dd tjtdt}d|j j v}tdd|y #t$r!}tdd d t|Yd }~d }~wwxYw#t$r!}tdd d t|Yd }~d }~wwxYw#t$r!}tddd t|Yd }~y d }~wwxYw)zTest Phase 4 invoice featuresrz$PHASE 4 TESTS - Invoice Enhancementsr /invoices/newrdue_date provider_feerzInvoice form has Phase 4 fieldszInvoice form loadsFNz'Invoice line items functionality existsTzRoutes implementedroverduezOverdue invoices detection) r+r9r:r;r<rArBr/rCr)rD has_due_datehas_provider_feerE has_overdues r test_phase4rpsQ - 01 &M@;;(=9?;S!X]]%8%8%:: )X]]-@-@-BB_O_` UDdL`a H;;(95;O8==#6#6#88 7E @/A??@ UDeSQRVTTU H7AGGHsIA+C*DA E* D3DD E D<<E E. E))E.c  tdtdtd tjtdt}t dd|j dk( tjtd t}t dd |j dk( t}|jd j}|j|rBtjtd|dt}t dd|j dk(nt ddd d t}|jdj}|j|rBtjtd|dt}t dd|j dk(nt ddd d trdtvr td}nOt}|jdj}|j|st ddd dy |d}tjtd|t}|j dv}t dd|d|j  t}|jd j}|j|r|d}tjtd|t}d|jjvxr:d|jjvxsd |jjv} t dd!| nt dd!d d tjtd"t}t dd#|j dk( t}|jd$j} |j| rQtjtd%| dd&t}t dd'|j dk(d|j y t dd'd d(y #t$r"}t ddd t|Yd }~d }~wwxYw#t$r"}t dd d t|Yd }~d }~wwxYw#t$r"}t ddd t|Yd }~ud }~wwxYw#t$r"}t ddd t|Yd }~d }~wwxYw#t$r"}t ddd t|Yd }~d }~wwxYw#t$r"}t dd!d t|Yd }~d }~wwxYw#t$r"}t dd#d t|Yd }~d }~wwxYw#t$r!}t dd'd t|Yd }~y d }~wwxYw))zTest Phase 5 featuresrz!PHASE 5 TESTS - Advanced Featuresr/tasksrrzTasks list page loadsr2FN /tasks/newzCreate task form loadsSELECT id FROM cases LIMIT 1z /tasks/new/rz Create task from case form loadszNo cases foundrz/tasks/new/appointment/z'Create task from appointment form loadsrrpSELECT id FROM invoices LIMIT 1z#Create task from invoice form loadsNo invoices found in databasez/tasks/new/invoice/rr/cases/rz upload reportreportz$Case view has reports upload sectionrrSELECT id FROM reports LIMIT 1 /reports/rzReport print view loadsNo reports found in database)r+r9r:r;r<r/r=rCrrrrr{r~rArB) rDrErcaserrpinvoicer rfhas_reports_sectionr s r test_phase5rs) - -. &MC;;(62O;L2H4H4HC4OP D;;(:6;P3X5I5IS5PQ N}||:;DDF {{hZ{4:,#GQ`{aH XA8CWCW[^C^ _ XA5JZ [ U}ll#HIRRT  {{hZ/F{SWGXFY#Zds{tH XH(J^J^beJe f XH%Qh i Q 2"<0J=Dll#DENNPG JJL#H%Qpq J;;(+>zlKUd;e%%3@&HU]UiUiTjJkl R}||:;DDF 4jG{{hZwwi#@/{ZH"+x}}/B/B/D"D#Y/]e]j]j]p]p]rJrKXv~CKCPCPCVCVCXwX  XEGZ [ XEuN^ _ E;;(84o;N4h6J6Jc6QR E}>?HHJ {{hZyf#MWf{gH X8(:N:NRU:UYabjbvbvawWx y X8%A_ `s C2E3q6BBC D3UCFCCD N=uc!fMMN UDeSQRVTTU* Q@%QPPQ RA5#a&QQR E4eSVDDE E4eSVDDEsS99S> T, T''T,/ U8UU V&VVc tdtdtd tjtdt}d|j vxsd|j j v}d|j vxsd |j j v}d |j j vxsd |j j v}td d |xr|xr| tjtdt}d|j vxsAt|j jDcgc]}d|vs d|vsd|vs|c}dkD}td d| tjtdt}d|j j vxsd|j j v}d|j j vxr:d|j j vxrd|j j v}td d|xr| trdtvr td} nOt} | jdj} | j!| std ddd y| d!} tjtd"| t}|j"d#v} |j"d$k(rtd%|j j vxs:d&|j j vxsd'|j j v} td d| d(|j"ntd dd)d*|j"d+ trd,tvr td,}nOt} | jd-j}| j!|std d.dd/y|d!}tjtd0|t}|j"d$k(} td d.| d(|j"d1 trld,tvrdtd,}td2}t} | jd3|fj}| j!|std d4dd5y|d6}nYt} | jd7j}| j!|std d4dd/y|d!}|d2}|d6}d8t$}tjtd0|d9t}|j"d$k7rtd d4dd:|j"yt} | jd;|fj}| jd<|fj}| j!|r|d=nd>t$}|r|d?n!t'j(j+}|r|d@ndAt$}|||dB|dC}tj-td0|d9|td)D}dEdl}|j0dFt} | jdG||fj}| j!td d4|dudH|rdIndJdK|r?t} | jdL||f| j3| j!yy#t$r"}td d dt|Yd}~d}~wwxYwcc}w#t$r"}td ddt|Yd}~d}~wwxYw#t$r"}td ddt|Yd}~d}~wwxYw#t$r"}td ddt|Yd}~d}~wwxYw#t$r"}td d.dt|Yd}~d}~wwxYw#t$r!}td d4dt|Yd}~yd}~wwxYw)MzTest features implemented todayrzTODAY'S FEATURES TESTSr /lawyers/newrz name="email"z lawyer.*emailz name="fax"faxassistant_name assistantrz0Lawyer form has email, fax, and assistant fieldsFNrrrMLECEz&Case form loads service codes from CSVrrrr vancouverz,Case form has service location city dropdownrmrrrrrrr2rrrrTrrrfz SELECT c.id, c.claimant_id FROM cases c WHERE c.claimant_id IS NOT NULL LIMIT 1 z'Case view has last name history sectionzNo cases with claimants foundr z* (section may be empty if no name changes)rQz,SELECT last_name FROM claimants WHERE id = ?z+Name change tracking creates history recordzClaimant not found last_namez SELECT c.id, c.claimant_id, cl.last_name FROM cases c JOIN claimants cl ON c.claimant_id = cl.id WHERE c.claimant_id IS NOT NULL LIMIT 1 TEST_NAME_CHANGE_rzCannot access edit page: z;SELECT file_case_id, file_open_date FROM cases WHERE id = ?z-SELECT first_name FROM claimants WHERE id = ? file_case_idrarrrHrb)rrrrrr5rg?zr SELECT * FROM claimant_name_history WHERE claimant_id = ? AND new_last_name = ? zHistory record foundz not foundz after name changez/UPDATE claimants SET last_name = ? WHERE id = ?)r+r9r:r;r<rArBr/rCrlensplitr~rrrr{r=rwrryr(r>timesleeprz)rD has_emailhas_fax has_assistantrExrr has_citiesrmrrrrrfrrQ old_claimantold_namenew_name existing_caseexisting_claimantrrr edit_datar#historys rtest_todays_featuresr1s - "# &M_;;(<8/;R"hmm3_(--J]J]J_7_ (--/Q5HMM.9IJTc;d'':5   3 &!)X]]-@-@-B!B"ShRZR_R_ReReRgFg"Sky~F~K~K~Q~Q~SlS  Y SUgkst|uIuItJjK L Y SUY]st|uIuItJJf\g h V i/ *G=D<<!   JJL$MuVuv4jG;;(77)^3 [3[..[36[;; \&\!!\&) ]2]] ^ ]==^ ^0^++^03 _<__c Ttdtdtdtjjitd}d}d}tj D]W\}}||dz }||dz }|d|d|d|dz|d|dzdkDr|d|d|dzz dzd d nd d |d |<Y||||z||zdkDr|||zz dzd d nd d|d d<dt d}t|d5}tj||ddddtdtdtdtd|d||zd|d dddtd|d j D]:\}}|dk7s td|jd|dd|dd |dd <td!|t|}dt d"} t| d5}|j|dddtd#| |S#1swYxYw#1swY%xYw)$z"Generate comprehensive test reportrzTEST REPORT GENERATIONr)r#summarydetailsrr r dz.1f%z0%)r r total success_rater3) total_passed total_failed total_testsr8overall test_report_z.jsonw)indentNz TEST SUMMARYz Overall: rz tests passed (r8)z By Phase:r%r&r7z passed (u 📄 Detailed report saved to: z.htmlu📄 HTML report saved to: ) r+rr'r(r)itemsrwopenjsondumpuppergenerate_html_reportwrite) r r9r:r,results report_filefr3 html_report html_files rgenerate_reportrNs - "# &M\\^--/F LL&,,. w)) )) h'h'X&)::nuv~nCJKSCToTXYnY 1WX5FQYIZ5Z [^a acfgghi_c $ y%  %$#l2[gjv[vz{Z{LL<,GH3NPSTTUVBF $F9i ! 06K k3 '1 &!A&' - . &M K ~Q|l'B&C?SYZcSdenSop~SSAAB CD - +113sw I  Bu{{}oR(9':!GG Vera Medical CRM - Test Report

Vera Medical CRM - Comprehensive Test Report

Generated: r#z

Total Tests

r3r<r;z

Passed

r9z

Failed

r:z

Success Rate

r8z)
r4r z5

PHASEzPHASE z# Tests

Passed: r z | Failed: r z

PASSr!passfailz#
z - r z r"z
zz
z
z
)rBrFreplace)r htmlr,rItest status_classs rrGrGs0k*+,% &,I%6y%A-%P$QR=>DI=Ny=YZh=iDI=Ny=YZh=i)Avv ##/.1&&*8n%5ZV ~N<@O;tI/x8QSTU   D&  D Krc jtdtdtd tjtdt}|j dk(xrd|j jv}tdd |trd tvrwd tvrmid d ddddddtdtjjddtddtddddtdddd d!d"d#d$d%d&d'd(d)td*d+d,d-t}tjtd|td./}|j dk(xr:d|j jvxsd0|j jv}tdd1||rnt}|j!d2d3td4fj#}|j%|r|d5td6<tdd7d.y;tdd7d8d9y;y;y;y;y;#t&$r!}tdd:d8t)|Yd;}~y;d;}~wwxYw)rrrr{rCr)rDhas_formrcreatedrrrEs rtest_case_creationrk3s -   &M*A;;(:6;P''3.R6X]]=P=P=R3R5x@ )3 y8P!#3"M  3N3CD  !$**,"8"8":  &);N;K'L %(9.9I&J),!L0@ "M#M $T'&~&)<^fg|r7|jd?|dd@fd?|d!ddAfd?|dBddCfd?|d6ddDfdE|ddFfg|r |jdG|ddHfdG|d!ddIfg|D]T\}}} tjt|t}|j dJv}t d||d |j Vy y #t$r#}t d|d t|Yd }~d }~wwxYw#t$r#}t d|d t|Yd }~sd }~wwxYw#t$r"}t d|d t|Yd }~d }~wwxYw)Kz%Test ALL endpoints in the applicationrzCOMPREHENSIVE ENDPOINT TESTSr))r1GETz Login page)z/logoutrmLogout)z /favicon.icormFavicon)rrm Dashboard)z/searchrmzGlobal search page)rrmz Cases list)rrmz New case form)rrmz Clients list)rrmz Lawyers list)rrmzNew lawyer form)rrmz Doctors list)z /doctors/newrmzNew doctor form)rrmzAppointments list)rrmzNew appointment form)rrmzUninvoiced appointments)rrmz Reports list)z /reports/newrmzNew report form)rrmz Invoices list)rrmzNew invoice form)rrmz Tasks list)rrmz New task form))z/api/search/casesrmzCase search API)z/api/search/clientsrmzClient search API)z/api/search/lawyersrmzLawyer search API)z/api/search/doctorsrmzDoctor search API)z /api/searchrmzGlobal search API)z/api/invoices/next_numberrmzNext invoice number API)z/api/forms/listrmzForms list API)z/api/check/claimantrmzCheck claimant APIr)r2.rrFN)r2irfrrrUrr`r doctor_idrrmrrrr rpr rv*SELECT id FROM bring_forward_tasks LIMIT 1r rmz Case viewrzCase edit formz/report/uploadz$Case report upload (POST-only route)z /api/cases/rzCase appointments APIrzCase invoices APIrz Client viewzClient edit formrzNew client contact formrzLawyer edit formrzDoctor edit formrzAppointment viewzAppointment edit formrzAppointment print viewrzAppointment additional servicesz/appointments/new/zNew appointment for caserz Report viewzReport print view /invoices/z Invoice viewzInvoice edit formz /line_itemszInvoice line itemszInvoice print viewz/invoices/new/zNew invoice from appointment/tasks/z Task viewzTask edit form)r2rqrsi)r+r9r:r;r<r=r/rCrr~rrrr{extend)static_endpoints api_endpointsendpointmethod descriptionrDr rErrfrrUrr`rrtrrmrrrr rprrvtask dynamic_viewss rtest_all_endpointsrfs] - () &M'T M*:A%&+ A{{hZz#:O{TH))_?HHJD$(d4jdGMM+. \\"BCLLNF(.t DIMM+. \\"JKTTVF(.t DIMM+. \\"BCLLNF(.t DI#'78,,'LMVVXK2=[.4NMM+. \\"BCLLNF(.t DI]]<0 ll#DENNPG*1tJ-- *<< LMVVXD$(d4jdG    7)$e[97)5)52BC7)>2E;abwi}5u>UVwiy15:MN "    YK(%?YKu-u6HIYK}5u>WX"    YKu-u6HI"    YKu-u6HI"    !.!12E;MN!.!17@WX!.!18%AYZ!.!11EFOpq%gY/8RS "    YK(%?YKv.7JK"    j\*E>Bj\/8KLj\5u>RSj\0%9MN!.!12E;YZ "    7)$e[97)5)52BC"  .; E )Hfk E";;(H:'>;X"--1EE{mfI]I]H^>_`  EW A Y;-%Q @ @ A A Y;-%Q @ @ Al E{meSVDD EsJA R" A SA T" S+S  S S=S88S= T+ T&&T+c F tdtdtdt}|jdj}|rt tj t d|dt}|jdk(xrd |jjd d v}td d |d|jntd d dd|jdj}|rt tj t d|dt}|jdk(xrd |jjd d v}td d|d|jntd ddd|jdj}|rt tj t d|dt}|jdk(xrd |jjd d v}td d|d|jntd ddd|jdj}|rt tj t d|dt}|jdk(xrd |jjd d v}td d|d|jntd ddd|jdj}|rt tj t d|dt}|jdk(xrd |jjd d v}td d|d|jntd ddd |jd!j} | rt tj t d"| dt}|jdk(xrd |jjd d v}td d#|d|jntd d#dd$|jy #t$r"}td d dt|Yd }~fd }~wwxYw#t$r"}td ddt|Yd }~d }~wwxYw#t$r"}td ddt|Yd }~|d }~wwxYw#t$r"}td ddt|Yd }~d }~wwxYw#t$r"}td ddt|Yd }~d }~wwxYw#t$r"}td d#dt|Yd }~d }~wwxYw)%z(Test all view pages for proper renderingrzVIEW PAGE TESTSrrr rrr2errorNrrzCase view page rendersrFNo cases found in databaserrzClient view page rendersNo clients found in databaserrzAppointment view page renders!No appointments found in databaser rzReport view page rendersrr rvzInvoice view page rendersr rurwzTask view page rendersNo tasks found in databaser+rrrr9r:r;r<r=rArBr/rCrr{) rrrDr rErrr rr~s rtest_all_viewsr+s -  &M =D <<6 7 @ @ BD  I{{hZwtDzl#C_{]H))S0_WHMMDWDWDYZ^[^D_5_F Y 8&HXMaMaLbBc d 4e=YZ\\: ; D D FF  K{{hZy#GQ`{aH))S0_WHMMDWDWDYZ^[^D_5_F Y :FhxOcOcNdDe f 6?]^,,DENNPK P{{hZ~k$>O=P#Q[j{kH))S0_WHMMDWDWDYZ^[^D_5_F Y ?8T\ThThSiIj k ;UDgh\\: ; D D FF  K{{hZy#GQ`{aH))S0_WHMMDWDWDYZ^[^D_5_F Y :FhxOcOcNdDe f 6?]^ll<=FFHG L{{hZz'$-#ISb{cH))S0_WHMMDWDWDYZ^[^D_5_F Y ;VxPXPdPdOeEf g 7@_` <<D E N N PD  I{{hZwtDzl#C_{]H))S0_WHMMDWDWDYZ^[^D_5_F Y 8&HXMaMaLbBc d 4e=YZJJLC I Y 8%Q H H I K Y :E3q6 J J K P Y ?A O O P K Y :E3q6 J J K L Y ;UCF K K L I Y 8%Q H H IsA2P1A2P=A2Q+7A2RA2S=A2S5 P:P55P:= Q(Q##Q(+ R4RR S"R??S S2S--S25 T >TT c >tdtdtdt}|jdj}|r tj t d|ddt}|jd k(xr[d |jjd d vxr:d |jjvxsd|jjv}tdd|d|jntdddd|jdj}|r tj t d|ddt}|jd k(xr[d |jjd d vxr:d |jjvxsd|jjv}tdd|d|jntdddd|jdj}|r tj t d|ddt}|jd k(xr[d |jjd d vxr:d |jjvxsd|jjv}tdd|d|jntdddd|jdj}|r tj t d|ddt}|jd k(xr[d |jjd d vxr:d |jjvxsd|jjv}tdd|d|jntdddd|jd j}|r tj t d!|ddt}|jd k(xr[d |jjd d vxr:d |jjvxsd|jjv}tdd"|d|jntdd"dd#|jd$j} | r tj t d%| ddt}|jd k(xr[d |jjd d vxr:d |jjvxsd|jjv}tdd&|d|jntdd&dd'|jd(j} | r tj t d)| ddt}|jd k(xr[d |jjd d vxr:d |jjvxsd|jjv}tdd*|d|jntdd*dd+|jy #t$r"}tdddt|Yd }~wd }~wwxYw#t$r"}tdddt|Yd }~d }~wwxYw#t$r"}tdddt|Yd }~d }~wwxYw#t$r"}tdddt|Yd }~ad }~wwxYw#t$r"}tdd"dt|Yd }~d }~wwxYw#t$r"}tdd&dt|Yd }~d }~wwxYw#t$r"}tdd*dt|Yd }~Kd }~wwxYw),z%Test CRUD operations for all entitiesrzCRUD OPERATIONS TESTSrz*SELECT id, file_case_id FROM cases LIMIT 1r rrrr2rNrforminputrzCase edit form loadsrFrrrzClient edit form loadsrrrzLawyer edit form loadszNo lawyers found in databaserrzDoctor edit form loadszNo doctors found in databaserrzAppointment edit form loadsrr rvzInvoice edit form loadsr rurwzTask edit form loadsrr) rrrDr rErrrrrr~s rtest_crud_operationsrs - !" &M =D <<D E N N PD  G{{hZwtDzl%#HRa{bH))S0jWHMMDWDWDYZ^[^D_5_jekowo|o|pCpCpEfEfiIPT\TaTaTgTgTiIiF Y 6(8K_K_J`@a b 2E;WX\\: ; D D FF  I{{hZye#LVe{fH))S0jWHMMDWDWDYZ^[^D_5_jekowo|o|pCpCpEfEfiIPT\TaTaTgTgTiIiF Y 8&HXMaMaLbBc d 4e=[\\\B C L L NF  I{{hZye#LVe{fH))S0jWHMMDWDWDYZ^[^D_5_jekowo|o|pCpCpEfEfiIPT\TaTaTgTgTiIiF Y 8&HXMaMaLbBc d 4e=[\\\: ; D D FF  I{{hZye#LVe{fH))S0jWHMMDWDWDYZ^[^D_5_jekowo|o|pCpCpEfEfiIPT\TaTaTgTgTiIiF Y 8&HXMaMaLbBc d 4e=[\,,DENNPK N{{hZ~k$>O=PPU#V`o{pH))S0jWHMMDWDWDYZ^[^D_5_jekowo|o|pCpCpEfEfiIPT\TaTaTgTgTiIiF Y =vRZRfRfQgGh i 95Befll<=FFHG J{{hZz'$-#NXg{hH))S0jWHMMDWDWDYZ^[^D_5_jekowo|o|pCpCpEfEfiIPT\TaTaTgTgTiIiF Y 96XhNbNbMcCd e 5u>]^ <<D E N N PD  G{{hZwtDzl%#HRa{bH))S0jWHMMDWDWDYZ^[^D_5_jekowo|o|pCpCpEfEfiIPT\TaTaTgTgTiIiF Y 6(8K_K_J`@a b 2E;WXJJL[ G Y 6s1v F F G I Y 8%Q H H I I Y 8%Q H H I I Y 8%Q H H I N Y =uc!f M M N J Y 95#a& I I J G Y 6s1v F F GsB/Y.B/Z B/Z9.B/['B/\.B/]B/]1 Z&ZZ Z6Z11Z69 [$[[$' \0\  \ ]\;;] ]. ]))].1 ^:^^c@ttty)z*Wrapper for comprehensive endpoint testingN)rrrrrtest_endpointsrsrctdtdtdtdttdttt s tdt j dtats tdtttttttt!t#t%}ttdtd td|d d d d kDrt j dyt j d y)z Run all testsrz+VERA MEDICAL CRM - COMPREHENSIVE TEST SUITEz Test Run: z Base URL: u❌ Failed to login. Exiting.r$u@⚠️ Warning: Test data creation failed. Some tests may fail.rzTEST SUITE COMPLETEr3r<r:rN)r+rwr;rrFsysexitrr~rrrkrrrrr1rrN)r s rmainrs &M 78 &M J~& '( Jxj !" 7 -.  !"I  PQNMMMMM F -   &Mi#N3a7    r__main__)rT),__doc__requestsrosrr#rrrrDr;rr?r@r<r'strftimerwSessionr9rr)r~rr/rFrrrrrrrrr1rNrGrkrrrrr__name__rrrrsV  ..  # $  ((9 (   !a"5a"5a"5a"5a"5q26    6".B+/beMV6OxTJtWHHDeEVhZ\8tH\1AfCEJRh^@ /b zFr