+ #i~ Rt^RIHt^RIt^RIt^RIHt^RIt]!]4P4Pt ] R, t Rt RtRtRtR tR ] R ] R 2tR RltRRlt]R8Xd]!]!44hR#)u One-off: read vori_ishida.template.ps1, fill from gcloud, COPY to Stedi. Run from repo: python3 _deploy_vori_ishida_stedi.py (Not for committing live passwords — uses gcloud from your environment.) ) annotationsN)Pathzvori_ishida.template.ps1ztransfer.us.stedi.com20CGWNO44598zsftp-user-external-20CGWNO4-93z vori-1bdf0zsftp:///z/vori_ishida.ps1cV^8dQhRR/#)returnint)formats"M/Users/aloksubbarao/Vori/backend/airport/install/_deploy_vori_ishida_stedi.py __annotate__rs9 9 c9 c \P4p\P!RRRRRR\ 2R\ 2.RR7P 4pT'g\R \PR 7^#TPR \4PR\4PRT4PR\4p\T\\4pT'd!\RT 2\PR 7^#\ P"!4pTP%R4TP%R4TPRR4pR pR&FpTP%R4TP%RT R\ RT R\ R2 4TP%R4TP%RT.4TP%R\& R24TP%R 4\R!\)T4 R"\& R#T R$24^# Te\R%T\PR 7^# \Pd(p\R T\PR 7R p?^#R p?ii;i \*d pTpTP%R4R p?EK6R p?ii;i)'gcloudsecretsversionsaccesslatestz --secret=z --project=T)textzgcloud failed:)fileNzempty password from gcloudz {{SFTP_HOST}}z{{SFTP_USERNAME}}z{{SFTP_PASSWORD}}z {{STORE_ID}}zrefusing upload: zinstall sshfs from community;z load sshfs;'z''z!drop secret if exists sftp_stedi;zcreate secret sftp_stedi (type z , username 'z ', password 'z', scope 'sftp://z');z-create or replace table _payload (c varchar);z insert into _payload values (?);z-copy (select c as content from _payload) to 'z' (header false, quote '');zdrop secret sftp_stedi;z uploaded z bytes to z (secret type )zCOPY to Stedi failed:)sshsftp)_TPL read_text subprocess check_output_SECRET_GCPstripCalledProcessErrorprintsysstderrreplace_STEDI_USER_STORE_validate_built_ps1duckdbconnectexecute_REMOTElen Exception) tplpwecontenterrconpwsqllast type_names r mainr;s@ .. C  $ $G9%TF#    %'   *< OV, $e , $b )  (  gvu 5C  !#'cjj9 .. CKK/0KK  JJsD !E!D$  = KK; < KK1)L}]b\cd!!'-  KKG H KK:WI F KK?yHcd  KK1 2 Ic'l^:gYnYKWXY Z%$  %t#**= U  ( (  3J =D KK; < < =s0;H B'I I5II J *JJ c(V^8dQhRRRRRRRR/#)rr5strstoreusernamer z str | Noner )r s"r rrTs(   S C J rcRV9gRV9dR#RV R2V9dRV: R2#RV R2V9dRV: R2#R V9gR V9dR #VP4F2pR V9gK R V9gKVR 8wgKR VP4: 2u# R#)z{{z}}u+unreplaced template {{…}} still in outputz$storeID = ""z3wrong or missing $storeID line (need exactly store rz$username = "z&wrong or missing $username line (need z$password = ""zempty $password in outputz$storeID9144z0wrong store id 9144 (Las Palmas) still present: N) splitlinesr")r5r>r?lns&&& r r+r+Ts w$'/< %"'1DUIQOO (1%W47|1EE'+>'+I*  "  " &Ebhhj^T T# r__main__)__doc__ __future__rrr%pathlibrr,__file__resolveparent_DIRrr(r)r*r r!r/r;r+__name__ SystemExitr rr rOs #   H~&& ((   * F81VH$4 59 x  z TV r