class RelationSQL extends Tabular with Serializable

The RelationSQL class provides an SQL-like API to data stored internally in a Relation object.

Linear Supertypes
Serializable, Serializable, Tabular, AnyRef, Any
Ordering
  1. Alphabetic
  2. By Inheritance
Inherited
  1. RelationSQL
  2. Serializable
  3. Serializable
  4. Tabular
  5. AnyRef
  6. Any
  1. Hide All
  2. Show All
Visibility
  1. Public
  2. All

Instance Constructors

  1. new RelationSQL(r: Relation)

    Construct a new RelationSQL object from an existing relation 'r'.

    Construct a new RelationSQL object from an existing relation 'r'.

    r

    the existing relation

  2. new RelationSQL(name: String, colName: Seq[String], col: Vector[Vec], key: Int = 0, domain: String = null, fKeys: Seq[(String, String, Int)] = null)

    name

    the name of the relation

    colName

    the names of columns

    col

    the Scala Vector of columns making up the columnar relation

    key

    the column number for the primary key (< 0 => no primary key)

    domain

    an optional string indicating domains for columns (e.g., 'SD' = 'StrNum', 'Double')

    fKeys

    an optional sequence of foreign keys - Seq (column name, ref table name, ref column position)

Value Members

  1. final def !=(arg0: Any): Boolean
    Definition Classes
    AnyRef → Any
  2. final def ##(): Int
    Definition Classes
    AnyRef → Any
  3. final def ==(arg0: Any): Boolean
    Definition Classes
    AnyRef → Any
  4. final def asInstanceOf[T0]: T0
    Definition Classes
    Any
  5. def clone(): AnyRef
    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @native() @throws( ... )
  6. final def eq(arg0: AnyRef): Boolean
    Definition Classes
    AnyRef
  7. def equals(arg0: Any): Boolean
    Definition Classes
    AnyRef → Any
  8. def finalize(): Unit
    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( classOf[java.lang.Throwable] )
  9. final def getClass(): Class[_]
    Definition Classes
    AnyRef → Any
    Annotations
    @native()
  10. def groupBy(cName: String*): RelationSQL

    Group 'this' relation by the specified column names, returning 'this' relation.

    Group 'this' relation by the specified column names, returning 'this' relation.

    cName

    the group column names

  11. def hashCode(): Int
    Definition Classes
    AnyRef → Any
    Annotations
    @native()
  12. def intersect(r2: RelationSQL): RelationSQL

    Intersect 'this' relation and 'r2'.

    Intersect 'this' relation and 'r2'. Check that the two relations are compatible. Use index to finish intersect operation.

    r2

    the other relation

  13. final def isInstanceOf[T0]: Boolean
    Definition Classes
    Any
  14. def join(r2: RelationSQL): RelationSQL

    Join 'this' relation and 'r2' by performing a "natural-join".

    Join 'this' relation and 'r2' by performing a "natural-join".

    r2

    the other relation

  15. def minus(r2: RelationSQL): RelationSQL

    Take the difference of 'this' relation and 'r2' ('this - r2').

    Take the difference of 'this' relation and 'r2' ('this - r2'). Check that the two relations are compatible.

    r2

    the other relation

  16. final def ne(arg0: AnyRef): Boolean
    Definition Classes
    AnyRef
  17. final def notify(): Unit
    Definition Classes
    AnyRef
    Annotations
    @native()
  18. final def notifyAll(): Unit
    Definition Classes
    AnyRef
    Annotations
    @native()
  19. def orderBy(cName: String*): RelationSQL

    Order (ascending) the rows in the relation by the selected columns '_cName'.

    Order (ascending) the rows in the relation by the selected columns '_cName'. A stable sorting is used to allow sorting on multiple columns.

    cName

    the column names that are to be sorted

  20. def repr: Relation

    Return the internal representation.

  21. def reverseOrderBy(cName: String*): RelationSQL

    Order (descending) the rows in the relation by the selected columns '_cName'.

    Order (descending) the rows in the relation by the selected columns '_cName'. A stable sorting is used to allow sorting on multiple columns.

    cName

    the column names that are to be sorted

  22. def save(): Unit

    Save 'this' relation in a file using serialization.

  23. def select(cName: String*): RelationSQL

    Select the attributes to return in the answer to the query.

    Select the attributes to return in the answer to the query.

    cName

    the attribute names

  24. def show(limit: Int = Int.MaxValue): Unit

    Show 'this' relation row by row.

    Show 'this' relation row by row.

    limit

    the limit on the number of rows to display

    Definition Classes
    RelationSQL → Tabular
  25. final def synchronized[T0](arg0: ⇒ T0): T0
    Definition Classes
    AnyRef
  26. def toString(): String
    Definition Classes
    AnyRef → Any
  27. def union(r2: RelationSQL): RelationSQL

    Union 'this' relation and 'r2'.

    Union 'this' relation and 'r2'. Check that the two relations are compatible. If they are not, return the first 'this' relation.

    r2

    the other relation

  28. final def wait(): Unit
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  29. final def wait(arg0: Long, arg1: Int): Unit
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  30. final def wait(arg0: Long): Unit
    Definition Classes
    AnyRef
    Annotations
    @native() @throws( ... )
  31. def where[T](p: Predicate[T]*)(implicit arg0: ClassTag[T]): RelationSQL

    The where function filters on predicates (logic is and), returning the relation satisfying the predicates (column compare with constant)

    The where function filters on predicates (logic is and), returning the relation satisfying the predicates (column compare with constant)

    T

    the predicate type

    p

    tuple(1): column name, tuple(2): predicate (T => Boolean)

Inherited from Serializable

Inherited from Serializable

Inherited from Tabular

Inherited from AnyRef

Inherited from Any

Ungrouped