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
50 lines
1.6 KiB
Go
50 lines
1.6 KiB
Go
// Copyright © 2023 Ory Corp
|
|
// SPDX-License-Identifier: Apache-2.0
|
|
|
|
package cleanup
|
|
|
|
import (
|
|
"fmt"
|
|
"time"
|
|
|
|
"github.com/ory/x/cmdx"
|
|
|
|
"github.com/spf13/cobra"
|
|
|
|
"github.com/ory/kratos/driver/config"
|
|
|
|
"github.com/ory/x/configx"
|
|
)
|
|
|
|
// cleanupSqlCmd represents the sql command
|
|
func NewCleanupSQLCmd() *cobra.Command {
|
|
c := &cobra.Command{
|
|
Use: "sql <database-url>",
|
|
Short: "Cleanup sql database from expired flows and sessions",
|
|
Long: `Run this command as frequently as you need.
|
|
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 cleanup sql -e
|
|
### WARNING ###
|
|
Before running this command on an existing database, create a back up!
|
|
`,
|
|
RunE: func(cmd *cobra.Command, args []string) error {
|
|
err := NewCleanupHandler().CleanupSQL(cmd, args)
|
|
if err != nil {
|
|
_, _ = fmt.Fprintln(cmd.OutOrStdout(), err)
|
|
return cmdx.FailSilently(cmd)
|
|
}
|
|
return nil
|
|
},
|
|
}
|
|
|
|
configx.RegisterFlags(c.PersistentFlags())
|
|
c.Flags().BoolP("read-from-env", "e", true, "If set, reads the database connection string from the environment variable DSN or config file key dsn.")
|
|
c.Flags().Duration(config.ViperKeyDatabaseCleanupSleepTables, time.Minute, "How long to wait between each table cleanup")
|
|
c.Flags().IntP(config.ViperKeyDatabaseCleanupBatchSize, "b", 100, "Set the number of records to be cleaned per run")
|
|
c.Flags().Duration("keep-last", 0, "Don't remove records younger than")
|
|
return c
|
|
}
|