Tutorials - hudec/sql-processor GitHub Wiki
###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