includetablefiltertest.java

一个基于JUnit测试框架的关于数据库的测试框架

        String[] actualNames = new DefaultDataSet(actualTables).getTableNames();
        assertEquals("table count", expectedNames.length, actualTables.length);
        assertEquals("table names",
                Arrays.asList(expectedNames), Arrays.asList(actualNames));
    }

    public void testCaseInsensitiveIterator() throws Exception
    {
        ITableFilter filter = new IncludeTableFilter(getExpectedNames());
        String[] lowerNames = getExpectedLowerNames();

        IDataSet dataSet = new LowerCaseDataSet(createDataSet());
        assertTrue("dataset names count",
                dataSet.getTableNames().length > lowerNames.length);

        ITable[] actualTables = DataSetUtils.getTables(
                filter.iterator(dataSet, false));
        String[] actualNames = new DefaultDataSet(actualTables).getTableNames();
        assertEquals("table count", lowerNames.length, actualTables.length);
        assertEquals("table names",
                Arrays.asList(lowerNames), Arrays.asList(actualNames));
    }

    public void testReverseIterator() throws Exception
    {
        String[] filterNames = getExpectedNames();
        String[] expectedNames = DataSetUtils.reverseStringArray(filterNames);
        ITableFilter filter = new IncludeTableFilter(filterNames);

        IDataSet dataSet = createDataSet();
        assertTrue("dataset names count",
                dataSet.getTableNames().length > expectedNames.length);

        ITable[] actualTables = DataSetUtils.getTables(
                filter.iterator(dataSet, true));
        String[] actualNames = new DefaultDataSet(actualTables).getTableNames();
        assertEquals("table count", expectedNames.length, actualTables.length);
        assertEquals("table names",
                Arrays.asList(expectedNames), Arrays.asList(actualNames));
    }

    public void testIteratorAndTableNotInDecoratedDataSet() throws Exception
    {
        String[] expectedNames = getExpectedNames();

        List filterNameList = new ArrayList(Arrays.asList(expectedNames));
        filterNameList.add("UNKNOWN_TABLE");
        String[] filterNames = (String[])filterNameList.toArray(new String[0]);
        ITableFilter filter = new IncludeTableFilter(filterNames);

        IDataSet dataSet = createDataSet();
        assertTrue("dataset names count",
                dataSet.getTableNames().length > expectedNames.length);

        ITable[] actualTables = DataSetUtils.getTables(
                filter.iterator(dataSet, false));
        String[] actualNames = new DefaultDataSet(actualTables).getTableNames();
        assertEquals("table count", expectedNames.length, actualTables.length);
        assertEquals("table names",
                Arrays.asList(expectedNames), Arrays.asList(actualNames));
    }

    ////////////////////////////////////////////////////////////////////////////

    public void testIsValidNameWithPatterns() throws Exception
    {
        String validName = MATCHING_NAME;

        String[] patterns = MATCHING_PATTERNS;
        for (int i = 0; i < patterns.length; i++)
        {
            String pattern = patterns[i];
            IncludeTableFilter filter = new IncludeTableFilter();
            filter.includeTable(pattern);
            assertEquals(pattern, true, filter.isValidName(validName));
        }
    }

    public void testIsValidNameInvalidWithPatterns() throws Exception
    {
        String validName = MATCHING_NAME;

        String[] patterns = NONMATCHING_PATTERNS;
        for (int i = 0; i < patterns.length; i++)
        {
            String pattern = patterns[i];
            IncludeTableFilter filter = new IncludeTableFilter();
            filter.includeTable(pattern);
            assertEquals(pattern, false, filter.isValidName(validName));
        }
    }

    public void testGetTableNamesWithPatterns() throws Exception
    {
        String[] expectedNames = new String[] {MATCHING_NAME};
        IDataSet dataSet = new DefaultDataSet(new ITable[] {
            new DefaultTable(MATCHING_NAME),
            new DefaultTable("toto"),
            new DefaultTable("1234"),
            new DefaultTable("fedcba"),
        });
        assertTrue("dataset names count",
                dataSet.getTableNames().length > expectedNames.length);

        String[] patterns = MATCHING_PATTERNS;
        for (int i = 0; i < patterns.length; i++)
        {
            String pattern = patterns[i];
            IncludeTableFilter filter = new IncludeTableFilter();
            filter.includeTable(pattern);

            // this pattern match everything, so ensure nothing is filtered
            if (pattern.equals("*"))
            {
                String[] actualNames = filter.getTableNames(dataSet);
                assertEquals("name count - " + pattern,
                        dataSet.getTableNames().length, actualNames.length);
                assertEquals("names - " + pattern,
                        Arrays.asList(dataSet.getTableNames()),
                        Arrays.asList(actualNames));
            }
            else
            {
                String[] actualNames = filter.getTableNames(dataSet);
                assertEquals("name count - " + pattern,
                        expectedNames.length, actualNames.length);
                assertEquals("names - " + pattern,
                        Arrays.asList(expectedNames), Arrays.asList(actualNames));
            }
        }
    }

    public void testGetTableNamesWithNonMatchingPatterns() throws Exception
    {
        IDataSet dataSet = new DefaultDataSet(new ITable[] {
            new DefaultTable(MATCHING_NAME),
        });
        assertTrue("dataset names count",
                dataSet.getTableNames().length > 0);

        String[] patterns = NONMATCHING_PATTERNS;
        for (int i = 0; i < patterns.length; i++)
        {
            String pattern = patterns[i];
            IncludeTableFilter filter = new IncludeTableFilter();
            filter.includeTable(pattern);

            String[] actualNames = filter.getTableNames(dataSet);
            assertEquals("name count - " + pattern, 0, actualNames.length);
        }
    }

    public void testGetTablesWithPatterns() throws Exception
    {
        String[] expectedNames = new String[] {MATCHING_NAME};
        IDataSet dataSet = new DefaultDataSet(new ITable[] {
            new DefaultTable(MATCHING_NAME),
            new DefaultTable("toto"),
            new DefaultTable("1234"),
            new DefaultTable("fedcba"),
        });
        assertTrue("dataset names count",
                dataSet.getTableNames().length > expectedNames.length);

        String[] patterns = MATCHING_PATTERNS;
        for (int i = 0; i < patterns.length; i++)
        {
            String pattern = patterns[i];
            IncludeTableFilter filter = new IncludeTableFilter();
            filter.includeTable(pattern);

            // this pattern match everything, so ensure nothing is filtered
            if (pattern.equals("*"))
            {
                ITable[] actualTables = DataSetUtils.getTables(
                        filter.iterator(dataSet, false));
                String[] actualNames = new DefaultDataSet(actualTables).getTableNames();
                assertEquals("table count - " + pattern,
                        dataSet.getTableNames().length, actualNames.length);
                assertEquals("table names - " + pattern,
                        Arrays.asList(dataSet.getTableNames()),
                        Arrays.asList(actualNames));
            }
            else
            {
                ITable[] actualTables = DataSetUtils.getTables(
                        filter.iterator(dataSet, false));
                String[] actualNames = new DefaultDataSet(actualTables).getTableNames();
                assertEquals("table count - " + pattern,
                        expectedNames.length, actualTables.length);
                assertEquals("table names - " + pattern,
                        Arrays.asList(expectedNames), Arrays.asList(actualNames));
            }
        }
    }

    public void testGetTablesWithNonMatchingPatterns() throws Exception
    {
        IDataSet dataSet = new DefaultDataSet(new ITable[] {
            new DefaultTable(MATCHING_NAME),
        });
        assertTrue("dataset names count",
                dataSet.getTableNames().length > 0);

        String[] patterns = NONMATCHING_PATTERNS;
        for (int i = 0; i < patterns.length; i++)
        {
            String pattern = patterns[i];
            IncludeTableFilter filter = new IncludeTableFilter();
            filter.includeTable(pattern);

            ITable[] actualTables = DataSetUtils.getTables(
                    filter.iterator(dataSet, false));
            assertEquals("table count - " + pattern, 0, actualTables.length);
        }
    }

}