Search in sources :

Example 66 with ValueMetaInterface

use of org.pentaho.di.core.row.ValueMetaInterface in project pentaho-kettle by pentaho.

the class Props method convertArguments.

public static final String[] convertArguments(RowMetaAndData row) {
    String[] args = new String[10];
    for (int i = 0; i < row.size(); i++) {
        ValueMetaInterface valueMeta = row.getValueMeta(i);
        int argNr = getArgumentNumber(valueMeta);
        if (argNr >= 0 && argNr < 10) {
            try {
                args[argNr] = row.getString(i, "");
            } catch (KettleValueException e) {
                // Should never happen
                args[argNr] = "";
            }
        }
    }
    return args;
}
Also used : KettleValueException(org.pentaho.di.core.exception.KettleValueException) ValueMetaInterface(org.pentaho.di.core.row.ValueMetaInterface)

Example 67 with ValueMetaInterface

use of org.pentaho.di.core.row.ValueMetaInterface in project pentaho-kettle by pentaho.

the class ValueMetaBaseTest method testMetdataPreviewSqlBitToPentahoBoolean.

@Test
public void testMetdataPreviewSqlBitToPentahoBoolean() throws SQLException, KettleDatabaseException {
    doReturn(Types.BIT).when(resultSet).getInt("DATA_TYPE");
    ValueMetaInterface valueMeta = valueMetaBase.getMetadataPreview(dbMetaMock, resultSet);
    assertTrue(valueMeta.isBoolean());
}
Also used : ValueMetaInterface(org.pentaho.di.core.row.ValueMetaInterface) Test(org.junit.Test)

Example 68 with ValueMetaInterface

use of org.pentaho.di.core.row.ValueMetaInterface in project pentaho-kettle by pentaho.

the class ValueMetaBaseTest method testMetdataPreviewSqlVarcharToPentahoString.

@Test
public void testMetdataPreviewSqlVarcharToPentahoString() throws SQLException, KettleDatabaseException {
    doReturn(Types.VARCHAR).when(resultSet).getInt("DATA_TYPE");
    ValueMetaInterface valueMeta = valueMetaBase.getMetadataPreview(dbMetaMock, resultSet);
    assertTrue(valueMeta.isString());
}
Also used : ValueMetaInterface(org.pentaho.di.core.row.ValueMetaInterface) Test(org.junit.Test)

Example 69 with ValueMetaInterface

use of org.pentaho.di.core.row.ValueMetaInterface in project pentaho-kettle by pentaho.

the class ValueMetaBaseTest method testMetdataPreviewUnsupportedSqlTimestamp.

@Test
public void testMetdataPreviewUnsupportedSqlTimestamp() throws SQLException, KettleDatabaseException {
    doReturn(Types.TIMESTAMP).when(resultSet).getInt("DATA_TYPE");
    doReturn(mock(Object.class)).when(resultSet).getObject("DECIMAL_DIGITS");
    doReturn(19).when(resultSet).getInt("DECIMAL_DIGITS");
    doReturn(false).when(dbMetaMock).supportsTimestampDataType();
    ValueMetaInterface valueMeta = valueMetaBase.getMetadataPreview(dbMetaMock, resultSet);
    assertTrue(!valueMeta.isDate());
}
Also used : LoggingObject(org.pentaho.di.core.logging.LoggingObject) ValueMetaInterface(org.pentaho.di.core.row.ValueMetaInterface) Test(org.junit.Test)

Example 70 with ValueMetaInterface

use of org.pentaho.di.core.row.ValueMetaInterface in project pentaho-kettle by pentaho.

the class ValueMetaBaseTest method testMetdataPreviewSqlBinaryToPentahoBinary.

@Test
public void testMetdataPreviewSqlBinaryToPentahoBinary() throws SQLException, KettleDatabaseException {
    doReturn(Types.BINARY).when(resultSet).getInt("DATA_TYPE");
    doReturn(mock(PostgreSQLDatabaseMeta.class)).when(dbMetaMock).getDatabaseInterface();
    ValueMetaInterface valueMeta = valueMetaBase.getMetadataPreview(dbMetaMock, resultSet);
    assertTrue(valueMeta.isBinary());
}
Also used : PostgreSQLDatabaseMeta(org.pentaho.di.core.database.PostgreSQLDatabaseMeta) ValueMetaInterface(org.pentaho.di.core.row.ValueMetaInterface) Test(org.junit.Test)

Aggregations

ValueMetaInterface (org.pentaho.di.core.row.ValueMetaInterface)908 RowMetaInterface (org.pentaho.di.core.row.RowMetaInterface)345 KettleException (org.pentaho.di.core.exception.KettleException)269 ValueMetaString (org.pentaho.di.core.row.value.ValueMetaString)243 RowMeta (org.pentaho.di.core.row.RowMeta)232 Test (org.junit.Test)212 ValueMetaInteger (org.pentaho.di.core.row.value.ValueMetaInteger)146 KettleStepException (org.pentaho.di.core.exception.KettleStepException)120 ArrayList (java.util.ArrayList)111 TableItem (org.eclipse.swt.widgets.TableItem)78 ErrorDialog (org.pentaho.di.ui.core.dialog.ErrorDialog)76 KettleValueException (org.pentaho.di.core.exception.KettleValueException)58 FileObject (org.apache.commons.vfs2.FileObject)55 Date (java.util.Date)49 ValueMetaBoolean (org.pentaho.di.core.row.value.ValueMetaBoolean)48 StepMeta (org.pentaho.di.trans.step.StepMeta)47 Database (org.pentaho.di.core.database.Database)46 KettleXMLException (org.pentaho.di.core.exception.KettleXMLException)46 ValueMetaDate (org.pentaho.di.core.row.value.ValueMetaDate)44 TableItemInsertListener (org.pentaho.di.ui.trans.step.TableItemInsertListener)43