Upgrade to Pro — share decks privately, control downloads, hide ads and more …

PyConTW 2026 - AI Coding 不只是工具升級, 區域醫院醫療資訊系統協作開...

Avatar for Max Lai Max Lai
October 17, 2026

PyConTW 2026 - AI Coding 不只是工具升級, 區域醫院醫療資訊系統協作開發與資訊團隊轉型實踐

Avatar for Max Lai

Max Lai

October 17, 2026

More Decks by Max Lai

Other Decks in Programming

Transcript

  1. 4.0.39 Python 3.11 5.x 5.0 2 bytes 4 bytes 5.x

    pyodbc 4.0.39 2027.10 #1392 -11060 4.x D S N = odbc.ini [ODBC] UNICODE=UCS-2 ? ?
  2. DATABASE billing MAIN DEFINE l_year, l_month SMALLINT DEFINE l_rec RECORD

    pt_no CHAR(10), amount DECIMAL(10,2) END RECORD ... REPORT report_main(l_rec) END MAIN import pyodbc, openpyxl, smtplib Skill Claude Code + 4gl-to-python-skills cn = pyodbc.connect(DSN) df = run_query(cn, year=2026, month=5) # # xlsx + email
  3. DECLARE c1 CURSOR FOR SELECT name, adm_dt, dept FROM patients

    SQL = ("SELECT name, adm_dt, dept FROM patients " WHERE adm_dt BETWEEN l_from AND l_to ORDER BY adm_dt "WHERE adm_dt BETWEEN ? AND ? ORDER BY adm_dt") START REPORT rpt TO "patients.txt" def run(cn, d_from, d_to, out): FOREACH c1 INTO r.* for name, adm_dt, dept in cn.execute(SQL, d_from, d_to): OUTPUT TO REPORT rpt(r.*) out.write(f"{name} · {adm_dt:%Y/%m/%d} · {dept}\n") END FOREACH ──→ FINISH REPORT rpt ──→ ✓ X · 2026/05/01 · ✓ X · 2026/05/03 · · X · 2026/05/01 · · X · 2026/05/03 · ✓ X · 2026/05/05 · · X · 2026/05/05 · ✓ X · 2026/05/07 · · X · 2026/05/07 · ✓ X · 2026/05/09 · · X · 2026/05/09 · #1 $ python batch.py #2 #3 #4 5 ✓ · 0 ✗ · #5
  4. PYTE · BIG5 localhost:8080 · oc22_ui $ uv run python

    oc22_interactive.py --fifo oc22> text 1234567 ⏎ screen 1234567 OC22 NiceGUI 1234567 ⇄ 2026/05/01 ──→ 037 Playwright MCP · E2E #1 #2 #3 #4 · E2E ✓ #5 vt100-bridge
  5. –