c60cc7ca75
Some checks failed
CI / Run tests and lints (push) Failing after 29s
CI / Build CLI docs (push) Has been skipped
CI / Run Playwright end-to-end tests (mysql) (push) Failing after 3s
CI / Run Playwright end-to-end tests (postgres) (push) Failing after 2s
CI / Run Playwright end-to-end tests (sqlite) (push) Failing after 3s
CodeQL / Analyze (go) (push) Failing after 4s
CodeQL / Analyze (javascript) (push) Failing after 3s
Docker Image Scanners / scanners (push) Failing after 4s
Synchronize Issue Labels / Synchronize Issue Labels (push) Has been skipped
CI / Run end-to-end tests (postgres) (push) Failing after 19s
CI / Run end-to-end tests (sqlite) (push) Failing after 2s
CI / Run Playwright end-to-end tests (cockroach) (push) Failing after 2s
CI / Draft newsletter (push) Has been skipped
CI / Generate release (push) Has been skipped
CI / Pending approval Slack notification (push) Has been skipped
CI / Send newsletter (push) Has been skipped
46 lines
1.5 KiB
Go
46 lines
1.5 KiB
Go
// Copyright © 2023 Ory Corp
|
|
// SPDX-License-Identifier: Apache-2.0
|
|
|
|
package migrate
|
|
|
|
import (
|
|
"github.com/spf13/cobra"
|
|
|
|
"github.com/ory/kratos/driver"
|
|
"github.com/ory/x/configx"
|
|
)
|
|
|
|
func NewMigrateSQLCmd(opts ...driver.RegistryOption) *cobra.Command {
|
|
c := &cobra.Command{
|
|
Use: "sql [database-url]",
|
|
Deprecated: "Please use `kratos migrate sql up|down|status` instead.",
|
|
Short: "Create SQL schemas and apply migration plans",
|
|
Long: `Run this command on a fresh SQL installation and when you upgrade Ory Kratos to a new minor version.
|
|
|
|
It is recommended to run this command close to the SQL instance (e.g. same subnet) instead of over the public internet.
|
|
This decreases risk of failure and decreases time required.
|
|
|
|
You can read in the database URL using the -e flag, for example:
|
|
export DSN=...
|
|
kratos migrate sql -e
|
|
|
|
### WARNING ###
|
|
|
|
Before running this command on an existing database, create a back up!
|
|
`,
|
|
RunE: func(cmd *cobra.Command, args []string) error {
|
|
return NewMigrateHandler().MigrateSQLUp(cmd, args, opts...)
|
|
},
|
|
}
|
|
|
|
configx.RegisterFlags(c.PersistentFlags())
|
|
c.PersistentFlags().BoolP("read-from-env", "e", false, "If set, reads the database connection string from the environment variable DSN or config file key dsn.")
|
|
c.Flags().BoolP("yes", "y", false, "If set all confirmation requests are accepted without user interaction.")
|
|
|
|
c.AddCommand(NewMigrateSQLStatusCmd(opts...))
|
|
c.AddCommand(NewMigrateSQLUpCmd(opts...))
|
|
c.AddCommand(NewMigrateSQLDownCmd(opts...))
|
|
|
|
return c
|
|
}
|