Hi,
I've started using OrientDB (version 2.0.2, remote protocol) last week. I
have the exact same need as Dan (using ligthweight edges, no need for
properties).
However I believe the query that you suggested doesn't answer to the need
as it prevents from creating more than one 'knows' edge per 'user' vertex
however the goal is to prevent duplicate edges between 2 users (as in "one
user can only be friend once with another user but can have several
friends"). With your query, #9:0 can only have one 'knows'.
Do you have any other suggestion (other than creating constraints) ?
Thank you for your help.
Cheers,
Alain
Le mercredi 7 janvier 2015 10:34:36 UTC+1, Riccardo Tasso a écrit :
>
> I would use the following query:
>
> CREATE EDGE knows FROM (SELECT FROM #9:0 WHERE out('knows') IS NULL) TO
> #9:1
>
> In this way you won't have any exception if the edge already exists, but
> it won't be inserted a duplicate.
>
> Cheers,
> Riccardo
>
> 2015-01-07 9:50 GMT+01:00 Dan Andrei <[email protected] <javascript:>>:
>
>> Hello, I've looked for some info but I couldn't find anything clearly
>> explained. My question is
>>
>> *How do I make a Edge unique in Orientdb ? version 1.7*
>>
>> The solution that I came up with:
>>
>> - delete the edge
>> - create it again
>>
>> but it's not nice. Edge is without any properties.
>>
>> *Example:*
>>
>> create edge is_friend from #12:0 to #12:3
>>
>> and if I call it again, there should be an error like when you make a
>> unique index.
>>
>> Lvca said Create a constraint on Edge out and in fields.
>>
>> But how exactly to do it ? I have a simple database with users and edges
>> "is_friend" from user to user without any additional properties on the edge.
>>
>>
>>
>>
>>
>> http://www.orientechnologies.com/docs/last/orientdb.wiki/Graph-Schema.html#constraints
>>
>>
>>
>> Thank you very much
>>
>> --
>>
>> ---
>> 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] <javascript:>.
>> 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.
