fr.cnes.genius.sqlite

Class ResultReader

java.lang.Object

fr.cnes.genius.sqlite.SqliteBase

fr.cnes.genius.sqlite.ResultReader

public class ResultReader
extends SqliteBase

Class in charge of reading the stored data in SQLite format.

Author:

escc

Field Summary

Fields inherited from class fr.cnes.genius.sqlite.SqliteBase

COMMA, DEFINITION_SUFIX, DESCRIPTION, GAP_THRESHOLD, NAME, TYPE, UNIT, USER_VISIBLE

Constructor Summary

Constructors

Constructor and Description
ResultReader(File sqlFile) Constructor using the sql file.

Method Summary

Modifier and Type	Method and Description
ColumnInfo	getColumnInfoByIndex(String tableName, int columnIndex) Get the column information given the table and the index.
ColumnInfo	getColumnInfoByName(String tableName, String columnName) Get the column information given the table and the index.
List<Object>	getColumns(String tableName, ColumnInfo column) Get the columns information.
List<Object>	getColumns(String tableName, ColumnInfo column, String sortColumn) Get the columns information.
List<Object>	getColumns(String tableName1, String tableName2, ColumnInfo column, String sortColumn) Get the columns information.
List<Object>	getColumnsWithUnit(String tableName, ColumnInfo column, GUnit unit) Get the columns information converted to the given unit.
List<Object>	getColumnsWithUnit(String tableName, ColumnInfo column, GUnit unit, String sortColumnName) Get the columns information converted to the given unit.
List<Object>	getColumnsWithUnit(String tableName1, String tableName2, ColumnInfo column, GUnit unit, String sortColumn) Get the columns information converted to the given unit joining the results of 2 tables simultaneously.
int	getNumberColumns(String tableName) Get the number of columns of the table.
int	getNumberRecords(String tableName) Get the number of records in the table.
int	getNumberTables() Get the number of tables stored in the database, excluding the definition tables.
Object	getRecord(String tableName, ColumnInfo columnInfo, GUnit unit, int index) Get the record corresponding to the index from the sql table.
Object	getRecord(String tableName, ColumnInfo columnInfo, int index) Get the record corresponding to the index from the sql table.
List<String>	getTableNames() Get the number of tables stored in the database, excluding the definition tables.
List<Object[]>	getXYColumns(String tableName, ColumnInfo xColumn, ColumnInfo yColumn) Get the X and Y columns information.
List<Object[]>	getXYColumnsWithUnit(String tableName, ColumnInfo xColumn, GUnit xUnit, ColumnInfo yColumn, GUnit yUnit) Get the X and Y columns information converted to their given units.
void	setRecord(String tableName, ColumnInfo columnInfo) Set the new column corresponding to a new index from the sql table.
void	writeToMadonaFile(String tableName, File outputMadonaFile, List<String> columnNameList, List<String> headerInfoLines, String sortColumn) Write the columns in a file using the Madona format.
void	writeToMadonaFile(String tableName1, String tableName2, File outputMadonaFile, List<String> columnNameList, List<String> headerInfoLines, String sortColumn) Write the columns in a file using the Madona format.
void	writeToVTSAtt(String tableName, File outputVTSFile, List<String> columnNameList, String sortColumn) Write the selected columns to a VTS (OEM) ephemeris file.
void	writeToVTSEphem(String tableName, File outputVTSFile, List<String> columnNameList, String sortColumn) Write the selected columns to a VTS (OEM) ephemeris file.
void	writeToVTSEvents(String tableName, File outputVTSFile, List<String> columnNameList, String sortColumn) Write the selected columns to a VTS (OEM) ephemeris file.
void	writeToVTSMem(String tableName, File outputVTSFile, VTSHeaderInfo vtsHeaderInfo, List<String> columnNameList, String sortColumn) Write the selected columns to a VTS (MEM) file.

Methods inherited from class fr.cnes.genius.sqlite.SqliteBase

close, executeStatement, getPreparedStatement, getStatement, open

Methods inherited from class java.lang.Object

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

Constructor Detail

ResultReader

public ResultReader(File sqlFile)

Constructor using the sql file.

Parameters:

sqlFile - to use

Method Detail

getNumberTables

public int getNumberTables()
                    throws SqliteException

Get the number of tables stored in the database, excluding the definition tables.

Returns:

the number of tables

Throws:

SqliteException - in case of error

getTableNames

public List<String> getTableNames()
                           throws SqliteException

Get the number of tables stored in the database, excluding the definition tables.

Returns:

the number of tables

Throws:

SqliteException - in case of error

getNumberRecords

public int getNumberRecords(String tableName)
                     throws SqliteException

Get the number of records in the table.

Parameters:

tableName - name of the table

Returns:

the number of records in the table

Throws:

SqliteException - in case of error

getNumberColumns

public int getNumberColumns(String tableName)
                     throws SqliteException

Get the number of columns of the table.

Parameters:

tableName - to search

Returns:

the number of columns

Throws:

SqliteException - in case of error

getColumnInfoByIndex

public ColumnInfo getColumnInfoByIndex(String tableName,
                                       int columnIndex)
                                throws SqliteException

Get the column information given the table and the index.

Parameters:

tableName - the table name to search

columnIndex - the index of the column

Returns:

the whole column information

Throws:

SqliteException - in case of error

getColumnInfoByName

public ColumnInfo getColumnInfoByName(String tableName,
                                      String columnName)
                               throws SqliteException

Get the column information given the table and the index.

Parameters:

tableName - the table name to search

columnName - Name of the column

Returns:

the whole column information

Throws:

SqliteException - in case of error

getColumnsWithUnit

public List<Object> getColumnsWithUnit(String tableName,
                                       ColumnInfo column,
                                       GUnit unit)
                                throws SqliteException

Get the columns information converted to the given unit.

Parameters:

tableName - the table to search

column - the column definition

unit - to convert

Returns:

the list of values converted to the given unit

Throws:

SqliteException - in case of error

getColumnsWithUnit

public List<Object> getColumnsWithUnit(String tableName,
                                       ColumnInfo column,
                                       GUnit unit,
                                       String sortColumnName)
                                throws SqliteException

Get the columns information converted to the given unit.

Parameters:

tableName - the table to search

column - the column definition

unit - to convert

sortColumnName - column name used to sort.

Returns:

the list of values converted to the given unit

Throws:

SqliteException - in case of error

getColumnsWithUnit

public List<Object> getColumnsWithUnit(String tableName1,
                                       String tableName2,
                                       ColumnInfo column,
                                       GUnit unit,
                                       String sortColumn)
                                throws SqliteException

Get the columns information converted to the given unit joining the results of 2 tables simultaneously.

Parameters:

tableName1 - the first table to search

tableName2 - the first table to search

column - the column definition

unit - to convert

sortColumn - column or expression used to sort.

Returns:

the list of values converted to the given unit

Throws:

SqliteException - in case of error

getRecord

public Object getRecord(String tableName,
                        ColumnInfo columnInfo,
                        int index)
                 throws SqliteException

Get the record corresponding to the index from the sql table.

Parameters:

tableName - the table to search

columnInfo - the column definition

index - index of the requested record.

Returns:

the value converted to the given unit

Throws:

SqliteException - in case of error

getRecord

public Object getRecord(String tableName,
                        ColumnInfo columnInfo,
                        GUnit unit,
                        int index)
                 throws SqliteException

Get the record corresponding to the index from the sql table.

Parameters:

tableName - the table to search

columnInfo - the column definition

unit - to convert

index - index of the requested record.

Returns:

the value converted to the given unit

Throws:

SqliteException - in case of error

setRecord

public void setRecord(String tableName,
                      ColumnInfo columnInfo)
               throws SqliteException

Set the new column corresponding to a new index from the sql table.

Parameters:

tableName - the table to search

columnInfo - the column definition

Throws:

SqliteException - in case of error

getColumns

public List<Object> getColumns(String tableName,
                               ColumnInfo column)
                        throws SqliteException

Get the columns information.

Parameters:

tableName - the table to search

column - the column definition

Returns:

the list of values converted to the given unit

Throws:

SqliteException - in case of error

getColumns

public List<Object> getColumns(String tableName,
                               ColumnInfo column,
                               String sortColumn)
                        throws SqliteException

Get the columns information.

Parameters:

tableName - the table to search

column - the column definition

sortColumn - column or expression used to sort.

Returns:

the list of values converted to the given unit

Throws:

SqliteException - in case of error

getColumns

public List<Object> getColumns(String tableName1,
                               String tableName2,
                               ColumnInfo column,
                               String sortColumn)
                        throws SqliteException

Get the columns information.

Parameters:

tableName1 - the first table to search

tableName2 - the first table to search

column - the column definition

sortColumn - column or expression used to sort.

Returns:

the list of values converted to the given unit

Throws:

SqliteException - in case of error

getXYColumnsWithUnit

public List<Object[]> getXYColumnsWithUnit(String tableName,
                                           ColumnInfo xColumn,
                                           GUnit xUnit,
                                           ColumnInfo yColumn,
                                           GUnit yUnit)
                                    throws SqliteException

Get the X and Y columns information converted to their given units.

Parameters:

tableName - the table to search

xColumn - the X column definition

xUnit - to convert

yColumn - the Y column definition

yUnit - to convert

Returns:

the list of values converted to the given unit

Throws:

SqliteException - in case of error

getXYColumns

public List<Object[]> getXYColumns(String tableName,
                                   ColumnInfo xColumn,
                                   ColumnInfo yColumn)
                            throws SqliteException

Get the X and Y columns information.

Parameters:

tableName - the table to search

xColumn - the X column definition

yColumn - the Y column definition

Returns:

the list of values converted to the given unit

Throws:

SqliteException - in case of error

writeToMadonaFile

public void writeToMadonaFile(String tableName,
                              File outputMadonaFile,
                              List<String> columnNameList,
                              List<String> headerInfoLines,
                              String sortColumn)
                       throws SqliteException

Write the columns in a file using the Madona format.

Parameters:

tableName - the table name to write

outputMadonaFile - destination file

columnNameList - the list of columns names to write

headerInfoLines - information lines to add to the header.

sortColumn - column or expression used to sort.

Throws:

SqliteException - in case of error

writeToMadonaFile

public void writeToMadonaFile(String tableName1,
                              String tableName2,
                              File outputMadonaFile,
                              List<String> columnNameList,
                              List<String> headerInfoLines,
                              String sortColumn)
                       throws SqliteException

Write the columns in a file using the Madona format.

Parameters:

tableName1 - the first table to search

tableName2 - the first table to search

outputMadonaFile - destination file

columnNameList - the list of columns names to write

headerInfoLines - information lines to add to the header.

sortColumn - column or expression used to sort.

Throws:

SqliteException - in case of error

writeToVTSMem

public void writeToVTSMem(String tableName,
                          File outputVTSFile,
                          VTSHeaderInfo vtsHeaderInfo,
                          List<String> columnNameList,
                          String sortColumn)
                   throws SqliteException,
                          GVTSException

Write the selected columns to a VTS (MEM) file. The list of columns should correspond to DATE (1), Position EME2000 (3), Velocity EME2000(3)

Parameters:

tableName - name of the table to extract the columns.

outputVTSFile - VTS file to write the results.

vtsHeaderInfo - header of the ASCII File

columnNameList - list of the column names. The list of columns should correspond to DATE (1), Position EME2000 (3), Velocity EME2000(3)

sortColumn - column or expression used to sort.

Throws:

SqliteException - in case or problem extracting the information from the sqlite database.

GVTSException - vts exception

writeToVTSEphem

public void writeToVTSEphem(String tableName,
                            File outputVTSFile,
                            List<String> columnNameList,
                            String sortColumn)
                     throws SqliteException

Write the selected columns to a VTS (OEM) ephemeris file. The list of columns should correspond to DATE (1), Position EME2000 (3), Velocity EME2000(3)

Parameters:

tableName - name of the table to extract the columns.

outputVTSFile - VTS file to write the results.

columnNameList - list of the column names. The list of columns should correspond to DATE (1), Position EME2000 (3), Velocity EME2000(3)

sortColumn - column or expression used to sort.

Throws:

SqliteException - in case or problem extracting the information from the sqlite database.

writeToVTSAtt

public void writeToVTSAtt(String tableName,
                          File outputVTSFile,
                          List<String> columnNameList,
                          String sortColumn)
                   throws SqliteException

Write the selected columns to a VTS (OEM) ephemeris file. The list of columns should correspond to DATE (1), Position EME2000 (3), Velocity EME2000(3)

Parameters:

tableName - name of the table to extract the columns.

outputVTSFile - VTS file to write the results.

columnNameList - list of the column names. The list of columns should correspond to DATE (1), Position EME2000 (3), Velocity EME2000(3)

sortColumn - column or expression used to sort.

Throws:

SqliteException - in case or problem extracting the information from the sqlite database.

writeToVTSEvents

public void writeToVTSEvents(String tableName,
                             File outputVTSFile,
                             List<String> columnNameList,
                             String sortColumn)
                      throws SqliteException

Write the selected columns to a VTS (OEM) ephemeris file. The list of columns should correspond to DATE (1), Position EME2000 (3), Velocity EME2000(3)

Parameters:

tableName - name of the table to extract the columns.

outputVTSFile - VTS file to write the results.

columnNameList - list of the column names. The list of columns should correspond to DATE (1), Position EME2000 (3), Velocity EME2000(3)

sortColumn - column or expression used to sort.

Throws:

SqliteException - in case or problem extracting the information from the sqlite database.