U%j) hdZddlmZddlZddlZddlZddlmZddlm Z e e jjZ e dz Ze dz Ze dz Ze d z Zgd Zgd Zgd Zd dddddddd ZdZgdZdZdZd&dZd'dZd(dZd)dZd*dZd+dZd,dZ d,d Z!d,d!Z"d-d"Z#d-d#Z$d.d$Z%e&d%k(re%yy)/z7Validate the EQIX quarterly-results production package.) annotationsN)Decimal)Pathzextract_eqix_quarterly.pyzeqix_source_manifest.csvz eqix_rows.csvzeqix_verification_report.md)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)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-loop01/artifacts/validate_eqix_quarterly.pyfailr8Ls  !!c|jdd5}ttj|cdddS#1swYyxYw)Nutf-8)newlineencoding)openlistcsv DictReader)pathhandles r7read_csvrEPs: 2 0,FCNN6*+,,,s <Ac|jddjddjddjddjddjddjddj}t|S) N,r;$()~GWMW)replacestripr)valuecleaneds r7numberrRUsq c2 b  b  b  b  r  r    7 r9c|jtstd||jt fdt Drtd|yy)Nznon-primary URL prefix: c3&K|]}|v ywr4).0markerlowereds r7 z'validate_primary_url..gs =6W  =szsecondary source rejected: ) startswithPRIMARY_URL_PREFIXESr8loweranySECONDARY_MARKERS)urlrXs @r7validate_primary_urlr`csO >>. / 'u -.iikG =+< == *3% 01>r9cg}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 changedrz#manifest period coverage mismatch: rEQIXzunexpected manifest company: r.r1r2z,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) lenr8r@keysMANIFEST_FIELDSEXPECTED_PERIODSr\r`append) manifest_rowschecksrowperiodss r7validate_manifestrnks0F =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)!Nrrz5row count must be 24 (8 quarters x 3 metrics); found rzexactdirectpartialzbad snippet support status: r>highmediumzbad confidence label: z metrics/order mismatch: rrr 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) rer8r@rfREQUIRED_FIELDSrhrir`itemsEXPECTED_METRICSvalidate_capexvalidate_pipelinevalidate_revenue) rowsrjrkrlmanifest_periods manifest_urlsr by_periodfield period_rowsmetricss r7 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)Nrractual_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 z: rrz, capex lacks required source-period context c3>K|]}|dvxs|dvyw)rrNrU)rVrWrls r7rYz!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_CAPEXr8rRrr]CUMULATIVE_CAPEX_MARKERSr\)rlrexpected_valueexpected_derivedrequired_contexthas_cumulative_markers` r7r{r{s ]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"r9c|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 >rMprojectsz:pipeline unit must be projects or explicitly caveated MW: rMr 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: r8rRr)rls r7r|r|s  $@@ 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 Er9c |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)rlexpecteds r7r}r}s  $== 0 67 6{n$ EcU KLc+&''$-7H6#0122 A# GH#3x=8=X`cdl`m=m 4SE :;>n8r9ctjd}|jddkr tddD]}||vstd|dgS) Nr<)r>z**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_textcountr8)texttokens r7validate_reportrsg   W  -D zz%&* JK 9   /w7 8 9 X XXr9cTtjtjt t gt dtt}tt}g}|jt||jt|||jt|S)NT)cwdcheck) subprocessrunsys executablestr EXTRACTORBASE_DIRrEMANIFESTROWSextendrnrr)rjr~rks r7validaterspNNCNNC N3NX&M D>DF MM#M23 MM-m45 MM/#$ Mr9cXt}td|D]}td|y)Nz'PASS: EQIX quarterly package validates.z - )rprint)rkrs r7mainr s/ ZF 34 UGnr9__main__)r6rreturnNone)rCrrlist[dict[str, str]])rPrrr)r_rrr)rjrr list[str])r~rrjrrr)rlzdict[str, str]rr)rr)rr)'__doc__ __future__rrArrdecimalrpathlibr__file__resolveparentrrrrrrxrhrzrrrgr[r^r8rErRr`rnrr{r|r}rrr__name__rUr9r7rs="   > ! ! # * * 2 2 0 0/! 1 1&TV 2 2 2 2 / 1 ; 3 \  ", 2*1hN: C <Y$ zFr9