16 lines
838 B
Python
16 lines
838 B
Python
# -*- coding: utf-8 -*-
|
|
import io, sys, pymysql
|
|
sys.stdout = io.TextIOWrapper(sys.stdout.buffer, encoding='utf-8')
|
|
for db in ['zentao_dev', 'zentao_dev_2026']:
|
|
conn = pymysql.connect(host='192.168.1.161', user='devgps', password='dev@2021GPS',
|
|
database=db, charset='utf8mb4')
|
|
cur = conn.cursor()
|
|
cur.execute("SELECT id, title, status, product FROM zt_story WHERE id=9130")
|
|
print(f"[{db}] story:", cur.fetchone())
|
|
cur.execute("""SELECT story_id, number_units, unit_business_complexity, technical_complexity_coefficient,
|
|
ai_efficiency_coefficient, requirement_status, workload_index, evaluation_time,
|
|
ai_participation_rate, product_person, develop_person, test_person
|
|
FROM zt_story_expand WHERE story_id=9130""")
|
|
print(f"[{db}] expand:", cur.fetchone())
|
|
conn.close()
|