NewSQLiteStore opens a SQLite-backed ledger at path.
(path string)
| 56 | |
| 57 | // NewSQLiteStore opens a SQLite-backed ledger at path. |
| 58 | func NewSQLiteStore(path string) (Store, error) { |
| 59 | db, err := sql.Open("sqlite", path) |
| 60 | if err != nil { |
| 61 | return nil, err |
| 62 | } |
| 63 | db.SetMaxOpenConns(1) |
| 64 | if _, err := db.Exec(sqliteSchema); err != nil { |
| 65 | _ = db.Close() |
| 66 | return nil, fmt.Errorf("sqlite migrate: %w", err) |
| 67 | } |
| 68 | if _, err := db.Exec(`PRAGMA foreign_keys = ON`); err != nil { |
| 69 | _ = db.Close() |
| 70 | return nil, fmt.Errorf("sqlite pragma: %w", err) |
| 71 | } |
| 72 | if err := migrateSQLiteLedger(db); err != nil { |
| 73 | _ = db.Close() |
| 74 | return nil, err |
| 75 | } |
| 76 | return &sqliteStore{db: db}, nil |
| 77 | } |
| 78 | |
| 79 | func migrateSQLiteLedger(db *sql.DB) error { |
| 80 | _, err := db.Exec(`ALTER TABLE requests ADD COLUMN ai_request_json TEXT`) |
no test coverage detected