Mercurial > libervia-backend
view frontends/src/wix/profile_manager.py @ 853:c2f6ada7858f
core (sqlite): automatic database update:
- new Updater class check database consistency (by calculating a hash on the .schema), and updates base if necessary
- database now has a version (1 for current, 0 will be for 0.3's database), for each change this version will be increased
- creation statements and update statements are in the form of dict of dict with tuples. There is a help text at the top of the module to explain how it works
- if we are on a development version, the updater try to update the database automaticaly (without deleting table or columns). The Updater.generateUpdateData method can be used to ease the creation of update data (i.e. the dictionary at the top, see the one for the key 1 for an example).
- if there is an inconsistency, an exception is raised, and a message indicate the SQL statements that should fix the situation.
- well... this is rather complicated, a KISS method would maybe have been better. The future will say if we need to simplify it :-/
- new DatabaseError exception
author | Goffi <goffi@goffi.org> |
---|---|
date | Sun, 23 Feb 2014 23:30:32 +0100 |
parents | 1fe00f0c9a91 |
children | 308a96bc7c1b |
line wrap: on
line source
#!/usr/bin/python # -*- coding: utf-8 -*- # wix: a SAT frontend # Copyright (C) 2009, 2010, 2011, 2012, 2013, 2014 Jérôme Poisson (goffi@goffi.org) # This program is free software: you can redistribute it and/or modify # it under the terms of the GNU Affero General Public License as published by # the Free Software Foundation, either version 3 of the License, or # (at your option) any later version. # This program is distributed in the hope that it will be useful, # but WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the # GNU Affero General Public License for more details. # You should have received a copy of the GNU Affero General Public License # along with this program. If not, see <http://www.gnu.org/licenses/>. from sat.core.i18n import _ import wx import pdb from logging import debug, info, error from sat.tools.jid import JID import pdb class ProfileManager(wx.Panel): def __init__(self, host): super(ProfileManager, self).__init__(host) self.host = host #self.sizer = wx.FlexGridSizer(cols=2) self.sizer = wx.BoxSizer(wx.VERTICAL) self.SetSizer(self.sizer) profiles = self.host.bridge.getProfilesList() self.profile_name = wx.ComboBox(self, -1, style=wx.CB_READONLY|wx.CB_SORT) self.__refillProfiles() self.Bind(wx.EVT_COMBOBOX, self.onProfileChange) self.panel_id = wx self.sizer.Add(wx.Window(self, -1), 1) self.sizer.Add(wx.StaticText(self, -1, _("Profile:")), 0, flag=wx.ALIGN_CENTER) self.sizer.Add(self.profile_name, 0, flag=wx.ALIGN_CENTER) button_panel = wx.Panel(self) button_panel.sizer = wx.BoxSizer(wx.HORIZONTAL) button_panel.SetSizer(button_panel.sizer) button_new = wx.Button(button_panel, -1, _("New")) button_del = wx.Button(button_panel, -1, _("Delete")) button_panel.sizer.Add(button_new) button_panel.sizer.Add(button_del) self.sizer.Add(button_panel, flag=wx.CENTER) self.Bind(wx.EVT_BUTTON, self.onNewProfile, button_new) self.Bind(wx.EVT_BUTTON, self.onDeleteProfile, button_del) login_box = wx.StaticBox(self, -1, _("Login")) self.login_sizer = wx.StaticBoxSizer(login_box, wx.VERTICAL) self.sizer.Add(self.login_sizer, 1, wx.EXPAND | wx.ALL) self.login_jid = wx.TextCtrl(self, -1) self.login_sizer.Add(wx.StaticText(self, -1, "JID:"), 0, flag=wx.ALIGN_CENTER) self.login_sizer.Add(self.login_jid, flag=wx.EXPAND) self.login_pass = wx.TextCtrl(self, -1, style = wx.TE_PASSWORD) self.login_sizer.Add(wx.StaticText(self, -1, _("Password:")), 0, flag=wx.ALIGN_CENTER) self.login_sizer.Add(self.login_pass, flag=wx.EXPAND) loggin_button = wx.Button(self, -1, _("Connect")) self.Bind(wx.EVT_BUTTON, self.onConnectButton, loggin_button) self.login_sizer.Add(loggin_button, flag=wx.ALIGN_CENTER) self.sizer.Add(wx.Window(self, -1), 1) #Now we can set the default value self.__setDefault() def __setDefault(self): profile_default = self.host.bridge.getProfileName("@DEFAULT@") if profile_default: self.profile_name.SetValue(profile_default) self.onProfileChange(None) def __refillProfiles(self): """Update profiles with current names. Must be called after a profile change""" self.profile_name.Clear() profiles = self.host.bridge.getProfilesList() profiles.sort() for profile in profiles: self.profile_name.Append(profile) def onNewProfile(self, event): dlg = wx.TextEntryDialog(self, _("Please enter the new profile name"), _("New profile"), style = wx.OK | wx.CANCEL) if dlg.ShowModal() == wx.ID_OK: name = dlg.GetValue() if name: if name[0]=='@': wx.MessageDialog(self, _("A profile name can't start with a @"), _("Bad profile name"), wx.ICON_ERROR).ShowModal() else: profile = self.host.bridge.createProfile(name) self.__refillProfiles() self.profile_name.SetValue(name) dlg.Destroy() def onDeleteProfile(self, event): name = self.profile_name.GetValue() if not name: return dlg = wx.MessageDialog(self, _("Are you sure to delete the profile [%s]") % name, _("Confirmation"), wx.ICON_QUESTION | wx.YES_NO) if dlg.ShowModal() == wx.ID_YES: self.host.bridge.deleteProfile(name) self.__refillProfiles() self.__setDefault() dlg.Destroy() def onProfileChange(self, event): """Called when a profile is choosen in the combo box""" def setJID(jabberID): self.login_jid.SetValue(jabberID) def setPassword(password): self.login_pass.SetValue(password) self.host.bridge.asyncGetParamA("JabberID", "Connection", profile_key=self.profile_name.GetValue(), callback=setJID, errback=self.getParamError) self.host.bridge.asyncGetParamA("Password", "Connection", profile_key=self.profile_name.GetValue(), callback=setPassword, errback=self.getParamError) def onConnectButton(self, event): """Called when the Connect button is pressed""" name = self.profile_name.GetValue() if not name: wx.MessageDialog(self, _("You must select a profile or create a new one before connecting"), _("No profile selected"), wx.ICON_ERROR).ShowModal() return if name[0]=='@': wx.MessageDialog(self, _("A profile name can't start with a @"), _("Bad profile name"), wx.ICON_ERROR).ShowModal() return profile = self.host.bridge.getProfileName(name) assert(profile) self.host.bridge.asyncGetParamA("JabberID", "Connection", profile_key=profile, callback=lambda old_jid: self.__old_jidReceived(old_jid, profile), errback=self.getParamError) def __old_jidReceived(self, old_jid, profile): self.host.bridge.asyncGetParamA("Password", "Connection", profile_key=profile, callback=lambda old_pass: self.__old_passReceived(old_jid, old_pass, profile), errback=self.getParamError) def __old_passReceived(self, old_jid, old_pass, profile): new_jid = self.login_jid.GetValue() new_pass = self.login_pass.GetValue() if old_jid != new_jid: debug(_('Saving new JID and server')) self.host.bridge.setParam("JabberID", new_jid, "Connection", profile_key=profile) self.host.bridge.setParam("Server", JID(new_jid).domain, "Connection", profile_key=profile) if old_pass != new_pass: debug(_('Saving new password')) self.host.bridge.setParam("Password", new_pass, "Connection", profile_key=profile) self.host.plug_profile(profile) def getParamError(self, ignore): wx.MessageDialog(self, _("Can't get profile parameter"), _("Profile error"), wx.ICON_ERROR).ShowModal()