Formed in 2009, the Archive Team (not to be confused with the archive.org Archive-It Team) is a rogue archivist collective dedicated to saving copies of rapidly dying or deleted websites for the sake of history and digital heritage. The group is 100% composed of volunteers and interested parties, and has expanded into a large amount of related projects for saving online and digital history.
Fetching latest commit…
sql-to-jdl
Tool to translate SQL databases to JDL format of jHipster (Created due to existing databases to be generated with jHipster and build angular-java web)
Why not use tools like UML provided on jHipster?
- JDL from web is ok for a few entities but not for more than 100 entities and relations
- UML software and xml exporters could have worked (other tools on jHipster) but:
- already many databases in production to be exported in JDL (faster to generate the JDL from it)
- already working UML design with MySQL Workbench
How to use
Set properties file:
- Schema name to export
- Tables names to be ignored
- Path of export file
After JDL file is generated
Still have some manual steps to do:
- review relations:
- ManyToMany
- Owner side display field
- Inverse side field name and display field
- Bidirectional or not
- add values to enums
- review validations of entities
Use of
- jOOQ
- Spring boot
Default specific rules
Table is treated as enum if only 2 columns and both are: "id" AND ("code" OR "name")
Table is treated as ManyToMany if only 2 columns and both are foreign keys