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 <mlenn...@club.worldonline.be
<mailto:mlenn...@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
_______________________________________________
grass-user mailing list
grass-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-user
