%j5 dZddlmZddlZddlZddlZddlZddlmZddl m Z e e jjZedz Zedz Zedz Zed z Zed z Zed z Zgd Zgd ZgdZddddddddd ZdZgdZgdZdZdZd+dZd,dZd-dZ d.dZ!d/d Z"d0d!Z#d1d"Z$d1d#Z%d1d$Z&d2d%Z'd3d&Z(d4d'Z)d2d(Z*d5d)Z+e,d*k(re+yy)6z7Validate the EQIX quarterly-results production package.) annotationsN)Decimal)Pathzextract_eqix_quarterly.pyeqix_source_manifest.csv eqix_rows.csvzeqix_verification_report.mdzeqix_verification_samples.csvzeqix_validation_summary.json)companyperiod metric_name raw_valuenormalized_valueunitvalue_qualifierownership_basisforecast_or_actual is_derived source_urlsource_locationsource_snippetsnippet_support_status confidencecaveat)2Q243Q244Q241Q252Q253Q254Q251Q26) capex_actualsfuture_capacity_pipelinerevenue_conversion)648falseThree Months Ended)724r$r%)987r$r%)750r$r%)989trueSix Months Ended)1136r*Nine Months Ended)1436r$zTotal Capital Expenditures)1256r$r%)r+r-zTwelve Months Ended)rr source_type source_familyrstable_locationexpected_tables_sections basis_caveats) sample_idrr r r r r check_typerrrverdictrr)z%https://d1io3yog0oux5.cloudfront.net/zhttps://investor.equinix.com/zhttps://www.sec.gov/)zdatacenterdynamics.comzdatacenterfrontier.comzsemianalysis.comzthebuildout.comz wikipedia.orgct|N)AssertionError)messages n/home/dev/research_loop/runs/auto-continue-20260607T140730Z-repair-loop02/artifacts/validate_eqix_quarterly.pyfailr=_s  !!c|jdd5}ttj|cdddS#1swYyxYw)Nutf-8)newlineencoding)openlistcsv DictReader)pathhandles r<read_csvrJcs: 2 0,FCNN6*+,,,s <Ac|jddjddjddjddjddjddjddj}t|S) N,r@$()~GWMW)replacestripr)valuecleaneds r<numberrWhsq c2 b  b  b  b  r  r    7 r>c|jtstd||jt fdt Drtd|yy)Nznon-primary URL prefix: c3&K|]}|v ywr9).0markerlowereds r< z'validate_primary_url..zs =6W  =szsecondary source rejected: ) startswithPRIMARY_URL_PREFIXESr=loweranySECONDARY_MARKERS)urlr]s @r<validate_primary_urlrevsO >>. / 'u -.iikG =+< == *3% 01>r>cg}t|dk7rtdt||r.t|djtk7r td|Dcgc]}|d }}|t k7rtd||D]p}|ddk7rtd ||d r |d r|d std ||ddvr&d|d j vrtd|dt|dr|jd|Scc}w)Nz.manifest must have one row per quarter; found rzmanifest field order changedr z#manifest period coverage mismatch: rEQIXzunexpected manifest company: r0r3r4z,manifest missing required provenance field: >rr cumulativez.manifest must flag cumulative capex basis for rzEmanifest has 8 primary-source rows with period-specific basis caveats) lenr=rEkeysMANIFEST_FIELDSEXPECTED_PERIODSrareappend) manifest_rowschecksrowperiodss r<validate_manifestrs~s0F =Q =c->P=Q RSmA.3356/I +,(56s8}6G6"" 27) <=0 y>V # 06 7=!-G)HPSTcPd ?uE F x=, ,SEYE_E_Ea1a A#h-Q RS./0 MMYZ M7s D c g}|Dchc]}|d }}|Dchc]}|d }}t|dk7rtdt||r.t|djtk7r tdt Dcic]}|g}}|D]}|d|vrtd|d||dj |tD]%}||dk(s td |d |dd |d '|d dk7rtd||d|vrtd|dt|d|d|vrd|dvrtd|d|ddvrtd||ddvstd||jD]1\}} | Dcgc]}|d  } }| tk7s"t|d| 3|D]O}|d dk(r t||d dk(r t|+|d dk(r t|?td|d Q|j d|j d|j d |Scc}wcc}wcc}wcc}w)!Nr rz5row count must be 24 (8 quarters x 3 metrics); found rzexactdirectpartialzbad snippet support status: r>highmediumzbad confidence label: z metrics/order mismatch: r r!r"zunexpected metric: zJcanonical output has 24 rows, 8-quarter coverage, and required field orderz4capex rows pass quarterly-vs-cumulative basis checksz:metric units and bases are separated with retained caveats) rjr=rErkREQUIRED_FIELDSrmrnreitemsEXPECTED_METRICSvalidate_capexvalidate_pipelinevalidate_revenue) rowsrorprqmanifest_periods manifest_urlsr by_periodfield period_rowsmetricss r< validate_rowsrsF1>?#H ??2?@3S&@M@ 4yB DSYK PQ T!W\\^$7 KLK[1\&"*1\I1\1 x= ) *3x=/: ;#h- '',$ QE5zRxwd3x=/3};M:NOP Q y>V # +C51 2 x= 0 0 4S]OD ES./ | M 16MUXYeUf6f RSVWcSdRef g ' (0N N /u5 6 | $6 6 )#/ 0%1( )0@ 1<=#3}%== & & F84WI> ?@ = }  0 3   #= = c "  #7 7 S ! &s='9&:; <= MM^_ MMHI MMNO M_@@2],>s I I  I Icd}t|\}}}ddk7rtdddk7rtddd k7rtd td td k7rtd td t|k7rt|d|dd d|k7rt|d|d|dvr|dvrt|d|dt fdt D}|rddk7r|dk7rtdddk(r%ddj vrtdyyy)Nr ractual_capex_spendz&capex not classified as actual spend: r USD_millionszcapex unit mismatch: r consolidated_company_capex_tablezcapex basis mismatch: r r zcapex raw/normalized mismatch: z capex expected quarterly value z, found rz capex derived flag should be : rrz, capex lacks required source-period context c3>K|]}|dvxs|dvyw)rrNrZ)r[r\rqs r<r^z!validate_capex..s7   #'((KFc:J6K,KK sr*rzHcumulative capex source cannot be used as non-derived quarterly actual: lessz7derived capex row lacks arithmetic support in snippet: )EXPECTED_CAPEXr=rWrrbCUMULATIVE_CAPEX_MARKERSra)rqr expected_valueexpected_derivedrequired_contexthas_cumulative_markers` r<rrs ]F9G9O6N$&6  $88 5cU ;< 6{n$ $SE *+ !CC %cU +, c+6#.@*A#BB .se 45 c$%&'.*AA x77GxPSTfPgOh ij <,, x56F5Gr# OPs#455:JRUVfRg:g xCDTCUUWX[W\ ]^ . \!2f!<6AQ WX[W\ ]^ <F"vS9I5J5P5P5R'R Fse LM(S"r>c|ddk7rtd||ddvrtd||ddk(rk|dd k7rtd |d |d vrd |d vrtd|t|dtdzt|dk7rtd|yyt|dt|dk7rtd|yy)Nrforecast_pipeline_estimatez2pipeline row not classified as forecast estimate: r >rRprojectsz:pipeline unit must be projects or explicitly caveated MW: rRr approximatez%MW pipeline row must be approximate: znot MW live capacityrznot live energized capacityz,MW pipeline row lacks live-capacity caveat: r r z!GW to MW normalization mismatch: z,project-count pipeline conversion mismatch: r=rWr)rqs r<rrs  $@@ A# GH 6{,, I# OP 6{d  !] 2 8> ? !X 6;X`cdl`m;m ?uE F #k" #gdm 3vcBT>U7V V 4SE: ; W K !VC0B,C%D D ;C5 AB Er>c |ddk7rtd||ddk7rtd|t|dtdz }|t|d k7rtd |d |d vrd |d vrtd|yyy)Nractual_reported_quarterz!revenue classification mismatch: r USD_billionsz6revenue unit should be USD_billions after conversion: r rr z2revenue millions-to-billions conversion mismatch: znormalized to USD billionsrzsummary uses USD billionsz%revenue row lacks conversion caveat: r)rqexpecteds r<rrs  $== 0 67 6{n$ EcU KLc+&''$-7H6#0122 A# GH#3x=8=X`cdl`m=m 4SE :;>n8r>ctjd}|jddkr tddD]}||vstd|dgS) NrArCz**Primary snippetz;verification report must sample at least 3 primary snippets)zSample AzSample BzSample CzSample DzCumulative capex controlz=2,875 is a 9M cumulative PP&E value, not 3Q25 quarterly capexzProduction gate statuszverification report missing zIverification report documents cumulative capex control and source samples)REPORT read_textcountr=)texttokens r<validate_reportrsg   W  -D zz%&* JK 9   /w7 8 9 X XXr>c tt}t|dkrtdt||rKt |dj t k7r(tdt |dj |Dchc]}|d|d|d|d|d f}}d}d}|D]}t D]}||d k(s td |d |t|d |d|d|d|d|d f}||vrtd||ddk(r|dz }n|ddk(r|dz }ntd||ddvstd|dt|d|dgScc}w)N z7verification CSV needs at least 12 sampled rows, found rz'verification CSV field order mismatch: rr r r r r@zverification sample missing rrz4verification sample does not match a canonical row: r7PASSFAILz)verification sample has invalid verdict: r>r{r|z,verification sample has invalid confidence: zverification CSV has z# samples with required columns and z pass verdicts)rJSAMPLESrjr=rErk SAMPLE_FIELDSre) rsamplesrqrow_keys pass_count fail_countsamplerkeys r<validate_samplesrswG 7|b Fs7|n UV4 )*m; 6tGAJOO1TU_T``n o pp;sEc tt}td|D}td|D}ddt|||dd|dk(rdndd d d d d dd|d}tj t j|ddzdy)Nc32K|]}|ddk(s dyw)r7rrNrZr[rs r<r^z write_summary..;L6y0AV0KQL c32K|]}|ddk(s dyw)r7rrNrZrs r<r^z write_summary..<rrrhz,auto-continue-20260607T140730Z-repair-loop02zvalidate_eqix_quarterly.pyrrr)scriptexpected_exit_codestatusrrrur)canonical_rows_file manifest_file row_countmetrics_per_periodrequired_fields)rrunsampled_row_countrr validator row_packagerp)indent rAr)rJrsumrjSUMMARY write_textjsondumps)rprrrsummarys r< write_summaryr9swGLWLLJLWLLJ= \  2"# *afV $37"#!  %G( tzz'!4t;gNr>ctjtjt t gt dtt}tt}g}|jt||jt|||jt|jt|t||S)NT)cwdcheck) subprocessrsys executablestr EXTRACTORBASE_DIRrJMANIFESTROWSextendrsrrrr)rorrps r<validaterTsNNCNNC N3NX&M D>DF MM#M23 MM-m45 MM/#$ MM"4()& Mr>cXt}td|D]}td|y)Nz'PASS: EQIX quarterly package validates.z - )rprint)rprs r<mainras/ ZF 34 UGnr>__main__)r;rreturnNone)rHrrlist[dict[str, str]])rUrrr)rdrrr)rorr list[str])rrrorrr)rqzdict[str, str]rr)rr)rrrr)rprrr)rr)-__doc__ __future__rrFrrrdecimalrpathlibr__file__resolveparentrrrrrrrr}rmrrrrlrr`rcr=rJrWrersrrrrrrrrr__name__rZr>r<rs5="   > ! ! # * * 2 2 0 0/! 1 1 4 4 3 3&TV 2 2 2 2 / 1 ; 3 \   ", 2*1hN: C <Y$$qNO6  zFr>