diff options
author | Alan Pearce | 2025-01-30 22:16:09 +0100 |
---|---|---|
committer | Alan Pearce | 2025-01-30 22:16:09 +0100 |
commit | 99f8047ef20a64f948ac2b703c81eb49bed091c0 (patch) | |
tree | a0365a7b2e477467a91bef247db09624028e1807 /internal/storage | |
parent | 4566db657dab6af43f8fce814cd0e42cbcc788bf (diff) | |
download | website-99f8047ef20a64f948ac2b703c81eb49bed091c0.tar.lz website-99f8047ef20a64f948ac2b703c81eb49bed091c0.tar.zst website-99f8047ef20a64f948ac2b703c81eb49bed091c0.zip |
re-organise everything sqlite
Diffstat (limited to 'internal/storage')
-rw-r--r-- | internal/storage/sqlite/reader.go | 7 | ||||
-rw-r--r-- | internal/storage/sqlite/writer.go | 11 |
2 files changed, 4 insertions, 14 deletions
diff --git a/internal/storage/sqlite/reader.go b/internal/storage/sqlite/reader.go index fe5da7e..fefeb74 100644 --- a/internal/storage/sqlite/reader.go +++ b/internal/storage/sqlite/reader.go @@ -19,12 +19,7 @@ type Reader struct { } } -func NewReader(dbPath string, log *log.Logger) (r *Reader, err error) { - db, err := openDB(dbPath) - if err != nil { - return nil, errors.WithMessage(err, "could not open SQLite database") - } - +func NewReader(db *sql.DB, log *log.Logger) (r *Reader, err error) { r = &Reader{ log: log, db: db, diff --git a/internal/storage/sqlite/writer.go b/internal/storage/sqlite/writer.go index c35494d..ec0d6d0 100644 --- a/internal/storage/sqlite/writer.go +++ b/internal/storage/sqlite/writer.go @@ -32,7 +32,7 @@ type Options struct { Compress bool } -func openDB(dbPath string) (*sql.DB, error) { +func OpenDB(dbPath string) (*sql.DB, error) { return sql.Open( "sqlite", fmt.Sprintf( @@ -44,14 +44,9 @@ func openDB(dbPath string) (*sql.DB, error) { ) } -func NewWriter(dbPath string, logger *log.Logger, opts *Options) (*Writer, error) { - db, err := openDB(dbPath) - if err != nil { - return nil, errors.WithMessage(err, "opening sqlite database") - } - +func NewWriter(db *sql.DB, logger *log.Logger, opts *Options) (*Writer, error) { // WIP: only memory database for now - _, err = db.Exec(` + _, err := db.Exec(` CREATE TABLE IF NOT EXISTS url ( id INTEGER PRIMARY KEY, path TEXT NOT NULL |