Packages

object RelationSQL extends Serializable

The RelationSQL companion object provides factory methods for creating RelationSQL object.

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

Value Members

  1. def apply(relName: String): RelationSQL

    Create a SQL-relation from a saved relation.

    Create a SQL-relation from a saved relation.

    relName

    the name of the relation

  2. def apply(name: String, colName: Seq[String], row: Seq[Row], key: Int, domain: String, fKeys: Seq[(String, String, Int)]): RelationSQL

    Create a SQL-relation from a sequence of row/tuples.

    Create a SQL-relation from a sequence of row/tuples. These rows must be converted to columns.

    name

    the name of the relation

    colName

    the names of columns

    row

    the sequence of rows to be converted to columns for 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)

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

    Create a SQL-relation object.

    Create a SQL-relation object.

    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)

  4. def from(relNames: String*): (RelationSQL, RelationSQL)

    Create a SQL-relation from a saved relation.

    Create a SQL-relation from a saved relation. FIX - should handle other than 2 relations

    relNames

    the names of the relations