Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add support for custom queries #132

Open
fsalem opened this issue Mar 28, 2023 · 1 comment
Open

Add support for custom queries #132

fsalem opened this issue Mar 28, 2023 · 1 comment
Labels
help wanted Extra attention is needed

Comments

@fsalem
Copy link

fsalem commented Mar 28, 2023

The current version of Kotysa does not support altering a table or writing custom queries. For migration proposes, it could be essential to adding, removing, or updating columns without removing the the whole table and recreate it again.

@pull-vert pull-vert added the help wanted Extra attention is needed label Apr 4, 2023
@pull-vert
Copy link
Contributor

pull-vert commented Apr 4, 2023

Hi @fsalem
This is perfectly exact ! Initially I provided very basic ability to create and delete tables in Kotysa for testing purpose, to populate a test database for example, based on your entities.

I don't think an ORM should provide a full migration database support, this is another type of tooling, that instead of an ORM cannot rely on the entities (that can have a new column, or had a column removed).
The production database modeling and migration must support fine-tuning, optimizations, encoding, checksum verification for migration scripts etc.
The JVM already have great tools for this specific need : Liquibase, Flyway and others. For now I advise to use these tools for database migration, and Kotysa for the queries.

I add the "help wanted" label, so if someone has the motivation to code this feature, a PR would be welcome !

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
help wanted Extra attention is needed
Projects
None yet
Development

No branches or pull requests

2 participants