43 lines
1.2 KiB
Python
43 lines
1.2 KiB
Python
"""check_last_dekurs.py – zobrazí posledních 5 záznamů v DEKURS + FILES pro pacienta 9742"""
|
||
import fdb
|
||
|
||
conn = fdb.connect(
|
||
dsn=r'localhost:c:\medicus 3\data\medicus.fdb',
|
||
user='SYSDBA', password='masterkey', charset='WIN1250'
|
||
)
|
||
cur = conn.cursor()
|
||
|
||
print("=== Posledních 5 záznamů DEKURS pro Buzalka (idpac=9742) ===")
|
||
cur.execute("""
|
||
SELECT id, datum, cas, OCTET_LENGTH(dekurs) as delka
|
||
FROM dekurs WHERE idpac = 9742
|
||
ORDER BY id DESC ROWS 5
|
||
""")
|
||
for row in cur.fetchall():
|
||
print(f" ID={row[0]} datum={row[1]} cas={row[2]} délka={row[3]} B")
|
||
|
||
print()
|
||
print("=== Obsah posledního DEKURS záznamu ===")
|
||
cur.execute("""
|
||
SELECT dekurs FROM dekurs WHERE idpac = 9742
|
||
ORDER BY id DESC ROWS 1
|
||
""")
|
||
row = cur.fetchone()
|
||
if row:
|
||
text = row[0]
|
||
if isinstance(text, bytes):
|
||
text = text.decode('cp1250', errors='replace')
|
||
print(text)
|
||
|
||
print()
|
||
print("=== Posledních 5 záznamů FILES pro Buzalka (idpac=9742) ===")
|
||
cur.execute("""
|
||
SELECT id, filename, datum, OCTET_LENGTH(body) as bodylen
|
||
FROM files WHERE idpac = 9742
|
||
ORDER BY id DESC ROWS 5
|
||
""")
|
||
for row in cur.fetchall():
|
||
print(f" ID={row[0]} filename={row[1]} datum={row[2]} body={row[3]} B")
|
||
|
||
conn.close()
|