import sys,json
from pathlib import Path
P=Path(__file__).parent
sys.path.insert(0,str(P.parent/'iqc-import-20261012/deps'))
import pymysql
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)
s={}
with c.cursor() as q:
 q.execute("SELECT id,name,code,status,tenant_id FROM system_role WHERE deleted=0 AND name=%s",('生产管理员',));s['roles']=q.fetchall()
 q.execute('SELECT u.id,u.username,u.nickname,u.status,u.tenant_id,ur.role_id FROM system_users u JOIN system_user_role ur ON ur.user_id=u.id WHERE u.deleted=0 AND ur.deleted=0 AND ur.role_id IN (SELECT id FROM system_role WHERE deleted=0 AND name=%s)',('生产管理员',));s['users']=q.fetchall()
 q.execute("SELECT * FROM system_operate_log WHERE trace_id LIKE 'BF-META-V1:%' ORDER BY id");s['logs']=q.fetchall()
(P/'before-log-production-role.json').write_text(json.dumps(s,ensure_ascii=False,default=str,indent=2),encoding='utf8')
print(json.dumps({'roles':s['roles'],'users':s['users'],'supplemented_logs':len(s['logs']),'target_logs':sum(r['type'].startswith(('MES ','MDM ')) for r in s['logs'])},ensure_ascii=False,default=str))
c.close()