Cypher questions - return updates count, update 2 things in a single query - Neo4j

The old Google Groups will be going away soon, but your browser is incompatible with the new version.
Message from discussion Cypher questions - return updates count, update 2 things in a single query
Received-SPF: pass (google.com: domain of azeeztechni...@gmail.com designates 209.85.160.47 as permitted sender) client-ip=209.85.160.47;
MIME-Version: 1.0
In-Reply-To: <86a8f9a6-5ac7-46d5-a705-53eb12debb6c@googlegroups.com>
References: <CAAuGTBi3pZ74PxhAeCsShw4WsehSwog84cPF4wWm4v3Zzta...@mail.gmail.com>
 <CAP4mnvY-364N9Z8T8c5Na4_frSxgYTWaUQB-r48A3tmC8O=...@mail.gmail.com> <86a8f9a6-5ac7-46d5-a705-53eb12debb6c@googlegroups.com>
From: Abdul Azeez Shaik <azeeztechni...@gmail.com>
Date: Thu, 18 Oct 2012 01:33:02 +0530
Message-ID: <CAP4mnvYzzuvQJN4JBDqv5XVTF-qVTsqi=26TwgAv2FHrhvL...@mail.gmail.com>
Subject: Re: [Neo4j] Cypher questions - return updates count, update 2 things
 in a single query
To: neo4j@googlegroups.com
Content-Type: multipart/alternative; boundary=e89a8ff1c83e7516f004cc46c494

--e89a8ff1c83e7516f004cc46c494
Content-Type: text/plain; charset=ISO-8859-1

AFIK, WHERE predicate can be removed, as anyways r.preferred is false.
But, i don't know what would be the performance effect on that. May be
Peter or Michael can answer this better.

BTW, what is your data size?

Thanks,
Abdul

On Thu, Oct 18, 2012 at 12:31 AM, wujek <wujek.sru...@gmail.com> wrote:

> Hi. This:
>
> start me = node({me}), like=node{{like}} match me-[r:LIKES]->t set
> r.preferred = false where r.preferred = true
> with me, like
> match me-[r:LIKES]->t set r.preferred = true
>
> doesn't work for me in the following scenario: there is no preferred yet
> (all relations have preferred = false), so the first part doesn't update
> anything, and then the second doesn't update anything as well.
> When I first set a preferred to some node, then the query works fine.
> Which means I cannot be used as is in my use case, as there is no preferred
> initially, and this seems to prevent setting one.
>
> Am I doing something wrong?
>
> wujek
>
>
> On Monday, October 15, 2012 12:57:03 PM UTC+2, Abdul Azeez Shaik wrote:
>>
>> Hi Wujek,
>>
>> You can use WITH clause to have two sub-queries in one query.
>> Your query would be,
>> start me = node({me}), like=node{{like}} match me-[r:LIKES]->t set
>> r.preferred = false where r.preferred = true
>> WITH me, like
>> match me-[r:LIKES]->t set r.preferred = true
>>
>>
>>  --
>
>
>

--e89a8ff1c83e7516f004cc46c494
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

AFIK, WHERE predicate can be removed, as anyways r.preferred is false.<div>=
But, i don&#39;t know what would be the performance effect on that. May be =
Peter or Michael can answer this better.</div><div><br></div><div>BTW, what=
 is your data size?</div>

<div><br></div><div>Thanks,</div><div>Abdul<br><div><br><div class=3D"gmail=
_quote">On Thu, Oct 18, 2012 at 12:31 AM, wujek <span dir=3D"ltr">&lt;<a hr=
ef=3D"mailto:wujek.sru...@gmail.com" target=3D"_blank">wujek.sru...@gmail.c=
om</a>&gt;</span> wrote:<br>

<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex">Hi. This:<div><div class=3D"im"><div><br></d=
iv><div>start me =3D node({me}), like=3Dnode{{like}} match me-[r:LIKES]-&gt=
;t set r.preferred =3D false where r.preferred =3D true</div>

</div><div>with me, like</div><div class=3D"im"><div>match me-[r:LIKES]-&gt=
;t set r.preferred =3D true</div></div></div><div><br></div><div>doesn&#39;=
t work for me in the following scenario: there is no preferred yet (all rel=
ations have preferred =3D false), so the first part doesn&#39;t update anyt=
hing, and then the second doesn&#39;t update anything as well.<div>

When I first set a preferred to some node, then the query works fine. Which=
 means I cannot be used as is in my use case, as there is no preferred init=
ially, and this seems to prevent setting one.</div><div><br></div><div>

Am I doing something wrong?</div><span class=3D"HOEnZb"><font color=3D"#888=
888"><div><br></div></font></span><div><span class=3D"HOEnZb"><font color=
=3D"#888888">wujek</font></span><div class=3D"im"><br><br>On Monday, Octobe=
r 15, 2012 12:57:03 PM UTC+2, Abdul Azeez Shaik wrote:<blockquote class=3D"=
gmail_quote" style=3D"margin:0;margin-left:0.8ex;border-left:1px #ccc solid=
;padding-left:1ex">

Hi Wujek,<div><br></div><div>You can use WITH clause to have two sub-querie=
s in one query.</div><div>Your query would be,</div><div>start me =3D node(=
{me}), like=3Dnode{{like}} match me-[r:LIKES]-&gt;t set r.preferred =3D fal=
se where r.preferred =3D true</div>



<div>WITH me, like</div><div>match me-[r:LIKES]-&gt;t set r.preferred =3D t=
rue</div><div><br></div></blockquote><blockquote class=3D"gmail_quote" styl=
e=3D"margin:0;margin-left:0.8ex;border-left:1px #ccc solid;padding-left:1ex=
">

<div><br></div>
</blockquote></div></div></div>

<p></p>

-- <br>
=A0<br>
=A0<br>
</blockquote></div><br></div></div>

--e89a8ff1c83e7516f004cc46c494--
Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
Account Options
