forked from robarchibald/onedb
-
Notifications
You must be signed in to change notification settings - Fork 0
/
dbToCSV.go
71 lines (64 loc) · 1.33 KB
/
dbToCSV.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
package onedb
import (
"encoding/csv"
"fmt"
"io"
"time"
)
// CSVOptions contains specifications for how text should be formatted in a CSV file
type CSVOptions struct {
DateOnly bool
}
func writeCSV(rows RowsScanner, w io.Writer, options CSVOptions) error {
headers, vals, err := getColumnNamesAndValues(rows, false)
if err != nil {
return err
}
csvWriter := csv.NewWriter(w)
if err := csvWriter.Write(headers); err != nil {
return err
}
for rows.Next() {
row, err := scanCSV(rows, vals, options)
if err != nil {
return err
}
if err = csvWriter.Write(row); err != nil {
return err
}
}
csvWriter.Flush()
return csvWriter.Error()
}
func scanCSV(s Scanner, vals []interface{}, options CSVOptions) ([]string, error) {
err := s.Scan(vals...)
if err != nil {
return nil, err
}
row := make([]string, len(vals))
for i, value := range vals {
row[i] = getCSVValue(value.(*interface{}), options)
}
return row, nil
}
func getCSVValue(pval *interface{}, options CSVOptions) string {
switch v := (*pval).(type) {
case nil:
return ""
case bool:
if v {
return "true"
}
return "false"
case time.Time:
timeFormat := "2006-01-02 15:04:05.999"
if options.DateOnly {
timeFormat = "2006-01-02"
}
return v.Format(timeFormat)
case string:
return string(v)
default:
return fmt.Sprintf("%v", v)
}
}