Set of simple utilities for my nuxt + postgres projects.
# In your nuxt project
git submodule add <this-repo> <target-path>
# Either
cd <target-path>
./init .
# Or
./<target-path>/init <target-path>
- Creates typescript + zod schema notations from the database schema.
# In your nuxt project
./<target-path>/generate <target-path> <db-connection-string> <schema-folder-name>
- Creates migration files from the database schema.
# Initialize first
./<target-path>/migrator init <target-path> <db-connection-string> <migrations-folder-name>
# Creates init.sql and journal.json
# Make new migration
./<target-path>/migrator make <target-path> <db-connection-string> <migrations-folder-name> <migration-name>
# Creates a new migration file xxxx<migration-name>.sql
# Updates journal.json
# Apply migrations
./<target-path>/migrator execute <target-path> <db-connection-string> <migrations-folder-name>
- I highly recommend creating your own
generate
andmigrator
scripts at the project level so you don't always need to type down all the parameters that (besides new migrations name) are constant for each project. - At this moment I'm not planing to develop the library for more than my own needs.