diff options
| -rw-r--r-- | license-generator/.env.sample | 63 |
1 files changed, 60 insertions, 3 deletions
diff --git a/license-generator/.env.sample b/license-generator/.env.sample index 325a279..14866f0 100644 --- a/license-generator/.env.sample +++ b/license-generator/.env.sample @@ -2,12 +2,15 @@ export DATABASE_NAME="" export DATABASE_USER="" export DATABASE_PASSWORD="" +export DATABASE_URL="mysql://tcp(localhost:3306)/dome_key" -function migrate () { + +function migrate-create () { local migration_name="$1" - command migrate \ - -database 'mysql://localhost:3306/dome_key' \ + migrate \ + -path migrations \ + -database "$DATABASE_URL" \ create \ -ext sql \ -format '20060102150405' \ @@ -15,3 +18,57 @@ function migrate () { mv *.sql migrations/ } + +function migrate-goto () { + local version="$1" + + migrate \ + -path migrations \ + -database "$DATABASE_URL" \ + goto \ + "$version" +} + +function migrate-up () { + local count="$1" + + migrate \ + -path migrations \ + -database "$DATABASE_URL" \ + up \ + "$count" +} + +function migrate-down () { + local count="$1" + + migrate \ + -path migrations \ + -database "$DATABASE_URL" \ + down \ + "$count" +} + +function migrate-drop () { + migrate \ + -path migrations \ + -database "$DATABASE_URL" \ + drop +} + +function migrate-force () { + local version="$1" + + migrate \ + -path migrations \ + -database "$DATABASE_URL" \ + force \ + "$version" +} + +function migrate-version () { + migrate \ + -path migrations \ + -database "$DATABASE_URL" \ + version +} |