import kinterbasdb,sys

# Classe de manipulation du SGBD
class FBhandler:

    def __init__(self,domain,path,login="SYSDBA",passwd="masterkey"):
        self.controller = kinterbasdb.connect(host=domain, database=path ,user=login, password=passwd)

    def query(self,request):
        ptr = self.controller.cursor()
        ptr.execute(request)
        return ptr.fetchall()

host = "10.0.0.251"
db = "/bases/prosper.gdb"

# Initialise le controller
controller = FBhandler(host,db)
# Ouvre le fichier
file_handle = open("mail.txt","w")

# Procedure d'aspiration :
for feed in ["MAIL_CAB","MAIL_DOM"]:
    for email in controller.query("select "+feed+" from client"):
        print(email)
        if email != None and email[0] != None and email[0] != "":
            file_handle.write(str(email[0]))
            file_handle.write("\r\n")

file_handle.close()