private Set<Column> listTableKeys(final Table table) { final Set<Column> tableKeys = new HashSet<>(); final PrimaryKey primaryKey = table.getPrimaryKey(); if (primaryKey != null && primaryKey.getColumns().size() == 1) { tableKeys.add(primaryKey.getColumns().get(0)); } for (final Index index: table.getIndexes()) { if (index != null && index.isUnique() && index.getColumns().size() == 1) { tableKeys.add(index.getColumns().get(0)); } } return tableKeys; }
private static Collection<List<String>> indexCoumnNames(final Table table, final boolean includeUniqueOnly) { final List<List<String>> allIndexCoumns = new ArrayList<>(); if (table instanceof PartialDatabaseObject) { return allIndexCoumns; } final PrimaryKey primaryKey = table.getPrimaryKey(); final List<String> pkColumns = columnNames(primaryKey); allIndexCoumns.add(pkColumns); for (final Index index: table.getIndexes()) { if (includeUniqueOnly && !index.isUnique()) { continue; } final List<String> indexColumns = columnNames(index); allIndexCoumns.add(indexColumns); } return allIndexCoumns; }
private static Collection<List<String>> indexCoumnNames(final Table table, final boolean includeUniqueOnly) { final List<List<String>> allIndexCoumns = new ArrayList<>(); if (table instanceof PartialDatabaseObject) { return allIndexCoumns; } final PrimaryKey primaryKey = table.getPrimaryKey(); final List<String> pkColumns = columnNames(primaryKey); allIndexCoumns.add(pkColumns); for (final Index index: table.getIndexes()) { if (includeUniqueOnly && !index.isUnique()) { continue; } final List<String> indexColumns = columnNames(index); allIndexCoumns.add(indexColumns); } return allIndexCoumns; }
@Override public DaPrimaryKey getPrimaryKey() { return table.getPrimaryKey() != null ? new DaPrimaryKeyImpl(table.getPrimaryKey(), schemaStrategy) : null; }
"Test Table 2"); final MutablePrimaryKey primaryKey = (MutablePrimaryKey) table0 .getPrimaryKey(); table1.setPrimaryKeyAndReplaceIndex(primaryKey); table2.setPrimaryKeyAndReplaceIndex(primaryKey);
private static List<String> extractPrimaryKeys(Table table, Map<List<String>, String> fks) { // todo handle composite keys List<String> pks = new ArrayList<>(); // String pk = null; if (table.getPrimaryKey() != null) { List<IndexColumn> pkColumns = table.getPrimaryKey().getColumns(); for (IndexColumn pkColumn : pkColumns) { String pkName = pkColumn.getName(); //TODO check and think // if (fks.containsKey(pkName)) continue; //TODO rule // if (isForeignKeyPart(fks, pkName)) continue; pks.add(pkName); } // System.out.println("Real? Primary Keys " + pks); } return pks; }
jsonTable.put("primaryKey", handleIndex(table.getPrimaryKey())); jsonTable.put("foreignKeys", handleForeignKeys(table.getForeignKeys())); if (!isBrief)
protected boolean isPrimaryKey(Table table, Column column) { if (table.getPrimaryKey() != null) { for (IndexColumn col : table.getPrimaryKey().getColumns()) { if (col.getName().equalsIgnoreCase(column.getName())) { return true; } } } else { LOG.warn("No primary key constraints for {}", table.getName()); } return false; }
printPrimaryKey(table.getPrimaryKey()); printForeignKeys(table); if (!isBrief)
private Map<String, Column> mapColumnNameMatches(final Table table) { final Map<String, Column> matchMap = new HashMap<>(); final PrimaryKey primaryKey = table.getPrimaryKey(); if (primaryKey != null && primaryKey.getColumns().size() == 1) { matchMap.put("id", primaryKey.getColumns().get(0)); } for (final Column column: table.getColumns()) { String matchColumnName = column.getName().toLowerCase(); if (matchColumnName.endsWith("_id")) { matchColumnName = matchColumnName .substring(0, matchColumnName.length() - 3); } if (matchColumnName.endsWith("id") && !matchColumnName.equals("id")) { matchColumnName = matchColumnName .substring(0, matchColumnName.length() - 2); } matchMap.put(matchColumnName, column); } return matchMap; }
private Set<Column> listTableKeys(final Table table) { final Set<Column> tableKeys = new HashSet<>(); final PrimaryKey primaryKey = table.getPrimaryKey(); if (primaryKey != null && primaryKey.getColumns().size() == 1) { tableKeys.add(primaryKey.getColumns().get(0)); } for (final Index index: table.getIndexes()) { if (index != null && index.isUnique() && index.getColumns().size() == 1) { tableKeys.add(index.getColumns().get(0)); } } return tableKeys; }
private Set<Column> listTableKeys(final Table table) { final Set<Column> tableKeys = new HashSet<>(); final PrimaryKey primaryKey = table.getPrimaryKey(); if (primaryKey != null && primaryKey.getColumns().size() == 1) { tableKeys.add(primaryKey.getColumns().get(0)); } for (final Index index: table.getIndexes()) { if (index != null && index.isUnique() && index.getColumns().size() == 1) { tableKeys.add(index.getColumns().get(0)); } } return tableKeys; }
private static Collection<List<String>> indexCoumnNames(final Table table, final boolean includeUniqueOnly) { final List<List<String>> allIndexCoumns = new ArrayList<>(); final PrimaryKey primaryKey = table.getPrimaryKey(); final List<String> pkColumns = columnNames(primaryKey); allIndexCoumns.add(pkColumns); for (final Index index: table.getIndices()) { if (includeUniqueOnly && !index.isUnique()) { continue; } final List<String> indexColumns = columnNames(index); allIndexCoumns.add(indexColumns); } return allIndexCoumns; }
private static Collection<List<String>> indexCoumnNames(final Table table, final boolean includeUniqueOnly) { final List<List<String>> allIndexCoumns = new ArrayList<>(); if (table instanceof PartialDatabaseObject) { return allIndexCoumns; } final PrimaryKey primaryKey = table.getPrimaryKey(); final List<String> pkColumns = columnNames(primaryKey); allIndexCoumns.add(pkColumns); for (final Index index: table.getIndexes()) { if (includeUniqueOnly && !index.isUnique()) { continue; } final List<String> indexColumns = columnNames(index); allIndexCoumns.add(indexColumns); } return allIndexCoumns; }
private static Collection<List<String>> indexCoumnNames(final Table table, final boolean includeUniqueOnly) { final List<List<String>> allIndexCoumns = new ArrayList<>(); if (table instanceof PartialDatabaseObject) { return allIndexCoumns; } final PrimaryKey primaryKey = table.getPrimaryKey(); final List<String> pkColumns = columnNames(primaryKey); allIndexCoumns.add(pkColumns); for (final Index index: table.getIndexes()) { if (includeUniqueOnly && !index.isUnique()) { continue; } final List<String> indexColumns = columnNames(index); allIndexCoumns.add(indexColumns); } return allIndexCoumns; }
String tableName = table.getName(); System.out.println(table + " pk " + table.getPrimaryKey() + " fks " + table.getForeignKeys() + " type " + table.getTableType()); if (rules.skipTable(tableName) || table.getTableType().isView()) { System.out.println("SKIPPED");
printTableColumns(columns); printPrimaryKey(table.getPrimaryKey()); printForeignKeys(table); if (isVerbose)
jsonTable.put("primaryKey", handleIndex(table.getPrimaryKey())); jsonTable.put("foreignKeys", handleForeignKeys(table.getForeignKeys()));
printPrimaryKey(table.getPrimaryKey()); printForeignKeys(table); if (!isBrief)
printPrimaryKey(table.getPrimaryKey()); printForeignKeys(table); if (!isBrief)