src/Pure/General/sql.scala
changeset 77346 cf2ef4be3630
parent 77039 2f09dc0e6dda
child 77348 885842575e2a
equal deleted inserted replaced
77345:a9decfa36e30 77346:cf2ef4be3630
    53 
    53 
    54   val join_outer: Source = " LEFT OUTER JOIN "
    54   val join_outer: Source = " LEFT OUTER JOIN "
    55   val join_inner: Source = " INNER JOIN "
    55   val join_inner: Source = " INNER JOIN "
    56   def join(outer: Boolean): Source = if (outer) join_outer else join_inner
    56   def join(outer: Boolean): Source = if (outer) join_outer else join_inner
    57 
    57 
    58   def member(x: Source, set: Iterable[String]): Source =
    58   def member(x: Source, set: Iterable[String]): Source = {
       
    59     require(set.nonEmpty)
    59     set.iterator.map(a => x + " = " + SQL.string(a)).mkString("(", " OR ", ")")
    60     set.iterator.map(a => x + " = " + SQL.string(a)).mkString("(", " OR ", ")")
       
    61   }
       
    62 
       
    63   def where_member(x: Source, set: Iterable[String]): Source = " WHERE " + member(x, set)
    60 
    64 
    61 
    65 
    62   /* types */
    66   /* types */
    63 
    67 
    64   object Type extends Enumeration {
    68   object Type extends Enumeration {