omero.gateway.facility

Class TablesFacility

java.lang.Object

omero.gateway.facility.Facility

omero.gateway.facility.TablesFacility

public class TablesFacility
extends Facility

Facility to interact with OMERO.tables

Author:

Dominik Lindner d.lindner@dundee.ac.uk

Field Summary

Fields

Modifier and Type	Field and Description
static int	DEFAULT_MAX_ROWS_TO_FETCH Maximum number of rows to fetch if not specified otherwise
static String	TABLES_MIMETYPE The mimetype of an omero tables file

Method Summary

Modifier and Type	Method and Description
TableData	addTable(SecurityContext ctx, DataObject target, String name, TableData data) Adds a new table with the provided data
Collection<FileAnnotationData>	getAvailableTables(SecurityContext ctx, DataObject parent) Get all available tables for a the specified object
TableData	getTable(SecurityContext ctx, long fileId) Load the data from a table (Note: limited to DEFAULT_MAX_ROWS_TO_FETCH number of rows)
TableData	getTable(SecurityContext ctx, long fileId, List<Long> rows) Load data from a table
TableData	getTable(SecurityContext ctx, long fileId, long... rows) Load data from a table
TableData	getTable(SecurityContext ctx, long fileId, long rowFrom, long rowTo, int... columns) Load data from a table
TableData	getTable(SecurityContext ctx, long fileId, long rowFrom, long rowTo, long... columns) Load data from a table
TableData	getTableInfo(SecurityContext ctx, long fileId) Get basic information about a table.
long[]	query(SecurityContext ctx, long fileId, String condition) Perform a query on the table
long[]	query(SecurityContext ctx, long fileId, String condition, long start, long stop, long step) Perform a query on the table

Methods inherited from class omero.gateway.facility.Facility

addPropertyChangeListener, clear, firePropertyChanged, firePropertyChanged, getFacility, logDebug, logError, logInfo, logWarn, removePropertyChangeListener

Methods inherited from class java.lang.Object

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

Field Detail

TABLES_MIMETYPE

public static final String TABLES_MIMETYPE

The mimetype of an omero tables file

See Also:

Constant Field Values

DEFAULT_MAX_ROWS_TO_FETCH

public static final int DEFAULT_MAX_ROWS_TO_FETCH

Maximum number of rows to fetch if not specified otherwise

See Also:

Constant Field Values

Method Detail

addTable

public TableData addTable(SecurityContext ctx,
                          DataObject target,
                          String name,
                          TableData data)
                   throws DSOutOfServiceException,
                          DSAccessException

Adds a new table with the provided data

Parameters:

ctx - The SecurityContext

target - The object to attach the table to

name - A name for the table (can be null)

data - The data

Returns:

The TableData

Throws:

DSOutOfServiceException - If the connection is broken, or not logged in

DSAccessException - If an error occurred while trying to retrieve data from OMERO service.

getTableInfo

public TableData getTableInfo(SecurityContext ctx,
                              long fileId)
                       throws DSOutOfServiceException,
                              DSAccessException

Get basic information about a table.

Parameters:

ctx - The SecurityContext

fileId - The id of the OriginalFile which stores the table

Returns:

An 'empty' TableData object without the actual table data loaded; which only contains information about the columns and the size of the table.

Throws:

DSOutOfServiceException - If the connection is broken, or not logged in

DSAccessException - If an error occurred while trying to retrieve data from OMERO service.

getTable

public TableData getTable(SecurityContext ctx,
                          long fileId)
                   throws DSOutOfServiceException,
                          DSAccessException

Load the data from a table (Note: limited to DEFAULT_MAX_ROWS_TO_FETCH number of rows)

Parameters:

ctx - The SecurityContext

fileId - The id of the OriginalFile which stores the table

Returns:

The data which the table contains

Throws:

DSOutOfServiceException - If the connection is broken, or not logged in

DSAccessException - If an error occurred while trying to retrieve data from OMERO service.

getTable

public TableData getTable(SecurityContext ctx,
                          long fileId,
                          long rowFrom,
                          long rowTo,
                          int... columns)
                   throws DSOutOfServiceException,
                          DSAccessException

Load data from a table

Parameters:

ctx - The SecurityContext

fileId - The id of the OriginalFile which stores the table

rowFrom - The start row (inclusive)

rowTo - The end row (inclusive) (can be -1 in which case DEFAULT_MAX_ROWS_TO_FETCH rows will be fetched)

columns - The columns to take into account (can be left unspecified, in which case all columns will used)

Returns:

The specified data

Throws:

DSOutOfServiceException - If the connection is broken, or not logged in

DSAccessException - If an error occurred while trying to retrieve data from OMERO service.

query

public long[] query(SecurityContext ctx,
                    long fileId,
                    String condition)
             throws DSOutOfServiceException,
                    DSAccessException

Perform a query on the table

Parameters:

ctx - The SecurityContext

fileId - The id of the OriginalFile which stores the table

condition - The query string

Returns:

A list of row indices matching the condition

Throws:

DSOutOfServiceException - If the connection is broken, or not logged in

DSAccessException - If an error occurred while trying to retrieve data from OMERO service.

query

public long[] query(SecurityContext ctx,
                    long fileId,
                    String condition,
                    long start,
                    long stop,
                    long step)
             throws DSOutOfServiceException,
                    DSAccessException

Perform a query on the table

Parameters:

ctx - The SecurityContext

fileId - The id of the OriginalFile which stores the table

condition - The query string

start - The index of the first row to consider (optional, default: 0)

stop - The index of the last+1 row to consider (optional, default: number of rows of the table)

step - The stepping interval between the start and stop rows to consider (optional, default: no stepping)

Returns:

A list of row indices matching the condition

Throws:

DSOutOfServiceException - If the connection is broken, or not logged in

DSAccessException - If an error occurred while trying to retrieve data from OMERO service.

getTable

public TableData getTable(SecurityContext ctx,
                          long fileId,
                          List<Long> rows)
                   throws DSOutOfServiceException,
                          DSAccessException

Load data from a table

Parameters:

ctx - The SecurityContext

fileId - The id of the OriginalFile which stores the table

rows - The rows to get

Returns:

The specified data

Throws:

DSOutOfServiceException - If the connection is broken, or not logged in

DSAccessException - If an error occurred while trying to retrieve data from OMERO service.

getTable

public TableData getTable(SecurityContext ctx,
                          long fileId,
                          long... rows)
                   throws DSOutOfServiceException,
                          DSAccessException

Load data from a table

Parameters:

ctx - The SecurityContext

fileId - The id of the OriginalFile which stores the table

rows - The rows to get

Returns:

The specified data

Throws:

DSOutOfServiceException - If the connection is broken, or not logged in

DSAccessException - If an error occurred while trying to retrieve data from OMERO service.

getTable

public TableData getTable(SecurityContext ctx,
                          long fileId,
                          long rowFrom,
                          long rowTo,
                          long... columns)
                   throws DSOutOfServiceException,
                          DSAccessException

Load data from a table

Parameters:

ctx - The SecurityContext

fileId - The id of the OriginalFile which stores the table

rowFrom - The start row (inclusive)

rowTo - The end row (inclusive) (can be -1 in which case DEFAULT_MAX_ROWS_TO_FETCH rows will be fetched)

columns - The columns to take into account (can be left unspecified, in which case all columns will used)

Returns:

The specified data

Throws:

DSOutOfServiceException - If the connection is broken, or not logged in

DSAccessException - If an error occurred while trying to retrieve data from OMERO service.

getAvailableTables

public Collection<FileAnnotationData> getAvailableTables(SecurityContext ctx,
                                                         DataObject parent)
                                                  throws DSOutOfServiceException,
                                                         DSAccessException

Get all available tables for a the specified object

Parameters:

ctx - The SecurityContext

parent - The DataObject

Returns:

See above

Throws:

DSOutOfServiceException - If the connection is broken, or not logged in

DSAccessException - If an error occurred while trying to retrieve data from OMERO service.