- commit
- 13809f2
- parent
- da52573
- author
- Eric Bower
- date
- 2024-11-12 09:46:20 -0500 EST
chore: enforce foreign_key constraints
+0,
-1
1@@ -5,7 +5,6 @@ import (
2 "time"
3
4 "github.com/bluekeyes/go-gitdiff/gitdiff"
5- _ "modernc.org/sqlite"
6 )
7
8 // User is a db model for users.
+1,
-0
1@@ -5,6 +5,7 @@ import (
2 "log/slog"
3
4 "github.com/jmoiron/sqlx"
5+ _ "modernc.org/sqlite"
6 )
7
8 var sqliteSchema = `
M
ssh.go
+2,
-2
1@@ -32,8 +32,8 @@ func authHandler(pr *PrCmd) func(ctx ssh.Context, key ssh.PublicKey) bool {
2 }
3
4 func GitSshServer(cfg *GitCfg, killCh chan error) {
5- dbpath := filepath.Join(cfg.DataDir, "pr.db")
6- dbh, err := SqliteOpen(dbpath, cfg.Logger)
7+ dbpath := filepath.Join(cfg.DataDir, "pr.db?_fk=on")
8+ dbh, err := SqliteOpen("file:"+dbpath, cfg.Logger)
9 if err != nil {
10 panic(fmt.Sprintf("cannot find database file, check folder and perms: %s: %s", dbpath, err))
11 }
M
web.go
+2,
-2
1@@ -955,8 +955,8 @@ func getEmbedFS(ffs embed.FS, dirName string) (fs.FS, error) {
2 func StartWebServer(cfg *GitCfg) {
3 addr := fmt.Sprintf("%s:%s", cfg.Host, cfg.WebPort)
4
5- dbpath := filepath.Join(cfg.DataDir, "pr.db")
6- dbh, err := SqliteOpen(dbpath, cfg.Logger)
7+ dbpath := filepath.Join(cfg.DataDir, "pr.db?_fk=on")
8+ dbh, err := SqliteOpen("file:"+dbpath, cfg.Logger)
9 if err != nil {
10 panic(fmt.Sprintf("cannot find database file, check folder and perms: %s: %s", dbpath, err))
11 }