import wx
import unit_database
class frame_pass(wx.Frame):
    def __init__(self):
        global passwTxt, loginTxt, tnsTxt
        wx.Frame.__init__(self, None, -1, 'Text Entry Example',
                size=(250, 150))
        panel = wx.Panel(self, -1)
        login = wx.StaticText(panel, -1, "Login:")
        loginTxt = wx.TextCtrl(panel, -1, "",
                size=(175, -1))
        tns = wx.StaticText(panel, -1, "TNS:")
        tnsTxt = wx.TextCtrl(panel, -1, "",
                size=(175, -1))
        loginTxt.SetInsertionPoint(0)
        passw = wx.StaticText(panel, -1, "Password:")
        passwTxt = wx.TextCtrl(panel, -1, "", size=(175, -1),
                style=wx.TE_PASSWORD)
        sizer = wx.FlexGridSizer(cols=2, hgap=6, vgap=6)
        sizer.AddMany([login, loginTxt, tns, tnsTxt, passw, passwTxt])
        panel.SetSizer(sizer)

        self.ConnectBtn = wx.Button(panel, -1, "Connect", pos=(40, 100))
        self.Bind(wx.EVT_BUTTON, self.OnConnectBtn, self.ConnectBtn)
        self.ConnectBtn.SetDefault()

        self.CancelBtn = wx.Button(panel, -1, "Cancel", pos=(135, 100))
        self.Bind(wx.EVT_BUTTON, self.OnCancelBtn, self.CancelBtn)

        dblogin = loginTxt.GetValue()
        dbpass = passwTxt.GetValue()
        dbtns = tnsTxt.GetValue()

    def OnConnectBtn(self, event):
        global connection
        dblogin = loginTxt.GetValue()
        dbpass = passwTxt.GetValue()
        dbtns = tnsTxt.GetValue()
        info = [dblogin, dbpass, dbtns]
        connection = unit_database.OpenDB(dblogin, dbpass, dbtns)
        return info
        self.Destroy()

    def OnCancelBtn(self, event):
        self.Destroy()

import wx
import unit_database
class FramePass(wx.Frame):
    def __init__(self):
        wx.Frame.__init__(self, None, -1, 'Text Entry Example',
                size=(250, 150))
        panel = wx.Panel(self, -1)
        self.info = None
        login = wx.StaticText(panel, -1, "Login:")
        self.loginTxt = wx.TextCtrl(panel, -1, "",
                size=(175, -1))
        tns = wx.StaticText(panel, -1, "TNS:")
        self.tnsTxt = wx.TextCtrl(panel, -1, "",
                size=(175, -1))
        self.loginTxt.SetInsertionPoint(0)
        passw = wx.StaticText(panel, -1, "Password:")
        self.passwTxt = wx.TextCtrl(panel, -1, "", size=(175, -1),
                style=wx.TE_PASSWORD)
        sizer = wx.FlexGridSizer(cols=2, hgap=6, vgap=6)
        sizer.AddMany([login, self.loginTxt, tns, self.tnsTxt, passw, self.passwTxt])
        panel.SetSizer(sizer)

        self.ConnectBtn = wx.Button(panel, -1, "Connect", pos=(40, 100))
        self.Bind(wx.EVT_BUTTON, self.OnConnectBtn, self.ConnectBtn)
        self.ConnectBtn.SetDefault()

        self.CancelBtn = wx.Button(panel, -1, "Cancel", pos=(135, 100))
        self.Bind(wx.EVT_BUTTON, self.OnCancelBtn, self.CancelBtn)

    def OnConnectBtn(self, event):
        global connection
        dblogin = self.loginTxt.GetValue()
        dbpass = self.passwTxt.GetValue()
        dbtns = self.tnsTxt.GetValue()
        self.info = [dblogin, dbpass, dbtns]
        connection = unit_database.OpenDB(dblogin, dbpass, dbtns)
        #return info
        self.Destroy()

    def OnCancelBtn(self, event):
        self.Destroy()

frame_pass = FramePass()
new_info = frame_pass.info

connection = unit_database.OpenDB(dbl=dblogin, dbp=dbpass, dbt=dbtns)

x = kwds["dbl"]
y = kwds["dbp"]
z = kwds["dbt"]