[GRASS-user] SQLite Error

[Mark Wynter]

Hi Moritz - the SQLite DB seems to be inheriting the schema from the previous PG driver?  Even if I db.dropdb….   I don’t encounter this if I create a new location… e.g. test

GRASS 7.0.0svn (nodeclean):~ > db.dropdb database='/var/tmp/nodeclean/PERMANENT/sqlite/sqlite.db'
GRASS 7.0.0svn (nodeclean):~ > db.connect driver=sqlite database='$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db'
GRASS 7.0.0svn (nodeclean):~ > db.connect -p
driver: sqlite
database: /var/tmp/nodeclean/PERMANENT/sqlite/sqlite.db
schema: grass
group: 


grass70 -text -c EPSG:3577 /var/tmp/test
GRASS 7.0.0svn (test):~ > db.connect -p
driver: sqlite
database: /var/tmp/test/PERMANENT/sqlite/sqlite.db
schema: 
group: 


On 12 Feb 2015, at 7:05 pm, Moritz Lennert <mlennert at club.worldonline.be> wrote:

On 12/02/15 02:14, Mark Wynter wrote:
> 
> #(2) RESET THE DATABASE DRIVER FOR THE CURRENT MAPSET TO SQLITE
> db.connect driver=sqlite
> database='$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db' schema=grass
> db.connect -p
> 
> #Output
> driver: sqlite
> database: /var/tmp/nodeclean/PERMANENT/sqlite/sqlite.db
> schema: grass
> group:

[...]

> #(5) Run v.net.allpairs….
> g.remove -f type=vector pattern="temp**"
> v.net.allpairs  --overwrite in=nsw_road_network_final_connected_copy
> cats=1-10  out=temp_8 afcolumn=fwdcost abcolumn=bwdcost
> DBMI-SQLite driver error:
> Error in sqlite3_prepare():
> unknown database grass
> 
> DBMI-SQLite driver error:
> Error in sqlite3_prepare():
> unknown database grass

I don't think SQLite supports schemas.

Moritz

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/grass-user/attachments/20150212/c3f22d96/attachment.html>