From 08bbcf18b1207153983261652b4a43a9b36f386c Mon Sep 17 00:00:00 2001 From: Peter Stone Date: Tue, 20 Jan 2026 11:34:33 -1000 Subject: Add session-based authentication Implement secure authentication using scs session manager with SQLite backing store and bcrypt password hashing. - Add users and sessions tables (migration 004) - Create internal/auth package with Service, Middleware, and Handlers - Protect all routes except /login, /logout, /static/* - Add login page template and logout button to dashboard - Default credentials: admin/changeme (configurable via env vars) Co-Authored-By: Claude Opus 4.5 --- internal/store/sqlite.go | 5 +++++ 1 file changed, 5 insertions(+) (limited to 'internal/store') diff --git a/internal/store/sqlite.go b/internal/store/sqlite.go index dac3321..7961f35 100644 --- a/internal/store/sqlite.go +++ b/internal/store/sqlite.go @@ -59,6 +59,11 @@ func (s *Store) Close() error { return s.db.Close() } +// DB returns the underlying database connection +func (s *Store) DB() *sql.DB { + return s.db +} + // runMigrations executes all migration files in order func (s *Store) runMigrations() error { // Get migration files -- cgit v1.2.3