[GRASS-dev] Re: [GRASS GIS] #391: SQLite driver doesn't complain enough with stupid mistakes

[GRASS GIS]

#391: SQLite driver doesn't complain enough with stupid mistakes
-----------------------+----------------------------------------------------
  Reporter:  hamish    |       Owner:  grass-dev at lists.osgeo.org
      Type:  defect    |      Status:  new                      
  Priority:  major     |   Milestone:  6.4.0                    
 Component:  Database  |     Version:  svn-develbranch6         
Resolution:            |    Keywords:  sqlite                   
  Platform:  Linux     |         Cpu:  Unspecified              
-----------------------+----------------------------------------------------
Comment (by glynn):

 Replying to [comment:1 neteler]:

 > If desired in the SQLite driver, only SQL parsing might solve the
 problem (complicated).

 The main problem is that, although DBMI specifies an "add column" method,
 none of the drivers implement it. So v.db.addcol just executes an SQL
 "ALTER TABLE ..." statement.

 So the only way to trap this in the driver would be to parse every SQL
 statement which is passed to it, which I don't expect to happen.

 BTW, even if all of the drivers were updated to implement the add_column
 method, and a corresponding db.addcol module was created, you could still
 get exactly the same problem from people/code adding columns or creating
 tables manually via e.g. db.execute or the sqlite3 command.

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