column.c File Reference

DBMI Library (client) - column info. More...

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

Include dependency graph for dbmi_client/column.c:

Go to the source code of this file.

Functions
int	db_column_sqltype (dbDriver *driver, const char *tab, const char *col)
	Get column sqltype.
int	db_column_Ctype (dbDriver *driver, const char *tab, const char *col)
	Get column ctype.
int	db_get_column (dbDriver *Driver, const char *tname, const char *cname, dbColumn **Column)
	Get column structure by table and column name.

Detailed Description

DBMI Library (client) - column info.

(C) 1999-2008, 2011 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

Update by Glynn Clement <glynn gclements.plus.com>

Martin Landa <landa.martin gmail.com>

Definition in file dbmi_client/column.c.

Function Documentation

db_column_Ctype()

int db_column_Ctype	(	dbDriver *	driver,
		const char *	tab,
		const char *	col
	)

Get column ctype.

See db_sqltype_to_Ctype().

Supported types:

• DB_C_TYPE_STRING
• DB_C_TYPE_INT
• DB_C_TYPE_DOUBLE
• DB_C_TYPE_DATETIME

Parameters

driver	DB driver
tab	table name
col	column name

Returns

column Ctype

-1 on error

Definition at line 99 of file dbmi_client/column.c.

References db_column_sqltype(), and db_sqltype_to_Ctype().

Referenced by IL_vector_input_data_2d(), and Vect_write_ascii().

db_column_sqltype()

int db_column_sqltype	(	dbDriver *	driver,
		const char *	tab,
		const char *	col
	)

Get column sqltype.

See db_sqltype_name().

Supported types:

• DB_SQL_TYPE_UNKNOWN
• DB_SQL_TYPE_CHARACTER
• DB_SQL_TYPE_SMALLINT
• DB_SQL_TYPE_INTEGER
• DB_SQL_TYPE_REAL
• DB_SQL_TYPE_DOUBLE_PRECISION
• DB_SQL_TYPE_DECIMAL
• DB_SQL_TYPE_NUMERIC
• DB_SQL_TYPE_DATE
• DB_SQL_TYPE_TIME
• DB_SQL_TYPE_TIMESTAMP
• DB_SQL_TYPE_INTERVAL
• DB_SQL_TYPE_TEXT
• DB_SQL_TYPE_SERIAL

Parameters

driver	DB driver
tab	table name
col	column name

Returns

column sqltype

-1 on error

Definition at line 51 of file dbmi_client/column.c.

References db_describe_table(), db_free_string(), db_free_table(), db_get_column_name(), db_get_column_sqltype(), db_get_table_column(), db_get_table_number_of_columns(), db_init_string(), DB_OK, and db_set_string().

Referenced by db_column_Ctype().

db_get_column()

int db_get_column	(	dbDriver *	Driver,
		const char *	tname,
		const char *	cname,
		dbColumn **	Column
	)

Get column structure by table and column name.

Column is set to new dbColumn structure or NULL if column was not found

Parameters

	Driver	DB driver
	tname	table name
	cname	column name
[out]	Column	column structure to store within

Returns

DB_OK on success

DB_FAILED on failure

Definition at line 124 of file dbmi_client/column.c.

References _, db_copy_column(), db_describe_table(), DB_FAILED, db_free_table(), db_get_column_name(), db_get_table_column(), db_get_table_number_of_columns(), db_init_string(), DB_OK, db_set_string(), G_debug(), G_strcasecmp(), G_warning(), and NULL.

Referenced by Vect_net_build_graph(), and Vect_net_ttb_build_graph().