[GRASS-dev] [GRASS GIS] #4022: impossible to remove vect and delete attribute from gui

#4022: impossible to remove vect and delete attribute from gui
---------------------+-------------------------
Reporter: 1266 | Owner: grass-dev@…
     Type: defect | Status: new
Priority: normal | Milestone:
Component: Default | Version: unspecified
Keywords: | CPU: Unspecified
Platform: Linux |
---------------------+-------------------------
I cannot remove vector object and/or attribute data from the right-clic
menu on attribute box in the gui (delete selected records/features) with
grass 7.8 or 7.9 (on debian buster with 'fr' or 'en' locale)

But "v.edit tool=delete map=mymap where="mycolum=myvalue" and db.execute
"sql=DELETE FROM mymap WHERE mycolomn = myvalue" work fine.

console return :
Traceback (most recent call last):
   File "/usr/local/grass78/gui/wxpython/dbmgr/base.py", line
1997, in OnDeleteSelected

if self.OnDataItemDelete(None) and self.mapdisplay:
   File "/usr/local/grass78/gui/wxpython/dbmgr/base.py", line
1748, in OnDataItemDelete

self.ApplyCommands(self.listOfCommands,
self.listOfSQLStatements)
   File "/usr/local/grass78/gui/wxpython/dbmgr/base.py", line
982, in ApplyCommands

sqlFile.write(sql.encode('utf-8') + ';')
TypeError
:
can't concat str to bytes

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/4022&gt;
GRASS GIS <https://grass.osgeo.org>

#4022: impossible to remove vect and delete attribute from gui
--------------------------+-------------------------
  Reporter: 1266 | Owner: grass-dev@…
      Type: defect | Status: new
  Priority: normal | Milestone:
Component: Default | Version: unspecified
Resolution: | Keywords:
       CPU: Unspecified | Platform: Linux
--------------------------+-------------------------

Comment (by hellik):

Confirmed with the latest winGRASS master daily builds

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/4022#comment:1&gt;
GRASS GIS <https://grass.osgeo.org>

#4022: impossible to remove vect and delete attribute from gui
--------------------------+---------------------------------
  Reporter: 1266 | Owner: grass-dev@…
      Type: defect | Status: new
  Priority: normal | Milestone:
Component: Python | Version: git-releasebranch78
Resolution: | Keywords: Py3, Python 3
       CPU: Unspecified | Platform: Linux
--------------------------+---------------------------------
Changes (by hellik):

* keywords: => Py3, Python 3
* version: unspecified => git-releasebranch78
* component: Default => Python

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/4022#comment:2&gt;
GRASS GIS <https://grass.osgeo.org>

#4022: impossible to remove vect and delete attribute from gui
--------------------------+---------------------------------
  Reporter: 1266 | Owner: grass-dev@…
      Type: defect | Status: new
  Priority: normal | Milestone:
Component: Python | Version: git-releasebranch78
Resolution: | Keywords: Py3, Python 3
       CPU: Unspecified | Platform: Linux
--------------------------+---------------------------------

Comment (by neteler):

See https://github.com/OSGeo/grass/pull/344 by Anna @petrasovaa

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/4022#comment:3&gt;
GRASS GIS <https://grass.osgeo.org>

#4022: impossible to remove vect and delete attribute from gui
--------------------------+---------------------------------
  Reporter: 1266 | Owner: grass-dev@…
      Type: defect | Status: new
  Priority: normal | Milestone:
Component: Python | Version: git-releasebranch78
Resolution: | Keywords: Py3, Python 3
       CPU: Unspecified | Platform: Linux
--------------------------+---------------------------------

Comment (by annakrat):

Changes are now in master available for testing.

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/4022#comment:4&gt;
GRASS GIS <https://grass.osgeo.org>

#4022: impossible to remove vect and delete attribute from gui
--------------------------+---------------------------------
  Reporter: 1266 | Owner: grass-dev@…
      Type: defect | Status: new
  Priority: normal | Milestone:
Component: Python | Version: git-releasebranch78
Resolution: | Keywords: Py3, Python 3
       CPU: Unspecified | Platform: Linux
--------------------------+---------------------------------

Comment (by hellik):

tested with

{{{
GRASS Version: 7.9.dev
Code revision: ac8bd2777
Build date: 2020-01-20
Build platform: x86_64-w64-mingw32
GDAL: 3.0.4
PROJ: 6.3.1
GEOS: 3.8.0
SQLite: 3.29.0
Python: 3.7.0
wxPython: 4.0.7
Platform: Windows-10-10.0.18362-SP0 (OSGeo4W)
}}}

seems to work.

closing ticket?

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/4022#comment:5&gt;
GRASS GIS <https://grass.osgeo.org>

#4022: impossible to remove vect and delete attribute from gui
--------------------------+---------------------------------
  Reporter: 1266 | Owner: grass-dev@…
      Type: defect | Status: new
  Priority: normal | Milestone:
Component: Python | Version: git-releasebranch78
Resolution: | Keywords: Py3, Python 3
       CPU: Unspecified | Platform: Linux
--------------------------+---------------------------------

Comment (by hellik):

Replying to [comment:5 hellik]:
> tested with
>
>
> {{{
> GRASS Version: 7.9.dev
> Code revision: ac8bd2777
> Build date: 2020-01-20
> Build platform: x86_64-w64-mingw32
> GDAL: 3.0.4
> PROJ: 6.3.1
> GEOS: 3.8.0
> SQLite: 3.29.0
> Python: 3.7.0
> wxPython: 4.0.7
> Platform: Windows-10-10.0.18362-SP0 (OSGeo4W)
> }}}
>
> seems to work.
>
> closing ticket?

backporting before closing.

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/4022#comment:6&gt;
GRASS GIS <https://grass.osgeo.org>

#4022: impossible to remove vect and delete attribute from gui
--------------------------+---------------------------------
  Reporter: 1266 | Owner: grass-dev@…
      Type: defect | Status: closed
  Priority: normal | Milestone:
Component: Python | Version: git-releasebranch78
Resolution: fixed | Keywords: Py3, Python 3
       CPU: Unspecified | Platform: Linux
--------------------------+---------------------------------
Changes (by annakrat):

* status: new => closed
* resolution: => fixed

Comment:

Merged to 78.

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/4022#comment:7&gt;
GRASS GIS <https://grass.osgeo.org>