update from subquery / aggregate

[Vincent Côté-Roy]

Hi,

I'm trying to figure out the syntax to update a row from a subquery to
another table. In sql it would look like this:

update Eval set totalScore = (select sum(score) from answer where
evalid = eval.id) where id = [xyz]

I tried the following:

update (evals) (e =>
where (e.id === id)
set (e.totalScore := from(answers)(a => where(a.evalId === [xyz])
compute (sum(a.score)))
)

This results in this error:
could not find implicit value for evidence parameter of type
(org.squeryl.dsl.Measures[Option[org.squeryl.PrimitiveTypeMode.IntType]]])
=> org.squeryl.dsl.ast.TypedExpressionNode[org.squeryl.PrimitiveTypeMode.IntType]

For testing purposes I also tried removing the aggregate, but it can't
get it to work either:

update (evals) (e =>
where (e.id === id)
set (e.totalScore := from(answers)(a => where(a.evalId === id)
select (a.score))
)

This gives me a similar error:
could not find implicit value for evidence parameter of type
(org.squeryl.Query[Int]) =>
org.squeryl.dsl.ast.TypedExpressionNode[org.squeryl.PrimitiveTypeMode.IntType]

Am I getting the syntax wrong or is this not supported right now? I
couldn't find a similar sample in the docs.

Thanks

Vincent

[Maxime Lévesque]

Subqueries in set functions are not supported,

please open a ticket : http://www.assembla.com/spaces/squeryl/tickets

Thanks

2011/1/25 Vincent Côté-Roy <vinc...@jucent.com>

[Vincent Côté-Roy]

Hi Maxime,

I tried but I don't seem to have the option to do so. There's no "new
ticket" button after I login.

Thanks,

Vincent

2011/1/25 Maxime Lévesque <maxime....@gmail.com>:

--

Vincent Côté-Roy

[Michael Gottschalk]

Hi Vincent,

On 26 Jan., 13:47, Vincent Côté-Roy <vincen...@jucent.com> wrote:
> Hi Maxime,
>
> I tried but I don't seem to have the option to do so. There's no "new
> ticket" button after I login.

you have to watch the space for being able to create a new ticket.
There should be a link "Watch this space" somewhere.

Cheers,
Michael

> 2011/1/25 Maxime Lévesque <maxime.leves...@gmail.com>:

>
>
>
>
>
> > Subqueries in set functions are not supported,
>
> > please open a ticket :http://www.assembla.com/spaces/squeryl/tickets
>
> > Thanks
>

> > 2011/1/25 Vincent Côté-Roy <vincen...@jucent.com>

[Vincent Côté-Roy]

Hi Michael,

I did and I still can't. I seem to have only read-only access to tickets.

--

Vincent Côté-Roy

[Maxime Lévesque]

Just pushed support for subqueries in partial update set clause :

 https://github.com/max-l/Squeryl/commit/e75ddecf4a0855771dd569b4c4df4e23fde2133e

please reopen the ticket if necessary.

2011/1/26 Vincent Côté-Roy <vinc...@jucent.com>

[Vincent Côté-Roy]

Thanks! I'll try it tomorrow.

2011/1/29 Maxime Lévesque <maxime....@gmail.com>:

--

Vincent Côté-Roy

[ÆtherSurfer]

Who were you, vincentcr?

What did you see?

http://xkcd.com/979/

http://stackoverflow.com/questions/29808430/squeryl-update-from-select

https://groups.google.com/forum/#!topic/squeryl/6ZRMk4I9vZU

[David Whittaker]

:)  So it seems there should be support for this.

Ummmm.... Max?

--
You received this message because you are subscribed to the Google Groups "Squeryl" group.
To unsubscribe from this group and stop receiving emails from it, send an email to squeryl+u...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[ÆtherSurfer]

I eventually settled on this workaround

update(widgets) (
  w=>
    where(w.id === 2)
    set(w.foo := from(widgets)(prevW => where(prevW.id === 1) compute(min(foo))))
)

http://stackoverflow.com/a/30783999/263306