Exemple #1
0
	def createBody(self):
		self.Form._convertTabs = False
		self.Sizer.appendSpacer(5)

		lbl = dLabel(self, Caption=_("Enter the name of your app:"))
		self.txtAppName = dabo.ui.dTextBox(self)
		hs = dabo.ui.dSizer("h")
		hs.append(lbl)
		hs.appendSpacer(5)
		hs.append1x(self.txtAppName)
		self.Sizer.append(hs, "x")
		self.Sizer.appendSpacer(10)

		txt = """Enter the directory where you wish to place your
new application. It will be placed in a folder in that
directory with the application name chosen above.
You can always move the directory later."""
		lbl = dLabel(self, Caption=txt)
		self.Sizer.append(lbl)

		hs = dabo.ui.dSizer("h")
		self.txtDir = dabo.ui.dTextBox(self)
		##pkm: Commented this out as it looks awful on Windows.
		##self.txtDir.FontSize=10
		self.txtDir.Value = ""
		hs.append(self.txtDir, 1)
		hs.appendSpacer(4)

		self.cmdPick = dabo.ui.dButton(self, Caption="...", Width=30,
				Height=self.txtDir.Height)
		self.cmdPick.bindEvent(dEvents.Hit, self.onPick)
		hs.append(self.cmdPick, 0)
		self.Sizer.append1x(hs)

		self.chkPKUI = dabo.ui.dCheckBox(self, Caption=_("Include PK fields in the UI"))
		self.Sizer.append(self.chkPKUI)

		self.chkUnknown = dabo.ui.dCheckBox(self, Caption=_("Include Unknown datatype fields"))
		self.Sizer.append(self.chkUnknown)

		self.chkSortFieldsAlpha = dabo.ui.dCheckBox(self, Caption=_("Sort Fields Alphabetically"))
		self.Sizer.append(self.chkSortFieldsAlpha)

		self.Sizer.appendSpacer(2)
		ln = dabo.ui.dLine(self, Width=200)
		self.Sizer.append(ln, halign="left")
		lbl = dabo.ui.dLabel(self, Caption=_("Tabs are the default for indentation."))
		lbl.FontSize -= 1
		self.Sizer.append(lbl)
		chkConvertTabs = dabo.ui.dCheckBox(self, RegID="chkConvertTabs",
				Caption=_("Check this if you insist on using spaces."),
				DataSource=self.Form, DataField="ConvertTabs",
				SaveRestoreValue=True)
		chkConvertTabs.FontSize -= 1
		self.Sizer.append(chkConvertTabs, valign="bottom")
Exemple #2
0
	def testAll(self):
		""" Create a dForm and populate it with example dWidgets.
		"""
		self.app.setup()
		frame = self.app.MainForm
		frame.Size = (340, 120)
		frame.Caption = "Test of all the dControls"
		frame.debug = True
		frame.LogEvents = ["All"]

		panel = frame.addObject(ui.dPanel, "panelTest")
		panel.LogEvents = ["All"]

		labelWidth = 150

		for objClass in (ui.dCheckBox,):

			label = ui.dLabel(panel)
			label.Width = labelWidth

			obj = objClass(panel)
			obj.bindEvent(dEvents.Hit, self.objHit)
			label.Caption = "%s:" % objClass.__name__

			obj.debug = True
			obj.LogEvents = ["All"]

		self.app.start()
Exemple #3
0
 def afterInit(self):
     hs = self.Sizer = dSizer("h")
     but_props = {
         "FontBold": True,
         "ShowInBrowser": False,
         "OnHit": self.onHit_but,
         "VisitedUnderline": False,
         "LinkUnderline": False,
         "VisitedColor": "black",
         "HoverUnderline": False,
         "LinkColor": "black"
     }
     left_but = dHyperLink(self,
                           Name="butLeft",
                           Caption="   <   ",
                           **but_props)
     right_but = dHyperLink(self,
                            Name="butRight",
                            Caption="   >   ",
                            **but_props)
     lbl = dLabel(self, Name="lblMonthYear", FontBold=True)
     hs.appendSpacer(20)
     hs.append(left_but)
     hs.appendSpacer(10)
     hs.append(lbl, alignment="middle")
     hs.appendSpacer(10)
     hs.append(right_but)
     hs.appendSpacer(20)
Exemple #4
0
    def testAll(self):
        """ Create a dForm and populate it with example dWidgets.
		"""
        self.app.setup()
        frame = self.app.MainForm
        frame.Size = (340, 120)
        frame.Caption = "Test of all the dControls"
        frame.debug = True
        frame.LogEvents = ["All"]

        panel = frame.addObject(ui.dPanel, "panelTest")
        panel.LogEvents = ["All"]

        labelWidth = 150

        for objClass in (ui.dCheckBox, ):

            label = ui.dLabel(panel)
            label.Width = labelWidth

            obj = objClass(panel)
            obj.bindEvent(dEvents.Hit, self.objHit)
            label.Caption = "%s:" % objClass.__name__

            obj.debug = True
            obj.LogEvents = ["All"]

        self.app.start()
Exemple #5
0
	def testAll(self):
		"""Create a dForm and populate it with example dWidgets."""
		frame = ui.dForm(Name="formTestAll")
		frame.Caption = "Test of all the dControls"
		frame.LogEvents = logEvents

		panel = frame.addObject(ui.dScrollPanel, "panelTest")
		panel.SetScrollbars(10,10,50,50)
		labelWidth = 150
		vs = ui.dSizer("vertical")

		# Get all the python modules in this directory into a list:
		modules = [modname.split(".")[0] for modname in os.listdir(".") if modname[-3:] == ".py"]

		for modname in sorted(modules):
			print "==> ", modname
			# if the module has a test class, instantiate it:
			if modname == "__init__":
				# importing __init__ will pollute the dabo.ui namespace and cause
				# isinstance() problems.
				continue
			try:
				mod = __import__(modname)
			except ImportError, e:
				print "ImportError:", e
				continue
			objname = "_%s_test" % modname
			if objname in mod.__dict__:
				print "Trying to instantiate %s..." % objname
				try:
					obj = mod.__dict__[objname](panel)
				except StandardError, e:
					print "+++++++++++++++++++++++++++++++++++++++"
					print "+++ Instantiating %s caused:" % objname
					print traceback.print_exception(*sys.exc_info())
					print "+++++++++++++++++++++++++++++++++++++++"
					continue

				if objname == "_dToolBar_test":
					frame.ToolBar = obj
					break

				bs = ui.dSizer("horizontal")
				label = ui.dLabel(panel, Alignment="Right", AutoResize=False, Width=labelWidth)

				label.Caption = "%s:" % modname
				bs.append(label)

				if isinstance(obj, ui.dEditBox):
					layout = "expand"
				else:
					layout = "normal"

				bs.append(obj, layout)

				if isinstance(obj, ui.dEditBox):
					vs.append(bs, "expand")
				else:
					vs.append(bs, "expand")
Exemple #6
0
 def afterInit(self):
     con = self.Form.Connection
     gs = self.Sizer = dGridSizer(MaxCols=7)
     self.bizStatic = biz.BizStatic(con)
     self.bizDaily = biz.BizDaily(con)
     header = calendar.weekheader(3).split()
     for x in header:
         gs.append(dLabel(self, Caption=x), alignment="center")
     for y in range(self._week_range):
         for x in range(7):
             gs.append(PnlDay(self, Pos=(x,y)), "expand")
             gs.setColExpand(True, x)
         gs.setRowExpand(True, y+1)
     self.setFocusToToday()
Exemple #7
0
 def afterInit(self):
     con = self.Form.Connection
     gs = self.Sizer = dGridSizer(MaxCols=7)
     self.bizStatic = biz.BizStatic(con)
     self.bizDaily = biz.BizDaily(con)
     header = calendar.weekheader(3).split()
     for x in header:
         gs.append(dLabel(self, Caption=x), alignment="center")
     for y in range(self._week_range):
         for x in range(7):
             gs.append(PnlDay(self, Pos=(x, y)), "expand")
             gs.setColExpand(True, x)
         gs.setRowExpand(True, y + 1)
     self.setFocusToToday()
Exemple #8
0
 def afterInit(self):
     hs = self.Sizer = dSizer("h")
     but_props = {"FontBold": True, "ShowInBrowser": False,
                  "OnHit": self.onHit_but, "VisitedUnderline": False,
                  "LinkUnderline": False, "VisitedColor": "black",
                  "HoverUnderline": False, "LinkColor": "black"}
     left_but = dHyperLink(self, Name="butLeft", Caption="   <   ", **but_props)
     right_but = dHyperLink(self, Name="butRight", Caption="   >   ", **but_props)
     lbl = dLabel(self, Name="lblMonthYear", FontBold=True)
     hs.appendSpacer(20)
     hs.append(left_but)
     hs.appendSpacer(10)
     hs.append(lbl, alignment="middle")
     hs.appendSpacer(10)
     hs.append(right_but)
     hs.appendSpacer(20)
Exemple #9
0
	def createBody(self):
		self.tableSelections = {}
		txt = _("""The connection to the database was successful.
The following tables were found for that database.
Please check all tables you want included in
your application.""")
		lbl = dLabel(self, Caption=txt)
		clb = dabo.ui.dCheckList(self, Name="clbTableSelection")
		self.Sizer.append(lbl)
		self.Sizer.append1x(clb)
		hsz = dabo.ui.dSizer("h")
		btn = dabo.ui.dButton(self, Caption=_("Select All"))
		btn.bindEvent(dEvents.Hit, self.onSelectAll)
		hsz.append(btn, border=5)
		btn = dabo.ui.dButton(self, Caption=_("Invert Selection"))
		btn.bindEvent(dEvents.Hit, self.onInvertSelect)
		hsz.append(btn, border=5)
		btn = dabo.ui.dButton(self, Caption=_("Select None"))
		btn.bindEvent(dEvents.Hit, self.onSelectNone)
		hsz.append(btn, border=5)
		self.Sizer.append(hsz, halign="center")
Exemple #10
0
    def createBody(self):
        self.tableSelections = {}
        txt = _("""The connection to the database was successful.
The following tables were found for that database.
Please check all tables you want included in
your application.""")
        lbl = dLabel(self, Caption=txt)
        clb = dabo.ui.dCheckList(self, Name="clbTableSelection")
        self.Sizer.append(lbl)
        self.Sizer.append1x(clb)
        hsz = dabo.ui.dSizer("h")
        btn = dabo.ui.dButton(self, Caption=_("Select All"))
        btn.bindEvent(dEvents.Hit, self.onSelectAll)
        hsz.append(btn, border=5)
        btn = dabo.ui.dButton(self, Caption=_("Invert Selection"))
        btn.bindEvent(dEvents.Hit, self.onInvertSelect)
        hsz.append(btn, border=5)
        btn = dabo.ui.dButton(self, Caption=_("Select None"))
        btn.bindEvent(dEvents.Hit, self.onSelectNone)
        hsz.append(btn, border=5)
        self.Sizer.append(hsz, halign="center")
Exemple #11
0
    def testAll(self):
        """Create a dForm and populate it with example dWidgets."""
        frame = ui.dForm(Name="formTestAll")
        frame.Caption = "Test of all the dControls"
        frame.LogEvents = logEvents

        panel = frame.addObject(ui.dScrollPanel, "panelTest")
        panel.SetScrollbars(10, 10, 50, 50)
        labelWidth = 150
        vs = ui.dSizer("vertical")

        # Get all the python modules in this directory into a list:
        modules = [
            modname.split(".")[0] for modname in os.listdir(".")
            if modname[-3:] == ".py"
        ]

        for modname in sorted(modules):
            print "==> ", modname
            # if the module has a test class, instantiate it:
            if modname == "__init__":
                # importing __init__ will pollute the dabo.ui namespace and cause
                # isinstance() problems.
                continue
            try:
                mod = __import__(modname)
            except ImportError, e:
                print "ImportError:", e
                continue
            objname = "_%s_test" % modname
            if objname in mod.__dict__:
                print "Trying to instantiate %s..." % objname
                try:
                    obj = mod.__dict__[objname](panel)
                except StandardError, e:
                    print "+++++++++++++++++++++++++++++++++++++++"
                    print "+++ Instantiating %s caused:" % objname
                    print traceback.print_exception(*sys.exc_info())
                    print "+++++++++++++++++++++++++++++++++++++++"
                    continue

                if objname == "_dToolBar_test":
                    frame.ToolBar = obj
                    break

                bs = ui.dSizer("horizontal")
                label = ui.dLabel(panel,
                                  Alignment="Right",
                                  AutoResize=False,
                                  Width=labelWidth)

                label.Caption = "%s:" % modname
                bs.append(label)

                if isinstance(obj, ui.dEditBox):
                    layout = "expand"
                else:
                    layout = "normal"

                bs.append(obj, layout)

                if isinstance(obj, ui.dEditBox):
                    vs.append(bs, "expand")
                else:
                    vs.append(bs, "expand")
Exemple #12
0
	def createControls(self):
		self.Caption = _("Connection Editor")
		self.bg = dui.dPanel(self, BackColor="LightSteelBlue")
		gbsz = dui.dGridSizer(VGap=12, HGap=5, MaxCols=2)

		# Add the fields
		# Connection Dropdown
		cap = dui.dLabel(self.bg, Caption=_("Connection"))
		ctl = dui.dDropdownList(self.bg, Choices=list(self.connDict.keys()),
				RegID="connectionSelector",
				OnHit=self.onConnectionChange)
		btn = dui.dButton(self.bg, Caption=_("Edit Name"), RegID="cxnEdit",
				OnHit=self.onCxnEdit)
		hsz = dui.dSizer("h")
		hsz.append(ctl)
		hsz.appendSpacer(10)
		hsz.append(btn)

		btn = dui.dButton(self.bg, Caption=_("Delete This Connection"), RegID="cxnDelete",
				DynamicEnabled=self.hasMultipleConnections,
				OnHit=self.onCxnDelete)
		hsz.appendSpacer(10)
		hsz.append(btn)

		gbsz.append(cap, halign="right", valign="middle")
		gbsz.append(hsz, valign="middle")

		# Backend Type
		cap = dui.dLabel(self.bg, Caption=_("Database Type"))
		ctl = dui.dDropdownList(self.bg, RegID="DbType",
				Choices=["MySQL", "Firebird", "PostgreSQL", "MsSQL", "SQLite"],
				DataSource="form", DataField="dbtype",
				OnHit=self.onDbTypeChanged)
		gbsz.append(cap, halign="right")
		gbsz.append(ctl)
		self.dbTypeSelector = ctl

		# Host
		cap = dui.dLabel(self.bg, Caption=_("Host"))
		ctl = dui.dTextBox(self.bg, DataSource="form", DataField="host")
		gbsz.append(cap, halign="right")
		gbsz.append(ctl, "expand")
		self.hostText = ctl

		# Port
		cap = dui.dLabel(self.bg, Caption=_("Port"))
		ctl = dui.dTextBox(self.bg, DataSource="form", DataField="port")
		gbsz.append(cap, halign="right")
		gbsz.append(ctl, "expand")
		self.portText = ctl

		# Database
		cap = dui.dLabel(self.bg, Caption=_("Database"))
		ctl = dui.dTextBox(self.bg, DataSource="form", DataField="database")
		hsz = dui.dSizer("h")
		self.btnDbSelect = dui.dButton(self.bg, Caption=" ... ", RegID="btnDbSelect",
				Visible=False, OnHit=self.onDbSelect)
		hsz.append1x(ctl)
		hsz.appendSpacer(2)
		hsz.append(self.btnDbSelect, 0, "x")
		gbsz.append(cap, halign="right")
		gbsz.append(hsz, "expand")
		self.dbText = ctl

		# Username
		cap = dui.dLabel(self.bg, Caption=_("User Name"))
		ctl = dui.dTextBox(self.bg, DataSource="form", DataField="user")
		gbsz.append(cap, halign="right")
		gbsz.append(ctl, "expand")
		self.userText = ctl

		# Password
		cap = dui.dLabel(self.bg, Caption=_("Password"))
		ctl = dui.dTextBox(self.bg, PasswordEntry=True,
				DataSource="form", DataField="password")
		gbsz.append(cap, halign="right")
		gbsz.append(ctl, "expand")
		self.pwText = ctl

		# Open Button
		btnSizer1 = dui.dSizer("h")
		btnSizer2 = dui.dSizer("h")
		btnTest = dui.dButton(self.bg, RegID="btnTest", Caption=_("Test..."),
				OnHit=self.onTest)
		btnSave = dui.dButton(self.bg, RegID="btnSave", Caption=_("Save"),
				OnHit=self.onSave)
		btnNewConn = dui.dButton(self.bg, RegID="btnNewConn",
				Caption=_("New Connection"),
				OnHit=self.onNewConn)
		btnNewFile = dui.dButton(self.bg, RegID="btnNewFile",
				Caption=_("New File"),
				OnHit=self.onNewFile)
		btnOpen = dui.dButton(self.bg, RegID="btnOpen",
				Caption=_("Open File..."),
				OnHit=self.onOpen)
		btnSizer1.append(btnTest, 0, border=3)
		btnSizer1.append(btnSave, 0, border=3)
		btnSizer2.append(btnNewConn, 0, border=3)
		btnSizer2.append(btnNewFile, 0, border=3)
		btnSizer2.append(btnOpen, 0, border=3)
		gbsz.setColExpand(True, 1)
		self.gridSizer = gbsz

		sz = self.bg.Sizer = dui.dSizer("v")
		sz.append(gbsz, 0, "expand", halign="center", border=20)
		sz.append(btnSizer1, 0, halign="center")
		sz.append(btnSizer2, 0, halign="center")
		# Only create the 'Set Crypto Key' button if PyCrypto is installed
		try:
			from Crypto.Cipher import DES3 as _TEST_DES3
			self._showKeyButton = True
			del _TEST_DES3
		except ImportError:
			self._showKeyButton = False
		if self._showKeyButton:
			self.cryptoKeyButton = dui.dButton(self.bg, Caption=_("Set Crypto Key"),
					OnHit=self.onSetCrypto)
			btnSizer1.append(self.cryptoKeyButton, 0, halign="center", border=3)
		self.Sizer = dui.dSizer("h")
		self.Sizer.append(self.bg, 1, "expand", halign="center")
		self.Layout()
Exemple #13
0
    def createBody(self):
        self.embeddedDbTypes = ("SQLite", )
        self.embeddedFields = ("DbType", "Database", "Name")
        self.serverFields = self.embeddedFields + ("Host", "User", "Password",
                                                   "Port")

        sz = self.Sizer
        lbl = dLabel(
            self,
            Caption=_("Enter the parameters here, and then click 'Next'."))
        sz.append(lbl)
        lbl = dLabel(self, Caption=_("Profile:"))

        self.dbDefaults = {}
        self.dbDefaults["MySQL"] = {
            "DbType": "MySQL",
            "Host": "dabodev.com",
            "Database": "webtest",
            "User": "******",
            "Password": "******",
            "Port": "3306",
            "Name": "MySQL-default"
        }
        self.dbDefaults["Firebird"] = {
            "DbType": "Firebird",
            "Host": "dabodev.com",
            "Database": "webtest",
            "User": "******",
            "Password": "******",
            "Port": "3050",
            "Name": "Firebird-default"
        }
        self.dbDefaults["PostgreSQL"] = {
            "DbType": "PostgreSQL",
            "Host": "dabodev.com",
            "Database": "webtest",
            "User": "******",
            "Password": "******",
            "Port": "5432",
            "Name": "PostgreSQL-default"
        }
        self.dbDefaults["MsSQL"] = {
            "DbType": "MsSQL",
            "Host": "",
            "Database": "",
            "User": "",
            "Password": "",
            "Port": "1433",
            "Name": "MsSQL-default"
        }
        self.dbDefaults["SQLite"] = {
            "DbType": "SQLite",
            "Database": "webtest.sqlite",
            "Name": "SQLite-default"
        }

        # Save the supported dbTypes into a list
        self.supportedDbTypes = self.dbDefaults.keys()

        # List of all fields to create for the user to select
        self.fieldNames = ("DbType", "Name", "Host", "Database", "User",
                           "Password", "Port")

        # Now go through the profiles that the user may have saved in the
        # user settings file:
        app = self.Application
        userProfiles = app.getUserSettingKeys("dbDefaults")
        dbDefaultKeys = self.dbDefaults.keys()
        dbDefaultMap = {}
        for key in dbDefaultKeys:
            dbDefaultMap[key.lower()] = key

        ## Default to MySQL first:
        defaultProfileName = "MySQL"
        defaultUserProfileName = None

        for profile in userProfiles:
            userDict = {}
            for field in (self.fieldNames):
                name = "dbDefaults.%s.%s" % (profile, field)
                val = app.getUserSetting(name)
                if val is None:
                    val = ""
                userDict[field] = val
            if profile in dbDefaultMap.keys():
                profile = dbDefaultMap[profile]
            self.dbDefaults[profile] = userDict

            # Override the default with the last user profile:
            defaultUserProfileName = profile

        # Set up the dropdown list based on the keys in the dbDefaults dict.
        self.ddProfile = dabo.ui.dDropdownList(self, Name="ddProfile")
        self.ddProfile.ValueMode = "string"
        self.ddProfile.Choices = self.dbDefaults.keys()
        if defaultUserProfileName is not None:
            self.ddProfile.Value = defaultUserProfileName
        else:
            self.ddProfile.Value = defaultProfileName
        self.ddProfile.bindEvent(dEvents.ValueChanged, self.onProfileChoice)

        cmd = dabo.ui.dButton(self,
                              Caption=_("New Profile..."),
                              Name="cmdNewProfile")
        cmd.bindEvent(dEvents.Hit, self.onNewProfile)

        gs = dabo.ui.dGridSizer()
        gs.MaxCols = 2
        gs.append(lbl)
        hs = dabo.ui.dSizer("h")
        hs.append(self.ddProfile, 1)
        hs.appendSpacer(8)
        hs.append(cmd, 0)
        gs.append(hs, "x")
        gs.appendSpacer(20, colSpan=2)
        gs.setColExpand(True, 1)

        for field in self.fieldNames:
            lbl = dLabel(self,
                         Name=("lbl%s" % field),
                         Width=75,
                         Caption=("%s:" % field))
            if field == "DbType":
                obj = dabo.ui.dDropdownList(self,
                                            Name=("ctl%s" % field),
                                            Choices=self.supportedDbTypes,
                                            ValueMode="string")
            else:
                pw = (field.lower() == "password")
                obj = dabo.ui.dTextBox(self,
                                       PasswordEntry=pw,
                                       Name=("ctl%s" % field),
                                       SelectOnEntry=True)
            obj.bindEvent(dEvents.ValueChanged, self.onParmValueChanged)

            gs.append(lbl)
            # Add a file search button. It will be hidden for all
            # non-file-based backends.
            if field == "Database":
                self.btnSrch = dabo.ui.dButton(self, Caption="...")
                self.btnSrch.Width = (self.btnSrch.Height * 2)
                self.btnSrch.bindEvent(dEvents.Hit, self.onDbSearch)
                hs = self.szDB = dabo.ui.dSizer("H")
                hs.append1x(obj)
                hs.append(self.btnSrch, border=10, borderSides="left")
                gs.append(hs, "x")
            else:
                gs.append(obj, "x")
        sz.append(gs, 1, "x")
        self.onProfileChoice()
Exemple #14
0
    def __init__(self, parent, Caption=_("Create Application")):
        super(PageGo, self).__init__(parent=parent, Caption=Caption)
        txt = _("""Press 'Finish' to create your application, or
'Back' to edit any information.""")
        lbl = dLabel(self, Caption=txt)
        self.Sizer.append1x(lbl)
Exemple #15
0
    def createBody(self):
        self.Form._convertTabs = False
        self.Sizer.appendSpacer(5)

        lbl = dLabel(self, Caption=_("Enter the name of your app:"))
        self.txtAppName = dabo.ui.dTextBox(self)
        hs = dabo.ui.dSizer("h")
        hs.append(lbl)
        hs.appendSpacer(5)
        hs.append1x(self.txtAppName)
        self.Sizer.append(hs, "x")
        self.Sizer.appendSpacer(10)

        txt = """Enter the directory where you wish to place your
new application. It will be placed in a folder in that
directory with the application name chosen above.
You can always move the directory later."""
        lbl = dLabel(self, Caption=txt)
        self.Sizer.append(lbl)

        hs = dabo.ui.dSizer("h")
        self.txtDir = dabo.ui.dTextBox(self)
        ##pkm: Commented this out as it looks awful on Windows.
        ##self.txtDir.FontSize=10
        self.txtDir.Value = ""
        hs.append(self.txtDir, 1)
        hs.appendSpacer(4)

        self.cmdPick = dabo.ui.dButton(self,
                                       Caption="...",
                                       Width=30,
                                       Height=self.txtDir.Height)
        self.cmdPick.bindEvent(dEvents.Hit, self.onPick)
        hs.append(self.cmdPick, 0)
        self.Sizer.append1x(hs)

        self.chkPKUI = dabo.ui.dCheckBox(
            self, Caption=_("Include PK fields in the UI"))
        self.Sizer.append(self.chkPKUI)

        self.chkUnknown = dabo.ui.dCheckBox(
            self, Caption=_("Include Unknown datatype fields"))
        self.Sizer.append(self.chkUnknown)

        self.chkSortFieldsAlpha = dabo.ui.dCheckBox(
            self, Caption=_("Sort Fields Alphabetically"))
        self.Sizer.append(self.chkSortFieldsAlpha)

        self.Sizer.appendSpacer(2)
        ln = dabo.ui.dLine(self, Width=200)
        self.Sizer.append(ln, halign="left")
        lbl = dabo.ui.dLabel(
            self, Caption=_("Tabs are the default for indentation."))
        lbl.FontSize -= 1
        self.Sizer.append(lbl)
        chkConvertTabs = dabo.ui.dCheckBox(
            self,
            RegID="chkConvertTabs",
            Caption=_("Check this if you insist on using spaces."),
            DataSource=self.Form,
            DataField="ConvertTabs",
            SaveRestoreValue=True)
        chkConvertTabs.FontSize -= 1
        self.Sizer.append(chkConvertTabs, valign="bottom")
Exemple #16
0
	def __init__(self, parent, Caption=_("Create Application")):
		super(PageGo, self).__init__(parent=parent, Caption=Caption)
		txt = _("""Press 'Finish' to create your application, or
'Back' to edit any information.""")
		lbl = dLabel(self, Caption=txt)
		self.Sizer.append1x(lbl)
Exemple #17
0
	def createBody(self):
		self.embeddedDbTypes = ("SQLite", )
		self.embeddedFields = ("DbType", "Database", "Name")
		self.serverFields = self.embeddedFields + ("Host", "User",
				"Password", "Port")

		sz = self.Sizer
		lbl = dLabel(self, Caption=_("Enter the parameters here, and then click 'Next'."))
		sz.append(lbl)
		lbl = dLabel(self, Caption=_("Profile:"))

		self.dbDefaults = {}
		self.dbDefaults["MySQL"] = {
				"DbType" : "MySQL",
				"Host" : "dabodev.com",
				"Database" : "webtest",
				"User" : "webuser",
				"Password" : "foxrocks",
				"Port" : "3306",
				"Name" : "MySQL-default" }
		self.dbDefaults["Firebird"] = {
				"DbType" : "Firebird",
				"Host" : "dabodev.com",
				"Database" : "webtest",
				"User" : "webuser",
				"Password" : "foxrox",
				"Port" : "3050",
				"Name" : "Firebird-default" }
		self.dbDefaults["PostgreSQL"] = {
				"DbType" : "PostgreSQL",
				"Host" : "dabodev.com",
				"Database" : "webtest",
				"User" : "webuser",
				"Password" : "foxrox",
				"Port" : "5432",
				"Name" : "PostgreSQL-default" }
		self.dbDefaults["MsSQL"] = {
				"DbType" : "MsSQL",
				"Host" : "",
				"Database" : "",
				"User" : "",
				"Password" : "",
				"Port" : "1433",
				"Name" : "MsSQL-default" }
		self.dbDefaults["SQLite"] = {
				"DbType" : "SQLite",
				"Database" : "webtest.sqlite",
				"Name" : "SQLite-default" }

		# Save the supported dbTypes into a list
		self.supportedDbTypes = self.dbDefaults.keys()

		# List of all fields to create for the user to select
		self.fieldNames = ("DbType", "Name", "Host", "Database", "User",
				"Password", "Port")

		# Now go through the profiles that the user may have saved in the
		# user settings file:
		app = self.Application
		userProfiles = app.getUserSettingKeys("dbDefaults")
		dbDefaultKeys = self.dbDefaults.keys()
		dbDefaultMap = {}
		for key in dbDefaultKeys:
			dbDefaultMap[key.lower()] = key

		## Default to MySQL first:
		defaultProfileName = "MySQL"
		defaultUserProfileName = None

		for profile in userProfiles:
			userDict = {}
			for field in (self.fieldNames):
				name = "dbDefaults.%s.%s" % (profile, field)
				val = app.getUserSetting(name)
				if val is None:
					val = ""
				userDict[field] = val
			if profile in dbDefaultMap.keys():
				profile = dbDefaultMap[profile]
			self.dbDefaults[profile] = userDict

			# Override the default with the last user profile:
			defaultUserProfileName=profile

		# Set up the dropdown list based on the keys in the dbDefaults dict.
		self.ddProfile = dabo.ui.dDropdownList(self, Name="ddProfile")
		self.ddProfile.ValueMode = "string"
		self.ddProfile.Choices = self.dbDefaults.keys()
		if defaultUserProfileName is not None:
			self.ddProfile.Value = defaultUserProfileName
		else:
			self.ddProfile.Value = defaultProfileName
		self.ddProfile.bindEvent(dEvents.ValueChanged, self.onProfileChoice)

		cmd = dabo.ui.dButton(self, Caption=_("New Profile..."), Name="cmdNewProfile")
		cmd.bindEvent(dEvents.Hit, self.onNewProfile)

		gs = dabo.ui.dGridSizer()
		gs.MaxCols = 2
		gs.append(lbl)
		hs = dabo.ui.dSizer("h")
		hs.append(self.ddProfile, 1)
		hs.appendSpacer(8)
		hs.append(cmd, 0)
		gs.append(hs, "x")
		gs.appendSpacer(20, colSpan=2)
		gs.setColExpand(True, 1)

		for field in self.fieldNames:
			lbl = dLabel(self, Name=("lbl%s" % field), Width=75, Caption=("%s:" % field) )
			if field == "DbType":
				obj = dabo.ui.dDropdownList(self, Name=("ctl%s" % field),
						Choices=self.supportedDbTypes, ValueMode="string")
			else:
				pw = (field.lower() == "password")
				obj = dabo.ui.dTextBox(self, PasswordEntry=pw,
						Name=("ctl%s" % field), SelectOnEntry=True )
			obj.bindEvent(dEvents.ValueChanged, self.onParmValueChanged)

			gs.append(lbl)
			# Add a file search button. It will be hidden for all
			# non-file-based backends.
			if field == "Database":
				self.btnSrch = dabo.ui.dButton(self, Caption="...")
				self.btnSrch.Width = (self.btnSrch.Height * 2)
				self.btnSrch.bindEvent(dEvents.Hit, self.onDbSearch)
				hs = self.szDB = dabo.ui.dSizer("H")
				hs.append1x(obj)
				hs.append(self.btnSrch, border=10, borderSides="left")
				gs.append(hs, "x")
			else:
				gs.append(obj, "x")
		sz.append(gs, 1, "x")
		self.onProfileChoice()
Exemple #18
0
	def createControls(self):
		self.Caption = _("Connection Editor")
		self.bg = dui.dPanel(self, BackColor="LightSteelBlue")
		gbsz = dui.dGridSizer(VGap=12, HGap=5, MaxCols=2)

		# Add the fields
		# Connection Dropdown
		cap = dui.dLabel(self.bg, Caption=_("Connection"))
		ctl = dui.dDropdownList(self.bg, Choices=self.connDict.keys(),
				RegID="connectionSelector",
				OnHit=self.onConnectionChange)
		btn = dui.dButton(self.bg, Caption=_("Edit Name"), RegID="cxnEdit",
				OnHit=self.onCxnEdit)
		hsz = dui.dSizer("h")
		hsz.append(ctl)
		hsz.appendSpacer(10)
		hsz.append(btn)

		btn = dui.dButton(self.bg, Caption=_("Delete This Connection"), RegID="cxnDelete",
				DynamicEnabled=self.hasMultipleConnections,
				OnHit=self.onCxnDelete)
		hsz.appendSpacer(10)
		hsz.append(btn)

		gbsz.append(cap, halign="right", valign="middle")
		gbsz.append(hsz, valign="middle")

		# Backend Type
		cap = dui.dLabel(self.bg, Caption=_("Database Type"))
		ctl = dui.dDropdownList(self.bg, RegID="DbType",
				Choices=["MySQL", "Firebird", "PostgreSQL", "MsSQL", "SQLite"],
				DataSource="form", DataField="dbtype",
				OnHit=self.onDbTypeChanged)
		gbsz.append(cap, halign="right")
		gbsz.append(ctl)
		self.dbTypeSelector = ctl

		# Host
		cap = dui.dLabel(self.bg, Caption=_("Host"))
		ctl = dui.dTextBox(self.bg, DataSource="form", DataField="host")
		gbsz.append(cap, halign="right")
		gbsz.append(ctl, "expand")
		self.hostText = ctl

		# Port
		cap = dui.dLabel(self.bg, Caption=_("Port"))
		ctl = dui.dTextBox(self.bg, DataSource="form", DataField="port")
		gbsz.append(cap, halign="right")
		gbsz.append(ctl, "expand")
		self.portText = ctl

		# Database
		cap = dui.dLabel(self.bg, Caption=_("Database"))
		ctl = dui.dTextBox(self.bg, DataSource="form", DataField="database")
		hsz = dui.dSizer("h")
		self.btnDbSelect = dui.dButton(self.bg, Caption=" ... ", RegID="btnDbSelect",
				Visible=False, OnHit=self.onDbSelect)
		hsz.append1x(ctl)
		hsz.appendSpacer(2)
		hsz.append(self.btnDbSelect, 0, "x")
		gbsz.append(cap, halign="right")
		gbsz.append(hsz, "expand")
		self.dbText = ctl

		# Username
		cap = dui.dLabel(self.bg, Caption=_("User Name"))
		ctl = dui.dTextBox(self.bg, DataSource="form", DataField="user")
		gbsz.append(cap, halign="right")
		gbsz.append(ctl, "expand")
		self.userText = ctl

		# Password
		cap = dui.dLabel(self.bg, Caption=_("Password"))
		ctl = dui.dTextBox(self.bg, PasswordEntry=True,
				DataSource="form", DataField="password")
		gbsz.append(cap, halign="right")
		gbsz.append(ctl, "expand")
		self.pwText = ctl

		# Open Button
		btnSizer1 = dui.dSizer("h")
		btnSizer2 = dui.dSizer("h")
		btnTest = dui.dButton(self.bg, RegID="btnTest", Caption=_("Test..."),
				OnHit=self.onTest)
		btnSave = dui.dButton(self.bg, RegID="btnSave", Caption=_("Save"),
				OnHit=self.onSave)
		btnNewConn = dui.dButton(self.bg, RegID="btnNewConn",
				Caption=_("New Connection"),
				OnHit=self.onNewConn)
		btnNewFile = dui.dButton(self.bg, RegID="btnNewFile",
				Caption=_("New File"),
				OnHit=self.onNewFile)
		btnOpen = dui.dButton(self.bg, RegID="btnOpen",
				Caption=_("Open File..."),
				OnHit=self.onOpen)
		btnSizer1.append(btnTest, 0, border=3)
		btnSizer1.append(btnSave, 0, border=3)
		btnSizer2.append(btnNewConn, 0, border=3)
		btnSizer2.append(btnNewFile, 0, border=3)
		btnSizer2.append(btnOpen, 0, border=3)
		gbsz.setColExpand(True, 1)
		self.gridSizer = gbsz

		sz = self.bg.Sizer = dui.dSizer("v")
		sz.append(gbsz, 0, "expand", halign="center", border=20)
		sz.append(btnSizer1, 0, halign="center")
		sz.append(btnSizer2, 0, halign="center")
		# Only create the 'Set Crypto Key' button if PyCrypto is installed
		try:
			from Crypto.Cipher import DES3 as _TEST_DES3
			self._showKeyButton = True
			del _TEST_DES3
		except ImportError:
			self._showKeyButton = False
		if self._showKeyButton:
			self.cryptoKeyButton = dui.dButton(self.bg, Caption=_("Set Crypto Key"),
					OnHit=self.onSetCrypto)
			btnSizer1.append(self.cryptoKeyButton, 0, halign="center", border=3)
		self.Sizer = dui.dSizer("h")
		self.Sizer.append(self.bg, 1, "expand", halign="center")
		self.Layout()