Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- val projectName1 = None //None
- val projectName2 = Some("Optimizacija u spicu")
- val firstname1 = Some("Ana")
- val firstname2 = Some("Pera")
- val query5 = withSQL {
- select(w.result.mbr, p.result.spr, p.result.projectName)
- .from(Worker as w)
- .leftJoin(WorkProject as wp).on(w.mbr, wp.mbr)
- .leftJoin(Project as p).on(wp.spr, p.spr)
- .where(toOrConditionOpt(
- projectName1.map(sqls.eq(p.projectName, _)),
- projectName2.map(sqls.eq(p.projectName, _))))
- .or(toOrConditionOpt(
- firstname1.map(sqls.eq(w.firstname, _)),
- firstname2.map(sqls.eq(w.firstname, _))))
- }.map(rs => (rs.long(1), rs.longOpt(2), rs.stringOpt(3))).list.apply
- select w.mbr as m_on_w, p.spr as s_on_p, p.project_name as pn_on_p from worker w left join workproject wp on w.mbr = wp.mbr left join project p on wp.spr = p.spr where p.project_name = 'Optimizacija u spicu' or ( w.firstname = 'Ana' or w.firstname = 'Pera'); (0 ms)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement