forked from marcboeker/go-duckdb
-
Notifications
You must be signed in to change notification settings - Fork 0
/
duckdb.go
88 lines (71 loc) · 2.07 KB
/
duckdb.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
// Use of this source code is governed by a MIT-style
// license that can be found in the LICENSE file.
// Package duckdb implements a databse/sql driver for the DuckDB database.
package duckdb
/*
#include <duckdb.h>
*/
import "C"
import (
"database/sql"
"database/sql/driver"
"errors"
"fmt"
"net/url"
"unsafe"
)
func init() {
sql.Register("duckdb", impl{})
}
type impl struct{}
func (impl) Open(dataSourceName string) (driver.Conn, error) {
var db C.duckdb_database
var con C.duckdb_connection
parsedDSN, err := url.Parse(dataSourceName)
if err != nil {
return nil, fmt.Errorf("%w: %s", parseConfigError, err.Error())
}
path := C.CString(parsedDSN.Path)
defer C.free(unsafe.Pointer(path))
// Check for config options.
if len(parsedDSN.RawQuery) == 0 {
if state := C.duckdb_open(path, &db); state == C.DuckDBError {
return nil, openError
}
} else {
config, err := prepareConfig(parsedDSN.Query())
if err != nil {
return nil, err
}
errMsg := C.CString("")
defer C.duckdb_free(unsafe.Pointer(errMsg))
if state := C.duckdb_open_ext(path, &db, config, &errMsg); state == C.DuckDBError {
return nil, fmt.Errorf("%w: %s", openError, C.GoString(errMsg))
}
}
if state := C.duckdb_connect(db, &con); state == C.DuckDBError {
return nil, openError
}
return &conn{db: &db, con: &con}, nil
}
func prepareConfig(options map[string][]string) (C.duckdb_config, error) {
var config C.duckdb_config
if state := C.duckdb_create_config(&config); state == C.DuckDBError {
return nil, createConfigError
}
for k, v := range options {
if len(v) > 0 {
state := C.duckdb_set_config(config, C.CString(k), C.CString(v[0]))
if state == C.DuckDBError {
return nil, fmt.Errorf("%w: affected config option %s=%s", prepareConfigError, k, v[0])
}
}
}
return config, nil
}
var (
openError = errors.New("could not open database")
parseConfigError = errors.New("could not parse config for database")
createConfigError = errors.New("could not create config for database")
prepareConfigError = errors.New("could not set config for database")
)