|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object org.pentaho.di.core.database.BaseDatabaseMeta org.pentaho.di.core.database.MSAccessDatabaseMeta
public class MSAccessDatabaseMeta
Contains MySQL specific information through static final members
Field Summary |
---|
Constructor Summary | |
---|---|
MSAccessDatabaseMeta()
|
Method Summary | |
---|---|
boolean |
checkIndexExists(Database database,
String schemaName,
String tableName,
String[] idx_fields)
Verifies on the specified database connection if an index exists on the fields with the specified name. |
int[] |
getAccessTypeList()
Get the list of possible access types for a database. |
String |
getAddColumnStatement(String tablename,
ValueMetaInterface v,
String tk,
boolean use_autoinc,
String pk,
boolean semicolon)
Generates the SQL statement to add a column to the specified table |
String |
getDriverClass()
Obtain the name of the JDBC driver class that we need to use! |
String |
getDropColumnStatement(String tablename,
ValueMetaInterface v,
String tk,
boolean use_autoinc,
String pk,
boolean semicolon)
Generates the SQL statement to drop a column from the specified table |
String |
getEndQuote()
|
String |
getFieldDefinition(ValueMetaInterface v,
String tk,
String pk,
boolean use_autoinc,
boolean add_fieldname,
boolean add_cr)
Describe a Value as a field in the database. |
int |
getMaxTextFieldLength()
Get the maximum length of a text field for this database connection. |
String |
getModifyColumnStatement(String tablename,
ValueMetaInterface v,
String tk,
boolean use_autoinc,
String pk,
boolean semicolon)
Generates the SQL statement to modify a column in the specified table |
int |
getNotFoundTK(boolean use_autoinc)
Get the not found technical key. |
String[] |
getReservedWords()
|
String |
getSchemaTableCombination(String schema_name,
String table_part)
Get the schema-table combination to query the right table. |
String |
getSQLInsertAutoIncUnknownDimensionRow(String schemaTable,
String keyField,
String versionField)
Get the SQL to insert a new empty unknown record in a dimension. |
String |
getStartQuote()
|
String |
getTruncateTableStatement(String tableName)
|
String |
getURL(String hostname,
String port,
String databaseName)
|
String[] |
getUsedLibraries()
|
boolean |
isFetchSizeSupported()
Checks whether or not the command setFetchSize() is supported by the JDBC driver... |
boolean |
supportsBitmapIndex()
|
boolean |
supportsGetBlob()
|
boolean |
supportsSetCharacterStream()
See if this database supports the setCharacterStream() method on a PreparedStatement. |
boolean |
supportsSetLong()
|
boolean |
supportsSynonyms()
|
boolean |
supportsTransactions()
|
boolean |
supportsViews()
|
Methods inherited from class java.lang.Object |
---|
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
---|
public MSAccessDatabaseMeta()
Method Detail |
---|
public int[] getAccessTypeList()
DatabaseInterface
getAccessTypeList
in interface DatabaseInterface
getAccessTypeList
in class BaseDatabaseMeta
public boolean supportsSetCharacterStream()
BaseDatabaseMeta
supportsSetCharacterStream
in interface DatabaseInterface
supportsSetCharacterStream
in class BaseDatabaseMeta
public int getNotFoundTK(boolean use_autoinc)
DatabaseInterface
getNotFoundTK
in interface DatabaseInterface
getNotFoundTK
in class BaseDatabaseMeta
use_autoinc
- Whether or not we want to use an auto increment field
DatabaseInterface.getNotFoundTK(boolean)
public String getDriverClass()
DatabaseInterface
getDriverClass
in interface DatabaseInterface
public String getURL(String hostname, String port, String databaseName)
getURL
in interface DatabaseInterface
hostname
- the hostnameport
- the port as a stringdatabaseName
- the database name
public boolean isFetchSizeSupported()
isFetchSizeSupported
in interface DatabaseInterface
isFetchSizeSupported
in class BaseDatabaseMeta
public String getSchemaTableCombination(String schema_name, String table_part)
BaseDatabaseMeta
getSchemaTableCombination
in interface DatabaseInterface
getSchemaTableCombination
in class BaseDatabaseMeta
schema_name
- The schema nametable_part
- The tablename
DatabaseInterface.getSchemaTableCombination(java.lang.String, java.lang.String)
public int getMaxTextFieldLength()
getMaxTextFieldLength
in interface DatabaseInterface
getMaxTextFieldLength
in class BaseDatabaseMeta
public boolean supportsTransactions()
supportsTransactions
in interface DatabaseInterface
supportsTransactions
in class BaseDatabaseMeta
public boolean supportsBitmapIndex()
supportsBitmapIndex
in interface DatabaseInterface
supportsBitmapIndex
in class BaseDatabaseMeta
public boolean supportsSetLong()
supportsSetLong
in interface DatabaseInterface
supportsSetLong
in class BaseDatabaseMeta
public boolean supportsViews()
supportsViews
in interface DatabaseInterface
supportsViews
in class BaseDatabaseMeta
public boolean supportsSynonyms()
supportsSynonyms
in interface DatabaseInterface
supportsSynonyms
in class BaseDatabaseMeta
public String getTruncateTableStatement(String tableName)
getTruncateTableStatement
in interface DatabaseInterface
getTruncateTableStatement
in class BaseDatabaseMeta
tableName
- The table to be truncated.
public String getAddColumnStatement(String tablename, ValueMetaInterface v, String tk, boolean use_autoinc, String pk, boolean semicolon)
getAddColumnStatement
in interface DatabaseInterface
tablename
- The table to addv
- The column defined as a valuetk
- the name of the technical key fielduse_autoinc
- whether or not this field uses auto incrementpk
- the name of the primary key fieldsemicolon
- whether or not to add a semi-colon behind the statement.
public String getDropColumnStatement(String tablename, ValueMetaInterface v, String tk, boolean use_autoinc, String pk, boolean semicolon)
getDropColumnStatement
in interface DatabaseInterface
getDropColumnStatement
in class BaseDatabaseMeta
tablename
- The table to addv
- The column defined as a valuetk
- the name of the technical key fielduse_autoinc
- whether or not this field uses auto incrementpk
- the name of the primary key fieldsemicolon
- whether or not to add a semi-colon behind the statement.
public String getModifyColumnStatement(String tablename, ValueMetaInterface v, String tk, boolean use_autoinc, String pk, boolean semicolon)
getModifyColumnStatement
in interface DatabaseInterface
tablename
- The table to addv
- The column defined as a valuetk
- the name of the technical key fielduse_autoinc
- whether or not this field uses auto incrementpk
- the name of the primary key fieldsemicolon
- whether or not to add a semi-colon behind the statement.
public String getFieldDefinition(ValueMetaInterface v, String tk, String pk, boolean use_autoinc, boolean add_fieldname, boolean add_cr)
DatabaseInterface
getFieldDefinition
in interface DatabaseInterface
v
- The value to describetk
- The field that's going to be the technical keypk
- The field that's going to be the primary keyuse_autoinc
- Use autoincrement or notadd_fieldname
- Add the fieldname to the definition or notadd_cr
- Add a cariage return at the end of the definition or not.
public String[] getReservedWords()
getReservedWords
in interface DatabaseInterface
getReservedWords
in class BaseDatabaseMeta
public String getStartQuote()
getStartQuote
in interface DatabaseInterface
getStartQuote
in class BaseDatabaseMeta
public String getEndQuote()
getEndQuote
in interface DatabaseInterface
getEndQuote
in class BaseDatabaseMeta
public String[] getUsedLibraries()
getUsedLibraries
in interface DatabaseInterface
public boolean supportsGetBlob()
supportsGetBlob
in interface DatabaseInterface
supportsGetBlob
in class BaseDatabaseMeta
public boolean checkIndexExists(Database database, String schemaName, String tableName, String[] idx_fields) throws KettleDatabaseException
checkIndexExists
in interface DatabaseInterface
checkIndexExists
in class BaseDatabaseMeta
database
- a connected databaseschemaName
- tableName
- idxFields
-
KettleException
KettleDatabaseException
public String getSQLInsertAutoIncUnknownDimensionRow(String schemaTable, String keyField, String versionField)
getSQLInsertAutoIncUnknownDimensionRow
in interface DatabaseInterface
getSQLInsertAutoIncUnknownDimensionRow
in class BaseDatabaseMeta
schemaTable
- the schema-table name to insert intokeyField
- The key fieldversionField
- the version field
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |