Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
v.db.reconnect.all(1)	    GRASS GIS User's Manual	 v.db.reconnect.all(1)

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)

       Main  index  | Vector index | Topics index | Keywords index | Graphical
       index | Full index

       A(C) 2003-2020 GRASS Development	Team, GRASS GIS	7.8.3 Reference	Manual

GRASS 7.8.3						 v.db.reconnect.all(1)

NAME | KEYWORDS | SYNOPSIS | DESCRIPTION | NOTES | EXAMPLES | SEE ALSO | AUTHORS | SOURCE CODE

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=v.db.reconnect.all&sektion=1&manpath=FreeBSD+12.1-RELEASE+and+Ports>

home | help