Comments (4)
You are using postgresql but I only support mysql.
I think it is possible to support it but you need to check.
Can you try to create postgresql repositories that gives same data contract as current repositories?
Then you can use @ConditionalOnProperty of Spring to either enable postgresql or mysql and add a property in application.yml
(but in fact it might still not compile due to missing jooq classes... -> instead I could include those generated classes in codebase and set jooq as false to auto-generate)
from sql-to-jdl.
Hi Yoann,
thanks for you reply, I completely miss that Postgres is not supported. So, if I'm not wrong, are you suggesting that if InformationSchemaRepository
would be an Interface, it should be enough to rewrite the actual queries taylored on MySQL Information_schema to retrieve from some Postgres metadata system tables:
-
TableRelationInformation
and its properties:
private final String tableName;
private final String columnName;
private final String referencedTableName;
private final String referencedColumnName; -
ColumnInformation
private final String name;
private final String type;
private final String collation;
private final boolean isNullable;
private final boolean isPrimary;
private final boolean isUnique;
private final String defaultValue;
private final String extra;
private final String comment; -
TableInformation
private final String name;
private final String comment;
and finally the list of all table name to feed the getAllTableName
method?
TIA,
R
from sql-to-jdl.
Yes exactly, it would be necessary to have InformationSchemaRepository as an Interface, then use a configuration class that expose beans of that interface, both on Conditional but only one at once (depending on option mysql or postgres).
After there is the issue of compiling the code when jOOQ generated code is missing.
For now you can either simply delete the mysql code in your local pc, do a bridge with postgres and the rest should be alright.
from sql-to-jdl.
Closed as not supported but can be done manually
from sql-to-jdl.
Related Issues (20)
- Convert MySQL cod to use SQL instead of jOOQ HOT 1
- Add support for best guess for relationship display fields HOT 2
- Add support for MsSQL Server
- Add support for Oracle HOT 1
- Add husky git hook to format code before commit HOT 1
- Use Mustache.java to render JDL HOT 2
- Add Lombok to reduce boilerplate code and add a builder pattern HOT 3
- Add ability to disable adding options to the generated JDL HOT 1
- Add support for enforcing creation of entity for many-to-many table HOT 5
- Fix unsupported char in filename for windows HOT 1
- In relation, project generate relation unique key instead primary. HOT 3
- Fix a bug 'relationship name is not synchronized' HOT 5
- Add query to fetch values of enums
- Can't use with Postgresql 15.1 HOT 9
- JdlViewMapperImpl is missing in repo HOT 1
- Getting this error when I run sql-to-jdl HOT 1
- Failed to bind properties under 'application' HOT 1
- Handle reflexive relationships
- Honour the unique attribute for a column
- The elements [application.table-to-export] were left unbound HOT 8
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from sql-to-jdl.