-
Notifications
You must be signed in to change notification settings - Fork 305
/
db.go
45 lines (40 loc) · 1.45 KB
/
db.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
// Copyright © 2022 The Things Network Foundation, The Things Industries B.V.
//
// Licensed under the Apache License, Version 2.0 (the "License");
// you may not use this file except in compliance with the License.
// You may obtain a copy of the License at
//
// http://www.apache.org/licenses/LICENSE-2.0
//
// Unless required by applicable law or agreed to in writing, software
// distributed under the License is distributed on an "AS IS" BASIS,
// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
// See the License for the specific language governing permissions and
// limitations under the License.
package store
import (
"context"
"database/sql"
"github.com/jackc/pgx/v5"
"github.com/jackc/pgx/v5/stdlib"
"github.com/uptrace/bun/driver/pgdriver"
"go.thethings.network/lorawan-stack/v3/pkg/experimental"
)
var pgdriverFeatureFlag = experimental.DefineFeature("db.pgdriver", false)
// OpenDB opens the database connection.
func OpenDB(ctx context.Context, databaseURI string) (*sql.DB, error) {
if pgdriverFeatureFlag.GetValue(ctx) {
return sql.OpenDB(pgdriver.NewConnector(
pgdriver.WithDSN(databaseURI),
pgdriver.WithResetSessionFunc(func(ctx context.Context, cn *pgdriver.Conn) error {
return checkConn(cn.Conn())
}),
)), nil
}
config, err := pgx.ParseConfig(databaseURI)
if err != nil {
return nil, err
}
config.DefaultQueryExecMode = pgx.QueryExecModeSimpleProtocol
return stdlib.OpenDB(*config), nil
}