dbdev icon indicating copy to clipboard operation
dbdev copied to clipboard

feat: add a "dbdev create" command

Open kiwicopple opened this issue 2 years ago • 2 comments

Chore

Describe the chore

(This one is up for debate but I think it would be useful especially for testing environments like GH actions)

The "dbdev install" command adds the TLE to the database but doesn't "enable" the extension. It could be useful to have a command like dbdev create pg_idkit --connection <CONNECTION>" which essentially runs:

CREATE EXTENSION pg_idkit;

Additional context

Add any other context or screenshots that help clarify the task.

kiwicopple avatar Nov 03 '23 18:11 kiwicopple

How about controlling this behavior on install with a flag --create-extension on the existing install command e.g. dbdev install ... --create-extension rather than a separating it?

olirice avatar Nov 03 '23 19:11 olirice

also good!

we might want something for updates too (alter extension ... update to NEW_VERSION);, although I'm not sure how far we need to go down this path - this might also mean that we need something to list the current version

kiwicopple avatar Nov 03 '23 20:11 kiwicopple