<?php
require __DIR__.'/NativeGate.php';$n=0;
foreach(['INSERT INTO ydy_staff (uuid) VALUES (?)','UPDATE ydy_staff SET name=?','DELETE FROM ydy_staff','CALL BAD(?)','SELECT * INTO OUTFILE \'a\' FROM ydy_staff','SELECT * FROM yoshop_staff','SELECT * FROM ydy_staff FOR UPDATE','SELECT * FROM ydy_staff; DELETE FROM ydy_staff','SELECT * FROM ydy_staff -- comment','SELECT * FROM remote.ydy_staff']as $sql){$thrown=false;try{NRGate::sql($sql);}catch(Throwable $e){$thrown=true;}if(!$thrown)throw new RuntimeException('False gate green');$n++;}
foreach(['SELECT * FROM ydy_staff WHERE uuid=?','SELECT a.uuid,c.energy FROM ydy_menu_recommend a LEFT JOIN ydy_date_menu b ON b.recommend_uuid=a.uuid LEFT JOIN ydy_dishes c ON b.dishes_uuid=c.uuid','SHOW FULL COLUMNS FROM ydy_staff','CALL SP_TABLEDEF(?, ?)']as $sql){NRGate::sql($sql);$n++;}
foreach([[1=>['value'=>'ZHCT_APP','type'=>2],2=>['value'=>'YDY_STAFF','type'=>2]],[1=>['value'=>'ZHCT_APP','type'=>2],2=>['value'=>'YDY_DATE_MENU','type'=>2]]]as $binds){NRGate::callBinds('CALL SP_TABLEDEF(?, ?)',$binds);$n++;}
foreach([[1=>['value'=>'LOCAL','type'=>2],2=>['value'=>'YDY_STAFF','type'=>2]],[1=>['value'=>'ZHCT_APP','type'=>1],2=>['value'=>'YDY_STAFF','type'=>2]],[1=>['value'=>'ZHCT_APP','type'=>2],2=>['value'=>'YDY_USER','type'=>2]]]as $binds){$t=false;try{NRGate::callBinds('CALL SP_TABLEDEF(?, ?)',$binds);}catch(Throwable $e){$t=true;}if(!$t)throw new RuntimeException('Metadata gate false green');$n++;}
echo json_encode(['gate_assertions'=>$n,'passed'=>true]),"\n";