-
Notifications
You must be signed in to change notification settings - Fork 0
/
example.go
55 lines (43 loc) · 1.04 KB
/
example.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
package example
import (
"context"
"database/sql"
"fmt"
"log"
"github.com/farislr/commoneer/rdbx"
"github.com/go-redis/redis/v8"
"github.com/go-redsync/redsync/v4"
_rsyncpool "github.com/go-redsync/redsync/v4/redis/goredis/v8"
)
func initDB() rdbx.DBTX {
username := "root"
password := ""
host := "localhost"
port := "3306"
dbname := "test"
parsetime := true
loc := "Asia%2FJakarta"
connection := fmt.Sprintf("%s:%s@tcp(%s:%s)/%s?parseTime=%t&loc=%s", username, password, host, port, dbname, parsetime, loc)
db, err := sql.Open("mysql", connection)
if err != nil {
panic(err)
}
rClient := redis.NewClient(&redis.Options{
Addr: "localhost:6379",
})
pool := _rsyncpool.NewPool(rClient)
rsync := redsync.New(pool)
return rdbx.NewDBx(db, rClient, rsync)
}
func queryx() {
db := initDB()
var model struct {
ID string
Name string
CreatedAt sql.NullTime
}
if err := db.Queryx(context.Background(), "SELECT * FROM model_table", model); err != nil {
log.Println(err)
}
fmt.Printf("model: %v\n", model)
}