10 lines
628 B
Python
10 lines
628 B
Python
# -*- coding: utf-8 -*-
|
|
import io, sys, pymysql
|
|
sys.stdout = io.TextIOWrapper(sys.stdout.buffer, encoding='utf-8')
|
|
conn = pymysql.connect(host='192.168.1.161', user='devgps', password='dev@2021GPS',
|
|
database='zentao_dev_2026', charset='utf8mb4')
|
|
cur = conn.cursor()
|
|
cur.execute("SELECT id, date_str, create_date, INSTR(scope_json,'\"productBugRate\":12'), INSTR(scope_json,'6.04') FROM zt_month_score WHERE account='weidongxia' ORDER BY date_str")
|
|
for r in cur.fetchall():
|
|
print(f"id={r[0]} 月份={r[1]} 创建={r[2]} productBugRate=12?{'是' if r[3] else '否'} 含6.04?{'是' if r[4] else '否'}")
|