Package app.babylon.table

Class Tables

java.lang.Object

app.babylon.table.Tables

public class Tables
extends Object

Constructor Summary

Constructors

Constructor	Description
Tables()

Method Summary

Modifier and Type	Method	Description
static TableColumnar	concat(TableName tableName, TableDescription tableDescription, TableColumnar... tables)
static TableColumnar	concat(TableName tableName, TableDescription tableDescription, Collection<TableColumnar> tables)
static TableColumnar	fromResultSet(TableName tableName, TableDescription tableDescription, ResultSet resultSet)	Reads a caller-owned ResultSet directly into a TableColumnar using JDBC metadata to choose column types.
static TableColumnar	fromResultSet(TableName tableName, ResultSet resultSet)	Reads a caller-owned ResultSet directly into a TableColumnar using JDBC metadata to choose column types.
static TableColumnar	leftOuterJoin(TableColumnar left, TableColumnar right, ColumnName[] leftKeys, ColumnName[] rightKeys, ColumnName... rightColumnsToAdd)
static TableColumnar	leftOuterJoin(TableColumnar left, TableColumnar right, ColumnName leftKey, ColumnName rightKey, ColumnName... rightColumnsToAdd)
static TableColumnar	newTable(TableName tableName, Column... columns)
static TableColumnar	newTable(TableName tableName, Column.Builder... columnBuilders)
static TableColumnar	newTable(TableName tableName, TableDescription description, Column... columns)
static TableColumnar	newTable(TableName tableName, TableDescription desc, Column[] firstColumns, Column[] lastColumns)
static TableColumnar	newTable(TableName tableName, TableDescription description, Column.Builder... columnBuilders)
static TableColumnar	newTable(TableName tableName, TableDescription description, Collection<Column> columns)
static TableColumnar	newTable(TableName tableName, Collection<Column> columns)
static TableColumnar	newTableView(TableName viewTableName, TableColumnar table, ViewIndex rowIndex)
static TableColumnar	newTableView(TableName viewTableName, TableDescription viewTableDescription, TableColumnar table, ViewIndex rowIndex)
static TableColumnar	removeDuplicates(TableColumnar table, ColumnName... indexColumns)
static TableColumnar	select(TableColumnar table, Selection selection)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

Tables

public Tables()

Method Details

fromResultSet

public static TableColumnar fromResultSet(TableName tableName,
 ResultSet resultSet)

Reads a caller-owned ResultSet directly into a TableColumnar using JDBC metadata to choose column types.

This direct path supports the common metadata-driven types:

- integer-like JDBC types to ColumnTypes.INT

- bigint to ColumnTypes.LONG

- floating-point types to ColumnTypes.DOUBLE

- decimal/numeric to ColumnTypes.DECIMAL

- everything else to ColumnTypes.STRING

The supplied ResultSet remains caller-owned and is not closed by this method.

Parameters:

tableName - the resulting table name

resultSet - the caller-owned result set to read

Returns:

a materialised columnar table

fromResultSet

public static TableColumnar fromResultSet(TableName tableName,
 TableDescription tableDescription,
 ResultSet resultSet)

Reads a caller-owned ResultSet directly into a TableColumnar using JDBC metadata to choose column types.

The supplied ResultSet remains caller-owned and is not closed by this method.

Parameters:

tableName - the resulting table name

tableDescription - the resulting table description

resultSet - the caller-owned result set to read

Returns:

a materialised columnar table

removeDuplicates

public static TableColumnar removeDuplicates(TableColumnar table,
 ColumnName... indexColumns)

concat

public static TableColumnar concat(TableName tableName,
 TableDescription tableDescription,
 TableColumnar... tables)

concat

public static TableColumnar concat(TableName tableName,
 TableDescription tableDescription,
 Collection<TableColumnar> tables)

select

public static TableColumnar select(TableColumnar table,
 Selection selection)

leftOuterJoin

public static TableColumnar leftOuterJoin(TableColumnar left,
 TableColumnar right,
 ColumnName leftKey,
 ColumnName rightKey,
 ColumnName... rightColumnsToAdd)

leftOuterJoin

public static TableColumnar leftOuterJoin(TableColumnar left,
 TableColumnar right,
 ColumnName[] leftKeys,
 ColumnName[] rightKeys,
 ColumnName... rightColumnsToAdd)

newTable

public static TableColumnar newTable(TableName tableName,
 TableDescription desc,
 Column[] firstColumns,
 Column[] lastColumns)

newTable

public static TableColumnar newTable(TableName tableName,
 TableDescription description,
 Column.Builder... columnBuilders)

newTable

public static TableColumnar newTable(TableName tableName,
 TableDescription description,
 Column... columns)

newTable

public static TableColumnar newTable(TableName tableName,
 Column... columns)

newTable

public static TableColumnar newTable(TableName tableName,
 Column.Builder... columnBuilders)

newTable

public static TableColumnar newTable(TableName tableName,
 Collection<Column> columns)

newTable

public static TableColumnar newTable(TableName tableName,
 TableDescription description,
 Collection<Column> columns)

newTableView

public static TableColumnar newTableView(TableName viewTableName,
 TableColumnar table,
 ViewIndex rowIndex)

newTableView

public static TableColumnar newTableView(TableName viewTableName,
 TableDescription viewTableDescription,
 TableColumnar table,
 ViewIndex rowIndex)