/[thuban]/branches/WIP-pyshapelib-bramz/Thuban/UI/tableview.py
ViewVC logotype

Diff of /branches/WIP-pyshapelib-bramz/Thuban/UI/tableview.py

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

trunk/thuban/Thuban/UI/tableview.py revision 1202 by jonathan, Fri Jun 13 16:01:10 2003 UTC branches/WIP-pyshapelib-bramz/Thuban/UI/tableview.py revision 2755 by dpinte, Thu Apr 12 09:21:58 2007 UTC
# Line 11  import os.path Line 11  import os.path
11    
12  from Thuban import _  from Thuban import _
13    
14  from wxPython.wx import *  import wx
15  from wxPython.grid import *  from wx import grid
16    
17  from Thuban.Lib.connector import Publisher  from Thuban.Lib.connector import Publisher
18  from Thuban.Model.table import FIELDTYPE_INT, FIELDTYPE_DOUBLE, \  from Thuban.Model.table import FIELDTYPE_INT, FIELDTYPE_DOUBLE, \
19       FIELDTYPE_STRING, table_to_dbf, table_to_csv       FIELDTYPE_STRING, table_to_dbf, table_to_csv
 import view  
20  from dialogs import ThubanFrame  from dialogs import ThubanFrame
21    
22  from messages import SHAPES_SELECTED, SESSION_REPLACED  from messages import SHAPES_SELECTED, SESSION_REPLACED
23  from Thuban.Model.messages import TABLE_REMOVED, MAP_LAYERS_REMOVED  from Thuban.Model.messages import TABLE_REMOVED, MAP_LAYERS_REMOVED
24    from Thuban.UI.common import ThubanBeginBusyCursor, ThubanEndBusyCursor
25    
26  wx_value_type_map = {FIELDTYPE_INT: wxGRID_VALUE_NUMBER,  wx_value_type_map = {FIELDTYPE_INT: grid.GRID_VALUE_NUMBER,
27                       FIELDTYPE_DOUBLE: wxGRID_VALUE_FLOAT,                       FIELDTYPE_DOUBLE: grid.GRID_VALUE_FLOAT,
28                       FIELDTYPE_STRING: wxGRID_VALUE_STRING}                       FIELDTYPE_STRING: grid.GRID_VALUE_STRING}
29    
30  ROW_SELECTED = "ROW_SELECTED"  ROW_SELECTED = "ROW_SELECTED"
31    
32  QUERY_KEY = 'S'  QUERY_KEY = 'S'
33    
34  class DataTable(wxPyGridTableBase):  class DataTable(grid.PyGridTableBase):
35    
36      """Wrapper around a Thuban table object suitable for a wxGrid"""      """Wrapper around a Thuban table object suitable for a wxGrid"""
37    
38      def __init__(self, table = None):      def __init__(self, table = None):
39          wxPyGridTableBase.__init__(self)          grid.PyGridTableBase.__init__(self)
40          self.num_cols = 0          self.num_cols = 0
41          self.num_rows = 0          self.num_rows = 0
42          self.columns = []          self.columns = []
# Line 71  class DataTable(wxPyGridTableBase): Line 71  class DataTable(wxPyGridTableBase):
71      # Renderer understands the type too,) not just strings as in the      # Renderer understands the type too,) not just strings as in the
72      # C++ version.      # C++ version.
73      def GetValue(self, row, col):      def GetValue(self, row, col):
74          record = self.table.ReadRowAsDict(row)          try:
75                record = self.table.ReadRowAsDict(row, row_is_ordinal = 1)
76            except UnicodeError:
77                record = dict()
78                for (key, val) in self.table.ReadRowAsDict(row, \
79                                  row_is_ordinal = 1).items():
80                    record[key] = val
81          return record[self.columns[col][0]]          return record[self.columns[col][0]]
82    
83      def SetValue(self, row, col, value):      def SetValue(self, row, col, value):
# Line 102  class DataTable(wxPyGridTableBase): Line 108  class DataTable(wxPyGridTableBase):
108          return self.CanGetValueAs(row, col, typeName)          return self.CanGetValueAs(row, col, typeName)
109    
110    
111        #
112        def RowIdToOrdinal(self, rowid):
113            """Return the ordinal of the row given by its id"""
114            return self.table.RowIdToOrdinal(rowid)
115    
116        def RowOrdinalToId(self, ordinal):
117            """Return the id of the row given by its ordinal"""
118            return self.table.RowOrdinalToId(ordinal)
119    
120  class NullRenderer(wxPyGridCellRenderer):  
121    class NullRenderer(grid.PyGridCellRenderer):
122    
123      """Renderer that draws NULL as a gray rectangle      """Renderer that draws NULL as a gray rectangle
124    
# Line 112  class NullRenderer(wxPyGridCellRenderer) Line 127  class NullRenderer(wxPyGridCellRenderer)
127      """      """
128    
129      def __init__(self, non_null_renderer):      def __init__(self, non_null_renderer):
130          wxPyGridCellRenderer.__init__(self)          grid.PyGridCellRenderer.__init__(self)
131          self.non_null_renderer = non_null_renderer          self.non_null_renderer = non_null_renderer
132    
133      def Draw(self, grid, attr, dc, rect, row, col, isSelected):      def Draw(self, grid, attr, dc, rect, row, col, isSelected):
134          value = grid.table.GetValue(row, col)          value = grid.table.GetValue(row, col)
135          if value is None:          if value is None:
136              dc.SetBackgroundMode(wxSOLID)              dc.SetBackgroundMode(wx.SOLID)
137              dc.SetBrush(wxBrush(wxColour(192, 192, 192), wxSOLID))              dc.SetBrush(wx.Brush(wx.Colour(192, 192, 192), wx.SOLID))
138              dc.SetPen(wxTRANSPARENT_PEN)              dc.SetPen(wx.TRANSPARENT_PEN)
139              dc.DrawRectangle(rect.x, rect.y, rect.width, rect.height)              dc.DrawRectangle(rect.x, rect.y, rect.width, rect.height)
140          else:          else:
141              self.non_null_renderer.Draw(grid, attr, dc, rect, row, col,              self.non_null_renderer.Draw(grid, attr, dc, rect, row, col,
# Line 133  class NullRenderer(wxPyGridCellRenderer) Line 148  class NullRenderer(wxPyGridCellRenderer)
148          return NullRenderer(self.non_null_renderer)          return NullRenderer(self.non_null_renderer)
149    
150    
151  class TableGrid(wxGrid, Publisher):  class TableGrid(grid.Grid, Publisher):
152    
153      """A grid view for a Thuban table      """A grid view for a Thuban table
154    
# Line 146  class TableGrid(wxGrid, Publisher): Line 161  class TableGrid(wxGrid, Publisher):
161      """      """
162    
163      def __init__(self, parent, table = None):      def __init__(self, parent, table = None):
164          wxGrid.__init__(self, parent, -1)          grid.Grid.__init__(self, parent, -1)
165    
166          self.allow_messages_count = 0          self.allow_messages_count = 0
167    
# Line 169  class TableGrid(wxGrid, Publisher): Line 184  class TableGrid(wxGrid, Publisher):
184          # long time.          # long time.
185          #self.AutoSizeColumns(False)          #self.AutoSizeColumns(False)
186    
187          self.SetSelectionMode(wxGrid.wxGridSelectRows)          self.SetSelectionMode(grid.Grid.wxGridSelectRows)
188    
189          self.ToggleEventListeners(True)          self.ToggleEventListeners(True)
190          EVT_GRID_RANGE_SELECT(self, self.OnRangeSelect)          self.Bind(grid.EVT_GRID_RANGE_SELECT, self.OnRangeSelect)
191          EVT_GRID_SELECT_CELL(self, self.OnSelectCell)          self.Bind(grid.EVT_GRID_SELECT_CELL, self.OnSelectCell)
192    
193          # Replace the normal renderers with our own versions which          # Replace the normal renderers with our own versions which
194          # render NULL/None values specially          # render NULL/None values specially
195          self.RegisterDataType(wxGRID_VALUE_STRING,          self.RegisterDataType(grid.GRID_VALUE_STRING,
196                                NullRenderer(wxGridCellStringRenderer()), None)                                NullRenderer(grid.GridCellStringRenderer()), None)
197          self.RegisterDataType(wxGRID_VALUE_NUMBER,          self.RegisterDataType(grid.GRID_VALUE_NUMBER,
198                                NullRenderer(wxGridCellNumberRenderer()), None)                                NullRenderer(grid.GridCellNumberRenderer()), None)
199          self.RegisterDataType(wxGRID_VALUE_FLOAT,          self.RegisterDataType(grid.GRID_VALUE_FLOAT,
200                                NullRenderer(wxGridCellFloatRenderer()), None)                                NullRenderer(grid.GridCellFloatRenderer()), None)
201    
202            self.Bind(wx.EVT_WINDOW_DESTROY, self.OnDestroy)
203    
204        def OnDestroy(self, event):
205            Publisher.Destroy(self)
206    
207      def SetTableObject(self, table):      def SetTableObject(self, table):
208          self.table.SetTable(table)          self.table.SetTable(table)
209    
210      def OnRangeSelect(self, event):      def OnRangeSelect(self, event):
211            to_id = self.table.RowOrdinalToId
212          if self.handleSelectEvents:          if self.handleSelectEvents:
213              self.rows = dict([(i, 0) for i in self.GetSelectedRows()])              self.rows = dict([(to_id(i), 0) for i in self.GetSelectedRows()])
214    
215              # if we're selecting we need to include the selected range and              # if we're selecting we need to include the selected range and
216              # make sure that the current row is also included, which may              # make sure that the current row is also included, which may
217              # not be the case if you just click on a single row!              # not be the case if you just click on a single row!
218              if event.Selecting():              if event.Selecting():
219                  for i in range(event.GetTopRow(), event.GetBottomRow() + 1):                  for i in range(event.GetTopRow(), event.GetBottomRow() + 1):
220                      self.rows[i] = 0                      self.rows[to_id(i)] = 0
221                  self.rows[event.GetTopLeftCoords().GetRow()] = 0                  self.rows[to_id(event.GetTopLeftCoords().GetRow())] = 0
222        
223              self.issue(ROW_SELECTED, self.rows.keys())              self.issue(ROW_SELECTED, self.rows.keys())
224    
225          event.Skip()          event.Skip()
226    
227      def OnSelectCell(self, event):      def OnSelectCell(self, event):
228            to_id = self.table.RowOrdinalToId
229          if self.handleSelectEvents:          if self.handleSelectEvents:
230              self.issue(ROW_SELECTED, self.GetSelectedRows())              self.issue(ROW_SELECTED,
231                           [to_id(i) for i in self.GetSelectedRows()])
232          event.Skip()          event.Skip()
233    
234      def ToggleEventListeners(self, on):      def ToggleEventListeners(self, on):
235          self.handleSelectEvents = on          self.handleSelectEvents = on
236                
237      def GetNumberSelected(self):      def GetNumberSelected(self):
238          return len(self.rows)          return len(self.rows)
239    
# Line 240  class TableGrid(wxGrid, Publisher): Line 263  class TableGrid(wxGrid, Publisher):
263          if self.allow_messages_count == 0:          if self.allow_messages_count == 0:
264              Publisher.issue(self, *args)              Publisher.issue(self, *args)
265    
266        def SelectRowById(self, rowid, do_select):
267            """Select row with the id rowid"""
268            self.SelectRow(self.table.RowIdToOrdinal(rowid), do_select)
269    
270    
271  class LayerTableGrid(TableGrid):  class LayerTableGrid(TableGrid):
272    
# Line 256  class LayerTableGrid(TableGrid): Line 283  class LayerTableGrid(TableGrid):
283          nothing. If shape or layer is None also do nothing.          nothing. If shape or layer is None also do nothing.
284          """          """
285          if layer is not None \          if layer is not None \
286              and layer.table is self.table.table:              and layer.ShapeStore().Table() is self.table.table:
287    
288              self.disallow_messages()              self.disallow_messages()
289              try:              try:
290                  self.ClearSelection()                  self.ClearSelection()
291                  if len(shapes) > 0:                  if len(shapes) > 0:
292                      #                      # keep track of the lowest id so we can make it the
293                      # keep track of the lowest id so we can make it                      # first visible item
294                      # the first visible item                      first = -1
                     #  
                     first = shapes[0]  
295    
296                        to_ordinal = self.table.RowIdToOrdinal
297                      for shape in shapes:                      for shape in shapes:
298                          self.SelectRow(shape, True)                          row = to_ordinal(shape)
299                          if shape < first:                          self.SelectRow(row, True)
300                              first = shape                          if row < first:
301                                first = row
302    
303                      self.SetGridCursor(first, 0)                      self.SetGridCursor(first, 0)
304                      self.MakeCellVisible(first, 0)                      self.MakeCellVisible(first, 0)
# Line 285  class TableFrame(ThubanFrame): Line 312  class TableFrame(ThubanFrame):
312    
313      def __init__(self, parent, name, title, table):      def __init__(self, parent, name, title, table):
314          ThubanFrame.__init__(self, parent, name, title)          ThubanFrame.__init__(self, parent, name, title)
315          self.panel = wxPanel(self, -1)          self.panel = wx.Panel(self, -1)
316    
317          self.table = table          self.table = table
318          self.grid = self.make_grid(self.table)          self.grid = self.make_grid(self.table)
# Line 294  class TableFrame(ThubanFrame): Line 321  class TableFrame(ThubanFrame):
321          self.session = self.app.Session()          self.session = self.app.Session()
322          self.session.Subscribe(TABLE_REMOVED, self.close_on_table_removed)          self.session.Subscribe(TABLE_REMOVED, self.close_on_table_removed)
323    
324        def OnDestroy(self, event):
325            """Extend inherited method to unsubscribe messages"""
326            self.app.Unsubscribe(SESSION_REPLACED, self.close_on_session_replaced)
327            self.session.Unsubscribe(TABLE_REMOVED, self.close_on_table_removed)
328            ThubanFrame.OnDestroy(self, event)
329    
330      def make_grid(self, table):      def make_grid(self, table):
331          """Return the table grid to use in the frame.          """Return the table grid to use in the frame.
# Line 303  class TableFrame(ThubanFrame): Line 335  class TableFrame(ThubanFrame):
335          """          """
336          return TableGrid(self, table)          return TableGrid(self, table)
337    
     def OnClose(self, event):  
         self.app.Unsubscribe(SESSION_REPLACED, self.close_on_session_replaced)  
         self.session.Unsubscribe(TABLE_REMOVED, self.close_on_table_removed)  
         ThubanFrame.OnClose(self, event)  
   
338      def close_on_session_replaced(self, *args):      def close_on_session_replaced(self, *args):
339          """Subscriber for the SESSION_REPLACED messages.          """Subscriber for the SESSION_REPLACED messages.
340    
# Line 329  class TableFrame(ThubanFrame): Line 356  class TableFrame(ThubanFrame):
356  ID_QUERY = 4001  ID_QUERY = 4001
357  ID_EXPORT = 4002  ID_EXPORT = 4002
358  ID_COMBOVALUE = 4003  ID_COMBOVALUE = 4003
359    ID_EXPORTSEL = 4004
360    
361  class QueryTableFrame(TableFrame):  class QueryTableFrame(TableFrame):
362    
# Line 342  class QueryTableFrame(TableFrame): Line 370  class QueryTableFrame(TableFrame):
370      def __init__(self, parent, name, title, table):      def __init__(self, parent, name, title, table):
371          TableFrame.__init__(self, parent, name, title, table)          TableFrame.__init__(self, parent, name, title, table)
372    
373          self.combo_fields = wxComboBox(self.panel, -1, style=wxCB_READONLY)          self.combo_fields = wx.ComboBox(self.panel, -1, style=wx.CB_READONLY)
374          self.choice_comp = wxChoice(self.panel, -1,          self.choice_comp = wx.Choice(self.panel, -1,
375                                choices=["<", "<=", "==", "!=", ">=", ">"])                                choices=["<", "<=", "==", "!=", ">=", ">"])
376          self.combo_value = wxComboBox(self.panel, ID_COMBOVALUE)          self.combo_value = wx.ComboBox(self.panel, ID_COMBOVALUE)
377          self.choice_action = wxChoice(self.panel, -1,          self.choice_action = wx.Choice(self.panel, -1,
378                                  choices=[_("Replace Selection"),                                  choices=[_("Replace Selection"),
379                                          _("Refine Selection"),                                          _("Refine Selection"),
380                                          _("Add to Selection")])                                          _("Add to Selection")])
381    
382          button_query = wxButton(self.panel, ID_QUERY, _("Query"))          button_query = wx.Button(self.panel, ID_QUERY, _("Query"))
383          button_saveas = wxButton(self.panel, ID_EXPORT, _("Export"))          button_export = wx.Button(self.panel, ID_EXPORT, _("Export"))
384            button_exportSel = wx.Button(self.panel, ID_EXPORTSEL, _("Export Selection"))
385            button_close = wx.Button(self.panel, wx.ID_CLOSE, _("Close"))
386    
387          self.CreateStatusBar()          self.CreateStatusBar()
388    
# Line 374  class QueryTableFrame(TableFrame): Line 404  class QueryTableFrame(TableFrame):
404    
405          self.UpdateStatusText()          self.UpdateStatusText()
406    
407          topBox = wxBoxSizer(wxVERTICAL)          topBox = wx.BoxSizer(wx.VERTICAL)
408    
409          sizer = wxStaticBoxSizer(wxStaticBox(self.panel, -1,          sizer = wx.StaticBoxSizer(wx.StaticBox(self.panel, -1,
410                                    _("Selection")),                                    _("Selection")),
411                                    wxHORIZONTAL)                                    wx.HORIZONTAL)
412          sizer.Add(self.combo_fields, 1, wxEXPAND|wxALL, 4)          sizer.Add(self.combo_fields, 1, wx.EXPAND|wx.ALL, 4)
413          sizer.Add(self.choice_comp, 0, wxALL, 4)          sizer.Add(self.choice_comp, 0, wx.ALL, 4)
414          sizer.Add(self.combo_value, 1, wxEXPAND|wxALL, 4)          sizer.Add(self.combo_value, 1, wx.EXPAND|wx.ALL, 4)
415          sizer.Add(self.choice_action, 0, wxALL, 4)          sizer.Add(self.choice_action, 0, wx.ALL, 4)
416          sizer.Add(button_query, 0, wxALL | wxALIGN_CENTER_VERTICAL, 4)          sizer.Add(button_query, 0, wx.ALL | wx.ALIGN_CENTER_VERTICAL, 4)
417          sizer.Add(40, 20, 0, wxALL, 4)          sizer.Add( (40, 20), 0, wx.ALL, 4)
418          sizer.Add(button_saveas, 0, wxALL | wxALIGN_CENTER_VERTICAL, 4)  
419            topBox.Add(sizer, 0, wx.EXPAND|wx.ALL, 4)
420          topBox.Add(sizer, 0, wxEXPAND|wxALL, 4)          topBox.Add(self.grid, 1, wx.EXPAND|wx.ALL, 0)
421          topBox.Add(self.grid, 1, wxEXPAND|wxALL, 0)  
422            sizer = wx.BoxSizer(wx.HORIZONTAL)
423            sizer.Add(button_export, 0, wx.ALL, 4)
424            sizer.Add(button_exportSel, 0, wx.ALL, 4)
425            sizer.Add( (60, 20), 1, wx.ALL|wx.EXPAND, 4)
426            sizer.Add(button_close, 0, wx.ALL|wx.ALIGN_RIGHT, 4)
427            topBox.Add(sizer, 0, wx.ALL | wx.EXPAND, 4)
428    
429          self.panel.SetAutoLayout(True)          self.panel.SetAutoLayout(True)
430          self.panel.SetSizer(topBox)          self.panel.SetSizer(topBox)
431          topBox.Fit(self.panel)          topBox.Fit(self.panel)
432          topBox.SetSizeHints(self.panel)          topBox.SetSizeHints(self.panel)
433    
434          panelSizer = wxBoxSizer(wxVERTICAL)          panelSizer = wx.BoxSizer(wx.VERTICAL)
435          panelSizer.Add(self.panel, 1, wxEXPAND, 0)          panelSizer.Add(self.panel, 1, wx.EXPAND, 0)
436          self.SetAutoLayout(True)          self.SetAutoLayout(True)
437          self.SetSizer(panelSizer)          self.SetSizer(panelSizer)
438          panelSizer.Fit(self)          panelSizer.Fit(self)
# Line 404  class QueryTableFrame(TableFrame): Line 440  class QueryTableFrame(TableFrame):
440    
441          self.grid.SetFocus()          self.grid.SetFocus()
442    
443          EVT_BUTTON(self, ID_QUERY, self.OnQuery)          self.Bind(wx.EVT_BUTTON, self.OnQuery, id=ID_QUERY)
444          EVT_BUTTON(self, ID_EXPORT, self.OnSaveAs)          self.Bind(wx.EVT_BUTTON, self.OnExport, id=ID_EXPORT)
445          EVT_KEY_DOWN(self.grid, self.OnKeyDown)          self.Bind(wx.EVT_BUTTON, self.OnExportSel, id=ID_EXPORTSEL)
446          EVT_GRID_RANGE_SELECT(self.grid, self.OnGridSelectRange)          self.Bind(wx.EVT_BUTTON, self.OnClose, id=wx.ID_CLOSE)
447          EVT_GRID_SELECT_CELL(self.grid, self.OnGridSelectCell)          self.Bind(wx.EVT_KEY_DOWN, self.OnKeyDown, self.grid)
448    
449      def UpdateStatusText(self):          self.grid.Subscribe(ROW_SELECTED, self.UpdateStatusText)
450          self.SetStatusText(_("%i rows (%i selected), %i columns")  
451              % (self.grid.GetNumberRows(),      def UpdateStatusText(self, rows=None):
452            self.SetStatusText(_("%i rows (%i selected), %i columns")
453                % (self.grid.GetNumberRows(),
454                 self.grid.GetNumberSelected(),                 self.grid.GetNumberSelected(),
455                 self.grid.GetNumberCols()))                 self.grid.GetNumberCols()))
456    
     def OnGridSelectRange(self, event):  
         self.UpdateStatusText()  
         event.Skip()  
   
     def OnGridSelectCell(self, event):  
         self.UpdateStatusText()  
         event.Skip()  
           
457      def OnKeyDown(self, event):      def OnKeyDown(self, event):
458          """Catch query key from grid"""          """Catch query key from grid"""
459          if event.AltDown() and event.GetKeyCode() == ord(QUERY_KEY):          if event.AltDown() and event.GetKeyCode() == ord(QUERY_KEY):
# Line 433  class QueryTableFrame(TableFrame): Line 463  class QueryTableFrame(TableFrame):
463              event.Skip()              event.Skip()
464    
465      def OnQuery(self, event):      def OnQuery(self, event):
466          wxBeginBusyCursor()          ThubanBeginBusyCursor()
467          try:          try:
468    
469              text = self.combo_value.GetValue()              text = self.combo_value.GetValue()
# Line 444  class QueryTableFrame(TableFrame): Line 474  class QueryTableFrame(TableFrame):
474                  value = self.table.Column(text)                  value = self.table.Column(text)
475    
476              ids = self.table.SimpleQuery(              ids = self.table.SimpleQuery(
477                      self.table.Column(self.combo_fields.GetStringSelection()),                      self.table.Column(self.combo_fields.GetStringSelection()),
478                      self.choice_comp.GetStringSelection(),                      self.choice_comp.GetStringSelection(),
479                      value)                      value)
480    
481              choice = self.choice_action.GetSelection()              choice = self.choice_action.GetSelection()
482                
483              #              #
484              # what used to be nice code got became a bit ugly because              # what used to be nice code got became a bit ugly because
485              # each time we select a row a message is sent to the grid              # each time we select a row a message is sent to the grid
# Line 484  class QueryTableFrame(TableFrame): Line 514  class QueryTableFrame(TableFrame):
514                  if firsttime:                  if firsttime:
515                      firsttime = False                      firsttime = False
516                  else:                  else:
517                      self.grid.SelectRow(id, True)                      self.grid.SelectRowById(id, True)
518    
519              self.grid.ToggleEventListeners(True)              self.grid.ToggleEventListeners(True)
520    
# Line 492  class QueryTableFrame(TableFrame): Line 522  class QueryTableFrame(TableFrame):
522              # select the first row              # select the first row
523              #              #
524              if ids:              if ids:
525                  self.grid.SelectRow(ids[0], True)                  self.grid.SelectRowById(ids[0], True)
526    
527          finally:          finally:
528              wxEndBusyCursor()              ThubanEndBusyCursor()
529            
530      def OnSaveAs(self, event):      def doExport(self, onlySelected):
531          dlg = wxFileDialog(self, _("Export Table To"), ".", "",  
532            dlg = wx.FileDialog(self, _("Export Table To"), ".", "",
533                             _("DBF Files (*.dbf)|*.dbf|") +                             _("DBF Files (*.dbf)|*.dbf|") +
534                             _("CSV Files (*.csv)|*.csv|") +                             _("CSV Files (*.csv)|*.csv|") +
535                             _("All Files (*.*)|*.*"),                             _("All Files (*.*)|*.*"),
536                             wxSAVE|wxOVERWRITE_PROMPT)                             wx.SAVE|wx.OVERWRITE_PROMPT)
537          if dlg.ShowModal() == wxID_OK:          if dlg.ShowModal() == wx.ID_OK:
538              filename = dlg.GetPath()              filename = dlg.GetPath()
539              type = os.path.basename(filename).split('.')[-1:][0]              type = os.path.basename(filename).split('.')[-1:][0]
540              dlg.Destroy()              dlg.Destroy()
541    
542                if onlySelected:
543                    records = self.grid.GetSelectedRows()
544                else:
545                    records = None
546    
547              if type.upper() == "DBF":              if type.upper() == "DBF":
548                  table_to_dbf(self.table, filename)                  table_to_dbf(self.table, filename, records)
549              elif type.upper() == 'CSV':              elif type.upper() == 'CSV':
550                  table_to_csv(self.table, filename)                  table_to_csv(self.table, filename, records)
551              else:              else:
552                  dlg = wxMessageDialog(None, "Unsupported format: %s" % type,                  dlg = wx.MessageDialog(None, "Unsupported format: %s" % type,
553                                        "Table Export", wxOK|wxICON_WARNING)                                        "Table Export", wx.OK|wx.ICON_WARNING)
554                  dlg.ShowModal()                  dlg.ShowModal()
555                  dlg.Destroy()                  dlg.Destroy()
556          else:          else:
557              dlg.Destroy()              dlg.Destroy()
558    
559        def OnExport(self, event):
560            self.doExport(False)
561    
562        def OnExportSel(self, event):
563            self.doExport(True)
564    
565      def OnClose(self, event):      def OnClose(self, event):
566          TableFrame.OnClose(self, event)          TableFrame.OnClose(self, event)
567    
568      def get_selected(self):      def get_selected(self):
569          """Return a dictionary of the selected rows.          """Return a dictionary of the selected rows.
570            
571          The dictionary has sthe indexes as keys."""          The dictionary has the indexes as keys."""
572          return dict([(i, 0) for i in self.grid.GetSelectedRows()])          to_id = self.table.RowOrdinalToId
573            return dict([(to_id(i), 0) for i in self.grid.GetSelectedRows()])
574    
575    
576  class LayerTableFrame(QueryTableFrame):  class LayerTableFrame(QueryTableFrame):
577    
# Line 548  class LayerTableFrame(QueryTableFrame): Line 593  class LayerTableFrame(QueryTableFrame):
593          # accordingly          # accordingly
594          sel = self.get_selected().keys()          sel = self.get_selected().keys()
595          for i in sel:          for i in sel:
596              self.grid.SelectRow(i, True)              self.grid.SelectRowById(i, True)
597    
598        def OnDestroy(self, event):
599            """Extend inherited method to unsubscribe messages"""
600            # There's no need to unsubscribe from self.grid's messages
601            # because it will get a DESTROY event too (since destroying the
602            # frame basically means that all child windows are also
603            # destroyed) and this it will clear all subscriptions
604            # automatically.  It may even have been destroyed already (this
605            # does happen on w2000 for instance) so calling any of its
606            # methods here would be an error.
607            self.parent.Unsubscribe(SHAPES_SELECTED, self.select_shapes)
608            self.map.Unsubscribe(MAP_LAYERS_REMOVED, self.map_layers_removed)
609            QueryTableFrame.OnDestroy(self, event)
610    
611      def make_grid(self, table):      def make_grid(self, table):
612          """Override the derived method to return a LayerTableGrid.          """Override the derived method to return a LayerTableGrid.
# Line 561  class LayerTableFrame(QueryTableFrame): Line 619  class LayerTableFrame(QueryTableFrame):
619          """          """
620          return dict([(i, 0) for i in self.parent.SelectedShapes()])          return dict([(i, 0) for i in self.parent.SelectedShapes()])
621    
     def OnClose(self, event):  
         """Override the derived method to first unsubscribed."""  
         self.parent.Unsubscribe(SHAPES_SELECTED, self.select_shapes)  
         self.grid.Unsubscribe(ROW_SELECTED, self.rows_selected)  
         self.map.Unsubscribe(MAP_LAYERS_REMOVED, self.map_layers_removed)  
         QueryTableFrame.OnClose(self, event)  
   
622      def select_shapes(self, layer, shapes):      def select_shapes(self, layer, shapes):
623          """Subscribed to the SHAPES_SELECTED message.          """Subscribed to the SHAPES_SELECTED message.
624    

Legend:
Removed from v.1202  
changed lines
  Added in v.2755

[email protected]
ViewVC Help
Powered by ViewVC 1.1.26