-
Notifications
You must be signed in to change notification settings - Fork 14
/
pusher_riak.go
163 lines (152 loc) · 4.33 KB
/
pusher_riak.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
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
package main
import (
"encoding/json"
"fmt"
log "github.com/sirupsen/logrus"
"github.com/tpjg/goriakpbc"
"time"
)
const RIAK_WORKERS = 100
// RiakPusher structure will help us to push CDRs to PostgreSQL.
// the structure will held properties to connect to the PG DBMS and
// push the CDRs, such as RiakConnect and RiakBucket
type RiakPusher struct {
bucket *riak.Bucket
RiakConnect string
RiakBucket string
cdrFields []ParseFields
switchIP string
cdrSourceType int
countPushed int
}
// Init is a constructor for RiakPusher
// It will help setting RiakConnect, cdrFields, switchIP and RiakBucket
func (p *RiakPusher) Init(RiakConnect string, cdrFields []ParseFields, switchIP string, cdrSourceType int, RiakBucket string) {
p.RiakConnect = RiakConnect
p.cdrFields = cdrFields
if switchIP == "" {
ip, err := externalIP()
if err == nil {
switchIP = ip
}
}
p.switchIP = switchIP
p.cdrSourceType = cdrSourceType
p.RiakBucket = RiakBucket
}
// Connect will help to connect to the DBMS, here we implemented the connection to SQLite
func (p *RiakPusher) Connect() error {
var err error
// client := riak.New(p.RiakConnect)
// err = client.Connect()
err = riak.ConnectClientPool(p.RiakConnect, 25)
if err != nil {
log.Error("Cannot connect to Riak: ", err.Error())
return err
}
// err = client.Ping()
// if err != nil {
// log.Error("Cannot ping Riak: ", err.Error())
// return err
// }
p.bucket, err = riak.NewBucket("testriak")
if err != nil {
log.Error("Cannot connect to Riak Bucket(", p.RiakConnect, "): ", err.Error())
return err
}
return nil
}
// ForceConnect will help to Reconnect to the DBMS
func (p *RiakPusher) ForceConnect() error {
for {
err := p.Connect()
if err != nil {
log.Error("Error connecting to Riak...", err)
time.Sleep(time.Second * time.Duration(5))
continue
}
return nil
}
}
// FmtDataExport will reformat the results properly for import
func (p *RiakPusher) FmtDataExport(fetchedResults map[int][]string) (map[int]map[string]interface{}, error) {
data := make(map[int]map[string]interface{})
i := 0
for _, v := range fetchedResults {
data[i] = make(map[string]interface{})
data[i]["id"] = v[0]
data[i]["switch"] = p.switchIP
data[i]["callid"] = ""
data[i]["cdr_source_type"] = p.cdrSourceType
// extradata := make(map[string]string)
for j, f := range p.cdrFields {
data[i][f.DestField] = v[j+1]
}
jsonData, err := json.Marshal(data[i])
if err != nil {
log.Error("Error:", err.Error())
return nil, err
} else {
data[i]["jsonfmt"] = string(jsonData)
}
i = i + 1
}
return data, nil
}
// RecordInsert will insert one record to Riak
func (p *RiakPusher) RecordInsert(val map[string]interface{}, c chan<- bool) error {
defer func() {
c <- true
}()
bucketkey := fmt.Sprintf("callid-%v-%v", val["callid"], val["switch"])
// log.Info("New bucketkey=> ", bucketkey)
obj := p.bucket.NewObject(bucketkey)
obj.ContentType = "application/json"
obj.Data = []byte(fmt.Sprintf("%v", val["jsonfmt"]))
obj.Store()
p.countPushed = p.countPushed + 1
log.Debug("Stored bucketkey=> ", bucketkey, " - Total pushed:", p.countPushed)
return nil
}
// BatchInsert take care of loop through the fetchedResults and push them to PostgreSQL
func (p *RiakPusher) BatchInsert(fetchedResults map[int][]string) error {
// create the statement string
log.WithFields(log.Fields{
"fetchedResults": fetchedResults,
}).Debug("Results:")
var err error
data, err := p.FmtDataExport(fetchedResults)
if err != nil {
return err
}
p.countPushed = 0
for _, val := range data {
//TODO: Could go faster by implementing a relaunch of worker for the free channels
workers := make(chan bool, RIAK_WORKERS)
for i := 0; i < RIAK_WORKERS; i++ {
go p.RecordInsert(val, workers)
}
for i := 0; i < RIAK_WORKERS; i++ {
<-workers
// log.Info("Missing wordkers: ", (RIAK_WORKERS-i)-1)
}
}
return nil
}
// Push is the main method that will connect to the DB, create the talbe
// if it doesn't exist and insert all the records received from the Fetcher
func (p *RiakPusher) Push(fetchedResults map[int][]string) error {
// Connect to DB
err := p.ForceConnect()
if err != nil {
return err
}
defer riak.Close()
// Insert in Batch to DB
err = p.BatchInsert(fetchedResults)
if err != nil {
return err
}
log.Info("Total number pushed to Riak:", p.countPushed)
return nil
}