gselect.py 31 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897
  1. """!
  2. @package gselect
  3. @brief Custom control that selects elements
  4. Classes:
  5. - Select
  6. - VectorSelect
  7. - TreeCrtlComboPopup
  8. - VectorDBInfo
  9. - LayerSelect
  10. - LayerNameSelect
  11. - DriverSelect
  12. - DatabaseSelect
  13. - ColumnSelect
  14. - LocationSelect
  15. - MapsetSelect
  16. - SubGroupSelect
  17. - FormatSelect
  18. (C) 2007-2010 by the GRASS Development Team This program is free
  19. software under the GNU General Public License (>=v2). Read the file
  20. COPYING that comes with GRASS for details.
  21. @author Michael Barton
  22. @author Martin Landa <landa.martin gmail.com>
  23. """
  24. import os
  25. import sys
  26. import wx
  27. import wx.combo
  28. import globalvar
  29. grassPath = os.path.join(globalvar.ETCDIR, "python")
  30. sys.path.append(grassPath)
  31. import grass.script as grass
  32. import gcmd
  33. import utils
  34. from preferences import globalSettings as UserSettings
  35. class Select(wx.combo.ComboCtrl):
  36. def __init__(self, parent, id, size = globalvar.DIALOG_GSELECT_SIZE,
  37. type = None, multiple = False, mapsets = None, exclude = [],
  38. updateOnPopup = True):
  39. """!Custom control to create a ComboBox with a tree control
  40. to display and select GIS elements within acessible mapsets.
  41. Elements can be selected with mouse. Can allow multiple selections, when
  42. argument multiple=True. Multiple selections are separated by commas.
  43. """
  44. wx.combo.ComboCtrl.__init__(self, parent=parent, id=id, size=size)
  45. self.GetChildren()[0].SetName("Select")
  46. self.GetChildren()[0].type = type
  47. self.tcp = TreeCtrlComboPopup()
  48. self.SetPopupControl(self.tcp)
  49. self.SetPopupExtents(0,100)
  50. if type:
  51. self.tcp.SetData(type = type, mapsets = mapsets,
  52. exclude = exclude, multiple = multiple,
  53. updateOnPopup = updateOnPopup)
  54. def SetElementList(self, type, mapsets = None, exclude = []):
  55. """!Set element list
  56. @param type GIS element type
  57. @param mapsets list of acceptable mapsets (None for all in search path)
  58. @param exclude list of GIS elements to be excluded
  59. """
  60. self.tcp.SetData(type = type, mapsets = mapsets,
  61. exclude = exclude)
  62. def GetElementList(self):
  63. """!Load elements"""
  64. self.tcp.GetElementList()
  65. class VectorSelect(Select):
  66. def __init__(self, parent, ftype, **kwargs):
  67. """!Custom to create a ComboBox with a tree control to display and
  68. select vector maps. Control allows to filter vector maps. If you
  69. don't need this feature use Select class instead
  70. @ftype filter vector maps based on feature type
  71. """
  72. Select.__init__(self, parent = parent, id = wx.ID_ANY,
  73. type = 'vector', **kwargs)
  74. self.ftype = ftype
  75. # remove vector maps which do not contain given feature type
  76. self.tcp.SetFilter(self.__isElement)
  77. def __isElement(self, vectorName):
  78. """!Check if element should be filtered out"""
  79. try:
  80. if int(grass.vector_info_topo(vectorName)[self.ftype]) < 1:
  81. return False
  82. except KeyError:
  83. return False
  84. return True
  85. class TreeCtrlComboPopup(wx.combo.ComboPopup):
  86. """!Create a tree ComboBox for selecting maps and other GIS elements
  87. in accessible mapsets within the current location
  88. """
  89. # overridden ComboPopup methods
  90. def Init(self):
  91. self.value = [] # for multiple is False -> len(self.value) in [0,1]
  92. self.curitem = None
  93. self.multiple = False
  94. self.type = None
  95. self.mapsets = []
  96. self.exclude = []
  97. self.SetFilter(None)
  98. def Create(self, parent):
  99. self.seltree = wx.TreeCtrl(parent, style=wx.TR_HIDE_ROOT
  100. |wx.TR_HAS_BUTTONS
  101. |wx.TR_SINGLE
  102. |wx.TR_LINES_AT_ROOT
  103. |wx.SIMPLE_BORDER
  104. |wx.TR_FULL_ROW_HIGHLIGHT)
  105. self.seltree.Bind(wx.EVT_MOTION, self.OnMotion)
  106. self.seltree.Bind(wx.EVT_LEFT_DOWN, self.OnLeftDown)
  107. self.seltree.Bind(wx.EVT_TREE_ITEM_EXPANDING, self.mapsetExpanded)
  108. self.seltree.Bind(wx.EVT_TREE_ITEM_COLLAPSED, self.mapsetCollapsed)
  109. self.seltree.Bind(wx.EVT_TREE_ITEM_ACTIVATED, self.mapsetActivated)
  110. self.seltree.Bind(wx.EVT_TREE_SEL_CHANGED, self.mapsetSelected)
  111. self.seltree.Bind(wx.EVT_TREE_DELETE_ITEM, lambda x: None)
  112. # the following dummy handler are needed to keep tree events from propagating up to
  113. # the parent GIS Manager layer tree
  114. def mapsetExpanded(self, event):
  115. pass
  116. def mapsetCollapsed(self, event):
  117. pass
  118. def mapsetActivated(self, event):
  119. pass
  120. def mapsetSelected(self, event):
  121. pass
  122. # end of dummy events
  123. def GetControl(self):
  124. return self.seltree
  125. def GetStringValue(self):
  126. str = ""
  127. for value in self.value:
  128. str += value + ","
  129. str = str.rstrip(',')
  130. return str
  131. def SetFilter(self, filter):
  132. """!Set filter for GIS elements, see e.g. VectorSelect"""
  133. self.filterElements = filter
  134. def OnPopup(self, force = False):
  135. """!Limited only for first selected"""
  136. if not force and not self.updateOnPopup:
  137. return
  138. self.GetElementList()
  139. def GetElementList(self):
  140. """!Get filtered list of GIS elements in accessible mapsets
  141. and display as tree with all relevant elements displayed
  142. beneath each mapset branch
  143. """
  144. # update list
  145. self.seltree.DeleteAllItems()
  146. self._getElementList(self.type, self.mapsets, self.exclude)
  147. if len(self.value) > 0:
  148. root = self.seltree.GetRootItem()
  149. if not root:
  150. return
  151. item = self.FindItem(root, self.value[0])
  152. try:
  153. self.seltree.EnsureVisible(item)
  154. self.seltree.SelectItem(item)
  155. except:
  156. pass
  157. def SetStringValue(self, value):
  158. # this assumes that item strings are unique...
  159. root = self.seltree.GetRootItem()
  160. if not root:
  161. return
  162. found = self.FindItem(root, value)
  163. if found:
  164. self.value.append(found)
  165. self.seltree.SelectItem(found)
  166. def GetAdjustedSize(self, minWidth, prefHeight, maxHeight):
  167. return wx.Size(minWidth, min(200, maxHeight))
  168. def _getElementList(self, element, mapsets=None, exclude=[]):
  169. """!Get list of GIS elements in accessible mapsets and display as tree
  170. with all relevant elements displayed beneath each mapset branch
  171. @param element GIS element
  172. @param mapsets list of acceptable mapsets (None for all mapsets in search path)
  173. @param exclude list of GIS elements to be excluded
  174. """
  175. # get current mapset
  176. curr_mapset = grass.gisenv()['MAPSET']
  177. # list of mapsets in current location
  178. if mapsets is None:
  179. mapsets = utils.ListOfMapsets()
  180. # map element types to g.mlist types
  181. elementdict = {'cell':'rast',
  182. 'raster':'rast',
  183. 'rast':'rast',
  184. 'raster files':'rast',
  185. 'grid3':'rast3d',
  186. 'rast3d':'rast3d',
  187. 'raster3D':'rast3d',
  188. 'raster3D files':'rast3d',
  189. 'vector':'vect',
  190. 'vect':'vect',
  191. 'binary vector files':'vect',
  192. 'dig':'oldvect',
  193. 'oldvect':'oldvect',
  194. 'old vector':'oldvect',
  195. 'dig_ascii':'asciivect',
  196. 'asciivect':'asciivect',
  197. 'asciivector':'asciivect',
  198. 'ascii vector files':'asciivect',
  199. 'icons':'icon',
  200. 'icon':'icon',
  201. 'paint icon files':'icon',
  202. 'paint/labels':'labels',
  203. 'labels':'labels',
  204. 'label':'labels',
  205. 'paint label files':'labels',
  206. 'site_lists':'sites',
  207. 'sites':'sites',
  208. 'site list':'sites',
  209. 'site list files':'sites',
  210. 'windows':'region',
  211. 'region':'region',
  212. 'region definition':'region',
  213. 'region definition files':'region',
  214. 'windows3d':'region3d',
  215. 'region3d':'region3d',
  216. 'region3D definition':'region3d',
  217. 'region3D definition files':'region3d',
  218. 'group':'group',
  219. 'imagery group':'group',
  220. 'imagery group files':'group',
  221. '3d.view':'3dview',
  222. '3dview':'3dview',
  223. '3D viewing parameters':'3dview',
  224. '3D view parameters':'3dview'}
  225. if element not in elementdict:
  226. self.AddItem(_('Not selectable element'))
  227. return
  228. # get directory tree nodes
  229. # reorder mapsets based on search path (TODO)
  230. for i in range(len(mapsets)):
  231. if i > 0 and mapsets[i] == curr_mapset:
  232. mapsets[i] = mapsets[0]
  233. mapsets[0] = curr_mapset
  234. if globalvar.have_mlist:
  235. filesdict = grass.mlist_grouped(elementdict[element])
  236. else:
  237. filesdict = grass.list_grouped(elementdict[element])
  238. first_dir = None
  239. for dir in mapsets:
  240. dir_node = self.AddItem('Mapset: ' + dir)
  241. if not first_dir:
  242. first_dir = dir_node
  243. self.seltree.SetItemTextColour(dir_node, wx.Colour(50, 50, 200))
  244. try:
  245. elem_list = filesdict[dir]
  246. elem_list.sort(key=str.lower)
  247. for elem in elem_list:
  248. if elem != '':
  249. fullqElem = elem + '@' + dir
  250. if len(exclude) > 0 and fullqElem in exclude:
  251. continue
  252. if self.filterElements:
  253. if self.filterElements(fullqElem):
  254. self.AddItem(fullqElem, parent=dir_node)
  255. else:
  256. self.AddItem(fullqElem, parent=dir_node)
  257. except:
  258. continue
  259. if self.seltree.ItemHasChildren(dir_node):
  260. sel = UserSettings.Get(group='general', key='elementListExpand',
  261. subkey='selection')
  262. collapse = True
  263. if sel == 0: # collapse all except PERMANENT and current
  264. if dir in ('PERMANENT', curr_mapset):
  265. collapse = False
  266. elif sel == 1: # collapse all except PERMANENT
  267. if dir == 'PERMANENT':
  268. collapse = False
  269. elif sel == 2: # collapse all except current
  270. if dir == curr_mapset:
  271. collapse = False
  272. elif sel == 3: # collapse all
  273. pass
  274. elif sel == 4: # expand all
  275. collapse = False
  276. if collapse:
  277. self.seltree.Collapse(dir_node)
  278. else:
  279. self.seltree.Expand(dir_node)
  280. if first_dir:
  281. # select first mapset (MSW hack)
  282. self.seltree.SelectItem(first_dir)
  283. # helpers
  284. def FindItem(self, parentItem, text):
  285. item, cookie = self.seltree.GetFirstChild(parentItem)
  286. while item:
  287. if self.seltree.GetItemText(item) == text:
  288. return item
  289. if self.seltree.ItemHasChildren(item):
  290. item = self.FindItem(item, text)
  291. item, cookie = self.seltree.GetNextChild(parentItem, cookie)
  292. return wx.TreeItemId()
  293. def AddItem(self, value, parent=None):
  294. if not parent:
  295. root = self.seltree.GetRootItem()
  296. if not root:
  297. root = self.seltree.AddRoot("<hidden root>")
  298. parent = root
  299. item = self.seltree.AppendItem(parent, text=value)
  300. return item
  301. def OnMotion(self, evt):
  302. # have the selection follow the mouse, like in a real combobox
  303. item, flags = self.seltree.HitTest(evt.GetPosition())
  304. if item and flags & wx.TREE_HITTEST_ONITEMLABEL:
  305. self.seltree.SelectItem(item)
  306. self.curitem = item
  307. evt.Skip()
  308. def OnLeftDown(self, evt):
  309. # do the combobox selection
  310. item, flags = self.seltree.HitTest(evt.GetPosition())
  311. if item and flags & wx.TREE_HITTEST_ONITEMLABEL:
  312. self.curitem = item
  313. if self.seltree.GetRootItem() == self.seltree.GetItemParent(item):
  314. self.value = [] # cannot select mapset item
  315. else:
  316. if self.multiple is True:
  317. # text item should be unique
  318. self.value.append(self.seltree.GetItemText(item))
  319. else:
  320. self.value = [self.seltree.GetItemText(item), ]
  321. self.Dismiss()
  322. evt.Skip()
  323. def SetData(self, **kargs):
  324. """!Set object properties"""
  325. if kargs.has_key('type'):
  326. self.type = kargs['type']
  327. if kargs.has_key('mapsets'):
  328. self.mapsets = kargs['mapsets']
  329. if kargs.has_key('exclude'):
  330. self.exclude = kargs['exclude']
  331. if kargs.has_key('multiple'):
  332. self.multiple = kargs['multiple']
  333. if kargs.has_key('updateOnPopup'):
  334. self.updateOnPopup = kargs['updateOnPopup']
  335. class VectorDBInfo:
  336. """!Class providing information about attribute tables
  337. linked to a vector map"""
  338. def __init__(self, map):
  339. self.map = map
  340. # dictionary of layer number and associated (driver, database, table)
  341. self.layers = {}
  342. # dictionary of table and associated columns (type, length, values, ids)
  343. self.tables = {}
  344. if not self.__CheckDBConnection(): # -> self.layers
  345. return
  346. self.__DescribeTables() # -> self.tables
  347. def __CheckDBConnection(self):
  348. """!Check DB connection"""
  349. nuldev = file(os.devnull, 'w+')
  350. self.layers = grass.vector_db(map=self.map, stderr=nuldev)
  351. nuldev.close()
  352. if (len(self.layers.keys()) == 0):
  353. return False
  354. return True
  355. def __DescribeTables(self):
  356. """!Describe linked tables"""
  357. for layer in self.layers.keys():
  358. # determine column names and types
  359. table = self.layers[layer]["table"]
  360. columns = {} # {name: {type, length, [values], [ids]}}
  361. i = 0
  362. for item in grass.db_describe(table = self.layers[layer]["table"],
  363. driver = self.layers[layer]["driver"],
  364. database = self.layers[layer]["database"])['cols']:
  365. name, type, length = item
  366. # FIXME: support more datatypes
  367. if type.lower() == "integer":
  368. ctype = int
  369. elif type.lower() == "double precision":
  370. ctype = float
  371. else:
  372. ctype = str
  373. columns[name.strip()] = { 'index' : i,
  374. 'type' : type.lower(),
  375. 'ctype' : ctype,
  376. 'length' : int(length),
  377. 'values' : [],
  378. 'ids' : []}
  379. i += 1
  380. # check for key column
  381. # v.db.connect -g/p returns always key column name lowercase
  382. if self.layers[layer]["key"] not in columns.keys():
  383. for col in columns.keys():
  384. if col.lower() == self.layers[layer]["key"]:
  385. self.layers[layer]["key"] = col.upper()
  386. break
  387. self.tables[table] = columns
  388. return True
  389. def Reset(self):
  390. """!Reset"""
  391. for layer in self.layers:
  392. table = self.layers[layer]["table"] # get table desc
  393. columns = self.tables[table]
  394. for name in self.tables[table].keys():
  395. self.tables[table][name]['values'] = []
  396. self.tables[table][name]['ids'] = []
  397. def GetName(self):
  398. """!Get vector name"""
  399. return self.map
  400. def GetKeyColumn(self, layer):
  401. """!Get key column of given layer
  402. @param layer vector layer number
  403. """
  404. return self.layers[layer]['key']
  405. def GetTable(self, layer):
  406. """!Get table name of given layer
  407. @param layer vector layer number
  408. """
  409. return self.layers[layer]['table']
  410. def GetDbSettings(self, layer):
  411. """!Get database settins
  412. @param layer layer number
  413. @return (driver, database)
  414. """
  415. return self.layers[layer]['driver'], self.layers[layer]['database']
  416. def GetTableDesc(self, table):
  417. """!Get table columns
  418. @param table table name
  419. """
  420. return self.tables[table]
  421. class LayerSelect(wx.Choice):
  422. def __init__(self, parent, id = wx.ID_ANY,
  423. size=globalvar.DIALOG_LAYER_SIZE,
  424. vector = None, choices = [], all = False, default = None):
  425. """!Creates widget for selecting vector map layer numbers
  426. @param vector vector map name or None
  427. @param choices list of predefined choices
  428. @param all adds layer '-1' (e.g., for d.vect)
  429. @param default default layer number
  430. """
  431. super(LayerSelect, self).__init__(parent, id, size = size,
  432. choices = choices)
  433. self.all = all
  434. self.SetName("LayerSelect")
  435. # default value
  436. self.default = default
  437. if len(choices) > 1:
  438. return
  439. if vector:
  440. self.InsertLayers(vector)
  441. else:
  442. if all:
  443. self.SetItems(['-1', '1'])
  444. else:
  445. self.SetItems(['1'])
  446. self.SetStringSelection('1')
  447. def InsertLayers(self, vector):
  448. """!Insert layers for a vector into the layer combobox"""
  449. layerchoices = utils.GetVectorNumberOfLayers(vector)
  450. if self.all:
  451. layerchoices.insert(0, '-1')
  452. if len(layerchoices) > 1:
  453. self.SetItems(layerchoices)
  454. self.SetStringSelection('1')
  455. else:
  456. self.SetItems(['1'])
  457. self.SetStringSelection('1')
  458. if self.default:
  459. self.SetStringSelection(str(self.default))
  460. class LayerNameSelect(wx.ComboBox):
  461. def __init__(self, parent, id = wx.ID_ANY,
  462. size = globalvar.DIALOG_COMBOBOX_SIZE,
  463. vector = None, dsn = None):
  464. """!Creates combo box for selecting vector map layer names
  465. @param vector vector map name (native or connected via v.external)
  466. @param dsn OGR data source name
  467. """
  468. super(LayerNameSelect, self).__init__(parent, id, size = size)
  469. self.SetName("LayerNameSelect")
  470. if vector:
  471. # -> native
  472. self.InsertLayers(vector = vector)
  473. elif dsn:
  474. self.InsertLayers(dsn = dsn)
  475. def InsertLayers(self, vector = None, dsn = None):
  476. """!Insert layers for a vector into the layer combobox
  477. @todo Implement native format
  478. @param vector vector map name (native or connected via v.external)
  479. @param dsn OGR data source name
  480. """
  481. layers = list()
  482. if vector:
  483. # TODO
  484. pass
  485. elif dsn:
  486. ret = gcmd.RunCommand('v.in.ogr',
  487. read = True,
  488. quiet = True,
  489. flags = 'l',
  490. dsn = dsn)
  491. if ret:
  492. layers = ret.splitlines()
  493. self.SetItems(layers)
  494. self.SetSelection(0)
  495. class DriverSelect(wx.ComboBox):
  496. """!Creates combo box for selecting database driver.
  497. """
  498. def __init__(self, parent, choices, value,
  499. id=wx.ID_ANY, pos=wx.DefaultPosition,
  500. size=globalvar.DIALOG_LAYER_SIZE, **kargs):
  501. super(DriverSelect, self).__init__(parent, id, value, pos, size,
  502. choices, style=wx.CB_READONLY)
  503. self.SetName("DriverSelect")
  504. self.SetStringSelection(value)
  505. class DatabaseSelect(wx.TextCtrl):
  506. """!Creates combo box for selecting database driver.
  507. """
  508. def __init__(self, parent, value='',
  509. id=wx.ID_ANY, pos=wx.DefaultPosition,
  510. size=globalvar.DIALOG_TEXTCTRL_SIZE, **kargs):
  511. super(DatabaseSelect, self).__init__(parent, id, value, pos, size)
  512. self.SetName("DatabaseSelect")
  513. class TableSelect(wx.ComboBox):
  514. """!Creates combo box for selecting attribute tables from the database
  515. """
  516. def __init__(self, parent,
  517. id=wx.ID_ANY, value='', pos=wx.DefaultPosition,
  518. size=globalvar.DIALOG_COMBOBOX_SIZE,
  519. choices=[]):
  520. super(TableSelect, self).__init__(parent, id, value, pos, size, choices,
  521. style=wx.CB_READONLY)
  522. self.SetName("TableSelect")
  523. if not choices:
  524. self.InsertTables()
  525. def InsertTables(self, driver=None, database=None):
  526. """!Insert attribute tables into combobox"""
  527. items = []
  528. if not driver or not database:
  529. connect = grass.db_connection()
  530. driver = connect['driver']
  531. database = connect['database']
  532. ret = gcmd.RunCommand('db.tables',
  533. flags = 'p',
  534. read = True,
  535. driver = driver,
  536. database = database)
  537. if ret:
  538. for table in ret.splitlines():
  539. items.append(table)
  540. self.SetItems(items)
  541. self.SetValue('')
  542. class ColumnSelect(wx.ComboBox):
  543. """!Creates combo box for selecting columns in the attribute table
  544. for a vector map.
  545. @param parent window parent
  546. @param id window id
  547. @param value default value
  548. @param size window size
  549. @param vector vector map name
  550. @param layer layer number
  551. @param param parameters list (see menuform.py)
  552. @param **kwags wx.ComboBox parameters
  553. """
  554. def __init__(self, parent, id = wx.ID_ANY, value = '',
  555. size=globalvar.DIALOG_COMBOBOX_SIZE,
  556. vector = None, layer = 1, param = None, **kwargs):
  557. self.defaultValue = value
  558. self.param = param
  559. super(ColumnSelect, self).__init__(parent, id, value, size = size, **kwargs)
  560. self.SetName("ColumnSelect")
  561. if vector:
  562. self.InsertColumns(vector, layer)
  563. def InsertColumns(self, vector, layer, excludeKey = False, type = None):
  564. """!Insert columns for a vector attribute table into the columns combobox
  565. @param vector vector name
  566. @param layer vector layer number
  567. @param excludeKey exclude key column from the list?
  568. @param type only columns of given type (given as list)
  569. """
  570. dbInfo = VectorDBInfo(vector)
  571. try:
  572. table = dbInfo.GetTable(int(layer))
  573. columnchoices = dbInfo.GetTableDesc(table)
  574. keyColumn = dbInfo.GetKeyColumn(int(layer))
  575. columns = len(columnchoices.keys()) * ['']
  576. for key, val in columnchoices.iteritems():
  577. columns[val['index']] = key
  578. if excludeKey: # exclude key column
  579. columns.remove(keyColumn)
  580. if type: # only selected column types
  581. for key, value in columnchoices.iteritems():
  582. if value['type'] not in type:
  583. columns.remove(key)
  584. except (KeyError, ValueError):
  585. columns = list()
  586. self.SetItems(columns)
  587. self.SetValue(self.defaultValue)
  588. if self.param:
  589. self.param['value'] = ''
  590. def InsertTableColumns(self, table, driver=None, database=None):
  591. """!Insert table columns
  592. @param table table name
  593. @param driver driver name
  594. @param database database name
  595. """
  596. columns = list()
  597. ret = gcmd.RunCommand('db.columns',
  598. read = True,
  599. driver = driver,
  600. database = database,
  601. table = table)
  602. if ret:
  603. columns = ret.splitlines()
  604. self.SetItems(columns)
  605. self.SetValue(self.defaultValue)
  606. if self.param:
  607. self.param['value'] = ''
  608. class LocationSelect(wx.ComboBox):
  609. """!Widget for selecting GRASS location"""
  610. def __init__(self, parent, id = wx.ID_ANY, size = globalvar.DIALOG_COMBOBOX_SIZE,
  611. gisdbase = None, **kwargs):
  612. super(LocationSelect, self).__init__(parent, id, size = size,
  613. style = wx.CB_READONLY, **kwargs)
  614. self.SetName("LocationSelect")
  615. if not gisdbase:
  616. self.gisdbase = grass.gisenv()['GISDBASE']
  617. else:
  618. self.gisdbase = gisdbase
  619. self.SetItems(utils.GetListOfLocations(self.gisdbase))
  620. class MapsetSelect(wx.ComboBox):
  621. """!Widget for selecting GRASS mapset"""
  622. def __init__(self, parent, id = wx.ID_ANY, size = globalvar.DIALOG_COMBOBOX_SIZE,
  623. gisdbase = None, location = None, setItems = True, **kwargs):
  624. super(MapsetSelect, self).__init__(parent, id, size = size,
  625. style = wx.CB_READONLY, **kwargs)
  626. self.SetName("MapsetSelect")
  627. if not gisdbase:
  628. self.gisdbase = grass.gisenv()['GISDBASE']
  629. else:
  630. self.gisdbase = gisdbase
  631. if not location:
  632. self.location = grass.gisenv()['LOCATION_NAME']
  633. else:
  634. self.location = location
  635. if setItems:
  636. self.SetItems(utils.GetListOfMapsets(self.gisdbase, self.location, selectable = True)) # selectable
  637. class SubGroupSelect(wx.ComboBox):
  638. """!Widget for selecting subgroups"""
  639. def __init__(self, parent, id = wx.ID_ANY, size = globalvar.DIALOG_GSELECT_SIZE,
  640. **kwargs):
  641. super(SubGroupSelect, self).__init__(parent, id, size = size,
  642. style = wx.CB_READONLY, **kwargs)
  643. self.SetName("SubGroupSelect")
  644. def Insert(self, group):
  645. """!Insert subgroups for defined group"""
  646. if not group:
  647. return
  648. gisenv = grass.gisenv()
  649. try:
  650. name, mapset = group.split('@', 1)
  651. except ValueError:
  652. name = group
  653. mapset = gisenv['MAPSET']
  654. path = os.path.join(gisenv['GISDBASE'], gisenv['LOCATION_NAME'], mapset,
  655. 'group', name, 'subgroup')
  656. try:
  657. self.SetItems(os.listdir(path))
  658. except OSError:
  659. self.SetItems([])
  660. self.SetValue('')
  661. class FormatSelect(wx.Choice):
  662. def __init__(self, parent, ftype, sourceType = None, id = wx.ID_ANY, size = globalvar.DIALOG_COMBOBOX_SIZE,
  663. **kwargs):
  664. """!Widget for selecting external (GDAL/OGR) format
  665. @param parent parent window
  666. @param sourceType source type ('file', 'directory', 'database', 'protocol') or None
  667. @param dataType data type ('gdal' or 'ogr')
  668. """
  669. super(FormatSelect, self).__init__(parent, id, size = size,
  670. style = wx.CB_READONLY, **kwargs)
  671. self.SetName("FormatSelect")
  672. formats = list()
  673. for f in globalvar.formats[ftype].values():
  674. formats += f
  675. self.SetItems(formats)
  676. def GetExtension(self, name):
  677. """!Get file extension by format name"""
  678. formatToExt = {
  679. # raster
  680. 'GeoTIFF' : 'tif',
  681. 'Erdas Imagine Images (.img)' : '.img',
  682. 'Ground-based SAR Applications Testbed File Format (.gff)' : '.gff',
  683. 'Arc/Info Binary Grid' : 'adf',
  684. 'Portable Network Graphics' : 'png',
  685. 'JPEG JFIF' : 'jpg',
  686. 'Japanese DEM (.mem)' : 'mem',
  687. 'Graphics Interchange Format (.gif)' : 'gif',
  688. 'X11 PixMap Format' : 'xpm',
  689. 'MS Windows Device Independent Bitmap' : 'bmp',
  690. 'SPOT DIMAP' : '.dim',
  691. 'RadarSat 2 XML Product' : 'xml',
  692. 'EarthWatch .TIL' : '.til',
  693. 'ERMapper .ers Labelled' : '.ers',
  694. 'ERMapper Compressed Wavelets' : 'ecw',
  695. 'GRIdded Binary (.grb)' : 'grb',
  696. 'EUMETSAT Archive native (.nat)' : '.nat',
  697. 'Idrisi Raster A.1' : 'rst',
  698. 'Golden Software ASCII Grid (.grd)' : '.grd',
  699. 'Golden Software Binary Grid (.grd)' : 'grd',
  700. 'Golden Software 7 Binary Grid (.grd)' : 'grd',
  701. 'R Object Data Store' : 'r',
  702. 'USGS DOQ (Old Style)' : 'doq',
  703. 'USGS DOQ (New Style)' : 'doq',
  704. 'ENVI .hdr Labelled' : 'hdr',
  705. 'ESRI .hdr Labelled' : 'hdr',
  706. 'Generic Binary (.hdr Labelled)' : 'hdr',
  707. 'PCI .aux Labelled' : 'aux',
  708. 'EOSAT FAST Format' : 'fst',
  709. 'VTP .bt (Binary Terrain) 1.3 Format' : 'bt',
  710. 'FARSITE v.4 Landscape File (.lcp)' : 'lcp',
  711. 'Swedish Grid RIK (.rik)' : 'rik',
  712. 'USGS Optional ASCII DEM (and CDED)' : '.dem',
  713. 'Northwood Numeric Grid Format .grd/.tab' : '',
  714. 'Northwood Classified Grid Format .grc/.tab' : '',
  715. 'ARC Digitized Raster Graphics' : 'arc',
  716. 'Magellan topo (.blx)' : 'blx',
  717. 'SAGA GIS Binary Grid (.sdat)' : 'sdat',
  718. # vector
  719. 'ESRI Shapefile' : 'shp',
  720. 'UK .NTF' : 'ntf',
  721. 'SDTS' : 'ddf',
  722. 'DGN' : 'dgn',
  723. 'VRT' : 'vrt',
  724. 'REC' : 'rec',
  725. 'BNA' : 'bna',
  726. 'CSV' : 'csv',
  727. 'GML' : 'gml',
  728. 'GPX' : 'gpx',
  729. 'KML' : 'kml',
  730. 'GMT' : 'gmt',
  731. 'PGeo' : 'mdb',
  732. 'XPlane' : 'dat',
  733. 'AVCBin' : 'adf',
  734. 'AVCE00' : 'e00',
  735. 'DXF' : 'dxf',
  736. 'Geoconcept' : 'gxt',
  737. 'GeoRSS' : 'xml',
  738. 'GPSTrackMaker' : 'gtm',
  739. 'VFK' : 'vfk'
  740. }
  741. try:
  742. return formatToExt[name]
  743. except KeyError:
  744. return ''