public void analyseImpact(
List<DatabaseImpact> impact,
TransMeta transMeta,
StepMeta stepMeta,
RowMetaInterface prev,
String[] input,
String[] output,
RowMetaInterface info)
throws KettleStepException {
RowMetaInterface out = prev.clone();
getFields(
out,
stepMeta.getName(),
new RowMetaInterface[] {
info,
},
null,
transMeta);
if (out != null) {
for (int i = 0; i < out.size(); i++) {
ValueMetaInterface outvalue = out.getValueMeta(i);
DatabaseImpact di =
new DatabaseImpact(
DatabaseImpact.TYPE_IMPACT_READ,
transMeta.getName(),
stepMeta.getName(),
databaseMeta.getDatabaseName(),
"", //$NON-NLS-1$
outvalue.getName(),
outvalue.getName(),
stepMeta.getName(),
sql,
Messages.getString("DynamicSQLRowMeta.DatabaseImpact.Title") // $NON-NLS-1$
);
impact.add(di);
}
}
}
public void getFields(
RowMetaInterface row,
String name,
RowMetaInterface[] info,
StepMeta nextStep,
VariableSpace space)
throws KettleStepException {
if (databaseMeta == null) return;
Database db = new Database(databaseMeta);
databases = new Database[] {db}; // Keep track of this one for cancelQuery
// First try without connecting to the database... (can be S L O W)
// See if it's in the cache...
RowMetaInterface add = null;
String realSQL = sql;
if (replacevars) realSQL = space.environmentSubstitute(realSQL);
try {
add = db.getQueryFields(realSQL, false);
} catch (KettleDatabaseException dbe) {
throw new KettleStepException(
Messages.getString("DynamicSQLRowMeta.Exception.UnableToDetermineQueryFields")
+ Const.CR
+ sql,
dbe); //$NON-NLS-1$
}
if (add != null) // Cache hit, just return it this...
{
for (int i = 0; i < add.size(); i++) {
ValueMetaInterface v = add.getValueMeta(i);
v.setOrigin(name);
}
row.addRowMeta(add);
} else
// No cache hit, connect to the database, do it the hard way...
try {
db.connect();
add = db.getQueryFields(realSQL, false);
for (int i = 0; i < add.size(); i++) {
ValueMetaInterface v = add.getValueMeta(i);
v.setOrigin(name);
}
row.addRowMeta(add);
db.disconnect();
} catch (KettleDatabaseException dbe) {
throw new KettleStepException(
Messages.getString("DynamicSQLRowMeta.Exception.ErrorObtainingFields"),
dbe); //$NON-NLS-1$
}
}
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 void getFields(
RowMetaInterface row,
String name,
RowMetaInterface[] info,
StepMeta nextStep,
VariableSpace space)
throws KettleStepException {
// the folderName
ValueMetaInterface folderName = new ValueMeta("folderName", ValueMeta.TYPE_STRING);
folderName.setLength(500);
folderName.setPrecision(-1);
folderName.setOrigin(name);
row.addValueMeta(folderName);
// the short folderName
ValueMetaInterface short_folderName = new ValueMeta("short_folderName", ValueMeta.TYPE_STRING);
short_folderName.setLength(500);
short_folderName.setPrecision(-1);
short_folderName.setOrigin(name);
row.addValueMeta(short_folderName);
// the path
ValueMetaInterface path = new ValueMeta("path", ValueMeta.TYPE_STRING);
path.setLength(500);
path.setPrecision(-1);
path.setOrigin(name);
row.addValueMeta(path);
// the ishidden
ValueMetaInterface ishidden = new ValueMeta("ishidden", ValueMeta.TYPE_BOOLEAN);
ishidden.setOrigin(name);
row.addValueMeta(ishidden);
// the isreadable
ValueMetaInterface isreadable = new ValueMeta("isreadable", ValueMeta.TYPE_BOOLEAN);
isreadable.setOrigin(name);
row.addValueMeta(isreadable);
// the iswriteable
ValueMetaInterface iswriteable = new ValueMeta("iswriteable", ValueMeta.TYPE_BOOLEAN);
iswriteable.setOrigin(name);
row.addValueMeta(iswriteable);
// the lastmodifiedtime
ValueMetaInterface lastmodifiedtime = new ValueMeta("lastmodifiedtime", ValueMeta.TYPE_DATE);
lastmodifiedtime.setOrigin(name);
row.addValueMeta(lastmodifiedtime);
// the uri
ValueMetaInterface uri = new ValueMeta("uri", ValueMeta.TYPE_STRING);
uri.setOrigin(name);
row.addValueMeta(uri);
// the rooturi
ValueMetaInterface rooturi = new ValueMeta("rooturi", ValueMeta.TYPE_STRING);
rooturi.setOrigin(name);
row.addValueMeta(rooturi);
// childrens
ValueMetaInterface childrens =
new ValueMeta(space.environmentSubstitute("childrens"), ValueMeta.TYPE_INTEGER);
childrens.setLength(ValueMetaInterface.DEFAULT_INTEGER_LENGTH, 0);
childrens.setOrigin(name);
row.addValueMeta(childrens);
if (includeRowNumber) {
ValueMetaInterface v =
new ValueMeta(space.environmentSubstitute(rowNumberField), ValueMeta.TYPE_INTEGER);
v.setLength(ValueMetaInterface.DEFAULT_INTEGER_LENGTH, 0);
v.setOrigin(name);
row.addValueMeta(v);
}
}