Java tutorial
/* * #%L * Alfresco Repository * %% * Copyright (C) 2005 - 2016 Alfresco Software Limited * %% * This file is part of the Alfresco software. * If the software was purchased under a paid Alfresco license, the terms of * the paid license agreement will prevail. Otherwise, the software is * provided under the following open source license terms: * * Alfresco is free software: you can redistribute it and/or modify * it under the terms of the GNU Lesser General Public License as published by * the Free Software Foundation, either version 3 of the License, or * (at your option) any later version. * * Alfresco is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU Lesser General Public License for more details. * * You should have received a copy of the GNU Lesser General Public License * along with Alfresco. If not, see <http://www.gnu.org/licenses/>. * #L% */ /* * Copytarget (C) 2005-2011 Alfresco Software Limited. * * This file is part of Alfresco * * Alfresco is free software: you can redistribute it and/or modify * it under the terms of the GNU Lesser General Public License as published by * the Free Software Foundation, either version 3 of the License, or * (at your option) any later version. * * Alfresco is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU Lesser General Public License for more details. * * You should have received a copy of the GNU Lesser General Public License * along with Alfresco. If not, see <http://www.gnu.org/licenses/>. */ package org.alfresco.util.schemacomp; import static org.alfresco.util.schemacomp.SchemaCompTestingUtils.columns; import static org.alfresco.util.schemacomp.SchemaCompTestingUtils.dumpDiffs; import static org.alfresco.util.schemacomp.SchemaCompTestingUtils.dumpValidation; import static org.alfresco.util.schemacomp.SchemaCompTestingUtils.fk; import static org.alfresco.util.schemacomp.SchemaCompTestingUtils.fkeys; import static org.alfresco.util.schemacomp.SchemaCompTestingUtils.indexes; import static org.alfresco.util.schemacomp.SchemaCompTestingUtils.pk; import static org.alfresco.util.schemacomp.SchemaCompTestingUtils.table; import static org.junit.Assert.assertEquals; import static org.junit.Assert.assertFalse; import java.util.ArrayList; import java.util.Arrays; import java.util.Collection; import java.util.Iterator; import java.util.List; import org.alfresco.util.schemacomp.Difference.Where; import org.alfresco.util.schemacomp.model.DbObject; import org.alfresco.util.schemacomp.model.Index; import org.alfresco.util.schemacomp.model.PrimaryKey; import org.alfresco.util.schemacomp.model.Schema; import org.alfresco.util.schemacomp.model.Table; import org.alfresco.util.schemacomp.validator.DbValidator; import org.alfresco.util.schemacomp.validator.NameValidator; import org.hibernate.dialect.Dialect; import org.hibernate.dialect.MySQL5InnoDBDialect; import org.junit.Before; import org.junit.Test; /** * Tests for the SchmeaComparator class. * * @author Matt Ward */ public class SchemaComparatorTest { private SchemaComparator comparator; private Schema reference; private Schema target; private Dialect dialect; @Before public void setup() { reference = new Schema("schema", "alf_", 590, true); target = new Schema("schema", "alf_", 590, true); dialect = new MySQL5InnoDBDialect(); } @Test public void canPerformDiff() { // Reference schema's database objects. reference.add(new Table(reference, "tbl_no_diff", columns("id NUMBER(10)", "nodeRef VARCHAR2(200)", "name VARCHAR2(150)"), pk("pk_tbl_no_diff", "id"), fkeys(fk("fk_tbl_no_diff", "nodeRef", "node", "nodeRef")), indexes("idx_node id nodeRef"))); reference.add(table("table_in_reference")); reference.add(new Table(reference, "tbl_has_diff_pk", columns("id NUMBER(10)", "nodeRef VARCHAR2(200)"), pk("pk_is_diff", "id"), fkeys(), indexes("idx_one id nodeRef", "idx_two id"))); // Target schema's database objects. target.add(new Table(target, "tbl_no_diff", columns("id NUMBER(10)", "nodeRef VARCHAR2(200)", "name VARCHAR2(150)"), pk("pk_tbl_no_diff", "id"), fkeys(fk("fk_tbl_no_diff", "nodeRef", "node", "nodeRef")), indexes("idx_node id nodeRef"))); target.add(new Table(target, "tbl_has_diff_pk", columns("id NUMBER(10)", "nodeRef VARCHAR2(200)"), pk("pk_is_diff", "nodeRef"), fkeys(), indexes("idx_one id nodeRef", "idx_two [unique] id"))); target.add(table("table_in_target")); comparator = new SchemaComparator(reference, target, dialect); comparator.validateAndCompare(); // See stdout for diagnostics dump... dumpDiffs(comparator.getComparisonResults(), false); dumpValidation(comparator.getComparisonResults()); Results results = comparator.getComparisonResults(); Iterator<Result> it = results.iterator(); // Table table_in_reference only appears in the reference schema Difference diff = (Difference) it.next(); assertEquals(Where.ONLY_IN_REFERENCE, diff.getWhere()); assertEquals("schema.table_in_reference", diff.getLeft().getPath()); assertEquals(null, diff.getRight()); assertEquals(null, diff.getLeft().getPropertyName()); assertEquals(null, diff.getLeft().getPropertyValue()); // Table tbl_has_diff_pk has PK of "id" in reference and "nodeRef" in target diff = (Difference) it.next(); assertEquals(Where.IN_BOTH_BUT_DIFFERENCE, diff.getWhere()); assertEquals("schema.tbl_has_diff_pk.pk_is_diff.columnNames[0]", diff.getLeft().getPath()); assertEquals("schema.tbl_has_diff_pk.pk_is_diff.columnNames[0]", diff.getRight().getPath()); assertEquals("columnNames[0]", diff.getLeft().getPropertyName()); assertEquals("id", diff.getLeft().getPropertyValue()); assertEquals("columnNames[0]", diff.getRight().getPropertyName()); assertEquals("nodeRef", diff.getRight().getPropertyValue()); // idx_two is unique in the righ_schema but not in the reference diff = (Difference) it.next(); assertEquals("schema.tbl_has_diff_pk.idx_two.unique", diff.getLeft().getPath()); assertEquals("schema.tbl_has_diff_pk.idx_two.unique", diff.getRight().getPath()); assertEquals("unique", diff.getLeft().getPropertyName()); assertEquals(false, diff.getLeft().getPropertyValue()); assertEquals("unique", diff.getRight().getPropertyName()); assertEquals(true, diff.getRight().getPropertyValue()); // Table table_in_target does not exist in the reference schema diff = (Difference) it.next(); assertEquals(Where.ONLY_IN_TARGET, diff.getWhere()); assertEquals("schema.table_in_target", diff.getRight().getPath()); assertEquals(null, diff.getLeft()); assertEquals(null, diff.getRight().getPropertyName()); assertEquals(null, diff.getRight().getPropertyValue()); assertFalse("There should be no more differences", it.hasNext()); } @Test public void pkOrderingComparedCorrectly() { reference = new Schema("schema", "alf_", 590, true); target = new Schema("schema", "alf_", 590, true); // Reference schema's database objects. reference.add(new Table(reference, "table_name", columns("id NUMBER(10)", "nodeRef VARCHAR2(200)", "name VARCHAR2(150)"), new PrimaryKey(null, "my_pk_name", Arrays.asList("id", "nodeRef"), Arrays.asList(1, 2)), fkeys(), indexes())); // Target schema's database objects - note different order of PK columns. target.add(new Table(target, "table_name", columns("id NUMBER(10)", "nodeRef VARCHAR2(200)", "name VARCHAR2(150)"), new PrimaryKey(null, "my_pk_name", Arrays.asList("id", "nodeRef"), Arrays.asList(2, 1)), fkeys(), indexes())); comparator = new SchemaComparator(reference, target, dialect); comparator.validateAndCompare(); // See stdout for diagnostics dump... dumpDiffs(comparator.getComparisonResults(), false); dumpValidation(comparator.getComparisonResults()); Results results = comparator.getComparisonResults(); Iterator<Result> it = results.iterator(); Difference diff = (Difference) it.next(); assertEquals(Where.IN_BOTH_BUT_DIFFERENCE, diff.getWhere()); assertEquals("schema.table_name.my_pk_name.columnOrders[0]", diff.getLeft().getPath()); assertEquals("schema.table_name.my_pk_name.columnOrders[0]", diff.getRight().getPath()); assertEquals("columnOrders[0]", diff.getLeft().getPropertyName()); assertEquals(1, diff.getLeft().getPropertyValue()); assertEquals("columnOrders[0]", diff.getRight().getPropertyName()); assertEquals(2, diff.getRight().getPropertyValue()); diff = (Difference) it.next(); assertEquals(Where.IN_BOTH_BUT_DIFFERENCE, diff.getWhere()); assertEquals("schema.table_name.my_pk_name.columnOrders[1]", diff.getLeft().getPath()); assertEquals("schema.table_name.my_pk_name.columnOrders[1]", diff.getRight().getPath()); assertEquals("columnOrders[1]", diff.getLeft().getPropertyName()); assertEquals(2, diff.getLeft().getPropertyValue()); assertEquals("columnOrders[1]", diff.getRight().getPropertyName()); assertEquals(1, diff.getRight().getPropertyValue()); assertFalse("There should be no more differences", it.hasNext()); } @Test public void indexColumnOrderingComparedCorrectly() { reference = new Schema("schema", "alf_", 590, true); target = new Schema("schema", "alf_", 590, true); // Reference schema's database objects. reference.add(new Table(reference, "table_name", columns("id NUMBER(10)", "nodeRef VARCHAR2(200)", "name VARCHAR2(150)"), pk("pk", "id"), fkeys(), indexes("index_name id nodeRef"))); // Target schema's database objects - note different order of index columns. target.add(new Table(target, "table_name", columns("id NUMBER(10)", "nodeRef VARCHAR2(200)", "name VARCHAR2(150)"), pk("pk", "id"), fkeys(), indexes("index_name nodeRef id"))); comparator = new SchemaComparator(reference, target, dialect); comparator.validateAndCompare(); // See stdout for diagnostics dump... dumpDiffs(comparator.getComparisonResults(), false); dumpValidation(comparator.getComparisonResults()); Results results = comparator.getComparisonResults(); Iterator<Result> it = results.iterator(); Difference diff = (Difference) it.next(); assertEquals(Where.IN_BOTH_BUT_DIFFERENCE, diff.getWhere()); assertEquals("schema.table_name.index_name.columnNames[0]", diff.getLeft().getPath()); assertEquals("schema.table_name.index_name.columnNames[0]", diff.getRight().getPath()); assertEquals("columnNames[0]", diff.getLeft().getPropertyName()); assertEquals("id", diff.getLeft().getPropertyValue()); assertEquals("columnNames[0]", diff.getRight().getPropertyName()); assertEquals("nodeRef", diff.getRight().getPropertyValue()); diff = (Difference) it.next(); assertEquals(Where.IN_BOTH_BUT_DIFFERENCE, diff.getWhere()); assertEquals("schema.table_name.index_name.columnNames[1]", diff.getLeft().getPath()); assertEquals("schema.table_name.index_name.columnNames[1]", diff.getRight().getPath()); assertEquals("columnNames[1]", diff.getLeft().getPropertyName()); assertEquals("nodeRef", diff.getLeft().getPropertyValue()); assertEquals("columnNames[1]", diff.getRight().getPropertyName()); assertEquals("id", diff.getRight().getPropertyValue()); assertFalse("There should be no more differences", it.hasNext()); } @Test public void columnOrderingComparedCorrectlyWhenEnabled() { reference = new Schema("schema", "alf_", 590, true); target = new Schema("schema", "alf_", 590, true); // Reference schema's database objects. reference.add(new Table(reference, "table_name", columns("id NUMBER(10)", "nodeRef VARCHAR2(200)", "name VARCHAR2(150)"), new PrimaryKey(null, "my_pk_name", Arrays.asList("id", "nodeRef"), Arrays.asList(1, 2)), fkeys(), indexes())); // Target schema's database objects - note different column order target.add(new Table(target, "table_name", columns("id NUMBER(10)", "name VARCHAR2(150)", "nodeRef VARCHAR2(200)"), new PrimaryKey(null, "my_pk_name", Arrays.asList("id", "nodeRef"), Arrays.asList(1, 2)), fkeys(), indexes())); comparator = new SchemaComparator(reference, target, dialect); comparator.validateAndCompare(); // See stdout for diagnostics dump... dumpDiffs(comparator.getComparisonResults(), false); dumpValidation(comparator.getComparisonResults()); Results results = comparator.getComparisonResults(); Iterator<Result> it = results.iterator(); Difference diff = (Difference) it.next(); assertEquals(Where.IN_BOTH_BUT_DIFFERENCE, diff.getWhere()); assertEquals("schema.table_name.nodeRef.order", diff.getLeft().getPath()); assertEquals("order", diff.getLeft().getPropertyName()); assertEquals(2, diff.getLeft().getPropertyValue()); assertEquals("schema.table_name.nodeRef.order", diff.getRight().getPath()); assertEquals("order", diff.getRight().getPropertyName()); assertEquals(3, diff.getRight().getPropertyValue()); diff = (Difference) it.next(); assertEquals(Where.IN_BOTH_BUT_DIFFERENCE, diff.getWhere()); assertEquals("schema.table_name.name.order", diff.getLeft().getPath()); assertEquals("order", diff.getLeft().getPropertyName()); assertEquals(3, diff.getLeft().getPropertyValue()); assertEquals("schema.table_name.name.order", diff.getRight().getPath()); assertEquals("order", diff.getRight().getPropertyName()); assertEquals(2, diff.getRight().getPropertyValue()); assertFalse("There should be no more differences", it.hasNext()); } @Test public void columnOrderingIgnoredWhenDisabled() { reference = new Schema("schema", "alf_", 590, false); target = new Schema("schema", "alf_", 590, false); // Reference schema's database objects. reference.add(new Table(reference, "table_name", columns(false, "id NUMBER(10)", "nodeRef VARCHAR2(200)", "name VARCHAR2(150)"), new PrimaryKey(null, "my_pk_name", Arrays.asList("id", "nodeRef"), Arrays.asList(1, 2)), fkeys(), indexes())); // Target schema's database objects - note different column order target.add(new Table(target, "table_name", columns(false, "id NUMBER(10)", "name VARCHAR2(150)", "nodeRef VARCHAR2(200)"), new PrimaryKey(null, "my_pk_name", Arrays.asList("id", "nodeRef"), Arrays.asList(1, 2)), fkeys(), indexes())); comparator = new SchemaComparator(reference, target, dialect); comparator.validateAndCompare(); // See stdout for diagnostics dump... dumpDiffs(comparator.getComparisonResults(), false); dumpValidation(comparator.getComparisonResults()); Results results = comparator.getComparisonResults(); // There are no logical differences assertEquals(0, results.size()); } /** * Tests index of primary key validation, problem found when comparing DB2 schemas which has * system generated indexes for primary keys */ @Test public void systemGeneratedPrimaryKeyAndIndex() { reference = new Schema("schema", "alf_", 9012, false); target = new Schema("schema", "alf_", 9012, false); NameValidator validator = new NameValidator(); validator.setProperty("pattern", "SQL[0-9]+"); final List<DbValidator> validators = new ArrayList<DbValidator>(); validators.add(new NameValidator()); reference.add(new Table(reference, "ALF_ACL_CHANGE_SET", columns(false, "id NUMBER(10)", "nodeRef VARCHAR2(200)", "name VARCHAR2(150)"), new PrimaryKey(null, "SQL120116153559440", Arrays.asList("id", "nodeRef"), Arrays.asList(1, 2)), fkeys(), indexes("SQL120116153559441 [unique] ID_", "fooX ID_"))); // Target schema's database objects target.add(new Table(target, "ALF_ACL_CHANGE_SET", columns(false, "id NUMBER(10)", "name VARCHAR2(150)", "nodeRef VARCHAR2(200)"), new PrimaryKey(null, "SQL120116153559442", Arrays.asList("id", "nodeRef"), Arrays.asList(1, 2)), fkeys(), indexes("SQL120116153559443 [unique] ID_", "fooX ID_"))); reference.add(new Table(reference, "ALF_LOCK_RESOURCE", columns(false, "id NUMBER(10)", "nodeRef VARCHAR2(200)", "name VARCHAR2(150)"), new PrimaryKey(null, "SQL120116153554310", Arrays.asList("ID", "int"), Arrays.asList(1, 2)), fkeys(), indexes("SQL120116153616440 [unique] ID_"))); target.add(new Table(reference, "ALF_LOCK_RESOURCE", columns(false, "id NUMBER(10)", "nodeRef VARCHAR2(200)", "name VARCHAR2(150)"), new PrimaryKey(null, "SQL120116153554313", Arrays.asList("ID", "int"), Arrays.asList(1, 2)), fkeys(), indexes("SQL120116153616444 [unique] ID_"))); /** * Now plug in the pattern validator */ DbObjectVisitor visitor = new DbObjectVisitor() { @Override public void visit(DbObject dbObject) { if (dbObject instanceof Index) { dbObject.setValidators(validators); } if (dbObject instanceof PrimaryKey) { dbObject.setValidators(validators); } } }; reference.accept(visitor); target.accept(visitor); comparator = new SchemaComparator(reference, target, dialect); comparator.validateAndCompare(); // See stdout for diagnostics dump... dumpDiffs(comparator.getComparisonResults(), false); dumpValidation(comparator.getComparisonResults()); Results results = comparator.getComparisonResults(); // There are no logical differences assertEquals(0, results.size()); } }