本文整理汇总了C++中db_free_result函数的典型用法代码示例。如果您正苦于以下问题:C++ db_free_result函数的具体用法?C++ db_free_result怎么用?C++ db_free_result使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了db_free_result函数的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的C++代码示例。
示例1: mapinfowindow_load_cities
static void mapinfowindow_load_cities(gint nStateID)
{
db_resultset_t* pResultSet = NULL;
db_row_t aRow;
//
// Load up all cities for this state
//
gchar* pszSQL = g_strdup_printf("SELECT City.ID, City.Name FROM City WHERE StateID=%d ORDER BY Name ASC;", nStateID);
db_query(pszSQL, &pResultSet);
g_free(pszSQL);
g_return_if_fail(pResultSet != NULL);
// New menu
if(g_MapInfoWindow.pCityMenu) {
gtk_widget_destroy(GTK_WIDGET(g_MapInfoWindow.pCityMenu));
}
g_MapInfoWindow.pCityMenu = GTK_MENU(gtk_menu_new());
// Fill menu
while((aRow = db_fetch_row(pResultSet)) != NULL) {
gint nCityID = atoi(aRow[0]);
gchar* pszName = aRow[1];
// Add new menu item
GtkMenuItem* pNewMenuItem = GTK_MENU_ITEM(gtk_menu_item_new_with_mnemonic(pszName));
g_signal_connect(G_OBJECT(pNewMenuItem), "activate", (GCallback)mapinfowindow_on_city_chosen, GINT_TO_POINTER(nCityID));
gtk_menu_shell_append(GTK_MENU_SHELL(g_MapInfoWindow.pCityMenu), GTK_WIDGET(pNewMenuItem));
}
db_free_result(pResultSet);
// Install new menu
gtk_widget_show_all(GTK_WIDGET(g_MapInfoWindow.pCityMenu));
gtk_menu_tool_button_set_menu(g_MapInfoWindow.pCityButton, GTK_WIDGET(g_MapInfoWindow.pCityMenu));
}
开发者ID:freedesktop-unofficial-mirror,项目名称:roadster,代码行数:35,代码来源:mapinfowindow.c
示例2: db_postgres_insert
/*
* Insert a row into specified table
* _con: structure representing database connection
* _k: key names
* _v: values of the keys
* _n: number of key=value pairs
*/
int db_postgres_insert(const db_con_t* _h, const db_key_t* _k,
const db_val_t* _v, const int _n)
{
db_res_t* _r = NULL;
CON_RESET_CURR_PS(_h); /* no prepared statements support */
/* This needs to be reset before each call to db_do_insert.
This is only used by inserts, but as a side effect delete and updates
will set it to 1 without resetting it. */
submit_func_called = 0;
int tmp = db_do_insert(_h, _k, _v, _n, db_postgres_val2str,
db_postgres_submit_query);
/* For bulk queries the insert may not be submitted until enough rows are queued */
if (submit_func_called)
{
/* Query was submitted.
Result must be handled. */
if (db_postgres_store_result(_h, &_r) != 0)
LM_WARN("unexpected result returned\n");
}
if (_r)
db_free_result(_r);
if (CON_HAS_INSLIST(_h))
CON_RESET_INSLIST(_h);
return tmp;
}
开发者ID:OpenSIPS,项目名称:opensips,代码行数:39,代码来源:dbase.c
示例3: erlang_srdb1_fetch_result
/**
* \brief Gets a partial result set, fetch rows from a result
*
* Gets a partial result set, fetch a number of rows from a database result.
* This function initialize the given result structure on the first run, and
* fetches the nrows number of rows. On subsequenting runs, it uses the
* existing result and fetches more rows, until it reaches the end of the
* result set. Because of this the result needs to be null in the first
* invocation of the function. If the number of wanted rows is zero, the
* function returns anything with a result of zero.
* \param _h structure representing the database connection
* \param _r pointer to a structure representing the result
* \param nrows number of fetched rows
* \return zero on success, negative value on failure
*/
int erlang_srdb1_fetch_result(const db1_con_t* _h, db1_res_t** _r, const int nrows)
{
int rows, i, code;
LM_DBG("erlang_srdb1_fetch_result\n");
if (!_h || !_r || nrows < 0) {
LM_ERR("Invalid parameter value\n");
return -1;
}
/* exit if the fetch count is zero */
if (nrows == 0) {
db_free_result(*_r);
*_r = 0;
return 0;
}
if(*_r==0) {
/* Allocate a new result structure */
*_r = db_new_result();
if (*_r == 0) {
LM_ERR("no memory left\n");
return -2;
}
} else {
/* free old rows */
if(RES_ROWS(*_r)!=0)
db_free_rows(*_r);
RES_ROWS(*_r) = 0;
RES_ROW_N(*_r) = 0;
}
/* determine the number of rows remaining to be processed */
rows = RES_NUM_ROWS(*_r) - RES_LAST_ROW(*_r);
/* If there aren't any more rows left to process, exit */
if(rows<=0)
return 0;
/* if the fetch count is less than the remaining rows to process */
/* set the number of rows to process (during this call) equal to the fetch count */
if(nrows < rows)
rows = nrows;
RES_ROW_N(*_r) = rows;
LM_DBG("converting row %d of %d count %d\n", RES_LAST_ROW(*_r),
RES_NUM_ROWS(*_r), RES_ROW_N(*_r));
RES_ROWS(*_r) = (struct db_row*)pkg_malloc(sizeof(db_row_t) * rows);
if (!RES_ROWS(*_r)) {
LM_ERR("no memory left\n");
return -5;
}
/* update the total number of rows processed */
RES_LAST_ROW(*_r) += rows;
return 0;
}
开发者ID:majastanislawska,项目名称:sip-router-erlang-module,代码行数:75,代码来源:db_erlang_srdb1.c
示例4: db_postgres_insert
/*
* Insert a row into specified table
* _con: structure representing database connection
* _k: key names
* _v: values of the keys
* _n: number of key=value pairs
*/
int db_postgres_insert(const db_con_t* _h, const db_key_t* _k,
const db_val_t* _v, const int _n)
{
db_res_t* _r = NULL;
CON_RESET_CURR_PS(_h); /* no prepared statements support */
int tmp = db_do_insert(_h, _k, _v, _n, db_postgres_val2str,
db_postgres_submit_query);
if (submit_func_called)
{
/* finish the async query,
* otherwise the next query will not complete */
/* only call this if the DB API has effectively called
* our submit_query function
*
* in case of insert queueing,
* it may postpone calling the insert func until
* enough rows have piled up */
if (db_postgres_store_result(_h, &_r) != 0)
LM_WARN("unexpected result returned\n");
submit_func_called = 0;
}
if (_r)
db_free_result(_r);
if (CON_HAS_INSLIST(_h))
CON_RESET_INSLIST(_h);
return tmp;
}
开发者ID:dynamicpacket-public,项目名称:opensips17,代码行数:41,代码来源:dbase.c
示例5: db_postgres_free_result
int db_postgres_free_result(db_con_t* _con, db_res_t* _r)
{
free_query(_con);
if (_r) db_free_result(_r);
_r = 0;
return 0;
}
开发者ID:dynamicpacket-public,项目名称:opensips17,代码行数:8,代码来源:dbase.c
示例6: db_postgres_async_free_result
int db_postgres_async_free_result(db_con_t *_h, db_res_t *_r, void *_priv)
{
struct pg_con *con = (struct pg_con *)_priv;
if (_r && db_free_result(_r) < 0) {
LM_ERR("error while freeing result structure\n");
}
PQclear(con->res);
con->res = NULL;
return 0;
}
开发者ID:OpenSIPS,项目名称:opensips,代码行数:12,代码来源:dbase.c
示例7: db_postgres_free_result
/*!
* \brief Free the query and the result memory in the core
* \param _con database connection
* \param _r result set
* \return 0 on success, -1 on failure
*/
int db_postgres_free_result(db1_con_t* _con, db1_res_t* _r)
{
if ((!_con) || (!_r)) {
LM_ERR("invalid parameter value\n");
return -1;
}
if (db_free_result(_r) < 0) {
LM_ERR("unable to free result structure\n");
return -1;
}
db_postgres_free_query(_con);
return 0;
}
开发者ID:kiryu,项目名称:kamailio,代码行数:19,代码来源:km_dbase.c
示例8: resume_async_dbquery
int resume_async_dbquery(int fd, struct sip_msg *msg, void *_param)
{
db_res_t *res = NULL;
query_async_param *param = (query_async_param *)_param;
int rc;
rc = param->dbf->async_raw_resume(param->hdl, fd, &res, param->db_param);
if (async_status == ASYNC_CONTINUE || async_status == ASYNC_CHANGE_FD) {
return rc;
}
if (rc != 0) {
LM_ERR("async query returned error\n");
pkg_free(param);
return -1;
}
if (!res || RES_ROW_N(res) <= 0 || RES_COL_N(res) <= 0) {
LM_DBG("query returned no results\n");
db_free_result(res);
pkg_free(param);
return -2;
}
if (db_query_avp_print_results(msg, res, param->output_avps) != 0) {
LM_ERR("failed to print results\n");
db_free_result(res);
pkg_free(param);
return -1;
}
async_status=ASYNC_DONE;
db_free_result(res);
pkg_free(param);
return 1;
}
开发者ID:AndreiPlesa,项目名称:opensips,代码行数:38,代码来源:avpops_impl.c
示例9: db_oracle_free_result
/*
* Release a result set from memory
*/
int db_oracle_free_result(db1_con_t* _h, db1_res_t* _r)
{
if (!_h || !_r) {
LM_ERR("invalid parameter value\n");
return -1;
}
if (db_free_result(_r) < 0)
{
LM_ERR("failed to free result structure\n");
return -1;
}
return 0;
}
开发者ID:SibghatullahSheikh,项目名称:kamailio,代码行数:17,代码来源:dbase.c
示例10: db_mysql_new_result
/*!
* \brief Allocate new result set with private structure
* \return db1_res_t object on success, NULL on failure
*/
db1_res_t* db_mysql_new_result(void)
{
db1_res_t* obj;
obj = db_new_result();
if (!obj)
return NULL;
RES_PTR(obj) = pkg_malloc(sizeof(struct my_res));
if (!RES_PTR(obj)) {
db_free_result(obj);
return NULL;
}
return obj;
}
开发者ID:4N7HR4X,项目名称:kamailio,代码行数:18,代码来源:km_res.c
示例11: db_mysql_free_result
/**
* Release a result set from memory.
* \param _h handle to the database
* \param _r result set that should be freed
* \return zero on success, negative value on failure
*/
int db_mysql_free_result(db1_con_t* _h, db1_res_t* _r)
{
if ((!_h) || (!_r)) {
LM_ERR("invalid parameter value\n");
return -1;
}
if (db_free_result(_r) < 0) {
LM_ERR("unable to free result structure\n");
return -1;
}
mysql_free_result(CON_RESULT(_h));
CON_RESULT(_h) = 0;
return 0;
}
开发者ID:mehulsbhatt,项目名称:voip-foip,代码行数:21,代码来源:km_dbase.c
示例12: db_postgres_insert
/*!
* \brief Insert a row into specified table
* \param _h structure representing database connection
* \param _k key names
* \param _v values of the keys
* \param _n number of key=value pairs
* \return 0 on success, negative on failure
*/
int db_postgres_insert(const db1_con_t* _h, const db_key_t* _k, const db_val_t* _v,
const int _n)
{
db1_res_t* _r = NULL;
int tmp = db_do_insert(_h, _k, _v, _n, db_postgres_val2str, db_postgres_submit_query);
// finish the async query, otherwise the next query will not complete
if (db_postgres_store_result(_h, &_r) != 0)
LM_WARN("unexpected result returned");
if (_r)
db_free_result(_r);
return tmp;
}
开发者ID:mehulsbhatt,项目名称:sip-router,代码行数:23,代码来源:km_dbase.c
示例13: db_postgres_delete
/*!
* \brief Delete a row from the specified table
* \param _h structure representing database connection
* \param _k key names
* \param _o operators
* \param _v values of the keys that must match
* \param _n number of key=value pairs
* \return 0 on success, negative on failure
*/
int db_postgres_delete(const db1_con_t* _h, const db_key_t* _k, const db_op_t* _o,
const db_val_t* _v, const int _n)
{
db1_res_t* _r = NULL;
int tmp = db_do_delete(_h, _k, _o, _v, _n, db_postgres_val2str,
db_postgres_submit_query);
if (db_postgres_store_result(_h, &_r) != 0)
LM_WARN("unexpected result returned");
if (_r)
db_free_result(_r);
return tmp;
}
开发者ID:mehulsbhatt,项目名称:sip-router,代码行数:24,代码来源:km_dbase.c
示例14: erlang_srdb1_free_result
/**
* Release a result set from memory.
* \param _h handle to the database
* \param _r result set that should be freed
* \return zero on success, negative value on failure
*/
int erlang_srdb1_free_result(db1_con_t* _h, db1_res_t* _r)
{
LM_DBG("erlang_srdb1_free_result\n");
if ((!_h) || (!_r)) {
LM_ERR("invalid parameter value\n");
return -1;
}
if (db_free_result(_r) < 0) {
LM_ERR("unable to free result structure\n");
return -1;
}
// mysql_free_result(CON_RESULT(_h));
// CON_RESULT(_h) = 0;
return 0;
}
开发者ID:majastanislawska,项目名称:sip-router-erlang-module,代码行数:22,代码来源:db_erlang_srdb1.c
示例15: db_mysql_free_result
/**
* Release a result set from memory.
* \param _h handle to the database
* \param _r result set that should be freed
* \return zero on success, negative value on failure
*/
int db_mysql_free_result(const db1_con_t* _h, db1_res_t* _r)
{
if ((!_h) || (!_r)) {
LM_ERR("invalid parameter value\n");
return -1;
}
mysql_free_result(RES_RESULT(_r));
RES_RESULT(_r) = 0;
pkg_free(RES_PTR(_r));
if (db_free_result(_r) < 0) {
LM_ERR("unable to free result structure\n");
return -1;
}
return 0;
}
开发者ID:AndreyRybkin,项目名称:kamailio,代码行数:23,代码来源:km_dbase.c
示例16: db_postgres_delete
/*
* Delete a row from the specified table
* _con: structure representing database connection
* _k: key names
* _o: operators
* _v: values of the keys that must match
* _n: number of key=value pairs
*/
int db_postgres_delete(const db_con_t* _h, const db_key_t* _k,
const db_op_t* _o, const db_val_t* _v, const int _n)
{
db_res_t* _r = NULL;
CON_RESET_CURR_PS(_h); /* no prepared statements support */
int tmp = db_do_delete(_h, _k, _o, _v, _n, db_postgres_val2str,
db_postgres_submit_query);
if (db_postgres_store_result(_h, &_r) != 0)
LM_WARN("unexpected result returned");
if (_r)
db_free_result(_r);
return tmp;
}
开发者ID:dynamicpacket-public,项目名称:opensips17,代码行数:25,代码来源:dbase.c
示例17: db_unixodbc_free_result
/*
* Release a result set from memory
*/
int db_unixodbc_free_result(db1_con_t* _h, db1_res_t* _r)
{
if ((!_h) || (!_r))
{
LM_ERR("invalid parameter value\n");
return -1;
}
if (db_free_result(_r) < 0)
{
LM_ERR("failed to free result structure\n");
return -1;
}
SQLFreeHandle(SQL_HANDLE_STMT, CON_RESULT(_h));
CON_RESULT(_h) = 0;
return 0;
}
开发者ID:albertollamaso,项目名称:kamailio,代码行数:20,代码来源:dbase.c
示例18: db_unixodbc_store_result
/*
* Retrieve result set
*/
static int db_unixodbc_store_result(const db_con_t* _h, db_res_t** _r)
{
SQLSMALLINT cols;
SQLLEN aff_cols;
if ((!_h) || (!_r))
{
LM_ERR("invalid parameter value\n");
return -1;
}
*_r = db_new_result();
if (*_r == 0)
{
LM_ERR("no memory left\n");
return -2;
}
SQLNumResultCols(CON_RESULT(_h), &cols);
if (!cols) {
SQLRowCount(CON_RESULT(_h), &aff_cols);
if (aff_cols > 0) {
(*_r)->col.n = 0;
(*_r)->n = 0;
return 0;
} else {
LM_ERR(" invalid SQL query\n");
db_free_result(*_r);
*_r = 0;
return -3;
}
}
if (db_unixodbc_convert_result(_h, *_r) < 0)
{
LM_ERR("failed to convert result\n");
pkg_free(*_r);
*_r = 0;
return -4;
}
return 0;
}
开发者ID:Distrotech,项目名称:opensips,代码行数:46,代码来源:dbase.c
示例19: db_postgres_update
/*!
* Update some rows in the specified table
* \param _h structure representing database connection
* \param _k key names
* \param _o operators
* \param _v values of the keys that must match
* \param _uk updated columns
* \param _uv updated values of the columns
* \param _n number of key=value pairs
* \param _un number of columns to update
* \return 0 on success, negative on failure
*/
int db_postgres_update(const db1_con_t* _h, const db_key_t* _k, const db_op_t* _o,
const db_val_t* _v, const db_key_t* _uk, const db_val_t* _uv, const int _n,
const int _un)
{
db1_res_t* _r = NULL;
int ret = db_do_update(_h, _k, _o, _v, _uk, _uv, _n, _un, db_postgres_val2str,
db_postgres_submit_query);
int tmp = db_postgres_store_result(_h, &_r);
if (tmp < 0) {
LM_WARN("unexpected result returned");
ret = tmp;
}
if (_r)
db_free_result(_r);
return ret;
}
开发者ID:kiryu,项目名称:kamailio,代码行数:31,代码来源:km_dbase.c
示例20: db_oracle_free_result
/*
* Release a result set from memory
*/
int db_oracle_free_result(db_con_t* _h, db_res_t* _r)
{
ub4 i;
if (!_h || !_r) {
LM_ERR("invalid parameter value\n");
return -1;
}
if (RES_NAMES(_r))
for (i=0; i < RES_COL_N(_r); ++i)
if (RES_NAMES(_r)[i]->s)
pkg_free(RES_NAMES(_r)[i]->s);
if (db_free_result(_r) < 0)
{
LM_ERR("failed to free result structure\n");
return -1;
}
return 0;
}
开发者ID:AndreiPlesa,项目名称:opensips,代码行数:24,代码来源:dbase.c
注:本文中的db_free_result函数示例由纯净天空整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论