Skip to content

Latest commit

 

History

History
151 lines (106 loc) · 5.56 KB

README.md

File metadata and controls

151 lines (106 loc) · 5.56 KB
Raw

OsalvadorCodeGenerators

OsalvadorCodeGenerators is a web application for source code generation from database given the definition (DDL) of table and automatically create Java Code (JPA Entity, JavaBean, View Model, JdbcTemplate DAO...) from these tables.

The generator is defined in templates of tePLSQL (JSP and PSP like syntax (<%%>)) and the result is shown on the screen and can be downloaded. The web application has been developed with APEX at apex.oracle.com. Currently I have included the templates that I usually use in my work, but the templates are easily customizable.

Online Code Generator Web Application

The aplication on APEX: Osalvador Live Code Generators

Demos

Java POJO Generator

The template: pojo.teplsql

Java Bean Generator

The template: bean.teplsql

Java JPA Entity Generator

The template: jpa-entity.teplsql

JdbcTemplate DAO Generator

The Interface template: jdbctemplate-dao-interface.teplsql

The Interface Implementation template: jdbctemplate-dao-implement.teplsql

Swagger YAML Generator

The template: swagger.yaml.teplsql

Why another code generator?

I usually use this type of code generators to create models, entities or DTOs based on database tables. The problem with these code generators is that they require instrumentation (installation and configuration) and a learning curve that is sometimes greater than the time they saved. In addition these generators are used occasionally, having to re-read the documentation again.

With a web application we save all these previous steps and focus on what really matters to us, get the boring part of our project, generating these classes.

I am also working on the generation of complete applications based on SpringBoot.

Roadmap

  • Enable the ability to upload a complete DDL script with multiple tables.
  • More templates:
    • Custom templates
    • Spring boot RestFull app
    • Complete JEE CRUD app
    • C# POCO
  • MySQL and Postgres DDL syntax compatibility.

SQL Data Type to Java Mapping Classes

SQL Data Type Java Mapping
VARCHAR2 String
CHAR String
CHARACTER String
LONG String
STRING String
VARCHAR String
RAW byte[]
LONG RAW byte[]
BINARY_INTEGER int
NATURAL int
NATURALN int
PLS_INTEGER int
POSITIVE int
POSITIVEN int
SIGNTYPE int
INT int
INTEGER int
SMALLINT int
DEC BigDecimal
DECIMAL BigDecimal
NUMBER BigDecimal
NUMERIC BigDecimal
DOUBLE PRECISION double
FLOAT double
REAL float
DATE Timestamp
TIMESTAMP Timestamp
INTERVAL String
ROWID RowId
UROWID RowId
CLOB Clob
BLOB Blob
XMLTYPE String

SQL Data Type to Swagger Mapping

SQL Data Type Swagger Type Swagger Format
VARCHAR2 string ``
CHAR string ``
CHARACTER string ``
LONG string ``
STRING string ``
VARCHAR string ``
RAW string byte
LONG RAW string byte
BINARY_INTEGER integer int32
NATURAL integer int32
NATURALN integer int32
PLS_INTEGER integer int32
POSITIVE integer int32
POSITIVEN integer int32
SIGNTYPE integer int32
INT integer int32
INTEGER integer int32
SMALLINT integer int32
DEC number ``
DECIMAL number ``
NUMBER number ``
NUMERIC number ``
DOUBLE PRECISION number double
FLOAT number float
REAL number ``
DATE string date-time
TIMESTAMP string date-time
INTERVAL string string
ROWID string ``
UROWID string ``
CLOB string ``
BLOB string byte
XMLTYPE string ``