-
Notifications
You must be signed in to change notification settings - Fork 0
/
cobr.go
96 lines (81 loc) · 1.96 KB
/
cobr.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
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
package main
import (
"database/sql"
"fmt"
"strconv"
"strings"
_ "github.com/mattn/go-sqlite3"
"github.com/spf13/cobra"
)
func appendTask(db *sql.DB, num int, task string) {
str := "Insert INTO tasks(task) values ('" + task + "')"
statement, _ := db.Prepare(str)
statement.Exec()
}
func displayTask(db *sql.DB) {
str := "SELECT * FROM tasks"
rows, err := db.Query(str)
if err != nil {
fmt.Println("Error querying db")
}
var id int
var task string
for rows.Next() {
rows.Scan(&id, &task)
fmt.Println(id, task)
}
}
func delTask(db *sql.DB, id int) {
//todo add check for valid id before deleting
str := "DELETE FROM tasks where id = " + strconv.Itoa(id)
statement, _ := db.Prepare(str)
statement.Exec()
}
func main() {
var taskNum int = 0
taskMap := make(map[int]string)
db, err := sql.Open("sqlite3", "./tasks.db")
if err != nil {
fmt.Println("error opening db")
fmt.Println(err)
}
var cmdAdd = &cobra.Command{
Use: "add [string to print]",
Short: "Add a task",
Long: `Add a task to the list`,
Args: cobra.MinimumNArgs(1),
Run: func(cmd *cobra.Command, args []string) {
taskMap[taskNum] = strings.Join(args, " ")
appendTask(db, taskNum, taskMap[taskNum])
taskNum++
},
}
var cmdDisplay = &cobra.Command{
Use: "display",
Short: "display all tasks",
Long: `display all tasks created`,
Args: cobra.MinimumNArgs(0),
Run: func(cmd *cobra.Command, args []string) {
displayTask(db)
},
}
var cmdDel = &cobra.Command{
Use: "del [number]",
Short: "delete a task",
Long: `delete an existing task`,
Args: cobra.MinimumNArgs(1),
Run: func(cmd *cobra.Command, args []string) {
/*if len(args) > 1 {
for _, arg := range args {
taskList = append(taskList, strconv.Atoi(stings.arg))
}
}
*/
taskNumber, _ := strconv.Atoi(strings.Join(args, " "))
delTask(db, taskNumber)
},
}
var rootCmd = &cobra.Command{Use: "app"}
rootCmd.AddCommand(cmdAdd, cmdDel, cmdDisplay)
rootCmd.Execute()
}