[GRASS-dev] Re: [GRASS GIS] #548: grass7 - v.reclass with sqlite driver: Cannot step: SQL logic error or missing database
#548: grass7 - v.reclass with sqlite driver: Cannot step: SQL logic error or
missing database
--+-
Reporter: mlennert | Owner: grass-dev@…
Type: defect| Status: new
Priority: normal| Milestone: 7.0.0
Component: Database | Version: svn-trunk
Keywords: v.reclass sqlite |Platform: Unspecified
Cpu: Unspecified |
--+-
Comment(by mmetz):
Replying to [comment:11 mmetz]:
Replying to [comment:10 mmetz]:
Debugging a bit, the problem of v.reclass with the sqlite driver seems
to be that the same database is opened twice (once by each driver
instance), which causes database locking, therefore it is not possible to
use one driver instance to fetch records from one table and use another
driver instance to insert records into another table, all in the same
sqlite database.
Now it's possible, the other driver just has to wait a little bit until
the first driver is finished.
Correction, only now (trunk r48333) it's possible. There were more bugs,
both in v.reclass and in the sqlite driver.
A test, within the sqlite mapset of nc_spm_08:
{{{
g.copy vect=zipcodes_wake,my_zipcodes_wake
v.dissolve input=my_zipcodes_wake@sqlite layer=1 column=ZIPNAME
output=zip_names
}}}
Markus M
--
Ticket URL: http://trac.osgeo.org/grass/ticket/548#comment:12
GRASS GIS http://grass.osgeo.org
___
grass-dev mailing list
grass-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-dev
[GRASS-dev] Re: [GRASS GIS] #1418: v.dissolve not working
#1418: v.dissolve not working +--- Reporter: hellik | Owner: grass-dev@… Type: defect | Status: new Priority: major | Milestone: 7.0.0 Component: Vector | Version: svn-trunk Keywords: |Platform: All Cpu: All | +--- Comment(by mmetz): Replying to [comment:4 neteler]: The bug is probably triggered by #548 (v.reclass + SQLite failure, but errors are suppressed in v.dissolve). See ticket #548, comment 12 http://trac.osgeo.org/grass/ticket/548#comment:12 Markus M -- Ticket URL: http://trac.osgeo.org/grass/ticket/1418#comment:5 GRASS GIS http://grass.osgeo.org ___ grass-dev mailing list grass-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/grass-dev
[GRASS-dev] Re: [GRASS GIS] #434: python swig bindings for 7.0 svn noyt working on ubuntu install
#434: python swig bindings for 7.0 svn noyt working on ubuntu install ---+ Reporter: mulligan | Owner: grass-dev@… Type: defect| Status: closed Priority: major | Milestone: 7.0.0 Component: Python| Version: svn-trunk Resolution: wontfix |Keywords: python swig Platform: Linux | Cpu: x86-32 ---+ Changes (by martinl): * status: new = closed * resolution: = wontfix Comment: Swig has been replaced by ctypes library some months ago. Closing as invalid. -- Ticket URL: https://trac.osgeo.org/grass/ticket/434#comment:5 GRASS GIS http://grass.osgeo.org ___ grass-dev mailing list grass-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/grass-dev
[GRASS-dev] Re: [GRASS GIS] #853: v.db.dropcolumn: allow column= opt to accept multiples
#853: v.db.dropcolumn: allow column= opt to accept multiples --+- Reporter: hamish | Owner: grass-dev@… Type: enhancement | Status: closed Priority: minor| Milestone: 7.0.0 Component: Database | Version: svn-trunk Resolution: fixed|Keywords: v.db.dropcolumn Platform: All | Cpu: All --+- Changes (by lucadelu): * status: new = closed * resolution: = fixed Comment: Hi, I implement it... try version r48337 Regards from FOSS4G 2011 Code Sprint Luca -- Ticket URL: https://trac.osgeo.org/grass/ticket/853#comment:1 GRASS GIS http://grass.osgeo.org ___ grass-dev mailing list grass-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/grass-dev
[GRASS-dev] Re: [GRASS GIS] #1229: Error in db.droptable
#1229: Error in db.droptable
--+-
Reporter: akbgf | Owner: grass-dev@…
Type: defect| Status: new
Priority: normal| Milestone: 7.0.0
Component: Database | Version: svn-trunk
Keywords: db.droptable |Platform: Linux
Cpu: x86-32|
--+-
Comment(by lucadelu):
I try with r48337 and NC datasete I got this error
{{{
db.droptable hospitals
dbmi: db_drop_table() not implemented
}}}
I grep db_drop_table and I found
lib/python/ctypes/dbmi.py
{{{
# /home/luca/compilati/grass70_new/dist.i686-pc-linux-
gnu/include/grass/dbmidefs.h: 123
if hasattr(_libs['grass_dbmiclient.7.0.svn'], 'db_drop_table'):
db_drop_table = _libs['grass_dbmiclient.7.0.svn'].db_drop_table
db_drop_table.restype = c_int
db_drop_table.argtypes = [POINTER(dbDriver), POINTER(dbString)]
}}}
cheers
Luca
--
Ticket URL: https://trac.osgeo.org/grass/ticket/1229#comment:1
GRASS GIS http://grass.osgeo.org
___
grass-dev mailing list
grass-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-dev
[GRASS-dev] Re: [GRASS GIS] #1229: Error in db.droptable
#1229: Error in db.droptable --+- Reporter: akbgf | Owner: grass-dev@… Type: defect| Status: new Priority: normal| Milestone: 7.0.0 Component: Database | Version: svn-trunk Keywords: db.droptable |Platform: Linux Cpu: x86-32| --+- Comment(by mmetz): Replying to [comment:1 lucadelu]: I try with r48337 and NC datasete I got this error [snip] Worksforme with both dbf and sqlite driver. Try make disclean, svn up, configure, make. Markus M -- Ticket URL: https://trac.osgeo.org/grass/ticket/1229#comment:2 GRASS GIS http://grass.osgeo.org ___ grass-dev mailing list grass-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/grass-dev
