multiple joins with slick

Question

For joining between two tables is done like

    (for {
    (computer, company) <- Computers leftJoin Companies on (_.companyId === _.id)
    if computer.name.toLowerCase like filter.toLowerCase()
    }

But in case if joining required between more tables what is the right way trying below but doesnt work

   (for {
    (computer, company,suppliers) <- Computers leftJoin Companies on (_.companyId ===        _.id)
     //not right leftjoin Suppliers on (_.suppId === _.id)
    if computer.name.toLowerCase like filter.toLowerCase()
  }

computer is associated with supplier – dsr301 Sep 04 '13 at 06:05 — dsr301, Sep 04 '13 at 06:05

cvogt · Accepted Answer · 2013-09-04T12:29:29.500

36

The first join results in a Query returning Tuples. One of the tuple components has the foreign key you want to use for the second join. You need to get this component in the second join condition before getting its field. If Companies is the table, that has the field suppId it would look like this:

(for {
  ((computer, company),suppliers) <- Computers leftJoin Companies on (_.companyId === _.id) leftJoin Suppliers on (_._2.suppId === _.id)
  if computer.name.toLowerCase like filter.toLowerCase()
} yield ... )

edited Sep 04 '13 at 12:29

answered Aug 31 '13 at 12:37

cvogt

11,260
30
46

here leftJoin Suppliers on (_._2.suppId === _.id) is this join on the first tuple? in case if want to join between computer and suppliers i am trying with leftJoin Suppliers on (_._1.suppId === _.id) but this one fails – dsr301 Sep 04 '13 at 08:10
This works, but i see that the full query with joins should be in one line , else its showing compilation errors – dsr301 Sep 04 '13 at 09:39
changed the answer to be in one line – cvogt Sep 04 '13 at 12:29

score 4 · Answer 2 · answered Sep 01 '13 at 07:16

4

I think you want this:

for {
    (computer, company) <- Computers leftJoin Companies on (_.companyId === _.id)
    (supp, _) <- company innerJoin Suppliers on (_.suppId === _.id)
    if computer.name.toLowerCase like filter.toLowerCase()
} yield (computer, company, supp)

Of course, I am making assumptions about your model. Not sure if suppliers are linked with companies or computers.

answered Sep 01 '13 at 07:16

pedrofurla

12,763
1
38
49

2

I like that the second join is a separate line in the "for" comprehension. – Eric Pabst Feb 27 '14 at 15:18
how does company do the inner join here ? It a model type? (second line in for loop) – Setheron Mar 31 '14 at 01:13
`company` is the one defined in the previous line. – pedrofurla Apr 01 '14 at 22:08
4

Because you can't reuse `company` as a Query, it is a Projection. I tested this solution 3 times on Slick 2.1 :p – AlixB Nov 25 '14 at 09:16
1

Look at the date of question and date of the answer. Anyways, if I get time I will amend the question. – pedrofurla Nov 27 '14 at 14:28

multiple joins with slick

2 Answers2

Linked