alvinalexander.com | career | drupal | java | mac | mysql | perl | scala | uml | unix  

Scala example source code file (JoinType.scala)

This example Scala source code file (JoinType.scala) is included in the DevDaily.com "Java Source Code Warehouse" project. The intent of this project is to help you "Learn Java by Example" TM.

Java - Scala tags/keywords

full, inner, join, join, jointype, jointype, left, left, outer, outer, right, string

The Scala JoinType.scala source code

/*                     __                                               *\
**     ________ ___   / /  ___     Scala API                            **
**    / __/ __// _ | / /  / _ |    (c) 2003-2011, LAMP/EPFL             **
**  __\ \/ /__/ __ |/ /__/ __ |    http://scala-lang.org/               **
** /____/\___/_/ |_/____/_/ | |                                         **
**                          |/                                          **
\*                                                                      */



package scala.dbc
package statement


/** A join behaviour in a <code>Jointure. */
@deprecated(DbcIsDeprecated, "2.9.0") abstract class JoinType {
  /** A SQL-99 string representation of the join behaviour. */
  def sqlString: String
}

@deprecated(DbcIsDeprecated, "2.9.0") object JoinType {

  /** A join behaviour where a joined tuple is created only when a
   *  corresponding tuple exists in both original relations.
   */
  case object Inner extends JoinType {
    val sqlString = "INNER JOIN"
  }

  /** A join behaviour family where a joined tuple is created even when a
   *  tuple has no corresponding tuple in the other relation. The fields
   *  populated by values of the other tuple will receive the NULL value.
   */
  abstract class Outer extends JoinType

  object Outer {
    /** An outer join behaviour where there will be at least on tuple for
     *  every tuple in the left relation.
     */
    case object Left extends Outer {
      val sqlString = "LEFT OUTER JOIN"
    }
    /** An outer join behaviour where there will be at least on tuple for
     *  every tuple in the right relation.
     */
    case object Right extends Outer {
      val sqlString = "RIGHT OUTER JOIN"
    }
    /** An outer join behaviour where there will be at least on tuple for
     *  every tuple in both right and left relations.
     */
    case object Full extends Outer {
      val sqlString = "FULL OUTER JOIN"
    }
  }
}

Other Scala examples (source code examples)

Here is a short list of links related to this Scala JoinType.scala source code file:

... this post is sponsored by my books ...

#1 New Release!

FP Best Seller

 

new blog posts

 

Copyright 1998-2021 Alvin Alexander, alvinalexander.com
All Rights Reserved.

A percentage of advertising revenue from
pages under the /java/jwarehouse URI on this website is
paid back to open source projects.