-
Notifications
You must be signed in to change notification settings - Fork 319
/
data.go
54 lines (48 loc) · 1.07 KB
/
data.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
package src
import "database/sql/driver"
func (This *ClickhouseDB) GetTableDataList(schema string,table string,where string) (data []map[string]driver.Value) {
if schema == ""{
return make([]map[string]driver.Value,0)
}
This.conn.Begin()
defer This.conn.Commit()
sql := "select * from "+schema+"."+table+" where 1=1"
if where != ""{
sql += " and "+where
}
stmt, err := This.conn.Prepare(sql)
if err == nil{
defer stmt.Close()
}
rows, err := stmt.Query([]driver.Value{})
if err != nil {
This.err = err
return
}
defer rows.Close()
data = make([]map[string]driver.Value,0)
n := len(rows.Columns())
row := make([]driver.Value, n)
for rows.Next(row) == nil {
d := make(map[string]driver.Value,0)
for i:=0;i<n;i++{
d[rows.Columns()[i]] = row[i]
}
data = append(data,d)
}
return data
}
func (This *ClickhouseDB) Exec(sql string,value []driver.Value) error {
This.conn.Begin()
defer This.conn.Commit()
stmt,e:=This.conn.Prepare(sql)
if e != nil{
return e
}
defer stmt.Close()
_,e1:= stmt.Exec(value)
if e != nil{
return e1
}
return nil
}