-
Notifications
You must be signed in to change notification settings - Fork 0
/
db.go
109 lines (91 loc) · 2.66 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
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
package sqlitex
import (
"context"
"database/sql"
"fmt"
"strings"
_ "github.com/mattn/go-sqlite3"
)
func NewDB(file string) (*DB, error) {
writer, err := setupWriter(file)
if err != nil {
return nil, fmt.Errorf("setup-writer: %w", err)
}
reader, err := setupReader(file)
if err != nil {
return nil, fmt.Errorf("setup-writer: %w", err)
}
return &DB{
writer: writer,
reader: reader,
}, nil
}
type DB struct {
writer *sql.DB
reader *sql.DB
}
func setupWriter(file string) (*sql.DB, error) {
params := strings.Join([]string{
"_journal_mode=WAL",
"_synchronous=NORMAL",
"_busy_timeout=5000",
"_txlock=immediate",
}, "&")
dsn := fmt.Sprintf("file:%s?%s", file, params)
sdb, err := sql.Open("sqlite3", dsn)
if err != nil {
return nil, fmt.Errorf("open %q: %w", file, err)
}
sdb.SetMaxOpenConns(1)
return sdb, nil
}
func setupReader(file string) (*sql.DB, error) {
params := strings.Join([]string{
"_busy_timeout=5000",
"mode=ro",
}, "&")
dsn := fmt.Sprintf("file:%s?%s", file, params)
sdb, err := sql.Open("sqlite3", dsn)
if err != nil {
return nil, fmt.Errorf("open %q: %w", file, err)
}
sdb.SetMaxOpenConns(5000)
return sdb, nil
}
func (db *DB) Close() {
db.reader.Close()
db.writer.Close()
}
func (db *DB) Begin() (*sql.Tx, error) {
return db.writer.BeginTx(context.Background(), nil)
}
func (db *DB) BeginTx(ctx context.Context, opts *sql.TxOptions) (*sql.Tx, error) {
return db.writer.BeginTx(ctx, opts)
}
func (db *DB) Exec(query string, args ...any) (sql.Result, error) {
return db.writer.ExecContext(context.Background(), query, args...)
}
func (db *DB) ExecContext(ctx context.Context, query string, args ...any) (sql.Result, error) {
return db.writer.ExecContext(ctx, query, args...)
}
func (db *DB) Query(query string, args ...any) (*sql.Rows, error) {
return db.reader.QueryContext(context.Background(), query, args...)
}
func (db *DB) QueryContext(ctx context.Context, query string, args ...any) (*sql.Rows, error) {
return db.reader.QueryContext(ctx, query, args...)
}
func (db *DB) QueryRow(query string, args ...any) *sql.Row {
return db.reader.QueryRowContext(context.Background(), query, args...)
}
func (db *DB) QueryRowContext(ctx context.Context, query string, args ...any) *sql.Row {
return db.reader.QueryRowContext(ctx, query, args...)
}
func (db *DB) PrepareExecContext(ctx context.Context, query string) (*sql.Stmt, error) {
return db.writer.PrepareContext(ctx, query)
}
func (db *DB) PrepareQueryContext(ctx context.Context, query string) (*sql.Stmt, error) {
return db.reader.PrepareContext(ctx, query)
}
func (db *DB) Stats() (writerStats, readerStats sql.DBStats) {
return db.writer.Stats(), db.reader.Stats()
}