storage

type CommandRecord struct {
	// Database identifier
	ID int64 `json:"id"` // Database record ID for deletion operations

	// Core command information
	Command   string            `json:"command"`              // The actual command text
	ExitCode  int               `json:"exit_code"`            // Command exit code
	Duration  int64             `json:"duration_ms"`          // Execution duration in milliseconds
	Note      string            `json:"note,omitempty"`       // Optional user note about the command
	Tags      []string          `json:"tags,omitempty"`       // Optional tags for command categorization
	TagColors map[string]string `json:"tag_colors,omitempty"` // Optional per-command tag colors (tag_name -> hex_color)

	// Context information
	WorkingDir string `json:"working_dir"`  // Directory where command was executed
	Timestamp  int64  `json:"timestamp_ms"` // Unix timestamp in milliseconds
	SessionID  string `json:"session_id"`   // Session UUID
	Hostname   string `json:"hostname"`     // Machine hostname

	// Optional context
	GitRoot   string `json:"git_root,omitempty"`   // Git repository root if applicable
	GitBranch string `json:"git_branch,omitempty"` // Git branch if applicable
	GitCommit string `json:"git_commit,omitempty"` // Git commit hash if applicable

	// Environment context
	User        string            `json:"user"`                  // Username
	Shell       string            `json:"shell"`                 // Shell type (bash, zsh, etc.)
	TTY         string            `json:"tty,omitempty"`         // TTY device
	Environment map[string]string `json:"environment,omitempty"` // Relevant environment variables

	// Metadata
	Version   int   `json:"version"`       // Schema version for future compatibility
	CreatedAt int64 `json:"created_at_ms"` // Record creation timestamp

	// NEW: Sync-related fields (backward compatible)
	DeviceID   string `json:"device_id,omitempty"`
	RecordHash string `json:"record_hash,omitempty"`
	LastSynced *int64 `json:"last_synced,omitempty"` // Unix timestamp in ms
	SyncStatus int    `json:"sync_status,omitempty"` // 0=local, 1=synced, 2=conflict
}

type Database struct {
	// contains filtered or unexported fields
}

type DatabaseOptions struct {
	Config          *config.DatabaseConfig
	CreateIfMissing bool
	MigrateOnOpen   bool
	ValidateSchema  bool
}

type DatabaseSchema struct {
	// Current schema version
	Version int

	// DDL statements
	Tables  []string
	Indexes []string

	// Migration statements for future use
	Migrations map[int][]string
}

type EncryptedHistoryRecord struct {
	ID            int64  `db:"id"`
	EncryptedData []byte `db:"encrypted_data"` // Encrypted CommandRecord JSON
	Timestamp     int64  `db:"timestamp"`      // Unencrypted timestamp for indexing
	Session       string `db:"session"`        // Unencrypted session ID for filtering
	Hostname      string `db:"hostname"`       // Unencrypted hostname for filtering
	CreatedAt     int64  `db:"created_at"`     // Record insertion timestamp
}

type Migrator struct {
	// contains filtered or unexported fields
}

type SchemaVersion struct {
	Version     int    `db:"version"`
	AppliedAt   int64  `db:"applied_at"`
	Description string `db:"description"`
}

type SessionMetadata struct {
	SessionID string `db:"session_id"`
	StartTime int64  `db:"start_time"`
	EndTime   *int64 `db:"end_time"` // NULL until session ends
	Hostname  string `db:"hostname"`
	UserName  string `db:"user_name"`
	ShellType string `db:"shell_type"`
	CreatedAt int64  `db:"created_at"`
}