<?php
declare(strict_types=1);
require __DIR__.'/common.php';$db=smPdo();$dm=getenv('SM7_LANE')==='C';
$meta=smRows($db,$dm?"SELECT COLUMN_NAME,DATA_TYPE,DATA_SCALE,NULLABLE FROM USER_TAB_COLUMNS WHERE TABLE_NAME='YDY_EQUIPMENT_VERSION' AND COLUMN_NAME='CREATE_TIME'":"SELECT COLUMN_NAME,DATA_TYPE,DATETIME_PRECISION,IS_NULLABLE FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='ydy_equipment_version' AND COLUMN_NAME='create_time'");
$responses=smLoad('responses-private.json');$counts=['length19'=>0,'zero_fraction'=>0,'nonzero_or_unknown'=>0];
foreach(['VERSION_LIST','VERSION_PAGE2','VERSION_READ'] as $name){$data=$responses[$name]['body']['data'];$rows=$name==='VERSION_READ'?[$data]:$data['row'];foreach($rows as $r){$v=$r['create_time'];if(is_string($v)&&preg_match('/^\d{4}-\d{2}-\d{2} \d{2}:\d{2}:\d{2}$/D',$v)){$counts['length19']++;}elseif(is_string($v)&&preg_match('/^\d{4}-\d{2}-\d{2} \d{2}:\d{2}:\d{2}\.0{1,6}$/D',$v)){$counts['zero_fraction']++;}else{$counts['nonzero_or_unknown']++;}}}
$out=['lane'=>getenv('SM7_LANE'),'source_datetime'=>$meta,'wire_counts'=>$counts,'database_writes'=>0,'new_http'=>0];smSave('version-date-metadata-private.json',$out);echo json_encode($out),PHP_EOL;