Geek Answers Handbook

Oridb sql edge update?

I talked to the orientdb sql website and I was wondering if there is a way to update the vertex edge along with some data on it.

Assuming I have the following data: Top: face, room Edge: inside (from person to number)

sort of:

UPDATE Persons SET phone=000000, out_Inside=(
    select @rid from Rooms where room_id=5) where person_id=8

obviously this does not work. This throws an exception:

Error: java.lang.ClassCastException: com.orientechnologies.orient.core.id.ORecordId cannot be cast to com.orientechnologies.orient.core.db.record.ridbag.ORidBag

I tried looking at sources in github to find the syntax for a bag with 1 element, but could not find (found%, but there seems to be no serialization for SQL).

(1) Is there a way to do this? how do i update the connection? Is there a way, or am I forced to create a new edge and delete the old one?

(2) , , , . , LINK. , , , , . , :

https://groups.google.com/forum/#!topic/orient-database/xXlNNXHI1UE

3 , Lvc @, :

"The suggested way is to always create an edge for relationships"

, , (1). .

p.s. , . , . , , , ( ), .

()

(1) . Lvca , !

(2) - -

+1
2

CREATE EDGE DELETE EDGE : .

, ( "" ), :

UPDATE Persons SET phone=000000, out_Inside=(
  select from Rooms where room_id=5) where person_id=8
+2
update EDGE Custom_Family_Of_Custom 
set survey_status = '%s', 
apply_source = '%s' 
where @rid in (
select level1_e.@rid from (
MATCH {class: Custom, as: custom, where: (custom_uuid = '%s')}.bothE('Custom_Family_Of_Custom') {as: level1_e} .bothV('Custom') {as: level1_v, where: (custom_uuid = '%s')} return level1_e
)
)

0

More articles:


All Articles