@Formula("abs(locationEnd - locationStart)") public int getDistance() { return distance; }
if ( formulaAnn != null ) { Ejb3Column formulaColumn = new Ejb3Column(); formulaColumn.setFormula( formulaAnn.value() ); formulaColumn.setImplicit( false ); formulaColumn.setBuildingContext( context );
private void init() { this.primaryKey = field.isAnnotationPresent(Id.class) || field.isAnnotationPresent(PrimaryKey.class); this.versionable = field.isAnnotationPresent(Version.class); this.javaProperty = field.getName(); this.javaType = field.getType(); this.columnName = PersistentRecognizer.getColumnName(field); if (field.isAnnotationPresent(Column.class)) { Column column = field.getAnnotation(Column.class); this.insertable = column.insertable(); this.updatable = column.updatable(); } if (field.isAnnotationPresent(Formula.class)) { Formula formula = field.getAnnotation(Formula.class); this.formulable = true; this.formula = formula.value(); this.insertable = false; this.updatable = false; } if (field.isAnnotationPresent(Enumerated.class)) { this.enumerated = true; this.enumeratedType = field.getAnnotation(Enumerated.class).value(); } resolveJdbc(); resolveTypeHandler(); }
@Formula("CAST(DISPLAY_CODE AS FLOAT)") public Integer getDisplayCodeAsFloat() { return displayCodeAsFloat; }
if ( formulaAnn != null ) { Ejb3Column formulaColumn = new Ejb3Column(); formulaColumn.setFormula( formulaAnn.value() ); formulaColumn.setImplicit( false ); formulaColumn.setMappings( mappings );
@Formula("CAST(DISPLAY_CODE AS INTEGER)") public Integer getDisplayCodeAsInteger() { return displayCodeAsInteger; }
if ( formulaAnn != null ) { Ejb3Column formulaColumn = new Ejb3Column(); formulaColumn.setFormula( formulaAnn.value() ); formulaColumn.setImplicit( false ); formulaColumn.setMappings( mappings );
@Entity public static class EntityWithIdAndFormula { @Id @Formula( value = "VALUE" ) public Integer id; } }
if ( formulaAnn != null ) { Ejb3Column formulaColumn = new Ejb3Column( context ); formulaColumn.setFormula( formulaAnn.value() ); formulaColumn.setImplicit( false ); formulaColumn.setPropertyHolder( propertyHolder );
@Formula(value = "credit * rate") private Double interest;
if ( formulaAnn != null ) { Ejb3Column formulaColumn = new Ejb3Column(); formulaColumn.setFormula( formulaAnn.value() ); formulaColumn.setImplicit( false ); formulaColumn.setMappings( mappings );
@Formula("balance/(select sum(c.balance) from Customer c where c.vip = {alias}.vip)") private BigDecimal percentage;
if ( formulaAnn != null ) { Ejb3Column formulaColumn = new Ejb3Column(); formulaColumn.setFormula( formulaAnn.value() ); formulaColumn.setImplicit( false ); formulaColumn.setMappings( mappings );
@Formula("( SELECT CASE WHEN c.type = 'owner' THEN c.firstname + ' ' + c.lastname END FROM contacts c where c.folder_id = id )") public String owner;
private Set<Lens> lenses; private String name; @Formula("lower(name)") private String lowerName;
public Bar bar; @Formula("CASE WHEN (\n" + " EXISTS (\n" + " SELECT *\n"
private Trimmed trimmed; @Formula("upper('a')") @Enumerated(EnumType.STRING) private Trimmed formula;
@Formula( "upper(name)" ) String upperCaseName;
@Override @Formula("(select count(*) from recording_log where recording_log.session_id = id)") public int getLogsCount() { return logsCount; }
@Formula("(case when customer_companyname is not null then customer_companyname else customer_surname || ' ' || customer_firstname end)") public String getCustomerName() { return customerName; }