public TargetSchema(final SourceSchema schema, JdbcLinkObject conObject) {
this.sourceSchema = schema;
Log.debug("Creating JDBC schema");
// Remember the settings.
this.conObj = conObject;
if (conObject != null) {
Log.debug("Creating schema " + conObject.getDatabaseName());
this.setKeyGuessing(conObject.isKeyGuessing());
this.setDataLinkSchema(conObject.getSchemaName());
this.setDataLinkDatabase(conObject.getDatabaseName());
}
}
/**
* hardcoded for icgc update command line
*
* @param conObj
* @return
* @throws MartBuilderException
*/
public List<String> getMainTables(JdbcLinkObject conObj) throws MartBuilderException {
StringBuffer sb =
new StringBuffer(
"select table_name,column_name,column_key "
+ "from information_schema.columns where table_schema='"
+ conObj.getSchemaName()
+ "' and "
+ "table_name like '%__main' order by table_name");
List<Map<String, String>> resultSet = ConnectionPool.Instance.query(conObj, sb.toString());
Set<String> tmp = new HashSet<String>();
for (Map<String, String> map : resultSet) {
String mainTableName = (String) map.get("table_name");
String tmpMartName = mainTableName.split("__")[0];
tmp.add(tmpMartName);
}
List<String> result = new ArrayList<String>(tmp);
return result;
}
