import sys,json
|
from pathlib import Path
|
sys.stdout.reconfigure(encoding='utf-8')
|
from decimal import Decimal
|
sys.path.insert(0,str(Path('scripts/iqc-import-20261012/deps').resolve()))
|
import pymysql
|
p=Path('scripts/qc-indicator-optimize-20261014')
|
c=pymysql.connect(host='36.213.150.237',port=10000,user='root',password=sys.stdin.readline().strip(),database='mom-hm',charset='utf8mb4',cursorclass=pymysql.cursors.DictCursor,autocommit=False)
|
with c.cursor() as q:
|
q.execute('SELECT id,name,result_type,unit_text FROM mes_qc_indicator WHERE id IN (47,286) FOR UPDATE');rows=q.fetchall();assert len(rows)==2 and all(x['result_type']==2 for x in rows)
|
assert rows[1]['unit_text']=='MPN/g'
|
(p/'mpn-type-before.json').write_text(json.dumps(rows,ensure_ascii=False,indent=2),encoding='utf8')
|
q.execute('UPDATE mes_qc_indicator SET result_type=1,update_time=update_time WHERE id IN (47,286) AND result_type=2');assert q.rowcount==2
|
c.commit()
|
r=json.loads((p/'result-applied.json').read_text(encoding='utf8'))
|
for change in r['changes']:
|
if change['table']=='mes_qc_indicator' and change['id'] in [47,286]:change['after']['result_type']=1
|
(p/'result-applied.json').write_text(json.dumps(r,ensure_ascii=False,indent=2),encoding='utf8')
|
with (p/'applied.sql').open('a',encoding='utf8') as f:f.write('\n-- MPN estimate supports decimal results; no rounding of microbial estimates.\nUPDATE mes_qc_indicator SET result_type=1,update_time=update_time WHERE id IN (47,286);\n')
|
print('MPN estimation fields support decimals; other data unchanged.');c.close()
|
