Hi,
Pawel just contributed by providing the new UPSERT feature on SQL UPDATE
command. Below the Pawel's comments:
"UPSERT update a record if it already exists, or insert a new record if it
does not - all in a single statement. It should decreases time of data
insertion, where the scenario
if( SELECT record exists ) {
UPDATE record;
} else {
INSERT record;
}
is common. UPSERT operator has a sense with class name and WHERE operator.
In other cases generates an exception.
Full UPDATE syntax would look following:
UPDATE |cluster:> [SET|ADD|PUT|REMOVE|INCREMENT|CONTENT {}|MERGE {}] [[,] =
|]* [LOCK ] [UPSERT] [RETURN ] [WHERE]"
It's already available in OrientDB 1.7-rc2-SNAPSHOT (or "develop" branch).
Thank you Pawel, hope other users will follow you by contributing with such
good Pull Requests!
Lvc@
--
---
You received this message because you are subscribed to the Google Groups
"OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
