NAME
sp_upsert - common get operation
SYNOPSIS
#include <sophia.h>
void *sp_upsert(void *object, void *document);
typedef int (*upsert_callback)(char **result,
char **key, int *key_size, int key_count,
char *src, int src_size,
char *upsert, int upsert_size,
void *arg);
DESCRIPTION
sp_upsert(database, document): do a single-statement transaction.
sp_upsert(transaction, document): do a key update as a part of multi-statement transaction.
As a part of a transactional statement a key-value document must be prepared using sp_document() method. First argument of sp_document() method must be an database object.
Object must be prepared by setting key and value fields. It is important that while setting key and value fields, only pointers are copied. Real data copies only during first operation.
Value field should contain user-supplied data, which should be enough to implement custom update or insert logic.
To enable upsert command, a db.database_name.index.upsert and optionally db.database_name.index.upsert_arg must be set to callback function pointer.
For additional information take a look at sp_document(), sp_begin() and Transactions and Upsert sections.
EXAMPLE
See Sophia repository upsert example.
RETURN VALUE
On success, sp_set() returns 0. On error, it returns -1.
Database object commit: (1) rollback or (2) lock.
SEE ALSO