-
Notifications
You must be signed in to change notification settings - Fork 22
/
command.go
70 lines (61 loc) · 1.77 KB
/
command.go
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
package deletestudy
import (
"os"
"github.com/c-bata/goptuna/internal/sqlalchemy"
"github.com/c-bata/goptuna/rdb.v2"
"github.com/spf13/cobra"
)
// GetCommand returns the cobra's command for create-study sub-command.
func GetCommand() *cobra.Command {
command := &cobra.Command{
Use: "delete-study",
Short: "Delete a study in your relational database storage.",
Example: " goptuna delete-study --storage sqlite:///example.db --study study",
Run: func(cmd *cobra.Command, args []string) {
storageURL, err := cmd.Flags().GetString("storage")
if err != nil {
cmd.PrintErrln(err)
os.Exit(1)
}
if storageURL == "" {
cmd.PrintErrln("Storage URL is specified neither in config file nor --storage option.")
os.Exit(1)
}
studyName, err := cmd.Flags().GetString("study")
if err != nil {
cmd.PrintErrln(err)
os.Exit(1)
}
db, err := sqlalchemy.GetGormDBFromURL(storageURL, nil)
if err != nil {
cmd.PrintErrln(err)
os.Exit(1)
}
// Enable cascade on delete
if db.Dialector.Name() == "sqlite" {
err = db.Exec("PRAGMA foreign_keys = ON").Error
if err != nil {
cmd.PrintErrln(err)
os.Exit(1)
}
}
storage := rdb.NewStorage(db)
studyID, err := storage.GetStudyIDFromName(studyName)
if err != nil {
cmd.PrintErrln(err)
os.Exit(1)
}
err = storage.DeleteStudy(studyID)
if err != nil {
cmd.PrintErrln(err)
os.Exit(1)
}
},
}
command.Flags().StringP(
"storage", "", "", "DB URL specified in Engine Database URL format of SQLAlchemy (e.g. sqlite:///example.db). See https://docs.sqlalchemy.org/en/13/core/engines.html for more details.")
command.Flags().StringP(
"study", "", "",
"A human-readable name of a study to distinguish it from others.")
return command
}