ODB 3.0 SQL UPDATE - No more ADD|PUT?

[Eric24]

According to the 3.0 documentation (http://orientdb.com/docs/3.0.x/sql/SQL-Update.html), ADD|PUT (and INCREMENT, which I don't use) have been removed from the SQL UPDATE syntax. Is there an alternative way in 3.0 to modify a Collection or Map, rather than overwrite it completely with SET?

Also, is there a document that describes all differences between 2.x and 3.0?

[user.w...@gmail.com]

Hi,

you can take a look at these links:

OrientDB 3.0 Release Notes: https://github.com/orientechnologies/orientdb/wiki/OrientDB-3.0-Release-Notes

OrientDB 2.2 Release Notes: https://github.com/orientechnologies/orientdb/wiki/OrientDB-2.2-Release-Notes

Here you can see all the differences / enhancement.

Hope it helps

Regards,

Michela

[Luigi Dell'Aquila]

Hi Eric,

The alternatives are:

PUT: just use dot notation

UPDATE ADoc PUT aMap = "aKey", "aValue"

can be written as

UPDATE ADoc SET aMap.aKey = "aValue"

or

UPDATE ADoc SET aMap["aKey"] = "aValue"

ADD: use array concatenation ||

UPDATE ADoc PUT aList = "aValue"

can be written as

UPDATE ADoc SET aList = aList || "aValue"

or

UPDATE ADoc SET aList =  "aValue" || aList 

depending on where you want to add the value (first or last element of the list). For sets it does not make any difference of course

For a full reference see http://orientdb.com/docs/3.0.x/sql/SQL-Syntax.html

Thanks

Luigi

--

---
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 orient-database+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Eric24]

Thanks Luigi; makes perfect sense. Is this syntax also supported on 2.2.x?

To unsubscribe from this group and stop receiving emails from it, send an email to orient-databa...@googlegroups.com.

[Luigi Dell'Aquila]

Hi Eric,

The UPDATE SET syntax is allowed also in v 2.2.x, but the || operator is a new addition and won't be backported to 2.2

Thanks

Luigi

To unsubscribe from this group and stop receiving emails from it, send an email to orient-database+unsubscribe@googlegroups.com.