Advertisement
Guest User

Untitled

a guest
Feb 12th, 2015
182
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Scala 0.96 KB | None | 0 0
  1.   val projectName1 = None //None
  2.   val projectName2 = Some("Optimizacija u spicu")
  3.  
  4.   val firstname1 = Some("Ana")
  5.   val firstname2 = Some("Pera")
  6.  
  7.   val query5 = withSQL {
  8.     select(w.result.mbr, p.result.spr, p.result.projectName)
  9.       .from(Worker as w)
  10.       .leftJoin(WorkProject as wp).on(w.mbr, wp.mbr)
  11.       .leftJoin(Project as p).on(wp.spr, p.spr)
  12.       .where(toOrConditionOpt(
  13.         projectName1.map(sqls.eq(p.projectName, _)),
  14.         projectName2.map(sqls.eq(p.projectName, _))))
  15.       .or(toOrConditionOpt(
  16.         firstname1.map(sqls.eq(w.firstname, _)),
  17.         firstname2.map(sqls.eq(w.firstname, _))))
  18.   }.map(rs => (rs.long(1), rs.longOpt(2), rs.stringOpt(3))).list.apply
  19.  
  20. 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