/** * Creates Lists of Tables with a common Schema name, then adds the Lists to the Schemas. * * @param schemaDescs List of Schemas. * @param tableDescs List of Tables. */ private void addTablesToSchemas(List<SchemaDesc> schemaDescs, List<TableDesc> tableDescs) { for (TableDesc tableDesc : tableDescs) { for (SchemaDesc schemaDesc : schemaDescs) { if (tableDesc.getSchemaName().equals(schemaDesc.getSchemaName())) { schemaDesc.getTableDescs().add(tableDesc); break; } } } }
public Object mapRow(ResultSet rs, int rowNum) throws SQLException { String sn = rs.getString("schema_name"); SchemaDesc schemaDesc = new SchemaDesc(sn); schemaDesc.description = rs.getString("description"); schemaDesc.utype = rs.getString("utype"); return schemaDesc; } }
public TableDesc findTable(String tableName) { for (SchemaDesc sd : schemaDescs) { TableDesc td = sd.getTable(tableName); if (td != null) return td; } return null; }
private TapSchema toTapSchema(Document doc) { TapSchema ret = new TapSchema(); Element root = doc.getRootElement(); Namespace xsi = root.getNamespace("xsi"); if ("tableset".equals(root.getName())) { // content is element-form unqualified List<Element> sels = root.getChildren("schema"); for (Element se : sels) { String sn = se.getChildTextTrim("name"); SchemaDesc sd = new SchemaDesc(sn); List<Element> tabs = se.getChildren("table"); for (Element te : tabs) { TableDesc td = TableReader.toTable(sn, te, xsi); String tn = td.getTableName(); sd.getTableDescs().add(td); } ret.getSchemaDescs().add(sd); } } return ret; } }
sd = new SchemaDesc(td.getSchemaName()); PutSchemaStatement pss = new PutSchemaStatement(update); log.debug("put missing schema: " + sd.getSchemaName()); pss.setSchema(sd); jdbc.update(pss);
public SchemaDesc getSchema(String schemaName) { for (SchemaDesc sd : schemaDescs) { if (sd.getSchemaName().equalsIgnoreCase(schemaName)) return sd; } return null; }
/** * Adds foreign keys (KeyDesc) to the from table. * * @param schemaDescs */ private void addForeignKeys(List<SchemaDesc> schemaDescs, List<KeyDesc> keyDescs) { for (KeyDesc key : keyDescs) { for (SchemaDesc sd : schemaDescs) { for (TableDesc td : sd.getTableDescs()) { if ( key.getFromTable().equals(td.getTableName())) { td.getKeyDescs().add(key); break; } } } } }
SchemaDesc tapUploadSchema = new SchemaDesc(uploadManager.getUploadSchema()); tapUploadSchema.getTableDescs().addAll(tableDescs.values()); tapSchema.getSchemaDescs().add(tapUploadSchema);
SchemaDesc getSchema(String schemaName) { // List of TAP_SCHEMA.schemas GetSchemasStatement gss = new GetSchemasStatement(schemasTableName); if (ordered) gss.setOrderBy(orderSchemaClause); JdbcTemplate jdbc = new JdbcTemplate(dataSource); List<SchemaDesc> schemaDescs = jdbc.query(gss, new SchemaMapper()); for (SchemaDesc sd : schemaDescs) { if (sd.getSchemaName().equals(schemaName)) { return sd; } } return null; }
/** * @param sd * @return */ private Element toXmlElement(SchemaDesc sd, Namespace ns) { Element eleSchema = new Element("schema", ns); Element ele; ele = new Element("name"); if (sd.getSchemaName() == null) ele.setText(DEFAULT_SCHEMA); else ele.setText(sd.getSchemaName()); eleSchema.addContent(ele); if (sd.getTableDescs() != null) for (TableDesc td : sd.getTableDescs()) { eleSchema.addContent(toXmlElement(td, Namespace.NO_NAMESPACE)); } return eleSchema; }
safeSetString(sb, ps, col++, schema.utype); safeSetInteger(sb, ps, col++, schema.schema_index); safeSetString(sb, ps, col++, schema.getSchemaName());
if (schemaDesc.getSchemaName() != null && schemaDesc.getSchemaName().equals("tap_schema")) continue; if (schemaDesc.getTableDescs() == null || schemaDesc.getTableDescs().isEmpty()) continue; for (TableDesc tableDesc : schemaDesc.getTableDescs()) if (schemaDesc.getSchemaName() != null && !schemaDesc.getSchemaName().isEmpty()) sb.append(schemaDesc.getSchemaName()); sb.append(".");
+ " AS " + table.getAlias() + " vs " + sd.getSchemaName()); || (sd.getSchemaName().equalsIgnoreCase(table.getSchemaName()))) for (TableDesc td : sd.getTableDescs())