[GRASS-user] SQLite Error

[Moritz Lennert]

On 12/02/15 11:16, Mark Wynter wrote:
> 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

Can you set schema='' or something like that ?

Moritz

>
> 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
> <mailto: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
>