v.db.reconnect.all(1grass) GRASS GIS User's Manual v.db.reconnect.all(1grass)
NAME
v.db.reconnect.all - Reconnects attribute tables for all vector maps
from the current mapset to a new database.
KEYWORDS
vector, attribute table, database
SYNOPSIS
v.db.reconnect.all
v.db.reconnect.all --help
v.db.reconnect.all [-cd] [old_database=name] [old_schema=name]
[new_driver=string] [new_database=name] [new_schema=name]
[--help] [--verbose] [--quiet] [--ui]
Flags:
-c
Copy attribute tables to the target database if not exist
-d
Delete attribute tables from the source database
--help
Print usage summary
--verbose
Verbose module output
--quiet
Quiet module output
--ui
Force launching GUI dialog
Parameters:
old_database=name
Name of source database
old_schema=name
Name of source database schema
Do not use this option if schemas are not supported by driver/data-
base server
new_driver=string
Name for target driver
new_database=name
Name for target database
new_schema=name
Name for target database schema
Do not use this option if schemas are not supported by driver/data-
base server
DESCRIPTION
v.db.reconnect.all changes database connection of all layers of all
vector maps in the current mapset from the source (old_database) to the
target (new_database) database. If a link does not match the old_data-
base it is left untouched.
If no new database is given, the default datase of the mapset is used
as printed by db.connect -g. If no old database is given, all layers
without a link in the new database will be liniked to the new database.
If an old database is given, only links in the old database will be
changed.
Optionally attribute tables in new_database can be created if not exist
by -c flag. In this case v.db.reconnect.all also tries to create an in-
dex on key column (usually "cat" column).
NOTES
The value of the old_database option needs to be the exact string which
appears as the fourth field printed by v.db.connect -g.
v.db.connect -g map=census
1/census|census|cat|/home/user/grassdata/nc_spm_base/PERMANENT/dbf/|dbf
v.db.reconnect.all respect also variables to be substituted. In the ex-
ample above, database /home/user/grassdata/nc_spm_base/PERMANENT/dbf/
can be also defined as ’$GISDBASE/$LOCATION_NAME/$MAPSET/dbf/’ (see ex-
amples).
Attribute tables from old_database are after reconnecting left un-
touched. v.db.reconnect.all deletes those tables automatically only
when -d flag is given.
Also note that v.db.reconnect.all doesn’t change default database
driver or database (db.connect -p). Default database connection set-
tings for newly created attribute data can be defined by db.connect.
EXAMPLES
In the examples below are assumed, that attribute tables are linked to
the vector maps through DBF database driver.
Reconnect DBF attribute tables to SQLite database
Reconnect DBF attribute tables linked to the vector maps in the current
mapset to SQLite database:
v.db.reconnect.all old_database=’$GISDBASE/$LOCATION_NAME/$MAPSET/dbf/’ \
new_driver=sqlite new_database=’$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db’
If attribute table doesn’t exist in the target database (new_database)
then the module prints an error message.
Convert DBF attribute tables to SQLite database
For coping DBF tables to SQLite database and reconnecting them for all
vector maps in the current mapset must be defined also -c flag.
v.db.reconnect.all -c old_database=’$GISDBASE/$LOCATION_NAME/$MAPSET/dbf/’ \
new_driver=sqlite new_database=’$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db’
or alternatively
# set default connection (sqlite)
db.connect -d
# verify default connection
db.connect -g
# reconnect
v.db.reconnect.all -c old_database=’$GISDBASE/$LOCATION_NAME/$MAPSET/dbf/’
To automatically remove original DBF attribute tables after reconnect-
ing the vector maps use -d flag. Note that attribute tables will be
deleted permanently from the source database. This option should be
used very carefully!
Convert GRASS 6 vector map to GRASS 7 including attribute transfer from DBF
to SQLite
To become usable in GRASS 7, all vector maps in a mapset need to be up-
dated:
# first rebuild topology for all vector maps
v.build.all
# set new default db connection (to SQLite default)
db.connect -d
# copy attribute tables from old DB to new SQLite DB, delete old tables in DBF format
v.db.reconnect.all -cd
SEE ALSO
v.db.connect, db.connect, db.copy, db.createdb, db.droptable
GRASS SQL interface
AUTHORS
Radim Blazek
Major update by Martin Landa, Czech Technical University in Prague,
Czech Republic
SOURCE CODE
Available at: v.db.reconnect.all source code (history)
Accessed: unknown
Main index | Vector index | Topics index | Keywords index | Graphical
index | Full index
© 2003-2022 GRASS Development Team, GRASS GIS 7.8.7 Reference Manual
GRASS 7.8.7 v.db.reconnect.all(1grass)
Generated by dwww version 1.14 on Fri Jan 24 06:01:57 CET 2025.