/*
* Just like insert, but replace the row if it exists
*/
int db_unixodbc_replace(const db_con_t* _h, const db_key_t* _k,
const db_val_t* _v, const int _n)
{
CON_RESET_CURR_PS(_h); /* no prepared statements support */
return db_do_replace(_h, _k, _v, _n, db_unixodbc_val2str,
db_unixodbc_submit_query);
}
/**
* Just like insert, but replace the row if it exists.
* \param _h database handle
* \param _k key names
* \param _v values of the keys that must match
* \param _n number of key=value pairs
* \return zero on success, negative value on failure
*/
int db_sqlite_replace(const db_con_t* _h, const db_key_t* _k, const db_val_t* _v, const int _n)
{
int ret;
sqlite3_stmt* stmt;
#ifdef SQLITE_BIND
db_ps_t ps;
CON_SET_CURR_PS(_h, &ps);
#else
CON_RESET_CURR_PS(_h);
#endif
ret = db_do_replace(_h, _k, _v, _n, db_sqlite_val2str,
db_sqlite_submit_dummy_query);
if (ret != 0) {
return ret;
}
again:
ret=sqlite3_prepare_v2(CON_CONNECTION(_h),
query_holder.s, query_holder.len, &stmt, NULL);
if (ret==SQLITE_BUSY)
goto again;
if (ret!=SQLITE_OK)
LM_ERR("failed to prepare: (%s)\n",
sqlite3_errmsg(CON_CONNECTION(_h)));
#ifdef SQLITE_BIND
if (db_sqlite_bind_values(stmt, _v, _n) != SQLITE_OK) {
LM_ERR("failed to bind values\n");
return -1;
}
#endif
again2:
ret = sqlite3_step(stmt);
if (ret==SQLITE_BUSY)
goto again2;
if (ret != SQLITE_DONE) {
LM_ERR("insert query failed %s\n", sqlite3_errmsg(CON_CONNECTION(_h)));
return -1;
}
sqlite3_finalize(stmt);
return 0;
}
/**
* Just like insert, but replace the row if it exists.
* \param _h database handle
* \param _k key names
* \param _v values of the keys that must match
* \param _n number of key=value pairs
* \return zero on success, negative value on failure
*/
int db_mysql_replace(const db1_con_t* _h, const db_key_t* _k, const db_val_t* _v, const int _n)
{
return db_do_replace(_h, _k, _v, _n, db_mysql_val2str,
db_mysql_submit_query);
}
/*
* Just like insert, but replace the row if it exists
*/
int db_unixodbc_replace(const db1_con_t* _h, const db_key_t* _k, const db_val_t* _v, const int _n,
const int _un, const int _m)
{
return db_do_replace(_h, _k, _v, _n, db_unixodbc_val2str,
db_unixodbc_submit_query);
}
