Package org.pentaho.di.core.database

Class LucidDBDatabaseMeta

java.lang.Object
org.pentaho.di.core.database.BaseDatabaseMeta
org.pentaho.di.core.database.LucidDBDatabaseMeta
All Implemented Interfaces:
Cloneable, DatabaseInterface, DatabaseInterfaceExtended
public class LucidDBDatabaseMeta extends BaseDatabaseMeta implements DatabaseInterface
Contains LucidDB specific information through static final members
Since:
24-oct-2008
Author:
Matt

  • Constructor Details

    • LucidDBDatabaseMeta

      public LucidDBDatabaseMeta()

  • Method Details

    • getAccessTypeList

      public int[] getAccessTypeList()
      Description copied from interface: DatabaseInterface
      Get the list of possible access types for a database.
      Specified by:
      getAccessTypeList in interface DatabaseInterface
      Specified by:
      getAccessTypeList in class BaseDatabaseMeta
      Returns:
      the list of possible access types for a database.

    • getDefaultDatabasePort

      public int getDefaultDatabasePort()
      Specified by:
      getDefaultDatabasePort in interface DatabaseInterface
      Overrides:
      getDefaultDatabasePort in class BaseDatabaseMeta
      Returns:
      the default database port number

    • getDriverClass

      public String getDriverClass()
      Description copied from interface: DatabaseInterface
      Obtain the name of the JDBC driver class that we need to use!
      Specified by:
      getDriverClass in interface DatabaseInterface
      Returns:
      the name of the JDBC driver class for the specific database

    • getURL

      public String getURL(String hostname, String port, String databaseName)
      Specified by:
      getURL in interface DatabaseInterface
      Parameters:
      hostname - the hostname
      port - the port as a string
      databaseName - the database name
      Returns:
      the URL to use for connecting to the database.

    • getSQLTableExists

      public String getSQLTableExists(String tablename)
      Specified by:
      getSQLTableExists in interface DatabaseInterface
      Overrides:
      getSQLTableExists in class BaseDatabaseMeta
      Parameters:
      tablename - The table to verify the existance for
      Returns:
      The SQL to execute to verify if the given table exists. If an Exception is thrown for this SQL, we don't have the table.

    • getSQLColumnExists

      public String getSQLColumnExists(String columnname, String tablename)
      Specified by:
      getSQLColumnExists in interface DatabaseInterface
      Overrides:
      getSQLColumnExists in class BaseDatabaseMeta
      Parameters:
      columnname - The column to verify the existance for
      tablename - The table to verify the existance for
      Returns:
      The SQL to execute to verify if the given table exists. If an Exception is thrown for this SQL, we don't have the column.

    • getSQLQueryColumnFields

      public String getSQLQueryColumnFields(String columnname, String tableName)

    • getAddColumnStatement

      public String getAddColumnStatement(String tablename, ValueMetaInterface v, String tk, boolean useAutoinc, String pk, boolean semicolon)
      Generates the SQL statement to add a column to the specified table
      Specified by:
      getAddColumnStatement in interface DatabaseInterface
      Parameters:
      tablename - The table to add
      v - The column defined as a value
      tk - the name of the technical key field
      useAutoinc - whether or not this field uses auto increment
      pk - the name of the primary key field
      semicolon - whether or not to add a semi-colon behind the statement.
      Returns:
      the SQL statement to add a column to the specified table

    • getModifyColumnStatement

      public String getModifyColumnStatement(String tablename, ValueMetaInterface v, String tk, boolean useAutoinc, String pk, boolean semicolon)
      Generates the SQL statement to modify a column in the specified table
      Specified by:
      getModifyColumnStatement in interface DatabaseInterface
      Parameters:
      tablename - The table to add
      v - The column defined as a value
      tk - the name of the technical key field
      useAutoinc - whether or not this field uses auto increment
      pk - the name of the primary key field
      semicolon - whether or not to add a semi-colon behind the statement.
      Returns:
      the SQL statement to modify a column in the specified table

    • getDropColumnStatement

      public String getDropColumnStatement(String tablename, ValueMetaInterface v, String tk, boolean useAutoinc, String pk, boolean semicolon)
      Generates the SQL statement to drop a column from the specified table
      Specified by:
      getDropColumnStatement in interface DatabaseInterface
      Overrides:
      getDropColumnStatement in class BaseDatabaseMeta
      Parameters:
      tablename - The table to add
      v - The column defined as a value
      tk - the name of the technical key field
      useAutoinc - whether or not this field uses auto increment
      pk - the name of the primary key field
      semicolon - whether or not to add a semi-colon behind the statement.
      Returns:
      the SQL statement to drop a column from the specified table

    • getFieldDefinition

      public String getFieldDefinition(ValueMetaInterface v, String tk, String pk, boolean useAutoinc, boolean addFieldName, boolean addCr)
      Description copied from interface: DatabaseInterface
      Describe a Value as a field in the database.
      Specified by:
      getFieldDefinition in interface DatabaseInterface
      Parameters:
      v - The value to describe
      tk - The field that's going to be the technical key
      pk - The field that's going to be the primary key
      useAutoinc - Use autoincrement or not
      addFieldName - Add the fieldname to the definition or not
      addCr - Add a cariage return at the end of the definition or not.
      Returns:
      a value described as a field in this database.

    • getReservedWords

      public String[] getReservedWords()
      Specified by:
      getReservedWords in interface DatabaseInterface
      Overrides:
      getReservedWords in class BaseDatabaseMeta
      Returns:
      an array of reserved words for the database type...

    • getUsedLibraries

      public String[] getUsedLibraries()
      Specified by:
      getUsedLibraries in interface DatabaseInterface
      Returns:
      the required libraries (in lib) for this database connection.

    • getExtraOptionsHelpText

      public String getExtraOptionsHelpText()
      Specified by:
      getExtraOptionsHelpText in interface DatabaseInterface
      Overrides:
      getExtraOptionsHelpText in class BaseDatabaseMeta
      Returns:
      extra help text on the supported options on the selected database platform.

    • useSchemaNameForTableList

      public boolean useSchemaNameForTableList()
      Specified by:
      useSchemaNameForTableList in interface DatabaseInterface
      Overrides:
      useSchemaNameForTableList in class BaseDatabaseMeta
      Returns:
      true if we need to supply the schema-name to getTables in order to get a correct list of items.

    • requiresCastToVariousForIsNull

      public boolean requiresCastToVariousForIsNull()
      Specified by:
      requiresCastToVariousForIsNull in interface DatabaseInterface
      Overrides:
      requiresCastToVariousForIsNull in class BaseDatabaseMeta
      Returns:
      true if the database requires you to cast a parameter to varchar before comparing to null. Only required for DB2 and Vertica