-
Notifications
You must be signed in to change notification settings - Fork 0
/
csvReader.go
95 lines (85 loc) · 1.94 KB
/
csvReader.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
package gotils
import (
"io"
"encoding/csv"
"reflect"
"strconv"
"time"
"strings"
)
var layout string = "2006-01-02"
func CsvReader(buff io.Reader) ([][]string, error) {
if buff == nil {
return nil, &errorString{"No buffer!"}
}
r := csv.NewReader(buff)
return r.ReadAll()
}
func CsvToMap(records [][]string) ([]map[string]interface{}, error) {
var a []map[string]interface{}
if len(records) == 0 {
return nil, &errorString{"No csv records!"}
}
for i, e := range records {
if i != 0 {
// r, err := ParseStruct(setVal(records[0], e), result)
// if err != nil {
// continue
// }
r := setVal(records[0], e)
a = append(a, r)
}
}
return a, nil
}
func setKey(keys []string) map[string]interface{} {
m := make(map[string]interface{})
for _, e := range keys {
if e == "" {
continue
}
m[e] = nil
}
return m
}
func setVal(keys []string, val []string) map[string]interface{} {
m := setKey(keys)
for i, e := range val {
if strings.Trim(e, "") == "" {
continue
}
m[keys[i]] = val[i]
}
return m
}
// func mapValue(value []string, obj interface{}) interface{} {
// // v := reflect.ValueOf(&obj)
// // for i, e := range value {
// // setType(v.Field(i), e)
// // v.Field(i).Set(reflect.ValueOf(e))
// // }
// val := reflect.ValueOf(&obj).Elem()
// for i := 0; i < val.NumField(); i++ {
// valueField := val.Field(i)
// typeField := val.Type().Field(i)
// // if key == strings.ToLower(typeField.Name) {
// // return valueField.Interface().(string)
// // }
// }
// return &obj
// }
func setType(f reflect.Value, v string) {
switch f.Interface().(type){
case string:
f.SetString(v)
case int:
i, _ := strconv.ParseInt(v, 64, 10)
f.SetInt(i)
case float64:
i, _ := strconv.ParseFloat(v, 10)
f.SetFloat(i)
case time.Time:
t, _ :=time.Parse(layout, v)
f.Set(reflect.ValueOf(t))
}
}