Returning boolean with Neo4j when request succeeds/fails
1
I am trying to make a query that would return me a boolean when the query succeeds or fails. So it would be true when it succeeds and false when it fails:
This is my request and after the RETURN is what I have tried so far neo4j:
MATCH (n:User),(d:Song)
WHERE n.username = "syord"
AND d.title = "Hello"
CREATE (n)-[r:PURCHASED]->(d)
SET n.totalStars = 999999
RETURN CASE
WHEN n IS NULL
THEN false
ELSE true
END
AS n
This returns true when it succeeds but when it fails I get nothing : (no changes, no records).
neo4j cypher
edited Nov 22 '18 at 20:20
ThirstForKnowledge
6651112
asked Nov 22 '18 at 19:00
RichardRichard
929
add a comment |
1
I am trying to make a query that would return me a boolean when the query succeeds or fails. So it would be true when it succeeds and false when it fails:
This is my request and after the RETURN is what I have tried so far neo4j:
MATCH (n:User),(d:Song)
WHERE n.username = "syord"
AND d.title = "Hello"
CREATE (n)-[r:PURCHASED]->(d)
SET n.totalStars = 999999
RETURN CASE
WHEN n IS NULL
THEN false
ELSE true
END
AS n
This returns true when it succeeds but when it fails I get nothing : (no changes, no records).
neo4j cypher
edited Nov 22 '18 at 20:20
ThirstForKnowledge
6651112
asked Nov 22 '18 at 19:00
RichardRichard
929
add a comment |
1
1
1
I am trying to make a query that would return me a boolean when the query succeeds or fails. So it would be true when it succeeds and false when it fails:
This is my request and after the RETURN is what I have tried so far neo4j:
MATCH (n:User),(d:Song)
WHERE n.username = "syord"
AND d.title = "Hello"
CREATE (n)-[r:PURCHASED]->(d)
SET n.totalStars = 999999
RETURN CASE
WHEN n IS NULL
THEN false
ELSE true
END
AS n
This returns true when it succeeds but when it fails I get nothing : (no changes, no records).
neo4j cypher
edited Nov 22 '18 at 20:20
ThirstForKnowledge
6651112
asked Nov 22 '18 at 19:00
RichardRichard
929
I am trying to make a query that would return me a boolean when the query succeeds or fails. So it would be true when it succeeds and false when it fails:
This is my request and after the RETURN is what I have tried so far neo4j:
MATCH (n:User),(d:Song)
WHERE n.username = "syord"
AND d.title = "Hello"
CREATE (n)-[r:PURCHASED]->(d)
SET n.totalStars = 999999
RETURN CASE
WHEN n IS NULL
THEN false
ELSE true
END
AS n
This returns true when it succeeds but when it fails I get nothing : (no changes, no records).
neo4j cypher
neo4j cypher
edited Nov 22 '18 at 20:20
ThirstForKnowledge
6651112
asked Nov 22 '18 at 19:00
RichardRichard
929
edited Nov 22 '18 at 20:20
ThirstForKnowledge
6651112
asked Nov 22 '18 at 19:00
RichardRichard
929
edited Nov 22 '18 at 20:20
ThirstForKnowledge
6651112
edited Nov 22 '18 at 20:20
ThirstForKnowledge
6651112
edited Nov 22 '18 at 20:20
ThirstForKnowledge
6651112
6651112
asked Nov 22 '18 at 19:00
RichardRichard
929
asked Nov 22 '18 at 19:00
RichardRichard
929
asked Nov 22 '18 at 19:00
RichardRichard
929
929
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
2
Underlying idea
MATCH (n:YourLabel) RETURN count(n)>0 AS result;
Result
╒════════╕
│"result"│
╞════════╡
│false │
└────────┘
Applied to your concrete query
MATCH (n:User),(d:Song)
WHERE n.username = "syord"
AND d.title = "Hello"
CREATE (n)-[r:PURCHASED]->(d)
SET n.totalStars = 999999
RETURN count(n)>0
AS n
answered Nov 22 '18 at 19:23
ThirstForKnowledgeThirstForKnowledge
6651112
That works exactly as I wanted it to, but why does thecount(n)>0return true/false?
– Richard
Nov 22 '18 at 19:44
1
After the amount fornhas been determined, the resulting boolean expression1>0is evaluated by Cypher, which leads to the valuetrueorfalsethat is returned byRETURN.
– ThirstForKnowledge
Nov 22 '18 at 19:55
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53436809%2freturning-boolean-with-neo4j-when-request-succeeds-fails%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
2
Underlying idea
MATCH (n:YourLabel) RETURN count(n)>0 AS result;
Result
╒════════╕
│"result"│
╞════════╡
│false │
└────────┘
Applied to your concrete query
MATCH (n:User),(d:Song)
WHERE n.username = "syord"
AND d.title = "Hello"
CREATE (n)-[r:PURCHASED]->(d)
SET n.totalStars = 999999
RETURN count(n)>0
AS n
answered Nov 22 '18 at 19:23
ThirstForKnowledgeThirstForKnowledge
6651112
That works exactly as I wanted it to, but why does thecount(n)>0return true/false?
– Richard
Nov 22 '18 at 19:44
1
After the amount fornhas been determined, the resulting boolean expression1>0is evaluated by Cypher, which leads to the valuetrueorfalsethat is returned byRETURN.
– ThirstForKnowledge
Nov 22 '18 at 19:55
add a comment |
2
Underlying idea
MATCH (n:YourLabel) RETURN count(n)>0 AS result;
Result
╒════════╕
│"result"│
╞════════╡
│false │
└────────┘
Applied to your concrete query
MATCH (n:User),(d:Song)
WHERE n.username = "syord"
AND d.title = "Hello"
CREATE (n)-[r:PURCHASED]->(d)
SET n.totalStars = 999999
RETURN count(n)>0
AS n
answered Nov 22 '18 at 19:23
ThirstForKnowledgeThirstForKnowledge
6651112
That works exactly as I wanted it to, but why does thecount(n)>0return true/false?
– Richard
Nov 22 '18 at 19:44
1
After the amount fornhas been determined, the resulting boolean expression1>0is evaluated by Cypher, which leads to the valuetrueorfalsethat is returned byRETURN.
– ThirstForKnowledge
Nov 22 '18 at 19:55
add a comment |
2
2
2
Underlying idea
MATCH (n:YourLabel) RETURN count(n)>0 AS result;
Result
╒════════╕
│"result"│
╞════════╡
│false │
└────────┘
Applied to your concrete query
MATCH (n:User),(d:Song)
WHERE n.username = "syord"
AND d.title = "Hello"
CREATE (n)-[r:PURCHASED]->(d)
SET n.totalStars = 999999
RETURN count(n)>0
AS n
answered Nov 22 '18 at 19:23
ThirstForKnowledgeThirstForKnowledge
6651112
Underlying idea
MATCH (n:YourLabel) RETURN count(n)>0 AS result;
Result
╒════════╕
│"result"│
╞════════╡
│false │
└────────┘
Applied to your concrete query
MATCH (n:User),(d:Song)
WHERE n.username = "syord"
AND d.title = "Hello"
CREATE (n)-[r:PURCHASED]->(d)
SET n.totalStars = 999999
RETURN count(n)>0
AS n
answered Nov 22 '18 at 19:23
ThirstForKnowledgeThirstForKnowledge
6651112
answered Nov 22 '18 at 19:23
ThirstForKnowledgeThirstForKnowledge
6651112
answered Nov 22 '18 at 19:23
ThirstForKnowledgeThirstForKnowledge
6651112
answered Nov 22 '18 at 19:23
ThirstForKnowledgeThirstForKnowledge
6651112
6651112
That works exactly as I wanted it to, but why does thecount(n)>0return true/false?
– Richard
Nov 22 '18 at 19:44
1
After the amount fornhas been determined, the resulting boolean expression1>0is evaluated by Cypher, which leads to the valuetrueorfalsethat is returned byRETURN.
– ThirstForKnowledge
Nov 22 '18 at 19:55
add a comment |
That works exactly as I wanted it to, but why does thecount(n)>0return true/false?
– Richard
Nov 22 '18 at 19:44
1
After the amount fornhas been determined, the resulting boolean expression1>0is evaluated by Cypher, which leads to the valuetrueorfalsethat is returned byRETURN.
– ThirstForKnowledge
Nov 22 '18 at 19:55
That works exactly as I wanted it to, but why does the
count(n)>0 return true/false?– Richard
Nov 22 '18 at 19:44
That works exactly as I wanted it to, but why does the
count(n)>0 return true/false?– Richard
Nov 22 '18 at 19:44
1
1
After the amount for
n has been determined, the resulting boolean expression 1>0 is evaluated by Cypher, which leads to the value true or false that is returned by RETURN.– ThirstForKnowledge
Nov 22 '18 at 19:55
After the amount for
n has been determined, the resulting boolean expression 1>0 is evaluated by Cypher, which leads to the value true or false that is returned by RETURN.– ThirstForKnowledge
Nov 22 '18 at 19:55
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53436809%2freturning-boolean-with-neo4j-when-request-succeeds-fails%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
