1
2
3
4
5
6
7
8
9
10
11
12
13
14
| 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()
|
|
