copy_tab.c File Reference

DBMI Library (client) - copy table. More...

#include <stdlib.h>
#include <string.h>
#include <grass/dbmi.h>
#include <grass/glocale.h>
#include "macros.h"

Include dependency graph for copy_tab.c:

Go to the source code of this file.

Functions
int	db_copy_table (const char *from_drvname, const char *from_dbname, const char *from_tblname, const char *to_drvname, const char *to_dbname, const char *to_tblname)
	Copy a table. More...
int	db_copy_table_where (const char *from_drvname, const char *from_dbname, const char *from_tblname, const char *to_drvname, const char *to_dbname, const char *to_tblname, const char *where)
	Copy a table (by where statement) More...
int	db_copy_table_select (const char *from_drvname, const char *from_dbname, const char *from_tblname, const char *to_drvname, const char *to_dbname, const char *to_tblname, const char *select)
	Copy a table (by select statement) More...
int	db_copy_table_by_ints (const char *from_drvname, const char *from_dbname, const char *from_tblname, const char *to_drvname, const char *to_dbname, const char *to_tblname, const char *selcol, int *ivals, int nvals)
	Copy a table (by keys) More...

Detailed Description

DBMI Library (client) - copy table.

(C) 1999-2008 by the GRASS Development Team

This program is free software under the GNU General Public License (>=v2). Read the file COPYING that comes with GRASS for details.

Author

Joel Jones (CERL/UIUC), Radim Blazek

Definition in file copy_tab.c.

Function Documentation

db_copy_table()

int db_copy_table	(	const char *	from_drvname,
		const char *	from_dbname,
		const char *	from_tblname,
		const char *	to_drvname,
		const char *	to_dbname,
		const char *	to_tblname
	)

Copy a table.

Parameters

from_drvname	name of driver from table is copied
from_dbname	name of database from table is copied
from_tblname	name of table to be copied
to_drvname	name of driver to - where table is copied to
to_dbname	name of database to - where table is copied to
to_tblname	name of copied table

Returns

DB_OK on success

DB_FAILED on failure

Definition at line 443 of file copy_tab.c.

db_copy_table_by_ints()

int db_copy_table_by_ints	(	const char *	from_drvname,
		const char *	from_dbname,
		const char *	from_tblname,
		const char *	to_drvname,
		const char *	to_dbname,
		const char *	to_tblname,
		const char *	selcol,
		int *	ivals,
		int	nvals
	)

Copy a table (by keys)

Parameters

from_drvname	name of driver from table is copied
from_dbname	name of database from table is copied
from_tblname	name of table to be copied
to_drvname	name of driver to - where table is copied to
to_dbname	name of database to - where table is copied to
to_tblname	name of copied table
selcol	name of column used to select records by values in ivals or NULL
ivals	pointer to array of integer values or NULL
nvals	number of values in ivals

Returns

DB_OK on success

DB_FAILED on failure

Definition at line 513 of file copy_tab.c.

db_copy_table_select()

int db_copy_table_select	(	const char *	from_drvname,
		const char *	from_dbname,
		const char *	from_tblname,
		const char *	to_drvname,
		const char *	to_dbname,
		const char *	to_tblname,
		const char *	select
	)

Copy a table (by select statement)

Parameters

from_drvname	name of driver from table is copied
from_dbname	name of database from table is copied
from_dbname	name of table to be copied
to_drvname	name of driver to - where table is copied to
to_dbname	name of database to - where table is copied to
to_tblname	name of copied table
select	full select statement

Returns

DB_OK on success

DB_FAILED on failure

Definition at line 488 of file copy_tab.c.

db_copy_table_where()

int db_copy_table_where	(	const char *	from_drvname,
		const char *	from_dbname,
		const char *	from_tblname,
		const char *	to_drvname,
		const char *	to_dbname,
		const char *	to_tblname,
		const char *	where
	)

Copy a table (by where statement)

Parameters

from_drvname	name of driver from table is copied
from_dbname	name of database from table is copied
from_tblname	name of table to be copied
to_drvname	name of driver to - where table is copied to
to_dbname	name of database to - where table is copied to
to_tblname	name of copied table
where	WHERE SQL condition (without where key word)

Returns

DB_OK on success

DB_FAILED on failure

Definition at line 465 of file copy_tab.c.