-
Notifications
You must be signed in to change notification settings - Fork 0
/
sqlite.go
82 lines (76 loc) · 2.04 KB
/
sqlite.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
package main
import (
"database/sql"
"fmt"
"log"
"os"
"strconv"
"time"
_ "github.com/mattn/go-sqlite3"
)
// apt-get -y update; apt-get -y install sqlite3
type Table struct {
Id int
Text string
Time int64
}
// go run sqlite.go create
// go run sqlite.go insert data1
// go run sqlite.go insert data2
// go run sqlite.go insert data3
// go run sqlite.go csv
func main() {
db, err := sql.Open("sqlite3", "./db.sqlite")
if err != nil {
log.Fatal("Error: %v", err)
return
}
defer db.Close()
if len(os.Args) < 2 {
log.Fatal("Error: no mode set")
return
}
mode := os.Args[1]
var qu Table
if mode == "select" {
q, err := db.Query("SELECT * FROM \"main\".\"test\" ORDER BY time DESC LIMIT 1;")
if err != nil {
log.Printf("Error: while getting data: %s\n", err)
} else {
q.Next()
err = q.Scan(&qu.Id, &qu.Text, &qu.Time)
if err != nil {
log.Printf("Error: while getting row data: %s\n", err)
}
fmt.Println("Last inserted data is: " + qu.Text)
t := time.Unix(qu.Time, 0)
fmt.Println("Inserted on " + t.Format(time.RFC1123Z))
}
} else if mode == "create" {
result, err := db.Exec("CREATE TABLE \"main\".\"test\" (`id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, \"text\" TEXT, \"time\" TEXT) ")
fmt.Println(" create table", ",result:", result, ",err:", err)
} else if mode == "insert" {
if len(os.Args) > 2 {
data := os.Args[2]
now := strconv.FormatInt(time.Now().Unix(), 10)
result, err := db.Exec("INSERT INTO \"main\".\"test\" (\"text\", \"time\") VALUES('" + data + "', '" + now + "')")
fmt.Println(data, " inserted", ",result:", result, ",err:", err)
} else {
log.Fatal("Error: no data provided")
}
} else if mode == "csv" {
q, err := db.Query("SELECT * FROM \"main\".\"test\" ORDER BY time DESC;")
if err != nil {
log.Printf("Error: while getting data: %s\n", err)
} else {
fmt.Println("Id,Text,Time")
for q.Next() {
err = q.Scan(&qu.Id, &qu.Text, &qu.Time)
if err != nil {
log.Fatal(err)
}
fmt.Printf("%v,%v,%v\n", qu.Id, qu.Text, qu.Time)
}
}
}
}