package store

import (
	"path/filepath"
	"strings"
	"testing"
)

func TestSaveAndCount(t *testing.T) {
	database, err := Open(filepath.Join(t.TempDir(), "fall.db"))
	if err != nil {
		t.Fatal(err)
	}
	defer database.Close()

	record := Record{
		EventID: "FALL-1", TrackID: "P-1", SourceID: "cam",
		CameraHost: "192.0.2.10", CameraPort: 554, CameraChannel: "102",
		ConfigVersion: "cfg-x", State: "CONFIRMED", LatencySeconds: 1.8,
		ScreenshotPath: "20260723/FALL-1.png", ConfirmedAtUTC: "2026-07-23T12:00:00Z",
	}
	if err := database.Save(record); err != nil {
		t.Fatal(err)
	}
	if err := database.Save(record); err != nil {
		t.Fatal(err)
	}
	count, err := database.Count()
	if err != nil {
		t.Fatal(err)
	}
	if count != 2 {
		t.Fatalf("count = %d, want 2", count)
	}
}

func TestSchemaHasNoPasswordColumn(t *testing.T) {
	if strings.Contains(strings.ToLower(schema), "password") {
		t.Fatal("fall_events schema must not store a password")
	}
}