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; }