def OnTestBtn(self, event):
message = u'Пожалуйста подождите, получение информации из базы...'
try:
busy = PBI.PyBusyInfo(message, parent=None, title=u"Формирование и отправка запроса к базе данных...")
wx.Yield()
cursor = cx_Oracle.Cursor(self.connection)
regexp = self.edit_regexp_txt.GetValue()
if not regexp:
sql = ('select * from %s.%s') % (self.schema, self.table)
else:
sql = ('select * from %s.%s where %s') % (self.schema, self.table, regexp)
cursor.execute(sql)
grid_data=cursor.fetchall()
data = []
for item in grid_data:
data.append(map(lambda a: a.decode('cp1251') if isinstance(a, basestring) else a, item))
if not data:
del busy
wx.MessageBox(u'Нет данных!')
event.Skip()
return
self.grid_table = GridTable(data, self.connection, self.table)
cursor.close()
fsg = fs_grid.fullgrid(self, self.grid_table)
fsg.Show()
del busy
except Exception, info:
del busy
info = str(info)
info = info.decode('cp1251').encode('utf8')
wx.MessageBox(info)
def OnTestBtn(self, event):
try:
cursor = cx_Oracle.Cursor(self.connection)
regexp = self.edit_regexp_txt.GetValue()
sql = ('select * from %s.%s where %s') % (self.schema, self.table, regexp)
cursor.execute(sql)
grid_data=cursor.fetchall()
data = []
for item in grid_data:
data.append(map(lambda a: a.decode('cp1251') if isinstance(a, basestring) else a, item))
self.grid_table = GridTable(data, self.connection, self.table)
cursor.close()
#self.check_grid.SetTable(self.grid_table, True)
fsg = fs_grid.fullgrid(self.grid_table)
fsg.Show()
except Exception, info:
info = str(info)
info = info.decode('cp1251').encode('utf8')
wx.MessageBox(info)
def OnGridTab(self, event):
fsg = fs_grid.fullgrid(self.grid_table)
fsg.Show()
self.check_grid.Destroy()
