Tutorials

###I mportant Before any SQLP/SQLMEP/SQLMOP usage, the IDE should be prepared as is described in IDE Setup and Coding Standards.

Basic Tutorials

• 10 minutes Tutorial - new SQLP 1.9.0 smart features
• Simple Tutorial - an introduction to the SQL Processor and a simple usage demo
• CRUD Tutorial - a simple CRUD usage demo
• Associations Tutorial - a simple associations usage demo
• Inheritance Tutorial - a simple inheritance (table per subclass) usage demo
• More Inheritance Tutorial - a simple inheritance (table per class hierarchy) usage demo
• Custom Types Tutorial - a simple custom types usage demo
• Stored Procedures Tutorial - a simple stored procedures usage demo
• IDE Setup and Coding Standards - IDE setup and coding standards for Eclipse / STS
• Catalog (JPA) Sample - a simple web application on top of JPA and Hibernate ORM
• Catalog (Hibernate) Sample - a simple web application on top of Hibernate ORM
• Catalog (Spring) Sample - a simple web application on top of Spring DAO
• Advanced Catalog (Spring) Sample - a simple web application presents the second level cache usage and the SQL Processor execution statistics

The Reference Guide

• Basic META SQL - the META SQL grammar and its usage
• Advanced META SQL - more advanced META SQL usage
• Input values - the dynamic/static input values and their META types
• Mapping rules - the mapping rules grammar and its usage
• Output values - the output values and their META types
• Enumerations - the enumeration based input/output values
• Optional features - the optional features
• Plugin mechanism - the plugins to alter the implementation
• Meta SQL Statements - the artifacts definition in the meta statements file
• Stacks Tutorial - overview of the SQL Processor collaborators (JDBC, Hibernate, Spring)
• Using the API - the primary SQL Processor contracts
• Validation API - the API for the input form validation
• Dynamic SQL Statements and JMX API
• Common processing cache
• Perform a new release - HOWTO perform a new SQL Processor release
• SQLP Archetypes - Maven archetypes to speed up development

The Eclipse Plugin (SQLM*P) Tutorials

• SQLMEP Basic Tutorial - it enables smart artifacts definition/writing
• SQLMOP POJO modelling - POJO modelling and Java classes generation
• SQLMOP POJO generation - POJO model generation based on DB
• SQLMOP POJO generation II - POJO model generation based on DB, II
• SQLMEP META SQL generation - META SQL generation based on DB
• SQLMOP DAO modelling - DAO modelling and Java classes generation
• SQLMOP DAO generation - DAO API generation based on DB
• SQLMEP META SQL generation II - META SQL generation based on DB, II
• SQLMEP SQLMOP Functions and Procedures - Procedures and function model generation

The Improvements

• SQLP 2.2.0 and SQLEP 1.6 Tutorial - the SQL operators, enumerations and annotations
• SQLP 2.2.1 and SQLEP 1.7 Tutorial - improved annotations, modifiers and directives
• SQLP 2.2.2 and SQLEP 1.7.1 Tutorial - optional features in the statement's execution scope, new SQLEP directives
• SQLEP 1.7.3 Tutorial - new SQLEP directives
• SQLEP 1.7.4 Tutorial - extended POJO and DAO grammar, new SQLEP directives
• SQLEP 1.7.5 Tutorial - a possibility to restrict the processed tables list
• SQLEP 1.7.6 Tutorial - new templates for definitions.qry
• SQLEP 1.7.7 Tutorial - database artefacts upper/lowercase conversion
• SQLP 1.9.x Changes Tutorial - changes and improvements in SQLP version 1.9.0
• SQLP 2.2.6 and SQLEP 1.7.8 Tutorial - references (REF) to another optional features, MAP based optional features