org.apache.ignite.schema.parser.DatabaseMetadataParser Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of ignite-schema-import Show documentation
Show all versions of ignite-schema-import Show documentation
Java-based middleware for in-memory processing of big data in a distributed environment.
/*
* Licensed to the Apache Software Foundation (ASF) under one or more
* contributor license agreements. See the NOTICE file distributed with
* this work for additional information regarding copyright ownership.
* The ASF licenses this file to You under the Apache License, Version 2.0
* (the "License"); you may not use this file except in compliance with
* the License. You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package org.apache.ignite.schema.parser;
import javafx.collections.*;
import org.apache.ignite.schema.model.*;
import org.apache.ignite.schema.parser.dialect.*;
import java.sql.*;
import java.util.*;
import java.util.logging.*;
/**
* Database metadata parser.
*/
public class DatabaseMetadataParser {
/** Logger. */
private static final Logger log = Logger.getLogger(DatabaseMetadataParser.class.getName());
/**
* Parse database metadata.
*
* @param conn Connection to database.
* @param tblsOnly If {@code true} then process tables only else process tables and views.
* @return Collection of POJO descriptors.
* @throws SQLException If parsing failed.
*/
public static ObservableList parse(Connection conn, boolean tblsOnly) throws SQLException {
DatabaseMetadataDialect dialect;
try {
String dbProductName = conn.getMetaData().getDatabaseProductName();
if ("Oracle".equals(dbProductName))
dialect = new OracleMetadataDialect();
else if (dbProductName.startsWith("DB2/"))
dialect = new DB2MetadataDialect();
else
dialect = new JdbcMetadataDialect();
}
catch (SQLException e) {
log.log(Level.SEVERE, "Failed to resolve dialect (JdbcMetaDataDialect will be used.", e);
dialect = new JdbcMetadataDialect();
}
Map parents = new HashMap<>();
Map> childrens = new HashMap<>();
for (DbTable tbl : dialect.tables(conn, tblsOnly)) {
String schema = tbl.schema();
PojoDescriptor parent = parents.get(schema);
Collection children = childrens.get(schema);
if (parent == null) {
parent = new PojoDescriptor(null, new DbTable(schema, "", Collections.emptyList(),
Collections.emptySet(), Collections.emptySet(),
Collections.>emptyMap()));
children = new ArrayList<>();
parents.put(schema, parent);
childrens.put(schema, children);
}
children.add(new PojoDescriptor(parent, tbl));
}
List res = new ArrayList<>();
for (String schema : parents.keySet()) {
PojoDescriptor parent = parents.get(schema);
Collection children = childrens.get(schema);
if (!children.isEmpty()) {
parent.children(children);
res.add(parent);
res.addAll(children);
}
}
Collections.sort(res, new Comparator() {
@Override public int compare(PojoDescriptor o1, PojoDescriptor o2) {
return o1.fullDbName().compareTo(o2.fullDbName());
}
});
return FXCollections.observableList(res);
}
}
© 2015 - 2025 Weber Informatics LLC | Privacy Policy