fdb

import fdb import os # Ensure the Firebird client library (fbclient.dll/.so) is installed and discoverable. # Replace with your Firebird database path and credentials. DB_DSN = os.environ.get('FDB_DSN', 'localhost:/opt/firebird/data/test.fdb') DB_USER = os.environ.get('FDB_USER', 'sysdba') DB_PASSWORD = os.environ.get('FDB_PASSWORD', 'masterkey') try: # Establish a connection to the Firebird database con = fdb.connect(dsn=DB_DSN, user=DB_USER, password=DB_PASSWORD) print("Successfully connected to Firebird database.") # Create a cursor object cur = con.cursor() # Execute a SQL query cur.execute("SELECT RDB$RELATION_NAME FROM RDB$RELATIONS WHERE RDB$SYSTEM_FLAG = 0") # Fetch and print results print("\nUser-defined tables:") for row in cur: print(f"- {row[0].strip()}") # RDB$RELATION_NAME is CHAR, needs stripping # Close the cursor and connection cur.close() con.close() print("\nConnection closed.") except fdb.Error as e: print(f"Failed to connect or query Firebird database: {e}") print("Please ensure Firebird server is running, the client library is installed,") print("and the DSN/credentials are correct.")