python.db Namespace Reference

Functions
def	db_describe
	Return the list of columns for a database table (interface to `db.describe -c'). More...
def	db_connection
	Return the current database connection parameters (interface to `db.connect -p'). More...
def	db_select
	Perform SQL select statement. More...

Function Documentation

def python.db.db_connection

(

)

Return the current database connection parameters (interface to `db.connect -p').

Example:

>>> grass.db_connection()
{'group': 'x', 'schema': '', 'driver': 'dbf', 'database': '$GISDBASE/$LOCATION_NAME/$MAPSET/dbf/'}

Returns

parsed output of db.connect

Definition at line 73 of file db.py.

References python.core.parse_key_val(), and python.core.read_command().

def python.db.db_describe	(		table,
			args
	)

Return the list of columns for a database table (interface to `db.describe -c').

Example:

>>> grass.db_describe('lakes')
{'nrows': 15279, 'cols': [['cat', 'INTEGER', '11'], ['AREA', 'DOUBLE PRECISION', '20'],
['PERIMETER', 'DOUBLE PRECISION', '20'], ['FULL_HYDRO', 'DOUBLE PRECISION', '20'],
['FULL_HYDR2', 'DOUBLE PRECISION', '20'], ['FTYPE', 'CHARACTER', '24'],
['FCODE', 'INTEGER', '11'], ['NAME', 'CHARACTER', '99']], 'ncols': 8}

Parameters

table	table name
args

Returns

parsed module output

Definition at line 33 of file db.py.

References python.core.fatal(), and python.core.read_command().

def python.db.db_select	(		sql = None,
			filename = None,
			table = None,
			args
	)

Perform SQL select statement.

Note: one of sql, filename, or table arguments must be provided.

Examples:

grass.db_select(sql = 'SELECT cat,CAMPUS FROM busstopsall WHERE cat < 4')

(('1', 'Vet School'), ('2', 'West'), ('3', 'North'))

grass.db_select(filename = '/path/to/sql/file')

Simplyfied usage

grass.db_select(table = 'busstopsall')

performs SELECT * FROM busstopsall.

Parameters

sql	SQL statement to perform (or None)
filename	name of file with SQL statements (or None)
table	name of table to query (or None)
args	see db.select arguments

Definition at line 87 of file db.py.

References python.core.fatal(), python.core.run_command(), utils.split(), and python.core.try_remove().