wx.Dialog subclass instantiates my dbServer class

[bartonc]

#Boa:Dialog:DBConnectDialog
 
import wx
 
import wxdbtools as db
 
def create(parent):
    return DBConnectDialog(parent)
 
[wxID_DBCONNECTDIALOG, wxID_DBCONNECTDIALOGCANCELBTN,
 wxID_DBCONNECTDIALOGCONNECTBTN, wxID_DBCONNECTDIALOGDATABASETEXTCTRL,
 wxID_DBCONNECTDIALOGPWDTEXTCTRL, wxID_DBCONNECTDIALOGSERVERNAMETEXTCTRL,
 wxID_DBCONNECTDIALOGSTATICTEXT1, wxID_DBCONNECTDIALOGSTATICTEXT2,
 wxID_DBCONNECTDIALOGSTATICTEXT3, wxID_DBCONNECTDIALOGSTATICTEXT4,
 wxID_DBCONNECTDIALOGSTATICTEXT5, wxID_DBCONNECTDIALOGSTATUSTEXTCTRL,
 wxID_DBCONNECTDIALOGUSERNAMETEXTCTRL,
] = [wx.NewId() for _init_ctrls in range(13)]
 
class DBConnectDialog(wx.Dialog):
    def _init_ctrls(self, prnt):
        # generated method, don't edit
        wx.Dialog.__init__(self, id=wxID_DBCONNECTDIALOG,
              name='DBConnectDialog', parent=prnt, pos=wx.Point(503, 380),
              size=wx.Size(385, 344),
              style=wx.STAY_ON_TOP | wx.DIALOG_MODAL | wx.TAB_TRAVERSAL | wx.SUNKEN_BORDER | wx.DEFAULT_DIALOG_STYLE,
              title='Database Connection Dialog')
        self.SetClientSize(wx.Size(377, 317))
        self.SetFont(wx.Font(10, wx.SWISS, wx.NORMAL, wx.NORMAL, False,
              'MS Shell Dlg 2'))
        self.SetThemeEnabled(True)
 
        self.staticText1 = wx.StaticText(id=wxID_DBCONNECTDIALOGSTATICTEXT1,
              label='User Name', name='staticText1', parent=self,
              pos=wx.Point(16, 8), size=wx.Size(63, 16), style=0)
        self.staticText1.SetFont(wx.Font(10, wx.SWISS, wx.NORMAL, wx.NORMAL,
              False, 'MS Shell Dlg 2'))
 
        self.staticText2 = wx.StaticText(id=wxID_DBCONNECTDIALOGSTATICTEXT2,
              label='Password', name='staticText2', parent=self,
              pos=wx.Point(200, 8), size=wx.Size(55, 16), style=0)
 
        self.usernameTextCtrl = wx.TextCtrl(id=wxID_DBCONNECTDIALOGUSERNAMETEXTCTRL,
              name='usernameTextCtrl', parent=self, pos=wx.Point(16, 24),
              size=wx.Size(160, 24), style=0, value='barton')
 
        self.servernameTextCtrl = wx.TextCtrl(id=wxID_DBCONNECTDIALOGSERVERNAMETEXTCTRL,
              name='servernameTextCtrl', parent=self, pos=wx.Point(16, 80),
              size=wx.Size(160, 24), style=0, value='genesis')
 
        self.staticText3 = wx.StaticText(id=wxID_DBCONNECTDIALOGSTATICTEXT3,
              label='Server Name or IP Address', name='staticText3',
              parent=self, pos=wx.Point(16, 64), size=wx.Size(156, 16),
              style=0)
 
        self.staticText5 = wx.StaticText(id=wxID_DBCONNECTDIALOGSTATICTEXT5,
              label='Default Database', name='staticText5', parent=self,
              pos=wx.Point(200, 64), size=wx.Size(97, 16), style=0)
 
        self.pwdTextCtrl = wx.TextCtrl(id=wxID_DBCONNECTDIALOGPWDTEXTCTRL,
              name='pwdTextCtrl', parent=self, pos=wx.Point(200, 24),
              size=wx.Size(160, 24), style=wx.TE_PASSWORD, value='1coolSQL')
 
        self.databaseTextCtrl = wx.TextCtrl(id=wxID_DBCONNECTDIALOGDATABASETEXTCTRL,
              name='databaseTextCtrl', parent=self, pos=wx.Point(200, 80),
              size=wx.Size(160, 24), style=0, value='Trails')
 
        self.staticText4 = wx.StaticText(id=wxID_DBCONNECTDIALOGSTATICTEXT4,
              label='Connection Status Log', name='staticText4', parent=self,
              pos=wx.Point(16, 120), size=wx.Size(127, 16), style=0)
 
        self.ConnectBtn = wx.Button(id=wxID_DBCONNECTDIALOGCONNECTBTN,
              label='Connect', name='ConnectBtn', parent=self, pos=wx.Point(104,
              280), size=wx.Size(75, 26), style=0)
        self.ConnectBtn.Bind(wx.EVT_BUTTON, self.OnConnectButton,
              id=wxID_DBCONNECTDIALOGCONNECTBTN)
 
        self.cancelBtn = wx.Button(id=wxID_DBCONNECTDIALOGCANCELBTN,
              label='Cancel', name='cancelBtn', parent=self, pos=wx.Point(200,
              280), size=wx.Size(75, 26), style=0)
        self.cancelBtn.Bind(wx.EVT_BUTTON, self.OnCancelButton,
              id=wxID_DBCONNECTDIALOGCANCELBTN)
 
        self.statusTextCtrl = wx.TextCtrl(id=wxID_DBCONNECTDIALOGSTATUSTEXTCTRL,
              name='statusTextCtrl', parent=self, pos=wx.Point(16, 136),
              size=wx.Size(344, 136), style=wx.TE_READONLY | wx.TE_MULTILINE,
              value='')
        self.statusTextCtrl.SetFont(wx.Font(8, wx.SWISS, wx.NORMAL, wx.NORMAL,
              False, 'MS Shell Dlg 2'))
 
    def __init__(self, parent):
        self._init_ctrls(parent)
 
        self.dbServer = db.DBServer(self)
        self.dbConnect = self.DBConnect()   # Don't call this guy directly (don't keep?)
        if not self.dbConnect:
            self.Show()
 
    def DBConnect(self):
        user = self.usernameTextCtrl.GetValue()
        password = self.pwdTextCtrl.GetValue()
        host = self.servernameTextCtrl.GetValue()
        dbConnect = self.dbServer.Login(host, user, password)
        database = self.databaseTextCtrl.GetValue()
        if database:
            self.dbServer.Execute("CREATE DATABASE IF NOT EXISTS %s" % database)
        self.dbServer.Execute("USE %s" % database)
        return dbConnect
 
    def GetDBServer(self):
        return self.dbServer
 
    def GetDefaultDatabase(self):
        return self.databaseTextCtrl.GetValue()
 
    def write(self, message):
        self.statusTextCtrl.AppendText("%s\n" %message)
 
    def OnConnectButton(self, event):
        if self.dbConnect:
            self.dbConnect.close()
        self.dbConnect = self.DBConnect()
        if self.dbConnect:
            self.write("Ready")
 
 
    def OnCancelButton(self, event):
        self.Hide()