# -*- coding: windows-1251 -*- 
import wx
import db
import msgbox
import cx_Oracle
class db_info(wx.Dialog):
    def __init__(self):
        # инициализация
        style=wx.FRAME_TOOL_WINDOW | wx.CLOSE_BOX
        wx.Dialog.__init__(self, None, -1, style=style, title='Информация для присоединения к базе',
                           size=(100,200))
        wx.Dialog.SetFocus(self)
        
        #panel = wx.Panel(self, -1)
        # Атрибуты
        login = wx.StaticText(self, -1, "Login:", pos=(1,1))
        self.loginTxt = wx.TextCtrl(self, -1, "artur", pos=(1,15))
        tns = wx.StaticText(self, -1, "TNS:", pos=(1,40))
        self.tnsTxt  = wx.TextCtrl(self, -1, "orcl", pos=(1,55))
        self.loginTxt.SetInsertionPoint(0)
        passw = wx.StaticText(self, -1, "Password:", pos=(1,80))
        self.passwTxt = wx.TextCtrl(self, -1, "123", pos=(1,100),
                style=wx.TE_PASSWORD)
        
        # Кнопки
        self.ConnectBtn = wx.Button(self, wx.ID_OK, "Присоединится", pos=(1, 125))
        self.Bind(wx.EVT_BUTTON, self.OnConnectBtn, self.ConnectBtn)
        self.ConnectBtn.SetDefault()

        self.CancelBtn = wx.Button(self, wx.ID_CANCEL,  "Отмена", pos=(2, 150))
        self.Bind(wx.EVT_BUTTON, self.OnCancelBtn, self.CancelBtn)
    
    def OnConnectBtn(self, event):
        global dblogin, dbpass, dbtns
        dblogin = (self.loginTxt.GetValue())
        dbpass = (self.passwTxt.GetValue())
        dbtns = (self.tnsTxt.GetValue())
        self.connection = db.OpenDB(dblogin, dbpass, dbtns)
        self.Close()
    
    def OnCancelBtn(self, event):
        self.Destroy()

# псевдокод
# --- module mainform.py ---
import createconnection
import newrecord

class MainForm:
    def __init__(self):
        ...
        self.db = None
        ...

    def get_connection(self):
        if self.db is None:
            self.db = createconnection.create_connection()
        return self.db

    def add_record(self):
        newrecord.add_record(db)
# --- end module ---

# --- module createconnection.py ---
class Connection:
    # пользователь вводит все необходимое для создания подключения
    ...

def create_connection():
    connection = None
    dlg = Connection()
    if wx.ID_OK == dlg.ShowModal():
        connection = # создаем подключение
    dlg.Destroy()
    return connection
# --- end module ---

# --- module newrecord.py ---
class NewRecord:
    # пользователь вводит все необходимое
    ...

def add_record(db):
    dlg = NewRecord()
    if wx.ID_OK == dlg.ShowModal():
        rs = db.cursor()
        rs.execute("INSERT ....")
        db.commit()
    dlg.Destroy()
# --- end module ---