Update from select?

[ÆtherSurfer]

Given a table:

╔════╦═════════╦═════╗
║ id ║ prev_id ║ foo ║
╠════╬═════════╬═════╣
║  1 ║         ║ bar ║
║  2 ║       1 ║     ║
╚════╩═════════╩═════╝

How do I do the following query in squeryl?

UPDATE widgets 
SET 
  widgets.foo = 
    (
     SELECT widgets.foo
     FROM widgets 
     WHERE widgets.id = 1
    )
WHERE
    widgets.id = 2

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

[Æ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

[David Whittaker]

Thanks for updating the thread.

-Dave

--
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.