public StepPartitioningMeta(Node partitioningMethodNode) throws KettleXMLException {
this();
setMethod(getMethod(XMLHandler.getTagValue(partitioningMethodNode, "method")));
partitionSchemaName = XMLHandler.getTagValue(partitioningMethodNode, "schema_name");
hasChanged = false;
if (partitioner != null) {
partitioner.loadXML(partitioningMethodNode);
}
if (methodType != PARTITIONING_METHOD_NONE && Const.isEmpty(partitionSchemaName)) {
throw new RuntimeException("bohoo!");
}
}
public static final String getMethod(String description) {
if (Const.isEmpty(description)) return methodCodes[PARTITIONING_METHOD_NONE];
for (int i = 0; i < methodDescriptions.length; i++) {
if (methodDescriptions[i].equalsIgnoreCase(description)) {
return methodCodes[i];
}
}
for (int i = 0; i < methodCodes.length; i++) {
if (methodCodes[i].equalsIgnoreCase(description)) return methodCodes[i];
}
if (StepLoader.getPartitioner(description) != null) {
return description;
}
return methodCodes[PARTITIONING_METHOD_NONE];
}
public void check(
List<CheckResultInterface> remarks,
TransMeta transMeta,
StepMeta stepinfo,
RowMetaInterface prev,
String[] input,
String[] output,
RowMetaInterface info) {
CheckResult cr;
String error_message = ""; // $NON-NLS-1$
// See if we have input streams leading to this step!
if (input.length > 0) {
cr =
new CheckResult(
CheckResult.TYPE_RESULT_OK,
Messages.getString("DynamicSQLRowMeta.CheckResult.ReceivingInfo"),
stepinfo); //$NON-NLS-1$
remarks.add(cr);
} else {
cr =
new CheckResult(
CheckResult.TYPE_RESULT_ERROR,
Messages.getString("DynamicSQLRowMeta.CheckResult.NoInputReceived"),
stepinfo); //$NON-NLS-1$
remarks.add(cr);
}
// Check for SQL field
if (Const.isEmpty(sqlfieldname)) {
cr =
new CheckResult(
CheckResult.TYPE_RESULT_ERROR,
Messages.getString("DynamicSQLRowMeta.CheckResult.SQLFieldNameMissing"),
stepinfo); //$NON-NLS-1$
remarks.add(cr);
} else {
ValueMetaInterface vfield = prev.searchValueMeta(sqlfieldname);
if (vfield == null)
cr =
new CheckResult(
CheckResult.TYPE_RESULT_ERROR,
Messages.getString("DynamicSQLRowMeta.CheckResult.SQLFieldNotFound", sqlfieldname),
stepinfo); //$NON-NLS-1$
else
cr =
new CheckResult(
CheckResult.TYPE_RESULT_OK,
Messages.getString(
"DynamicSQLRowMeta.CheckResult.SQLFieldFound",
sqlfieldname,
vfield.getOrigin()),
stepinfo);
remarks.add(cr);
}
if (databaseMeta != null) {
Database db = new Database(databaseMeta);
databases = new Database[] {db}; // Keep track of this one for cancelQuery
try {
db.connect();
if (sql != null && sql.length() != 0) {
error_message = ""; // $NON-NLS-1$
RowMetaInterface r = db.getQueryFields(sql, true);
if (r != null) {
cr =
new CheckResult(
CheckResult.TYPE_RESULT_OK,
Messages.getString("DynamicSQLRowMeta.CheckResult.QueryOK"),
stepinfo); //$NON-NLS-1$
remarks.add(cr);
} else {
error_message =
Messages.getString("DynamicSQLRowMeta.CheckResult.InvalidDBQuery"); // $NON-NLS-1$
cr = new CheckResult(CheckResult.TYPE_RESULT_ERROR, error_message, stepinfo);
remarks.add(cr);
}
}
} catch (KettleException e) {
error_message =
Messages.getString("DynamicSQLRowMeta.CheckResult.ErrorOccurred")
+ e.getMessage(); // $NON-NLS-1$
cr = new CheckResult(CheckResult.TYPE_RESULT_ERROR, error_message, stepinfo);
remarks.add(cr);
} finally {
db.disconnect();
}
} else {
error_message =
Messages.getString("DynamicSQLRowMeta.CheckResult.InvalidConnection"); // $NON-NLS-1$
cr = new CheckResult(CheckResult.TYPE_RESULT_ERROR, error_message, stepinfo);
remarks.add(cr);
}
}
public String getRequiredFilesDesc(String tt) {
if (Const.isEmpty(tt)) return RequiredFoldersDesc[0];
if (tt.equalsIgnoreCase(RequiredFoldersCode[1])) return RequiredFoldersDesc[1];
else return RequiredFoldersDesc[0];
}
public void check(
List<CheckResultInterface> remarks,
TransMeta transMeta,
StepMeta stepinfo,
RowMetaInterface prev,
String input[],
String output[],
RowMetaInterface info) {
CheckResult cr;
// See if we get input...
if (isFoldernameDynamic) {
if (input.length > 0)
cr =
new CheckResult(
CheckResultInterface.TYPE_RESULT_OK,
Messages.getString("GetSubFoldersMeta.CheckResult.InputOk"),
stepinfo);
else
cr =
new CheckResult(
CheckResultInterface.TYPE_RESULT_ERROR,
Messages.getString("GetSubFoldersMeta.CheckResult.InputErrorKo"),
stepinfo);
remarks.add(cr);
if (Const.isEmpty(dynamicFoldernameField))
cr =
new CheckResult(
CheckResultInterface.TYPE_RESULT_ERROR,
Messages.getString("GetSubFoldersMeta.CheckResult.FolderFieldnameMissing"),
stepinfo);
else
cr =
new CheckResult(
CheckResultInterface.TYPE_RESULT_OK,
Messages.getString("GetSubFoldersMeta.CheckResult.FolderFieldnameOk"),
stepinfo);
remarks.add(cr);
} else {
if (input.length > 0)
cr =
new CheckResult(
CheckResultInterface.TYPE_RESULT_ERROR,
Messages.getString("GetSubFoldersMeta.CheckResult.NoInputError"),
stepinfo);
else
cr =
new CheckResult(
CheckResultInterface.TYPE_RESULT_OK,
Messages.getString("GetSubFoldersMeta.CheckResult.NoInputOk"),
stepinfo);
remarks.add(cr);
// check specified folder names
FileInputList fileList = getFolderList(transMeta);
if (fileList.nrOfFiles() == 0) {
cr =
new CheckResult(
CheckResultInterface.TYPE_RESULT_ERROR,
Messages.getString("GetSubFoldersMeta.CheckResult.ExpectedFoldersError"),
stepinfo);
remarks.add(cr);
} else {
cr =
new CheckResult(
CheckResultInterface.TYPE_RESULT_OK,
Messages.getString(
"GetSubFoldersMeta.CheckResult.ExpectedFilesOk", "" + fileList.nrOfFiles()),
stepinfo);
remarks.add(cr);
}
}
}
