Function New

pkg/session/sqlite/store.go:31–50

New creates a new SQLite session service. dbPath is the path to the SQLite database file. If the file doesn't exist, it will be created.

(dbPath string)

// dbPath is the path to the SQLite database file.
// If the file doesn't exist, it will be created.
func New(dbPath string) (*Service, error) {
	db, err := sql.Open("sqlite3", dbPath+"?_journal_mode=WAL&_busy_timeout=5000")
	if err != nil {
		return nil, fmt.Errorf("open sqlite database: %w", err)
	}

	// Set connection pool settings for SQLite
	db.SetMaxOpenConns(1) // SQLite only supports one writer
	db.SetMaxIdleConns(1)
	db.SetConnMaxLifetime(time.Hour)

	s := &Service{db: db}

	if err := s.migrate(); err != nil {
		_ = db.Close() // Ignore close error, migration error is more important
		return nil, fmt.Errorf("migrate database: %w", err)
	}

	return s, nil
}

// migrate creates the necessary tables if they don't exist.
func (s *Service) migrate() error {