[GRASS-dev] [GRASS GIS] #2568: Upper-lower case issues with sqlite driver and affect on v.db.reconnect.all

[GRASS GIS]

#2568: Upper-lower case issues with sqlite driver and affect on v.db.reconnect.all
-----------------------+----------------------------------------------------
  Reporter:  ewcgrass  |       Owner:  grass-dev@…              
      Type:  defect    |      Status:  closed                   
  Priority:  major     |   Milestone:  7.0.0                    
 Component:  Database  |     Version:  svn-releasebranch70      
Resolution:  fixed     |    Keywords:                           
  Platform:  Linux     |         Cpu:  x86-64                   
-----------------------+----------------------------------------------------
Changes (by ewcgrass):

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


Comment:

 Thanks for solving this so quickly. I missed that entirely because having
 different key column names never negatively affected doing work with the
 vector file attribute data in GRASS 6.4. Running v.db.connect map= key=cat
 in GRASS 6.4 before migrating fixes the problem, as it does running
 v.db.connect map= key=CAT in GRASS 7.0 after migrating from .dbf to
 sqlite!

 v.db.reconnect.all still hangs at every other database error it encounters
 during migration (eg. syntax issues re. column names vs sqlite keywords,
 quotes or squiggles in table data, dropping columns due to name length >10
 in the .dbf table which for odd reasons were never caught earlier, etc.).
 But I guess this is not all bad, as it is an opportunity to clean up
 database files? About 300 dbf tables migrations completed, about 1200 more
 to go.

 Perhaps this Ticket should be changed from a "bug" to a "wish", where
 v.db.reconnect.all could perhaps be modified to catch these migration
 errors more graciously?

-- 
Ticket URL: <http://trac.osgeo.org/grass/ticket/2568#comment:2>
GRASS GIS <http://grass.osgeo.org>