Examples with Formula org.hibernate.mapping.Formula used on opensource projects

Example 6 with Formula

use of org.hibernate.mapping.Formula in project hibernate-orm by hibernate.

the class ComponentTest method afterMetadataBuilt.

@Override
protected void afterMetadataBuilt(Metadata metadata) {
    // Oracle and Postgres do not have year() functions, so we need to
    // redefine the 'User.person.yob' formula
    //
    // consider temporary until we add the capability to define
    // mapping formulas which can use dialect-registered functions...
    PersistentClass user = metadata.getEntityBinding(User.class.getName());
    org.hibernate.mapping.Property personProperty = user.getProperty("person");
    Component component = (Component) personProperty.getValue();
    Formula f = (Formula) component.getProperty("yob").getValue().getColumnIterator().next();
    SQLFunction yearFunction = metadata.getDatabase().getJdbcEnvironment().getDialect().getFunctions().get("year");
    if (yearFunction == null) {
        // the dialect not know to support a year() function, so rely on the
        // ANSI SQL extract function
        f.setFormula("extract( year from dob )");
    } else {
        List args = new ArrayList();
        args.add("dob");
        f.setFormula(yearFunction.render(StandardBasicTypes.INTEGER, args, null));
    }
}

Example 7 with Formula

use of org.hibernate.mapping.Formula in project hibernate-orm by hibernate.

the class DiscriminatorFormulaTest method testDiscriminatorFormulaInAuditTable.

@Test
public void testDiscriminatorFormulaInAuditTable() {
    assert parentAudit.getDiscriminator().hasFormula();
    Iterator iterator = parentAudit.getDiscriminator().getColumnIterator();
    while (iterator.hasNext()) {
        Object o = iterator.next();
        if (o instanceof Formula) {
            Formula formula = (Formula) o;
            Assert.assertEquals(ParentEntity.DISCRIMINATOR_QUERY, formula.getText());
            return;
        }
    }
    assert false;
}