6,596
Expand|Select|Wrap|Line Numbers
- #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()
