private Query getSelectWithKeyQuery(
List<String> param,
String tablePrimaryKey,
String queryId,
String tableName,
DataService dataServiceObject,
DatabaseMetaData metaData,
String dbName,
String schema,
String colomNames)
throws IllegalArgumentException, DataServiceFault, SQLException {
DynamicSqlUtils sqlStatement = new DynamicSqlUtils();
String query = sqlStatement.getSelectByKey(tableName, schema, tablePrimaryKey, colomNames);
Result result = this.getResult(dataServiceObject, metaData, dbName, schema, tableName);
Map<String, String> advanceProp = new HashMap<String, String>();
return new SQLQuery(
dataServiceObject,
queryId,
DBConstants.DataServiceGenerator.CONFIG_ID,
false,
null,
query,
this.getQueryParamList(metaData, dbName, schema, tableName, param),
result,
null,
null,
advanceProp,
null);
}
private SQLQuery getInsertQuery(
List<String> param,
String queryId,
String tableName,
DataService dataServiceObject,
DatabaseMetaData metaData,
String dbName,
String schema)
throws IllegalArgumentException, DataServiceFault, SQLException {
/* get the query */
DynamicSqlUtils sqlStatementCreator = new DynamicSqlUtils();
String query = sqlStatementCreator.getInsertStatement(tableName, schema, param);
Result result = null;
Map<String, String> advanceProp = new HashMap<String, String>();
return new SQLQuery(
dataServiceObject,
queryId,
DBConstants.DataServiceGenerator.CONFIG_ID,
false,
null,
query,
this.getQueryParamList(metaData, dbName, schema, tableName, param),
result,
null,
null,
advanceProp,
null);
}