o [<hÆã@srddlmZmZmZddlZddlmZddlmZedeƒZ e j ddgdd d „ƒZe j ddgdd d„ƒZdS)é)Ú BlueprintÚrequestÚjsonifyN)Údatetime)Úget_db_connectionÚcarbonation_testz/save_carbonation_testÚPOST)Úmethodsc CsVz‚t ¡}| d¡}| dg¡}|stddiƒdfWS|s&tddiƒdfWStƒ}| ¡}| d¡| d|f¡d }|D]-}| d ¡}| d¡}| d¡} | d ¡} |rj|rj| rj| rj| d|||| | f¡|d7}q=| ¡| ¡| ¡td|›d|dœƒWSt yª}zt dt|ƒ›ƒtddt|ƒ›iƒdfWYd}~Sd}~ww)NÚfile_idÚcarbonation_dataÚerrorõíŒŒì¼ IDê°€ í•„ìš”í•©ë‹ˆë‹¤.éu$íƒ„ì‚°í™” ë°ì´í„°ê°€ ì—†ìŠµë‹ˆë‹¤.a¾ CREATE TABLE IF NOT EXISTS carbonation_test ( id SERIAL PRIMARY KEY, file_id TEXT NOT NULL, component TEXT NOT NULL, position TEXT NOT NULL, test_type TEXT NOT NULL, grade TEXT NOT NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ) z/DELETE FROM carbonation_test WHERE file_id = %srÚ componentÚpositionÚ test_typeÚgradezö INSERT INTO carbonation_test (file_id, component, position, test_type, grade, created_at, updated_at) VALUES (%s, %s, %s, %s, %s, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP) éTu;ê°œì˜ íƒ„ì‚°í™” ì‹œí—˜ ë°ì´í„°ê°€ ì €ìž¥ë˜ì—ˆìŠµë‹ˆë‹¤.)ÚsuccessÚmessageÚsaved_countu*íƒ„ì‚°í™” ì‹œí—˜ ë°ì´í„° ì €ìž¥ ì˜¤ë¥˜: u)ì €ìž¥ ì¤‘ ì˜¤ë¥˜ê°€ ë°œìƒí–ˆìŠµë‹ˆë‹¤: éô)rÚget_jsonÚgetrrÚcursorÚexecuteÚcommitÚcloseÚ ExceptionÚprintÚstr)Údatar rÚconnrÚinsert_countÚitemrrrrÚe©r&úC/home/skpark/git/infrasmart_work/infrasmart/api/carbonation_test.pyÚsave_carbonation_test sJ ü€ ý&€þr(z/get_carbonation_testÚGETc CsüzUtj d¡}|stddiƒdfWStƒ}| ¡}| d|f¡| ¡}| ¡| ¡g}|D]}| |d|d|d|d |d |ddœ¡q0td |t |ƒdœƒWSty}}ztdt |ƒ›ƒtddt |ƒ›iƒdfWYd}~Sd}~ww)Nr rr rzÅ SELECT component, position, test_type, grade, created_at, updated_at FROM carbonation_test WHERE file_id = %s ORDER BY position, test_type rréééé)rrrrÚ created_atÚ updated_atT)rrÚcountu*íƒ„ì‚°í™” ì‹œí—˜ ë°ì´í„° ì¡°íšŒ ì˜¤ë¥˜: u)ì¡°íšŒ ì¤‘ ì˜¤ë¥˜ê°€ ë°œìƒí–ˆìŠµë‹ˆë‹¤: r)rÚargsrrrrrÚfetchallrÚappendÚlenrrr )r r"rÚrowsrÚrowr%r&r&r'Úget_carbonation_testJs@û ú ý&€þr7) ÚflaskrrrÚjsonrÚutils.commonrÚ__name__Úcarbonation_test_bpÚrouter(r7r&r&r&r'Ús @