Search in sources :

Example 1 with NameValidator

use of org.alfresco.util.schemacomp.validator.NameValidator in project alfresco-repository by Alfresco.

the class Schema method addDefaultValidators.

/**
 * Add a set of validators that should be present by default on Schema objects.
 */
private void addDefaultValidators() {
    // We expect the user's database to have a different schema name to the reference schema.
    NameValidator nameValidator = new NameValidator();
    nameValidator.setPattern(Pattern.compile(".*"));
    getValidators().add(nameValidator);
    // The schema version shouldn't have to match exactly.
    SchemaVersionValidator versionValidator = new SchemaVersionValidator();
    getValidators().add(versionValidator);
}
Also used : NameValidator(org.alfresco.util.schemacomp.validator.NameValidator) SchemaVersionValidator(org.alfresco.util.schemacomp.validator.SchemaVersionValidator)

Example 2 with NameValidator

use of org.alfresco.util.schemacomp.validator.NameValidator in project alfresco-repository by Alfresco.

the class DbObjectXMLTransformerTest method transformObjectWithValidators.

@Test
public void transformObjectWithValidators() throws IOException {
    Collection<Column> columns = columns("one VARCHAR2(100)", "two NUMBER(10)");
    PrimaryKey pk = new PrimaryKey(null, "pk_for_my_table", Arrays.asList("id"), Arrays.asList(1));
    Collection<ForeignKey> fks = fkeys(fk("fk_one", "lc", "tt", "tc"), fk("fk_two", "lc", "tt", "tc"));
    Collection<Index> indexes = indexes("index_one col1 col2", "index_two col3 col4");
    Table table = new Table(null, "my_table", columns, pk, fks, indexes);
    NameValidator nameValidator = new NameValidator();
    nameValidator.setPattern(Pattern.compile("match_me_if_you_can"));
    List<DbValidator> validators = new ArrayList<DbValidator>();
    validators.add(nameValidator);
    table.setValidators(validators);
    transformer.output(table);
    BufferedReader reader = new BufferedReader(new StringReader(writer.toString()));
    dumpOutput();
    assertHasPreamble(reader);
    assertEquals("<table name=\"my_table\">", reader.readLine());
    assertEquals("  <validators>", reader.readLine());
    assertEquals("    <validator class=\"org.alfresco.util.schemacomp.validator.NameValidator\">", reader.readLine());
    assertEquals("      <properties>", reader.readLine());
    assertEquals("        <property name=\"pattern\">match_me_if_you_can</property>", reader.readLine());
    assertEquals("      </properties>", reader.readLine());
    assertEquals("    </validator>", reader.readLine());
    assertEquals("  </validators>", reader.readLine());
    assertEquals("  <columns>", reader.readLine());
    skipUntilEnd("       {column}", reader);
    skipUntilEnd("       {column}", reader);
    assertEquals("  </columns>", reader.readLine());
    skipUntilEnd("  {primarykey}", reader);
    assertEquals("  <foreignkeys>", reader.readLine());
    skipUntilEnd("       {foreignkey}", reader);
    skipUntilEnd("       {foreignkey}", reader);
    assertEquals("  </foreignkeys>", reader.readLine());
    assertEquals("  <indexes>", reader.readLine());
    skipUntilEnd("       {index}", reader);
    skipUntilEnd("       {index}", reader);
    assertEquals("  </indexes>", reader.readLine());
    assertEquals("</table>", reader.readLine());
}
Also used : Table(org.alfresco.util.schemacomp.model.Table) NameValidator(org.alfresco.util.schemacomp.validator.NameValidator) ArrayList(java.util.ArrayList) PrimaryKey(org.alfresco.util.schemacomp.model.PrimaryKey) Index(org.alfresco.util.schemacomp.model.Index) ForeignKey(org.alfresco.util.schemacomp.model.ForeignKey) Column(org.alfresco.util.schemacomp.model.Column) BufferedReader(java.io.BufferedReader) StringReader(java.io.StringReader) DbValidator(org.alfresco.util.schemacomp.validator.DbValidator) Test(org.junit.Test)

Example 3 with NameValidator

use of org.alfresco.util.schemacomp.validator.NameValidator in project alfresco-repository by Alfresco.

the class SchemaComparatorTest method systemGeneratedPrimaryKeyAndIndex.

/**
 * Tests index of primary key validation, problem found when comparing DB2 schemas (now EOLed) which has
 * system generated indexes for primary keys, but might still be useful as a test.
 */
@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());
}
Also used : Table(org.alfresco.util.schemacomp.model.Table) DbObject(org.alfresco.util.schemacomp.model.DbObject) NameValidator(org.alfresco.util.schemacomp.validator.NameValidator) Schema(org.alfresco.util.schemacomp.model.Schema) ArrayList(java.util.ArrayList) PrimaryKey(org.alfresco.util.schemacomp.model.PrimaryKey) Index(org.alfresco.util.schemacomp.model.Index) DbValidator(org.alfresco.util.schemacomp.validator.DbValidator) Test(org.junit.Test)

Aggregations

NameValidator (org.alfresco.util.schemacomp.validator.NameValidator)3 ArrayList (java.util.ArrayList)2 Index (org.alfresco.util.schemacomp.model.Index)2 PrimaryKey (org.alfresco.util.schemacomp.model.PrimaryKey)2 Table (org.alfresco.util.schemacomp.model.Table)2 DbValidator (org.alfresco.util.schemacomp.validator.DbValidator)2 Test (org.junit.Test)2 BufferedReader (java.io.BufferedReader)1 StringReader (java.io.StringReader)1 Column (org.alfresco.util.schemacomp.model.Column)1 DbObject (org.alfresco.util.schemacomp.model.DbObject)1 ForeignKey (org.alfresco.util.schemacomp.model.ForeignKey)1 Schema (org.alfresco.util.schemacomp.model.Schema)1 SchemaVersionValidator (org.alfresco.util.schemacomp.validator.SchemaVersionValidator)1