Vladimir Buzalka
65 lines
1.7 KiB
Python
65 lines
1.7 KiB
Python
#!/usr/bin/env python
|
|
# -*- coding: utf-8 -*-
|
|
"""Test pripojeni k Firebird databazi na REPORTER"""
|
|
|
|
import sys
|
|
|
|
print("=== Test pripojeni k Firebird na REPORTER ===\n")
|
|
|
|
# 1. Zkontroluj fdb
|
|
try:
|
|
import fdb
|
|
print("+ fdb je nainstalovan")
|
|
except ImportError as e:
|
|
print(f"- fdb neni nainstalovan: {e}")
|
|
print(" Instalace: pip install fdb")
|
|
sys.exit(1)
|
|
|
|
# 2. Zkus pripojeni
|
|
print("\nPokus o pripojeni k databazi...")
|
|
print(" dsn: reporter:c:\\medicus\\medicus.fdb")
|
|
print(" user: SYSDBA")
|
|
print(" charset: win1250\n")
|
|
|
|
try:
|
|
conn = fdb.connect(
|
|
dsn=r'reporter:c:\medicus\medicus.fdb',
|
|
user='SYSDBA',
|
|
password='masterkey',
|
|
charset='win1250'
|
|
)
|
|
print("+ Pripojeni se podarilo!")
|
|
|
|
# Testovaci SELECT
|
|
cursor = conn.cursor()
|
|
|
|
# Jednoducky test - zjisti verzi Firebirdu
|
|
cursor.execute("SELECT RDB$GET_CONTEXT('SYSTEM', 'ENGINE_VERSION') FROM RDB$DATABASE")
|
|
version = cursor.fetchone()[0]
|
|
print(f"+ Firebird verze: {version}")
|
|
|
|
# Zjisti kolik je tabulek
|
|
cursor.execute("SELECT COUNT(*) FROM RDB$RELATIONS WHERE RDB$SYSTEM_FLAG = 0")
|
|
table_count = cursor.fetchone()[0]
|
|
print(f"+ Pocet uzivatelskych tabulek: {table_count}")
|
|
|
|
conn.close()
|
|
|
|
print("\n" + "="*60)
|
|
print("SUCCESS: Databaze na REPORTER je dostupna a funguje!")
|
|
print("="*60)
|
|
print("\nMuzete pouzit:")
|
|
print(" conn = fdb.connect(")
|
|
print(" dsn=r'reporter:c:\\medicus\\medicus.fdb',")
|
|
print(" user='SYSDBA',")
|
|
print(" password='masterkey',")
|
|
print(" charset='win1250'")
|
|
print(" )")
|
|
|
|
except Exception as e:
|
|
print(f"\n- Chyba: {type(e).__name__}")
|
|
print(f" {e}")
|
|
import traceback
|
|
traceback.print_exc()
|
|
sys.exit(1)
|