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

Auto create table if table not exists when service startup #3455

Open
Anilople opened this issue Dec 24, 2020 · 1 comment
Open

Auto create table if table not exists when service startup #3455

Anilople opened this issue Dec 24, 2020 · 1 comment
Labels
area/mysql area/operations Information technology operations discussion Categorizes issue as related to discussion feature request Categorizes issue as related to a new feature.

Comments

@Anilople
Copy link
Contributor

Anilople commented Dec 24, 2020

Is your feature request related to a problem? Please describe.

Relate to issue #1424 #2539

User need to run sql manually to initial tables.

Is it possible to auto create those tables?

Describe the solution you'd like

Auto create tables when config service,admin service,portal startup.

Then user didn't need to run sql manually. That could be make operations and deployment more simpler.

Describe alternatives you've considered

Is hibernate support that? Maybe there are some configuration to support that.

Some problem need to consider

  • Is it safe? i.e the influence of old data when services update.
  • How user update their system if table auto create?
@Anilople Anilople added discussion Categorizes issue as related to discussion feature request Categorizes issue as related to a new feature. area/mysql area/operations Information technology operations labels Dec 24, 2020
@nobodyiam
Copy link
Member

Spring Data Jpa can do that, but it is risky to me since the mysql account would have ddl permissions...

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
area/mysql area/operations Information technology operations discussion Categorizes issue as related to discussion feature request Categorizes issue as related to a new feature.
Projects
None yet
Development

No branches or pull requests

2 participants