How to UNRELATE records

[zecar]

RELATE (SELECT * from user where username = 'user_male')->interested_in->gender:couple;
RELATE (SELECT * from user where username = 'user_male')->interested_in->gender:female;
RELATE (SELECT * from user where username = 'user_male')->interested_in->gender:trans;

RELATE (SELECT * from user WHERE username ='user_female')->interested_in->gender:female;

let's say that user_male no longer likes women. In order to unrelate that, we can use something like this:

DELETE interested_in WHERE gender:female INSIDE ->gender AND count(array::distinct(array::concat(<-user, (SELECT id FROM user WHERE username = "user_male")))) = 1 RETURN BEFORE
Do you guys have a better solution?

[IngwiePhoenix]

My immediate - but untested - thought would be

DELETE gender WHERE <-interested_in<-user:"user_male"

I am pretty sure there is a short version. Try something with the reverse traversal, I think that's the key.

[zecar]

My immediate - but untested - thought would be

DELETE gender WHERE <-interested_in<-user:"user_male"

I am pretty sure there is a short version. Try something with the reverse traversal, I think that's the key.

user_male is the username, not the id

also, this is confusing but wouldn't this delete the gender from the genders table instead of the relation?

[anonimusprogramus]

This is what I come so far -- it works.

--empty node
delete user;
delete fruit;
delete interested_in;

-- create user
create user content {
  username: 'user_male'
};

create user content {
  username: "user_female"
};

select * from user;

--create fruit
create fruit:apple;
create fruit:banana;
create fruit:cherry;

select * from fruit;

--make relation
relate (select * from user where username = 'user_male')->interested_in->fruit:apple;
relate (select * from user where username = 'user_male')->interested_in->fruit:banana;
relate (select * from user where username = 'user_male')->interested_in->fruit:cherry;
relate (seleCT * from user where username ='user_female')->interested_in->fruit:banana;

select * from interested_in order by in;

--user_male not interested in banana, remove it
delete interested_in where in inside (select id from user where username = 'user_male') and out = fruit:banana;

select * from interested_in;

[zecar]

yours is good.. a guy on stackoverflow came with a simpler one

DELETE interested_in WHERE in.username = 'user_male' AND out = gender:female

[anonimusprogramus]

wow 🔥