import fdb
import pandas as pd

fdb.load_api("D:/fb_work/fb64/fbclient.dll")
con = fdb.connect(dsn='D:/Bd_dados/DEVSYS_DATABASE.GDB', user='SYSDBA', password='masterkey', charset='WIN1252')
cur = con.cursor()

# Check STATUS field values
cur.execute("SELECT DISTINCT STATUS FROM EST_PRODUTO ROWS 20")
print("STATUS values:", [r[0] for r in cur.fetchall()])

cur.execute("SELECT DISTINCT FINALIZADO FROM VEN_SAIDA ROWS 10")
print("FINALIZADO values:", [r[0] for r in cur.fetchall()])

# Check data sample
cur.execute("SELECT REFERENCIAL, NOME, PRECO_CUSTO, MARGEM, STATUS FROM EST_PRODUTO ROWS 5")
for r in cur.fetchall():
    print(r)
con.close()