public SchemaDesc getSchema(String schemaName) { for (SchemaDesc sd : schemaDescs) { if (sd.getSchemaName().equalsIgnoreCase(schemaName)) return sd; } return null; }
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; }
/** * 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; } } } }
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.getSchemaName() != null && !schemaDesc.getSchemaName().isEmpty()) sb.append(schemaDesc.getSchemaName()); sb.append(".");
+ " AS " + table.getAlias() + " vs " + sd.getSchemaName()); || (sd.getSchemaName().equalsIgnoreCase(table.getSchemaName())))
/** * @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; }
sd = new SchemaDesc(td.getSchemaName()); PutSchemaStatement pss = new PutSchemaStatement(update); log.debug("put missing schema: " + sd.getSchemaName()); pss.setSchema(sd); jdbc.update(pss);