1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
|
/*!
* \file db/dbmi_client/c_execute.c
*
* \brief 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
*/
#include <grass/dbmi.h>
#include "macros.h"
/*!
\brief Execute SQL statements
\param driver db driver
\param SQLstatement SQL statement (alter, update, ...)
\return DB_OK on success
\return DB_FAILED on failure
*/
int db_execute_immediate(dbDriver * driver, dbString * SQLstatement)
{
int ret_code;
/* start the procedure call */
db__set_protocol_fds(driver->send, driver->recv);
DB_START_PROCEDURE_CALL(DB_PROC_EXECUTE_IMMEDIATE);
/* send the argument(s) to the procedure */
DB_SEND_STRING(SQLstatement);
/* get the return code for the procedure call */
DB_RECV_RETURN_CODE(&ret_code);
if (ret_code != DB_OK)
return ret_code; /* ret_code SHOULD == DB_FAILED */
/* no results */
return DB_OK;
}
/*!
\brief Begin transaction
\return driver db driver
\return DB_OK on success
\return DB_FAILED on failure
*/
int db_begin_transaction(dbDriver * driver)
{
int ret_code;
/* start the procedure call */
db__set_protocol_fds(driver->send, driver->recv);
DB_START_PROCEDURE_CALL(DB_PROC_BEGIN_TRANSACTION);
/* get the return code for the procedure call */
DB_RECV_RETURN_CODE(&ret_code);
if (ret_code != DB_OK)
return ret_code;
/* no results */
return DB_OK;
}
/*!
\brief Commit transaction
\param driver db driver
\return DB_OK on success
\return DB_FAILED on failure
*/
int db_commit_transaction(dbDriver * driver)
{
int ret_code;
/* start the procedure call */
db__set_protocol_fds(driver->send, driver->recv);
DB_START_PROCEDURE_CALL(DB_PROC_COMMIT_TRANSACTION);
/* get the return code for the procedure call */
DB_RECV_RETURN_CODE(&ret_code);
if (ret_code != DB_OK)
return ret_code;
/* no results */
return DB_OK;
}
|
