This is the right one https://github.com/orientechnologies/orientdb/blob/develop/core/src/main/java/com/orientechnologies/orient/core/sql/OCommandExecutorSQLUpdate.java#L379
Thanks Luigi 2016-04-20 18:00 GMT+02:00 Luigi Dell'Aquila <[email protected]>: > ops, sorry... wrong link... I'll give you the info asap > > 2016-04-20 17:59 GMT+02:00 Luigi Dell'Aquila <[email protected]>: > >> Hi Simon, >> >> You can take a look at the execute() method of >> >> >> https://github.com/orientechnologies/orientdb/blob/develop/graphdb/src/main/java/com/orientechnologies/orient/graph/sql/OCommandExecutorSQLMoveVertex.java >> >> Thanks >> >> Luigi >> >> >> 2016-04-20 17:53 GMT+02:00 'Simon White' via OrientDB < >> [email protected]>: >> >>> Oh sorry - I *did* miss that!! :) >>> >>> But look at the URI I posted... it says 2.1, surely this page should not >>> appear in 2.1 if it is a 2.2 feature. >>> >>> >>> Anyway... any chance you could help me write the commands to manually >>> update the edges? >>> >>> from >>> A ----> friend ----> B >>> >>> to >>> A ----> friend ----> C >>> >>> something like.... >>> 1. Update B remove in friend >>> 2. Update friend set out C >>> 3. Update C set in friend >>> >>> >>> >>> >>> On Wednesday, April 20, 2016 at 4:44:09 PM UTC+1, Luigi Dell'Aquila >>> wrote: >>>> >>>> Hi Simon, >>>> >>>> I think you missed line 7 in the docs ;-) >>>> >>>> "This command was introduced in version 2.2." >>>> >>>> Thanks >>>> >>>> Luigi >>>> >>>> >>>> 2016-04-20 17:42 GMT+02:00 'Simon White' via OrientDB < >>>> [email protected]>: >>>> >>>>> >>>>> So this documentation is completely wrong?! >>>>> >>>>> http://orientdb.com/docs/2.1/SQL-Update-Edge.html >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> On Wednesday, April 20, 2016 at 4:33:24 PM UTC+1, Ivan Mainetti wrote: >>>>>> >>>>>> Yes you're right, that feature will be in 2.2 >>>>>> >>>>>> >>>>>> >>>>>> Il giorno mercoledì 20 aprile 2016 17:23:07 UTC+2, Simon White ha >>>>>> scritto: >>>>>>> >>>>>>> As far as I can tell this *does not maintain graph consistency* >>>>>>> i.e. automatically remove the out edge on the old vertex and set it on >>>>>>> the >>>>>>> new - it simply updates the edge so I would have to manage the edges >>>>>>> myself. The documentation suggests that update edge would do this for >>>>>>> me? >>>>>>> >>>>>>> On Wednesday, April 20, 2016 at 4:16:43 PM UTC+1, Ivan Mainetti >>>>>>> wrote: >>>>>>>> >>>>>>>> Hi, >>>>>>>> >>>>>>>> use this: >>>>>>>> >>>>>>>> UPDATE 50:12 SET out=14:10 >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> Il giorno mercoledì 20 aprile 2016 17:09:05 UTC+2, Simon White ha >>>>>>>> scritto: >>>>>>>>> >>>>>>>>> I am probably being stupid but I am trying to run the sql UPDATE >>>>>>>>> EDGE command (from the docs >>>>>>>>> http://orientdb.com/docs/2.1/SQL-Update-Edge.html) >>>>>>>>> >>>>>>>>> But I can't get it to run.... >>>>>>>>> >>>>>>>>> UPDATE EDGE Friend SET out = (SELECT FROM #14:10) WHERE @rid = >>>>>>>>> '#50:12' >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> com.orientechnologies.orient.core.sql.OCommandSQLParsingException: >>>>>>>>> Error on parsing command at position #0: Error parsing query: UPDATE >>>>>>>>> EDGE Friend >>>>>>>>> set out = #14:10 Encountered " <EDGE> "EDGE "" at line 1, column 8. >>>>>>>>> Was >>>>>>>>> expecting one of: <TO> ... <VALUES> ... <SET> ... <ADD> ... <PUT> ... >>>>>>>>> <MERGE> ... <CONTENT> ... <REMOVE> ... <ORDER> ... <GROUP> ... >>>>>>>>> <OFFSET> ... >>>>>>>>> <RECORD> ... <LUCENE> ... <NEAR> ... <WITHIN> ... <EXCEPTION> ... >>>>>>>>> <FIND> >>>>>>>>> ... <REFERENCES> ... <THIS> ... <RECORD_ATTRIBUTE> ... >>>>>>>>> <INTEGER_LITERAL> >>>>>>>>> ... "(" ... "[" ... "?" ... ":" ... "-" ... "*" ... <IN> ... <KEY> ... >>>>>>>>> <CLUSTER> ... <IDENTIFIER> ... <QUOTED_IDENTIFIER> ... >>>>>>>>> <INDEX_IDENTIFIER> >>>>>>>>> ... <INDEXVALUES_IDENTIFIER> ... <INDEXVALUESASC_IDENTIFIER> ... >>>>>>>>> <INDEXVALUESDESC_IDENTIFIER> ... <CLUSTER_IDENTIFIER> ... >>>>>>>>> <CLUSTER_NUMBER_IDENTIFIER> ... <METADATA_IDENTIFIER> ... "#" ... >>>>>>>>> >>>>>>>>> I need to update the OUT value of an edge whilst maintaining the >>>>>>>>> graph consistency with vertices and *without recreating the edge* >>>>>>>>> >>>>>>>> -- >>>>> >>>>> --- >>>>> 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/d/optout. >>>>> >>>> >>>> -- >>> >>> --- >>> 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/d/optout. >>> >> >> > -- --- 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/d/optout.
