mirror of
https://github.com/hanzoai/sqlite.git
synced 2026-10-30 18:22:26 +00:00
zeekayandHanzo Dev
9fec90146d
Adds the surface Hanzo Base needs to import ONLY github.com/hanzoai/sqlite and
never register modernc.org/sqlite directly — so a CGO consumer that needs
SQLCipher (commerce's per-tenant money DBs) no longer hits `panic: sql: Register
called twice for driver sqlite` from base's modernc registration colliding with
hanzoai/sqlite's mattn one. Complements the v0.1.5 sqlite_purego opt-out, which
serves the other case (a pure-Go cgo consumer wanting neither SQLCipher nor to
drop modernc); commerce needs SQLCipher, so it takes THIS path.
- hooks.go + hooks_{cgo,nocgo}.go: CommitHookRegisterer bridges the backends'
divergent native commit-hook signatures (mattn func() int / modernc func()
int32) to one CommitHookFn. Same cgo&&!sqlite_purego / !cgo||sqlite_purego
split as the drivers, so all four tag/cgo combos stay exclusive + exhaustive.
- pragma.go + pragma_{cgo,nocgo}.go: PragmaDSN + DefaultPragmas encode one pragma
set in the ACTIVE backend's DSN syntax (mattn _name=value / modernc
_pragma=name(value)); a single-form DSN is silently ignored by the other
backend, so busy_timeout/WAL would otherwise not apply when the binary is built
for the other backend.
- hooks_test.go + pragma_test.go: prove (all pure-Go combos) the hook
fires/aborts/clears and the pragmas take effect (journal_mode=WAL,
busy_timeout=10000, FK=ON).
Exactly one "sqlite" registration per build preserved (drivers unchanged);
encrypted-at-rest path untouched.
Co-authored-by: Hanzo Dev <[email protected]>
25 lines
929 B
Go
25 lines
929 B
Go
//go:build cgo && !sqlite_purego
|
|
|
|
package sqlite
|
|
|
|
import (
|
|
"fmt"
|
|
"strings"
|
|
)
|
|
|
|
// PragmaDSN builds an unencrypted `file:` DSN for path that applies pragmas in
|
|
// mattn's `_NAME=VALUE` syntax. mattn recognises _busy_timeout, _journal_mode,
|
|
// _synchronous, _foreign_keys and _cache_size and silently ignores any other
|
|
// parameter — so pragmas it cannot express as a DSN param (journal_size_limit,
|
|
// temp_store) are inert here but harmless, while the correctness-critical ones
|
|
// (busy_timeout, WAL) DO apply. The path is percent-escaped (escapeDBPath) so a
|
|
// '?'/'#' in it cannot strip the query. No key is added — keyed/encrypted opens
|
|
// go through OpenDB/DSN.
|
|
func PragmaDSN(path string, pragmas []Pragma) string {
|
|
parts := make([]string, 0, len(pragmas))
|
|
for _, p := range pragmas {
|
|
parts = append(parts, "_"+p.Name+"="+p.Value)
|
|
}
|
|
return fmt.Sprintf("file:%s?%s", escapeDBPath(path), strings.Join(parts, "&"))
|
|
}
|