if (session.getProperties().getLoadSchemasCatalogs()) { final String[] catalogs = md.getCatalogs(); CatalogFilterMatcher filterMatcher = new CatalogFilterMatcher(session.getProperties()); for (int i = 0; i < catalogs.length; ++i) { IDatabaseObjectInfo dbo = new DatabaseObjectInfo(null, null, catalogs[i], DatabaseObjectType.CATALOG, md); if (filterMatcher.matches(dbo.getSimpleName())) { childNodes.add(new ObjectTreeNode(session, dbo)); } } }
session.getSchemaInfo().waitTillSchemasAndCatalogsLoaded(); final String[] schemas = session.getSchemaInfo().getSchemas(); SchemaFilterMatcher filterMatcher = new SchemaFilterMatcher(session.getProperties()); for (int i = 0; i < schemas.length; ++i) { IDatabaseObjectInfo dbo = new DatabaseObjectInfo(catalogName, null, schemas[i], DatabaseObjectType.SCHEMA, md); if(filterMatcher.matches(dbo.getSimpleName())) { childNodes.add(new ObjectTreeNode(session, dbo)); } }
Clone fragments detected by clone detection tool
File path: /sql12/app/src/net/sourceforge/squirrel_sql/client/session/mainpanel/objecttree/expanders/DatabaseExpander.java File path: /sql12/app/src/net/sourceforge/squirrel_sql/client/session/mainpanel/objecttree/expanders/DatabaseExpander.java
Method name: List createCatalogNodes(ISession, SQLDatabaseMetaData) Method name: List createSchemaNodes(ISession, SQLDatabaseMetaData, String)
Number of AST nodes: 7 Number of AST nodes: 7
1
if (session.getProperties().getLoadSchemasCatalogs())
1
session.getSchemaInfo().waitTillSchemasAndCatalogs
2
		{
3
			final String[] catalogs = md.getCatalog
2
Loaded();
4
s();
3
         final String[] schemas = session.getSchemaInfo().getSchemas();
5
         CatalogFilterMatcher filterMatcher = new CatalogFilterMatcher(session.getProperties());
4
         SchemaFilterMatcher filterMatcher = new SchemaFilterMatcher(session.getProperties());
6
			for (int i = 0; i < catalogs.length; ++i)
5
			for (int i = 0; i < schemas.length; ++i)
7
			{
6
			{
8
            IDatabaseObjectInfo dbo = new DatabaseObjectInfo(null, null,
7
            IDatabaseObjectInfo dbo = new DatabaseObjectInfo(catalogName, null,
9
                                 catalogs[i],
8
                                    schemas[i],
10
                                 DatabaseObjectType.CATALOG,
9
                                    DatabaseObjectType.
11
                                 md);
10
SCHEMA, md);
12
            if (filterMatcher.matches(dbo.getSimpleName()))
11
            if(filterMatcher.matches(dbo.getSimpleName()))
13
            {
12
            {
14
					childNodes.add(new ObjectTreeNode(session, dbo));
13
               childNodes.add(new ObjectTreeNode(session, dbo));
15
				}
14
				}
16
			}
15
			}
17
		}
Summary
Number of common nesting structure subtrees1
Number of refactorable cases1
Number of non-refactorable cases0
Time elapsed for finding largest common nesting structure subtrees (ms)0.5
Clones locationClones are declared in the same class
Number of node comparisons12
  1. {Refactorable}
    Mapping Summary
    Number of mapped statements5
    Number of unmapped statements in the first code fragment1
    Number of unmapped statements in the second code fragment2
    Time elapsed for statement mapping (ms)22.3
    Clone typeType 3
    Mapped Statements
    ID Statement ID Statement
                                                                                                                                
    3
    session.getSchemaInfo().waitTillSchemasAndCatalogsLoaded();
    3
    final String[] catalogs = md.getCatalogs();
                                                                                            
                                                                                                                                  
    4
    final String[] schemas = session.getSchemaInfo().getSchemas();
    4
    CatalogFilterMatcher filterMatcher = new CatalogFilterMatcher(session.getProperties());
    4
    CatalogFilterMatcher filterMatcher = new CatalogFilterMatcher(session.getProperties());
    5
    SchemaFilterMatcher filterMatcher = new SchemaFilterMatcher(session.getProperties());
    Differences
    Expression1Expression2Difference
    net.sourceforge.squirrel_sql.client.session.schemainfo.CatalogFilterMatchernet.sourceforge.squirrel_sql.client.session.schemainfo.SchemaFilterMatcherSUBCLASS_TYPE_MISMATCH
    net.sourceforge.squirrel_sql.client.session.schemainfo.CatalogFilterMatchernet.sourceforge.squirrel_sql.client.session.schemainfo.SchemaFilterMatcherSUBCLASS_TYPE_MISMATCH
    net.sourceforge.squirrel_sql.client.session.schemainfo.CatalogFilterMatchernet.sourceforge.squirrel_sql.client.session.schemainfo.SchemaFilterMatcherSUBCLASS_TYPE_MISMATCH
    5
    SchemaFilterMatcher filterMatcher = new SchemaFilterMatcher(session.getProperties());
    5
    for (int i = 0; i < catalogs.length; ++i)
    5
    for (int i = 0; i < catalogs.length; ++i)
    6
    for (int i = 0; i < schemas.length; ++i)
    Differences
    Expression1Expression2Difference
    catalogsschemasVARIABLE_NAME_MISMATCH
    6
    for (int i = 0; i < schemas.length; ++i)
    6
    IDatabaseObjectInfo dbo = new DatabaseObjectInfo(null, null, catalogs[i], DatabaseObjectType.CATALOG, md);
    6
    IDatabaseObjectInfo dbo = new DatabaseObjectInfo(null, null, catalogs[i], DatabaseObjectType.CATALOG, md);
    7
    IDatabaseObjectInfo dbo = new DatabaseObjectInfo(catalogName, null, schemas[i], DatabaseObjectType.SCHEMA, md);
    Differences
    Expression1Expression2Difference
    nullcatalogNameTYPE_COMPATIBLE_REPLACEMENT
    catalogsschemasVARIABLE_NAME_MISMATCH
    CATALOGSCHEMAVARIABLE_NAME_MISMATCH
    7
    IDatabaseObjectInfo dbo = new DatabaseObjectInfo(catalogName, null, schemas[i], DatabaseObjectType.SCHEMA, md);
    7
    if (filterMatcher.matches(dbo.getSimpleName()))
    7
    if (filterMatcher.matches(dbo.getSimpleName()))
    8
    if (filterMatcher.matches(dbo.getSimpleName()))
    Differences
    Expression1Expression2Difference
    net.sourceforge.squirrel_sql.client.session.schemainfo.CatalogFilterMatchernet.sourceforge.squirrel_sql.client.session.schemainfo.SchemaFilterMatcherSUBCLASS_TYPE_MISMATCH
    8
    if (filterMatcher.matches(dbo.getSimpleName()))
    8
    childNodes.add(new ObjectTreeNode(session, dbo));
    9
    childNodes.add(new ObjectTreeNode(session, dbo));
    Precondition Violations (0)
    Row Violation