class K2Importer:
    dbname = "D:/database/MH.FDB"
    dbuser = 'SYSDBA'
    dbpass = 'masterkey'
    dbcharset = 'UTF8'
    def __init__(self):
        self.con = fdb.connect(dsn= self.dbname, user = self.dbuser, password = self.dbpass, charset=self.dbcharset)
        self.cur = self.con.cursor

    def storeclear(self):
        self.con.begin()
        #Clear stock
        cur.execute(storeclear)
        self.con.commit()


    def storeadd(self, line):
        self.con.begin()
        storage = line[2]
        material = line[4]
        coutntmaterial = line[9]
        self.cur.callproc('K2IMPORT', (storage, material, coutntmaterial))
        #print (line)
        self.con.commit()

    #def __del__(self):
        #self.con.close()


hFile = open(FileImport, 'r')
curLine = []
recordNum = 0
storeclass = K2Importer()
storeclass.storeclear()

for line in hFile:
    recordNum += 1
    if recordNum == 12:
        #ProcessRecord(curLine)
        storeclass.storeadd(curLine)
        recordNum = 1
        curLine = []
    curLine.append(line.strip())
#storeclass.__del__()

self.cur.callproc('K2IMPORT', (storage, material, coutntmaterial))

        #Clear stock
        self.con.begin()
        cur = self.con.cursor()
        cur.execute(storeclear_sql)
        self.con.commit()