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]>
22 lines
727 B
Go
22 lines
727 B
Go
//go:build !cgo || sqlite_purego
|
|
|
|
package sqlite
|
|
|
|
import (
|
|
"fmt"
|
|
"strings"
|
|
)
|
|
|
|
// PragmaDSN builds an unencrypted `file:` DSN for path that applies pragmas in
|
|
// modernc's `_pragma=NAME(VALUE)` syntax — the form modernc actually applies.
|
|
// The path is percent-escaped (escapeDBPath) so a '?' or '#' in it cannot
|
|
// terminate the path early and strip the query. This is the CGO-off default
|
|
// engine; keyed/encrypted opens go through OpenDB/DSN instead.
|
|
func PragmaDSN(path string, pragmas []Pragma) string {
|
|
parts := make([]string, 0, len(pragmas))
|
|
for _, p := range pragmas {
|
|
parts = append(parts, "_pragma="+p.Name+"("+p.Value+")")
|
|
}
|
|
return fmt.Sprintf("file:%s?%s", escapeDBPath(path), strings.Join(parts, "&"))
|
|
}
|