G%j.VddlZddlZddlmZeej j Zedz Zedz Z iddddd d d d d dddddddddddddddddddd d!d"d#d$d%d&d'd(Z gd)Z d*d+hZ hd,Z hd-Zd.Zd/Zd2d0Zed1k(rej&eyy)3N)Pathzcompany_source_manifest.csvzcompany_metric_map.yamlORCLOracleMSFT MicrosoftAMZNAmazonGOOGLAlphabetMETAzMeta PlatformsCRWV CoreWeaveDLRzDigital RealtyEQIXEquinixIRMz Iron MountainAPLDzApplied DigitalCORZzCore ScientificIRENWULFTeraWulfCIFRz Cipher MiningHUTzHut 8NBISNebiusNVDANVIDIAVertivEaton)VRTETN) companyticker source_role source_family source_urlstable_locationextractable_metricscadence basis_caveatsextraction_difficultynotesprimarysecondary_discovery>lowhighmedium> rpo_backlog book_to_bill capex_actuals live_capacity secured_powercapacity_addedcapex_guidanceequipment_orderssource_discoverylease_commitmentsrevenue_conversionpreleased_percentageconstruction_underwaydata_center_commentaryfuture_capacity_pipelinecloud_capacity_commitmentsexpected_commencement_windowc&|j|y)N)append)errorsmessages f/home/dev/research_loop/runs/next3-task2-source-manifest/artifacts/validate_company_source_manifest.pyfailrHEs MM'c 2g}tjst|dtjtjst|dtj|r t |Stj d}tD]}d|d|vs t|d|tjdd5}ttj|}dddst|d t |Sttt|d z }|rt|d t|tDcic]}|d }}t}d } t!|d D]\} } tD]5} | j#| dj%r$t|d| d| 7| j#dd}| j#dd} |dk7r|tvrt|d| d|| t&vrt|d| d| | j#dt(vr!t|d| d| j#d| j#ddj+dst|d| d| j#ddj-dDcgc]#}|j%s|j%%}}|st|d| d|D]3}|dk7r|tvrt|d| d|d|j/|5| d k(r||vr ||xxd!z cc<| d"k(s| d!z } d#| j#d$dj1vst|d| d%|j3Dcgc] \}}|d k(s |}}}|rt|d&|| d k(r t|d't5|d(krt|d)t5|t |t5|t5|t5|*S#1swYxYwcc}wcc}wcc}}w)+Nzmissing zutf-8)encodingz :zmetric map missing )newlinerKzmanifest has no rowsrzmissing columns: )startzrow z : missing r#r$ALLz: unexpected ticker z: invalid source_role r+z : invalid extraction_difficulty r&zhttps://z: source_url must be httpsr(;z: no extractable metricsr:z : metric z missing from metric mapr-r. secondaryr,z2: secondary row must be labeled secondary in notesz!missing primary source rows for: z-expected at least one secondary_discovery row&z(expected at least 38 manifest rows, got )rowstickersmetrics)MANIFESTexistsrHname METRIC_MAPreport read_textREQUIRED_METRICSopenlistcsv DictReadersetREQUIRED_COLUMNSsortedTARGETS enumerategetstrip ALLOWED_ROLESALLOWED_DIFFICULTY startswithsplitaddloweritemslen)rE metric_textmetricfrVmissing_columnsr#primary_by_ticker metrics_seensecondary_countirowcolrolemrXcountmissing_primarys rGmainrIs F ??  Vx /0     Vx 012 f~&&&8K"9 xq> , .vh7 89 rG 4'CNN1%&'  V+,f~*+c$q'l:O V()@(ABC189v995LOD*[3# 8C773#))+VtA3j67 82&ww}b) U?vW4 4s"6vh? @ } $ 4s"8? @ 77* +3E E 4s"B377KbCcBde fww|R(33J? 4s"<= >&)gg.CR&H&N&Ns&SaWXW^W^W`1779aa 4s":; < %F++>N0NVtA3ix7OPQ   V $ % 9 +>VtA3&XYZ5[84E3J3J3L[-&%PUYZPZv[O[ V88IJK! VDE 4y2~ V?D {KL &s4y#6G2HRUVbRc ddc'':"b\s*O< P P+P5 PP<Pc|r!td|D]}td|ytdtd|td|td|y) Nz)Company source manifest validation failedz- rSz)Company source manifest validation passedz- rows checked: z- target companies covered: z- metric labels seen: r)print)rErVrWrXerrors rGr]r]sj  9: E Bug,   56 TF #$ ( 23 "7) ,- rI__main__)rrr)rbsyspathlibr__file__resolveparentBASErYr\rgrerkrlr_rHrr]__name__exitrIrGrso  H~&& / / - -   H  K  H  Z        K     I  ?      F  J  O  7   H! " H# $  ' , 12 .*?eD   z CHHTVrI