Search in sources :

Example 1 with TableInformationImpl

use of org.hibernate.tool.schema.extract.internal.TableInformationImpl in project hibernate-orm by hibernate.

the class CheckForExistingForeignKeyTest method testCheckForExistingForeignKeyOne2One.

/**
 * Check detection of existing foreign key with the same mappings for a simple mapping (table1.objectId =>
 * table2.id).
 *
 * @throws SecurityException - error
 * @throws NoSuchMethodException - error
 * @throws InvocationTargetException - error
 * @throws IllegalArgumentException - error
 * @throws IllegalAccessException - error
 * @throws NoSuchFieldException - error
 */
@Test
public void testCheckForExistingForeignKeyOne2One() throws NoSuchMethodException, SecurityException, IllegalAccessException, IllegalArgumentException, InvocationTargetException, NoSuchFieldException {
    // Get the private method
    Method method = AbstractSchemaMigrator.class.getDeclaredMethod("checkForExistingForeignKey", ForeignKey.class, TableInformation.class);
    method.setAccessible(true);
    ForeignKey foreignKey = new ForeignKey();
    // Make sure the match is not successful based on key name
    foreignKey.setName("objectId2id_1");
    foreignKey.addColumn(new Column("id"));
    foreignKey.setReferencedTable(new Table("table2"));
    Name schemaName = new Name(new Identifier("-", false), new Identifier("-", false));
    InformationExtractor informationExtractor = Mockito.mock(InformationExtractor.class);
    IdentifierHelper identifierHelper = new IdentifierHelperImpl();
    List<ForeignKeyInformation> fks = new ArrayList<>();
    fks.add(getForeignKeyInformation("table2", "id", "object2Id_2"));
    Mockito.when(informationExtractor.getForeignKeys(Mockito.any())).thenReturn(fks);
    QualifiedTableName tableName = new QualifiedTableName(schemaName, new Identifier("-", false));
    TableInformation tableInformation = new TableInformationImpl(informationExtractor, identifierHelper, tableName, false, null);
    AbstractSchemaMigrator schemaMigrator = new SchemaMigrator();
    // Check single-column-key to single-column-key, existing (table1.objectId => table2.id)
    boolean found = (boolean) method.invoke(schemaMigrator, foreignKey, tableInformation);
    Assert.assertTrue("Key should be found", found);
}
Also used : QualifiedTableName(org.hibernate.boot.model.relational.QualifiedTableName) Table(org.hibernate.mapping.Table) ArrayList(java.util.ArrayList) Method(java.lang.reflect.Method) ForeignKey(org.hibernate.mapping.ForeignKey) Name(org.hibernate.boot.model.relational.Namespace.Name) QualifiedTableName(org.hibernate.boot.model.relational.QualifiedTableName) IdentifierHelper(org.hibernate.engine.jdbc.env.spi.IdentifierHelper) ForeignKeyInformation(org.hibernate.tool.schema.extract.spi.ForeignKeyInformation) Identifier(org.hibernate.boot.model.naming.Identifier) TableInformationImpl(org.hibernate.tool.schema.extract.internal.TableInformationImpl) AbstractSchemaMigrator(org.hibernate.tool.schema.internal.AbstractSchemaMigrator) Column(org.hibernate.mapping.Column) InformationExtractor(org.hibernate.tool.schema.extract.spi.InformationExtractor) TableInformation(org.hibernate.tool.schema.extract.spi.TableInformation) AbstractSchemaMigrator(org.hibernate.tool.schema.internal.AbstractSchemaMigrator) Test(org.junit.Test)

Example 2 with TableInformationImpl

use of org.hibernate.tool.schema.extract.internal.TableInformationImpl in project hibernate-orm by hibernate.

the class CheckForExistingForeignKeyTest method testForeignKeyWithoutName.

/**
 * If the key has no name it should never be found. Result is that those keys are always recreated. But keys always
 * have a name so this is no problem.
 *
 * @throws NoSuchMethodException - error
 * @throws SecurityException - error
 * @throws IllegalAccessException - error
 * @throws IllegalArgumentException - error
 * @throws InvocationTargetException - error
 */
@Test
public void testForeignKeyWithoutName() throws NoSuchMethodException, SecurityException, IllegalAccessException, IllegalArgumentException, InvocationTargetException {
    // Get the private method
    Method method = AbstractSchemaMigrator.class.getDeclaredMethod("checkForExistingForeignKey", ForeignKey.class, TableInformation.class);
    method.setAccessible(true);
    // foreignKey name with same name should match
    ForeignKey foreignKey = new ForeignKey();
    TableInformation tableInformation = new TableInformationImpl(null, null, null, false, null);
    boolean found = (boolean) method.invoke(new SchemaMigrator(), foreignKey, tableInformation);
    Assert.assertFalse("Key should not be found", found);
}
Also used : TableInformationImpl(org.hibernate.tool.schema.extract.internal.TableInformationImpl) AbstractSchemaMigrator(org.hibernate.tool.schema.internal.AbstractSchemaMigrator) TableInformation(org.hibernate.tool.schema.extract.spi.TableInformation) Method(java.lang.reflect.Method) ForeignKey(org.hibernate.mapping.ForeignKey) Test(org.junit.Test)

Example 3 with TableInformationImpl

use of org.hibernate.tool.schema.extract.internal.TableInformationImpl in project hibernate-orm by hibernate.

the class CheckForExistingForeignKeyTest method testKeyWithSameNameNotExists.

/**
 * Check detection of existing foreign keys with the same name exists.
 *
 * @throws SecurityException - error
 * @throws NoSuchMethodException - error
 * @throws InvocationTargetException - error
 * @throws IllegalArgumentException - error
 * @throws IllegalAccessException - error
 * @throws NoSuchFieldException - error
 */
@Test
public void testKeyWithSameNameNotExists() throws NoSuchMethodException, SecurityException, IllegalAccessException, IllegalArgumentException, InvocationTargetException, NoSuchFieldException {
    // Get the private method
    Method method = AbstractSchemaMigrator.class.getDeclaredMethod("checkForExistingForeignKey", ForeignKey.class, TableInformation.class);
    method.setAccessible(true);
    ForeignKey foreignKey = new ForeignKey();
    foreignKey.setName("objectId2id_1");
    foreignKey.addColumn(new Column("id"));
    foreignKey.setReferencedTable(new Table("table2"));
    InformationExtractor informationExtractor = Mockito.mock(InformationExtractor.class);
    IdentifierHelper identifierHelper = new IdentifierHelperImpl();
    List<ForeignKeyInformation> fks = new ArrayList<>();
    fks.add(new ForeignKeyInformationImpl(new Identifier("objectId2id_2", false), new ArrayList<>()));
    Mockito.when(informationExtractor.getForeignKeys(Mockito.any())).thenReturn(fks);
    Name schemaName = new Name(new Identifier("-", false), new Identifier("-", false));
    QualifiedTableName tableName = new QualifiedTableName(schemaName, new Identifier("-", false));
    TableInformation tableInformation = new TableInformationImpl(informationExtractor, identifierHelper, tableName, false, null);
    // foreignKey name with same name should match
    boolean found = (boolean) method.invoke(new SchemaMigrator(), foreignKey, tableInformation);
    Assert.assertFalse("Key should not be found", found);
}
Also used : QualifiedTableName(org.hibernate.boot.model.relational.QualifiedTableName) Table(org.hibernate.mapping.Table) ArrayList(java.util.ArrayList) Method(java.lang.reflect.Method) ForeignKey(org.hibernate.mapping.ForeignKey) IdentifierHelper(org.hibernate.engine.jdbc.env.spi.IdentifierHelper) Name(org.hibernate.boot.model.relational.Namespace.Name) QualifiedTableName(org.hibernate.boot.model.relational.QualifiedTableName) ForeignKeyInformation(org.hibernate.tool.schema.extract.spi.ForeignKeyInformation) Identifier(org.hibernate.boot.model.naming.Identifier) TableInformationImpl(org.hibernate.tool.schema.extract.internal.TableInformationImpl) AbstractSchemaMigrator(org.hibernate.tool.schema.internal.AbstractSchemaMigrator) Column(org.hibernate.mapping.Column) ForeignKeyInformationImpl(org.hibernate.tool.schema.extract.internal.ForeignKeyInformationImpl) InformationExtractor(org.hibernate.tool.schema.extract.spi.InformationExtractor) TableInformation(org.hibernate.tool.schema.extract.spi.TableInformation) Test(org.junit.Test)

Example 4 with TableInformationImpl

use of org.hibernate.tool.schema.extract.internal.TableInformationImpl in project hibernate-orm by hibernate.

the class CheckForExistingForeignKeyTest method getColumnInformation.

private ColumnInformation getColumnInformation(String tableName, String columnName) {
    Name schemaName = new Name(new Identifier("-", false), new Identifier("-", false));
    TableInformation containingTableInformation = new TableInformationImpl(null, null, new QualifiedTableName(schemaName, new Identifier(tableName, false)), false, null);
    Identifier columnIdentifier = new Identifier(columnName, false);
    int typeCode = 0;
    String typeName = null;
    int columnSize = 0;
    int decimalDigits = 0;
    TruthValue nullable = null;
    ColumnInformationImpl columnInformation = new ColumnInformationImpl(containingTableInformation, columnIdentifier, typeCode, typeName, columnSize, decimalDigits, nullable);
    return columnInformation;
}
Also used : QualifiedTableName(org.hibernate.boot.model.relational.QualifiedTableName) Identifier(org.hibernate.boot.model.naming.Identifier) TableInformationImpl(org.hibernate.tool.schema.extract.internal.TableInformationImpl) TruthValue(org.hibernate.boot.model.TruthValue) TableInformation(org.hibernate.tool.schema.extract.spi.TableInformation) ColumnInformationImpl(org.hibernate.tool.schema.extract.internal.ColumnInformationImpl) Name(org.hibernate.boot.model.relational.Namespace.Name) QualifiedTableName(org.hibernate.boot.model.relational.QualifiedTableName)

Example 5 with TableInformationImpl

use of org.hibernate.tool.schema.extract.internal.TableInformationImpl in project hibernate-orm by hibernate.

the class CheckForExistingForeignKeyTest method testCheckForNotExistingForeignKeyOne2One.

/**
 * Check detection of not existing foreign key with the same mappings for a simple mapping (table1.objectId =>
 * table2.id).
 *
 * @throws SecurityException - error
 * @throws NoSuchMethodException - error
 * @throws InvocationTargetException - error
 * @throws IllegalArgumentException - error
 * @throws IllegalAccessException - error
 * @throws NoSuchFieldException - error
 */
@Test
public void testCheckForNotExistingForeignKeyOne2One() throws NoSuchMethodException, SecurityException, IllegalAccessException, IllegalArgumentException, InvocationTargetException, NoSuchFieldException {
    // Get the private method
    Method method = AbstractSchemaMigrator.class.getDeclaredMethod("checkForExistingForeignKey", ForeignKey.class, TableInformation.class);
    method.setAccessible(true);
    ForeignKey foreignKey = new ForeignKey();
    // Make sure the match is not successful based on key name
    foreignKey.setName("objectId2id_1");
    foreignKey.addColumn(new Column("id"));
    foreignKey.setReferencedTable(new Table("table2"));
    Name schemaName = new Name(new Identifier("-", false), new Identifier("-", false));
    InformationExtractor informationExtractor = Mockito.mock(InformationExtractor.class);
    IdentifierHelper identifierHelper = new IdentifierHelperImpl();
    List<ForeignKeyInformation> fks = new ArrayList<>();
    fks.add(getForeignKeyInformation("table2", "blah", "blahKey_001"));
    fks.add(getForeignKeyInformation("table3", "id", "blahKey_002"));
    fks.add(getForeignKeyInformation("table3", "blah", "blahKey_003"));
    Mockito.when(informationExtractor.getForeignKeys(Mockito.any())).thenReturn(fks);
    QualifiedTableName tableName = new QualifiedTableName(schemaName, new Identifier("-", false));
    TableInformation tableInformation = new TableInformationImpl(informationExtractor, identifierHelper, tableName, false, null);
    AbstractSchemaMigrator schemaMigrator = new SchemaMigrator();
    // Check single-column-key to single-column-key, existing (table1.objectId => table2.id)
    boolean found = (boolean) method.invoke(schemaMigrator, foreignKey, tableInformation);
    Assert.assertFalse("Key should not be found", found);
}
Also used : QualifiedTableName(org.hibernate.boot.model.relational.QualifiedTableName) Table(org.hibernate.mapping.Table) ArrayList(java.util.ArrayList) Method(java.lang.reflect.Method) ForeignKey(org.hibernate.mapping.ForeignKey) Name(org.hibernate.boot.model.relational.Namespace.Name) QualifiedTableName(org.hibernate.boot.model.relational.QualifiedTableName) IdentifierHelper(org.hibernate.engine.jdbc.env.spi.IdentifierHelper) ForeignKeyInformation(org.hibernate.tool.schema.extract.spi.ForeignKeyInformation) Identifier(org.hibernate.boot.model.naming.Identifier) TableInformationImpl(org.hibernate.tool.schema.extract.internal.TableInformationImpl) AbstractSchemaMigrator(org.hibernate.tool.schema.internal.AbstractSchemaMigrator) Column(org.hibernate.mapping.Column) InformationExtractor(org.hibernate.tool.schema.extract.spi.InformationExtractor) TableInformation(org.hibernate.tool.schema.extract.spi.TableInformation) AbstractSchemaMigrator(org.hibernate.tool.schema.internal.AbstractSchemaMigrator) Test(org.junit.Test)

Aggregations

TableInformationImpl (org.hibernate.tool.schema.extract.internal.TableInformationImpl)6 TableInformation (org.hibernate.tool.schema.extract.spi.TableInformation)6 Method (java.lang.reflect.Method)5 Identifier (org.hibernate.boot.model.naming.Identifier)5 Name (org.hibernate.boot.model.relational.Namespace.Name)5 QualifiedTableName (org.hibernate.boot.model.relational.QualifiedTableName)5 ForeignKey (org.hibernate.mapping.ForeignKey)5 AbstractSchemaMigrator (org.hibernate.tool.schema.internal.AbstractSchemaMigrator)5 Test (org.junit.Test)5 ArrayList (java.util.ArrayList)4 IdentifierHelper (org.hibernate.engine.jdbc.env.spi.IdentifierHelper)4 Column (org.hibernate.mapping.Column)4 Table (org.hibernate.mapping.Table)4 ForeignKeyInformation (org.hibernate.tool.schema.extract.spi.ForeignKeyInformation)4 InformationExtractor (org.hibernate.tool.schema.extract.spi.InformationExtractor)4 ForeignKeyInformationImpl (org.hibernate.tool.schema.extract.internal.ForeignKeyInformationImpl)2 TruthValue (org.hibernate.boot.model.TruthValue)1 ColumnInformationImpl (org.hibernate.tool.schema.extract.internal.ColumnInformationImpl)1