db

package

v1.0.1 Latest Latest Go to latest Published: Aug 5, 2026 License: MIT Imports: 6 Imported by: 0

Details

This section is empty.

View Source

var DB *sql.DB

func CloseDB()

CloseDB closes database connection.

func GetDBFilePath() (string, error)

GetDBFilePath returns path to ~/.config/jeeratype/stats.db with permission fallback.

func GetKeyMetrics() map[rune]KeyMetric

GetKeyMetrics returns map of key stats for ASCII Keyboard Heatmap rendering.

func GetTopSlowestBigrams(limit int) []string

GetTopSlowestBigrams returns top slowest key transition pairs.

func GetTopWeakKeys(limit int) []rune

GetTopWeakKeys returns the most missed or slowest keys.

func InitDB() error

InitDB initializes SQLite connection and creates schema.

func RecordBigramHit(bigram string, latencyMs int64) error

RecordBigramHit updates count and latency for a key-to-key transition.

func RecordKeyHit(keyChar string, isError bool, latencyMs int64) error

RecordKeyHit updates hits, errors, and latency for a single key.

func SaveTestRun(mode string, wpm, rawWPM, accuracy, consistency float64, durationSec int) error

SaveTestRun records a test session in test_runs table.

type KeyMetric struct {
	Char       rune
	TotalHits  int
	ErrorCount int
	AvgLatency float64
	Accuracy   float64
}