SQLEP 2.0.0 Tutorial

###The tutorial is updated for SQLP 2.5.0+ and SQLEP 2.0.0+

###Introduction SQLEP grammar syntax have been completely rewritten. The POJO and DAO modeling syntax is not compatible with the previous versions. The primary goal of this change is to model APP layer. This grammar redefinition is one of more steps toward this goal.

To move grammar closer to Java syntax, we have a new set of Meta Control Directives instead of special syntax used in previous SQLEP versions. The Meta Control Directive start with a character #, similar to Java annotations approach (@). Every Meta Control Directive is used in context of some modeling element. So, based on target context, we have

###Package directives

• #Implementation TODO

###Annotation directives

• #Conflict TODO
• #Static TODO
• #Constructor TODO
• #Standard TODO
• #Setter TODO
• #Getter TODO
• #Attribute TODO

###Implements directives

• #Generics TODO

###POJO and Enum directives TODO

• #ToString TODO
• #Index TODO
• #Operators TODO
• #Serializable TODO
• #InheritanceChild TODO
• #Equals TODO
• #HashCode TODO

###POJO attributes directives

• #Required TODO
• #PrimaryKey TODO
• #InheritanceDiscriminator TODO
• #Index TODO
• #Version TODO
• #UpdateCol TODO
• #CreateCol TODO
• #ToInit TODO
• #EnumInit TODO
• #IsDef TODO
• #EnumDef TODO

###Enum attributes directives

• #Values TODO

###DAO directives

• #Serializable TODO
• #InheritanceHandler TODO
• #CRUD TODO
• #Query TODO
• #FunctionCallQuery TODO
• #ProcedureCallQuery TODO
• #FunctionCall TODO
• #ProcedureUpdate TODO
• #FunctionQuery TODO

The sample code can be seen at

• https://github.com/hudec/sql-processor/blob/master/simple-samples/simple-hsqldb/src/main/resources/pojo.qry
• https://github.com/hudec/sql-processor/blob/master/simple-samples/simple-hsqldb/src/main/resources/dao.qry

All the SQLP samples in version 2.4.2 have been rewritten using the new SQLEP grammar.