Package adams.data.conversion

Class SpreadSheetToCreateTableStatement

  • All Implemented Interfaces:
    AdditionalInformationHandler, CleanUpHandler, Destroyable, GlobalInfoSupporter, LoggingLevelHandler, LoggingSupporter, OptionHandler, QuickInfoSupporter, ShallowCopySupporter<AbstractConversion>, SizeOfHandler, Stoppable, Conversion, Serializable
    public class SpreadSheetToCreateTableStatement
extends AbstractConversion
    Turns a spreadsheet into a SQL 'CREATE TABLE' statement.
    Requires two columns: column names, SQL column types.
    An optional 3rd column can be used to indicate whether a column is to be used as an index (boolean). 

    -logging-level <OFF|SEVERE|WARNING|INFO|CONFIG|FINE|FINER|FINEST> (property: loggingLevel)
    The logging level for outputting errors and debugging output.
    default: WARNING
 
    -table-name <java.lang.String> (property: tableName)
    The name of the table.
    default: newtable
 
    -name-column <adams.data.spreadsheet.SpreadSheetColumnIndex> (property: nameColumn)
    The column in the spreadsheet that holds the name of the table columns.
    default: 1
    example: An index is a number starting with 1; column names (case-sensitive) as well as the following placeholders can be used: first, second, third, last_2, last_1, last; numeric indices can be enforced by preceding them with '#' (eg '#12'); column names can be surrounded by double quotes.
 
    -type-column <adams.data.spreadsheet.SpreadSheetColumnIndex> (property: typeColumn)
    The column in the spreadsheet that holds the SQL types for the table columns.
    default: 2
    example: An index is a number starting with 1; column names (case-sensitive) as well as the following placeholders can be used: first, second, third, last_2, last_1, last; numeric indices can be enforced by preceding them with '#' (eg '#12'); column names can be surrounded by double quotes.
 
    -index-column <adams.data.spreadsheet.SpreadSheetColumnIndex> (property: indexColumn)
    The column in the spreadsheet that indicates whether a column should be 
    an index.
    default: 3
    example: An index is a number starting with 1; column names (case-sensitive) as well as the following placeholders can be used: first, second, third, last_2, last_1, last; numeric indices can be enforced by preceding them with '#' (eg '#12'); column names can be surrounded by double quotes.
    Version:
    $Revision$
    Author:
    fracpete (fracpete at waikato dot ac dot nz)
    See Also:
    Serialized Form

    • Constructor Detail

      • SpreadSheetToCreateTableStatement

        public SpreadSheetToCreateTableStatement()

    • Method Detail

      • setTableName

        public void setTableName​(String value)
        Sets the name of the table.
        Parameters:
        value - the name

      • getTableName

        public String getTableName()
        Returns the name of the table.
        Returns:
        the name

      • tableNameTipText

        public String tableNameTipText()
        Returns the tip text for this property.
        Returns:
        tip text for this property suitable for displaying in the GUI or for listing the options.

      • setNameColumn

        public void setNameColumn​(SpreadSheetColumnIndex value)
        Sets the name column.
        Parameters:
        value - the column

      • nameColumnTipText

        public String nameColumnTipText()
        Returns the tip text for this property.
        Returns:
        tip text for this property suitable for displaying in the GUI or for listing the options.

      • setTypeColumn

        public void setTypeColumn​(SpreadSheetColumnIndex type)
        Sets the type column.
        Parameters:
        type - the column

      • typeColumnTipText

        public String typeColumnTipText()
        Returns the tip text for this property.
        Returns:
        tip text for this property suitable for displaying in the GUI or for listing the options.

      • setIndexColumn

        public void setIndexColumn​(SpreadSheetColumnIndex index)
        Sets the index column.
        Parameters:
        index - the column

      • getIndexColumn

        public SpreadSheetColumnIndex getIndexColumn()
        Returns the index column.
        Returns:
        the column

      • indexColumnTipText

        public String indexColumnTipText()
        Returns the tip text for this property.
        Returns:
        tip text for this property suitable for displaying in the GUI or for listing the options.