\gS ddlmZmZmZddlmZddlmZddlZ ddl Z eZ e jedgddgdgdZ d Zd Zee eeZd Ze j%d ed fdefdZy))FastAPIFile UploadFile)CORSMiddleware)TableN*T) allow_originsallow_credentials allow_methods allow_headerszRpatxeXDdZuJZIfTr7.734a61f1569b3a858451002068d5e0a7a47c23cfb96faa101284dc09a65f341aapphI6IdboDIR9P0l ProductsV2cbtj|s|tdtdfvry|S)z)Convert problematic float or NaN to None.infz-infN)pdisnafloat)values /var/www/html/lionshead/main.pysanitizers) wwu~5<v"?? Lz /upload-sdr.filec K |jd{}tjtj|j d}d}|j D]y\}}t|jd}|s$id|dt|jddt|jdd t|jd d t|jd d t|jddt|jddt|jddt|jddt|jddt|jddt|jddt|jddt|jddt|jddt|jddt|jdt|jdt|jdt|jdd }tjd!|d"#}|rtj|dd$|ntj||d%z }|d&|d'S7#t$r} d(t| d)cYd} ~ Sd} ~ wwxYww)*Nzutf-8rzTM ARTICLE NUMBERzTM Article Numberz Product Linez PRODUCT LINE Subfamily SUBFAMILYz Style Namez STYLE NAMEz OG Style Namez OG STYLE NAMEz Color Namez COLOR NAMESeasonSEASONzPAR DatezNumber of Samples ReceivedzMarketing Sample Estimated DatezRep SMS/Photoshop CommentsLocationLOCATIONzSample Pass off DatezLionshead Received DatezFlatlay Shoot DatezOn Model Shoot DatezOn Models ShotzOn Models Shot (Y or N)Sample Return DateLast Updated DateTime Updated By)r r!r"z{TM Article Number} = '')formulaidsuccess)statusupsertederror)r(message)readrread_csvioStringIOdecodeiterrowsrgettableallupdatecreate Exceptionstr) rcontentsdfr)_rowtm_idfieldsexistinges r upload_sdrrAs.6$ [[X__W%=> ?kkmFAsSWW%89:E#U)@ AXcggk&:;hsww|'<=   #''/*B!C  hsww}'=> (3778#45HSWWZ%89-hsww?[7\.]28CGGDerMs--2  i%%% h    4 -(,S /6:/6/6r