c_execute.c File Reference

DBMI Library (client) - execute SQL statements. More...

#include <grass/dbmi.h>
#include "macros.h"

Include dependency graph for c_execute.c:

Go to the source code of this file.

Functions
int	db_execute_immediate (dbDriver *driver, dbString *SQLstatement)
	Execute SQL statements. More...
int	db_begin_transaction (dbDriver *driver)
	Begin transaction. More...
int	db_commit_transaction (dbDriver *driver)
	Commit transaction. More...

Detailed Description

DBMI Library (client) - execute SQL statements.

(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 c_execute.c.

Function Documentation

db_begin_transaction()

int db_begin_transaction

(

dbDriver *

driver

)

Begin transaction.

Parameters

driver

db driver

Returns

DB_OK on success

DB_FAILED on failure

Definition at line 56 of file c_execute.c.

References db__set_protocol_fds(), DB_OK, DB_PROC_BEGIN_TRANSACTION, DB_RECV_RETURN_CODE, DB_START_PROCEDURE_CALL, _db_driver::recv, and _db_driver::send.

db_commit_transaction()

int db_commit_transaction

(

dbDriver *

driver

)

Commit transaction.

Parameters

driver

db driver

Returns

DB_OK on success

DB_FAILED on failure

Definition at line 82 of file c_execute.c.

References db__set_protocol_fds(), DB_OK, DB_PROC_COMMIT_TRANSACTION, DB_RECV_RETURN_CODE, DB_START_PROCEDURE_CALL, _db_driver::recv, and _db_driver::send.

db_execute_immediate()

int db_execute_immediate	(	dbDriver *	driver,
		dbString *	SQLstatement
	)

Execute SQL statements.

Parameters

driver	db driver
SQLstatement	SQL statement (alter, update, ...)

Returns

DB_OK on success

DB_FAILED on failure

Definition at line 27 of file c_execute.c.

References db__set_protocol_fds(), DB_OK, DB_PROC_EXECUTE_IMMEDIATE, DB_RECV_RETURN_CODE, DB_SEND_STRING, DB_START_PROCEDURE_CALL, _db_driver::recv, and _db_driver::send.

Referenced by db_delete_table(), and P_Drop_Aux_Table().