forked from snowflakedb/gosnowflake
-
Notifications
You must be signed in to change notification settings - Fork 0
/
showparam.go
94 lines (86 loc) · 2.22 KB
/
showparam.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
// Example: Set the session parameter in DSN and verify it
//
package main
import (
"database/sql"
"flag"
"fmt"
"log"
"os"
"strconv"
sf "github.com/snowflakedb/gosnowflake"
)
// getDSN constructs a DSN based on the test connection parameters
func getDSN(params map[string]*string) (string, *sf.Config, error) {
env := func(k string, failOnMissing bool) string {
if value := os.Getenv(k); value != "" {
return value
}
if failOnMissing {
log.Fatalf("%v environment variable is not set.", k)
}
return ""
}
account := env("SNOWFLAKE_TEST_ACCOUNT", true)
user := env("SNOWFLAKE_TEST_USER", true)
password := env("SNOWFLAKE_TEST_PASSWORD", true)
host := env("SNOWFLAKE_TEST_HOST", false)
port := env("SNOWFLAKE_TEST_PORT", false)
protocol := env("SNOWFLAKE_TEST_PROTOCOL", false)
portStr, _ := strconv.Atoi(port)
cfg := &sf.Config{
Account: account,
User: user,
Password: password,
Host: host,
Port: portStr,
Protocol: protocol,
Params: params,
}
dsn, err := sf.DSN(cfg)
return dsn, cfg, err
}
func main() {
if !flag.Parsed() {
// enable glog for Go Snowflake Driver
flag.Parse()
}
tmfmt := "MM-DD-YYYY"
dsn, cfg, err := getDSN(
map[string]*string{
"TIMESTAMP_OUTPUT_FORMAT": &tmfmt, // session parameter
})
if err != nil {
log.Fatalf("failed to create DSN from Config: %v, err: %v", cfg, err)
}
if err != nil {
log.Fatalf("failed to create DSN from Config: %v, err: %v", cfg, err)
}
db, err := sql.Open("snowflake", dsn)
if err != nil {
log.Fatalf("failed to connect. %v, err: %v", dsn, err)
}
defer db.Close()
query := "SHOW PARAMETERS LIKE 'TIMESTAMP_OUTPUT_FORMAT'"
rows, err := db.Query(query) // no cancel is allowed
if err != nil {
log.Fatalf("failed to run a query. %v, err: %v", query, err)
}
defer rows.Close()
var v1, v2, v3, v4, v5 string
for rows.Next() {
err := rows.Scan(&v1, &v2, &v3, &v4, &v5)
if err != nil {
log.Fatalf("failed to get result. err: %v", err)
}
if v1 != "TIMESTAMP_OUTPUT_FORMAT" {
log.Fatalf("failed to get 1. got: %v", v1)
}
fmt.Printf("fmt: %v\n", v2)
}
if rows.Err() != nil {
fmt.Printf("ERROR: %v\n", rows.Err())
return
}
fmt.Printf("Congrats! You have successfully run %v with Snowflake DB!\n", query)
}