-
Notifications
You must be signed in to change notification settings - Fork 499
/
write.go
134 lines (123 loc) · 2.99 KB
/
write.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
package client
import (
"context"
"database/sql"
"fmt"
"strings"
"github.com/apache/arrow/go/v16/arrow"
"github.com/cloudquery/plugin-sdk/v4/message"
"github.com/cloudquery/plugin-sdk/v4/schema"
)
func (c *Client) Write(ctx context.Context, res <-chan message.WriteMessage) error {
if err := c.writer.Write(ctx, res); err != nil {
return fmt.Errorf("failed to write: %w", err)
}
if err := c.writer.Flush(ctx); err != nil {
return fmt.Errorf("failed to flush: %w", err)
}
return nil
}
func (c *Client) WriteTableBatch(ctx context.Context, name string, msgs message.WriteInserts) (err error) {
if len(msgs) == 0 {
return nil
}
tx, err := c.db.BeginTx(ctx, nil)
if err != nil {
return err
}
defer func() {
if err == nil {
err = tx.Commit()
if err != nil {
c.logger.Error().Err(err).Msg("failed to commit transaction")
}
}
if err != nil {
if rollbackErr := tx.Rollback(); rollbackErr != nil {
c.logger.Error().Err(rollbackErr).Str("table", msgs[0].GetTable().Name).Msg("Failed to rollback transaction")
}
}
}()
for _, msg := range msgs {
err = c.insertMessage(ctx, tx, msg)
if err != nil {
return err
}
}
return nil
}
func (c *Client) insertMessage(ctx context.Context, tx *sql.Tx, m *message.WriteInsert) error {
table := m.GetTable()
sc := m.Record.Schema()
var sqlString string
if len(table.PrimaryKeys()) == 0 {
sqlString = c.insert(sc)
} else {
sqlString = c.upsert(sc)
}
vals := transformRecord(m.Record)
for _, v := range vals {
if _, err := tx.ExecContext(ctx, sqlString, v...); err != nil {
return fmt.Errorf("failed to execute '%s': %w", sqlString, err)
}
}
return nil
}
func (*Client) insert(sc *arrow.Schema) string {
var sb strings.Builder
tableName, ok := sc.Metadata().GetValue(schema.MetadataTableName)
if !ok {
panic("missing table name in schema metadata")
}
sb.WriteString("insert into ")
sb.WriteString(identifier(tableName))
sb.WriteString(" (")
columns := sc.Fields()
columnsLen := len(columns)
for i, c := range columns {
sb.WriteString(identifier(c.Name))
if i < columnsLen-1 {
sb.WriteString(",")
} else {
sb.WriteString(") values (")
}
}
for i := range columns {
sb.WriteString(fmt.Sprintf("$%d", i+1))
if i < columnsLen-1 {
sb.WriteString(",")
} else {
sb.WriteString(")")
}
}
return sb.String()
}
func (*Client) upsert(sc *arrow.Schema) string {
var sb strings.Builder
tableName, ok := sc.Metadata().GetValue(schema.MetadataTableName)
if !ok {
panic("missing table name in schema metadata")
}
sb.WriteString("insert or replace into ")
sb.WriteString(identifier(tableName))
sb.WriteString(" (")
columns := sc.Fields()
columnsLen := len(columns)
for i, c := range columns {
sb.WriteString(identifier(c.Name))
if i < columnsLen-1 {
sb.WriteString(",")
} else {
sb.WriteString(") values (")
}
}
for i := range columns {
sb.WriteString(fmt.Sprintf("$%d", i+1))
if i < columnsLen-1 {
sb.WriteString(",")
} else {
sb.WriteString(")")
}
}
return sb.String()
}