Support database bootstrap in the admin tool

[dimas-b]

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

Currently the Admin Tool has a bootstrap command that initializes "realms".

However, currently the JDBC persistence allows multiple realms to be stored within the same JDBC schema.

Therefore, managing the database schema is a high-level concern than managing realms.

It would be nice to have a separate command in the Admin Tool dedicated specifically to running one-time Persistence setup tasks (e.g. creating JDBC schema).

Describe the solution you'd like

No response

Describe alternatives you've considered

No response

Additional context

No response

[sclee01]

@dimas-b Makes sense. Schema setup should ideally come before realm init.
Mind if I pick this up and work on a separate command?

[dimas-b]

@sclee01 : absolutely - thx for contributing :)

[sclee01]

@dimas-b

I looked into this and it seems that schema setup isn’t handled solely by the Admin Tool.
The bootstrapRealms() method in MetaStoreManagerFactory currently runs the schema initialization script every time it's called — for each realm.

To support a proper one-time setup via a new Admin Tool command, we’d need to refactor this logic and move schema setup into a separate method (e.g. setupSchema(SchemaOptions)).
Since MetaStoreManagerFactory is an interface, this would also require changes across related implementations and test classes.

Just wanted to check if you're okay with this broader scope before proceeding further.

[dimas-b]

@sclee01 : I agree with your assessment :)

I'd personally prefer to introduce new interfaces dedicated to bootstrapping and schema setup so as to keep MetaStoreManagerFactory to routine runtime concerns (those that pertain to every API call).

Since this change is going to be touching old core interfaces (which is ok, IMHO), it might be worth mentioning your PR on the dev email list (when you have it) for visibility.