13 Mar
2012
13 Mar
'12
5:20 p.m.
Module: sip-router
Branch: master
Commit: 061453b77e82e2fa92af2f57db67b6f9f8ac8302
URL:
http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=061453b…
Author: Daniel-Constantin Mierla <miconda(a)gmail.com>
Committer: Daniel-Constantin Mierla <miconda(a)gmail.com>
Date: Tue Mar 13 13:58:27 2012 +0100
lib/srdb1: updated DB API prototype for replace
- replace method takes two more parameters to allow implementation of
replace functionality inside the db connector module, via update,
affected rows and insert
- first is the number of column-value pairs to be used as unique key.
They have to be located at the beginning of the array given so far as
parameter to replace
- second is a mode, that will allow doing custom replace by:
- update, if affected rows == 0 then insert
- insert, if duplicate key error, then update
- for the db connectors that have access to a native REPLACE command in
the DB backend, the new parameters are ignored
---
lib/srdb1/db.h | 7 ++++++-
1 files changed, 6 insertions(+), 1 deletions(-)
diff --git a/lib/srdb1/db.h b/lib/srdb1/db.h
index e27969f..6d3a45d 100644
--- a/lib/srdb1/db.h
+++ b/lib/srdb1/db.h
@@ -245,10 +245,15 @@ typedef int (*db_update_f) (const db1_con_t* _h, const db_key_t* _k,
const db_op
* \param _k key names
* \param _v values of the keys
* \param _n number of key=value pairs
+ * \param _un number of keys to build the unique key, starting from first _k
+ * \param _m mode - first update, then insert, or first insert, then update
+ * \note the last two parameters are used only if the DB server does not
+ * have native replace command (like postgres - the module doing an internal
+ * implementation using synchronized update/affected rows/insert mechanism)
* \return returns 0 if everything is OK, otherwise returns value < 0
*/
typedef int (*db_replace_f) (const db1_con_t* handle, const db_key_t* keys,
- const db_val_t* vals, const int n);
+ const db_val_t* vals, const int n, const int _un, const int _m);
/**