class OptiesVenster (Venster): TITLE = 'Databasevoorkeuren' def fill(self): #Frames self.inhoudFrame = Frame(self.master, pady=10, padx=10) self.inhoudFrame.grid(row=0) self.knopFrame = Frame(self.master, padx=10, pady=10) self.knopFrame.grid(row=1, sticky=E) #Knoppen self.okKnop = Button(self.knopFrame, text='OK', state=DISABLED, command=self.ok) self.okKnop.grid(row=0, column=2) self.annulerenKnop = Button(self.knopFrame, text='Annuleren', command=self.sluit) self.annulerenKnop.grid(row=0, column =1) self.testKnop = Button(self.knopFrame, text='Test verbinding', command=self.test) self.testKnop.grid(row=0, column=0) #entries self.naamField = EntryField(self.inhoudFrame, 'Naam') self.hostField = EntryField(self.inhoudFrame, 'Host', row=1) self.portField = EntryField(self.inhoudFrame, 'Port', row=2) self.userField = EntryField(self.inhoudFrame, 'Gebruiksernaam', row=3) self.passField = EntryField(self.inhoudFrame, 'Wachtwoord', row=4) self.naamField.setValue(self.app.verbinding.name) self.hostField.setValue(self.app.verbinding.host) self.portField.setValue(self.app.verbinding.port) self.userField.setValue(self.app.verbinding.username) self.passField.setValue(self.app.verbinding.password) def sluit(self): self.vensterBeheer.removeVenster(self.vensterId) def test(self): self.testcnx = Verbinding(name=self.naamField.getValue(), host=self.hostField.getValue(), port=self.portField.getValue(), username=self.userField.getValue(), password=self.passField.getValue(), errorcallback=self.app.dberror) if self.testcnx.tryConnection(): tkMessageBox.showinfo('Databaseverbinding', 'Verbinding met database geslaagd.') self.okKnop.config(state=NORMAL) else: tkMessageBox.showerror('Databaseverbinding', 'Geen verbinding met database mogelijk.') def disableContent(self): pass def enableContent(self): pass def ok(self): try: self.app.verbinding.sluit() except: pass self.app.verbinding = self.testcnx self.app.verbinding.verbind() self.sluit() self.app.vensterBeheer.enableAll()
def test(self): self.testcnx = Verbinding(name=self.naamField.getValue(), host=self.hostField.getValue(), port=self.portField.getValue(), username=self.userField.getValue(), password=self.passField.getValue(), errorcallback=self.app.dberror) if self.testcnx.tryConnection(): tkMessageBox.showinfo('Databaseverbinding', 'Verbinding met database geslaagd.') self.okKnop.config(state=NORMAL) else: tkMessageBox.showerror('Databaseverbinding', 'Geen verbinding met database mogelijk.')