SQL : Put schema constraints into bean model

Bug #623994 reported by Timo Westkämper on 2010-08-25
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Querydsl
Fix Released
Medium
Unassigned

Bug Description

 Put schema constraints into bean model in annotation form (nullability, size, regex constraints ?!?)

Changed in querydsl:
importance: Undecided → Medium
Changed in querydsl:
milestone: none → 2.0
summary: - SQL: Put schema constraints into bean model
+ SQL : Put schema constraints into bean model

The annotation set to be used would be the annoations for Bean Validation : http://relation.to/Bloggers/BeanValidationSneakPeekPartI

Here is a mapping from the DatabaseMetaData getColumns values

COLUMN_SIZE -> @Max(n)
NULLABLE columnNoNulls -> @NotNull

Currently Max and NotNull are used. Feel free to suggest additions :

@Table("EMPLOYEE")
public class Employee {

    @Column("DATEFIELD")
    private java.sql.Date datefield;

    @Max(50)
    @Column("FIRSTNAME")
    private String firstname;

    @NotNull
    @Column("ID")
    private Integer id;

...

}

Changed in querydsl:
status: New → Fix Committed

Released in 1.9.4

Changed in querydsl:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers