o Sh @s`ddlmZmZmZddlmZddlmZejddgddd Z ejd d gdd d Z dS))requestjsonifysession)get_db_connection)api_bpz/save_span_damagePOST)methodsc CsJzt}|d}td}td}td}|dg}|r%|r%|s/tdddd fWSt}|}|D]}|d |||d fq8|D](}|d |||||d |d |d|d|d|d|df qI|| | tddddfWSt y} ztdt | ddfWYd} ~ Sd} ~ ww)Nfilenameuser_idemailusername damage_listFu*필수 데이터가 누락되었습니다.successerrorz~ DELETE FROM span_damage WHERE filename = %s AND user_id = '%s' AND type = %s typea& INSERT INTO span_damage ( filename, user_id, username, email, span_id, type, damage_type, damage_quantity, count, unit, inspection_area, updated_at ) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, NOW()) spanId damageTypedamageQuantitycountunitinspectionAreaTu*손상 데이터가 저장되었습니다.)rmessagei) rget_jsongetrrrcursorexecutecommitclose Exceptionstr) datar r r r rconncuritemer)>/home/skpark/git/infrasmart_work/infrasmart/api/span_damage.pysave_span_damagesN       "r+z/get_span_damageGETcstjd}td}|r|stddddfSt}|}|d||f|}| | gdfd d |D}td |d d fS)Nr r Fu-필수 파라미터가 누락되었습니다.rrz SELECT span_id, type, damage_type, damage_quantity, count, unit, inspection_area, updated_at FROM span_damage WHERE filename = %s AND user_id = '%s' ORDER BY updated_at DESC )rrrrrrr updatedAtcsg|] }tt|qSr))dictzip).0rowcolumnsr)r* Osz#get_span_damage..T)rr$r) rargsrrrrrrfetchallr!)r r r%r&rowsr$r)r2r*get_span_damage:s  r8N) flaskrrr utils.commonrrrouter+r8r)r)r)r*s   4